Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Databases used
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Databases used

 Post Reply Post Reply Page  12>
Poll Question: Which database do you use the most?
Poll Choice Votes Poll Statistics
6 [75.00%]
2 [25.00%]
You can not vote in this poll

Author
theSCIENTIST View Drop Down
Senior Member
Senior Member


Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440
Post Options Post Options   Thanks (0) Thanks(0)   Quote theSCIENTIST Quote  Post ReplyReply Direct Link To This Post Topic: Databases used
    Posted: 06 October 2004 at 12:41pm
The application I'm building will be using WWF as the core, and I'm facing a difficult decision regarding the backend support.

I want it to reach a wide group of people but at the same time I'm inclined not to support MS Access at all (and remove all code related to it), and focus only on MSSQL, because I think that those that still use MS Access will sooner or later upgrade to MSSQL, I need to know your opinions on this matter, as supporting both backends will require a great deal of time, you know adding design to one and then the other is too much.

Please vote and be fair.
Thx.
Back to Top
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373
Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Posted: 06 October 2004 at 1:13pm
If your attempting to market software, always make it as scalable as possible.  Don't make MS-SQL the only option, recommend it but also support Access.  The more you support, the wider your audience.  The code change between the two isn't much anyway most likely.
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 06 October 2004 at 1:50pm
Originally posted by Gullanian Gullanian wrote:

The code change between the two isn't much anyway most likely.


Thats not always true, I often use quite complex stored procedures in SQL Server and some of those could not be easily rewritting in access. Well at least without making multiple queries
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 06 October 2004 at 3:09pm
Both of you are right, you need to know your audience. Looking at this forum there are plenty of "kids" that use free hosting and don't see the benefit of using sql server. if you use wwf as the core you might as well use both systems. the main problem is that you need to scale functions, or you will end up with two code sets, as some things are just not possible with access.
Back to Top
theSCIENTIST View Drop Down
Senior Member
Senior Member


Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440
Post Options Post Options   Thanks (0) Thanks(0)   Quote theSCIENTIST Quote  Post ReplyReply Direct Link To This Post Posted: 06 October 2004 at 4:09pm
That's the kind of thing I'm trying to avoind, having to develope scalable code to support both backends, that will take twice as long, not to mention having to debug and test both, I know some people still use Access, but the trend will be to move away from it sooner or later. On the other end, I could be doing a critical mistake by not supporting Access, since I want a wide audience, that's the purpose of starting this poll.
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 06 October 2004 at 4:14pm
I think it all depends on what is more important to this application. performance (if you choose ONE database platform you will be able to optimise it more for that platform) or extensibility which will probably lead to a decrease in performance. It all depends on what the application is
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 06 October 2004 at 4:16pm
Also, it depends who the application is aimed at. If it is high end (i.e. aimed at corporate customers and needs to be very scalable) or aimed at the lower end that want a quick and easy to use datasource but are not too worried about scalability.
Back to Top
theSCIENTIST View Drop Down
Senior Member
Senior Member


Joined: 31 July 2003
Location: United Kingdom
Status: Offline
Points: 440
Post Options Post Options   Thanks (0) Thanks(0)   Quote theSCIENTIST Quote  Post ReplyReply Direct Link To This Post Posted: 06 October 2004 at 5:32pm
So far, I'm inclined to drop Access altogether, I know this "kids" who use free hosting to have some fun, but even they will not be "kids" forever and they will not want to just have fun forever, there's going to be a time they start being a bit more serious and then they will move to a proper paid host with MSSQL..

Humm, I think I should focus on MSSQL, but let's run this poll for a few more days.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.