Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best free RDMS engine
Message
From
23/06/2011 16:48:50
Luis Navas
Independent Consultant
Auckland, New Zealand
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01515394
Message ID:
01515758
Views:
74
>>>>>Hi everybody, I want to begin developing a commercial application using VFP 9 as my front end and a free RDBMS (not DBFs) as the back end. I'd like to know what is the best one to work with VFP9. I have in mind 3: PostgreSQL, Firebird, and MySQL. I've never worked with them and of those three I guess MySQL is not completely free. I would like to know from the ones that have had any chance to work with any of those databases or perhaps any other that you may consider as a better alternative.
>>>>>
>>>>>TIA
>>>>
>>>>SQLExpress IMHO. This gives you most of the features of SQL Server (including reporting service) and direct scalability to huge databases. Free.
>>>
>>>Thanks for the advice, but, I guess you have to pay for using Reporting service, right? I'm not sure about it.
>>
>>The main problem will be if your application grows outside of the Express version capabilities (4GB of data and 1GB of RAM I think).
>
>You're right on the RAM but data capacity has increased to 10GB.
>
>>At that point you will be tied up with SQL Server and you will have to pay to upgrade the version, that is the common trick these vendors do (Oracle does the same)
>>
>>In my honest opinion with PostgreSQL or Firebird you will have no limitations from the beginning all for free.
>
>I usually assume that when a companys storage requirement surpasses the 10GB limit then the cost of MS-SQL will not be a significant factor - and the migration from SQL Express will be painless..

It's good they have increase the size of the DB thank you for letting me know. Do they also have the limit of 1 CPU?

I know SQL Server is an excellent product, I used to use it. However in my personal experience PostgreSQL has been fantastic, the documentation it's excellent, the developer community is friendly, professional and they have a really nice support life cycle and all of this hard work for free :-)
I never forget a face, but in your case I will make an exception :-)
Previous
Reply
Map
View

Click here to load this message in the networking platform