PureBasic Forums - English

I've just had to go through a lengthy (and expensive) migration from Access to mySQL on our Win2003 server, because we found out bugs exists in the Jet Engine version of Win2003 server. MS know of it but waiting for SP1 to fix (properly).

Just a though ...

SQLite is a very nice engine, small and compact.

Take a look at the C code, it is rather neatly written.

Genuinely free, in every possible way.

I'm not sure about it's scalability.

IMHO the problem with SQLite are the concurrent connections. While it's fine as a DB for a standalone Program I'm not sure if it behaves normal in a distributed environment and because every client program is also a server connecting to the DB file, it could get really slow with many clients because there is no instance that could manage the traffic and file access (if not written by yourself). The new Version however could have many new features I don't know about. Don't even know if it's finished yet

Karbon wrote:I would be surprised if any of my existing customers even knew what MySQL was, much less had it installed.. I wish I had a more computer saavy target for my software(s) but that just isn't the way it is!

If you are writing shareware business desktop software and requiring the users to install MySQL you are probably losing a LOT of business. People, especially small business people, want it to "just work". If you aren't writing shareware and can offer on-site installation or are selling an enterprise level product then you can probably get away with requiring an RDBMS to already be in place.

Because I am not a salesman and that's not how I live. But it was just another idea for you. At any rate, te people I usually deal with are either other programmers looking for a quick fix they don't have time for or IT department heads with this sort of thing in place already.

Anyway, as I said, it was just another idea trying to help here:):)

Don't use MS Access if you want to use your application on a network. The endless data corruptions will drive you crazy. Plus you only get the runtime with the developer version which is pretty expensive.

My understanding is if you create a commercial application that works ONLY with MySQL you can not distribute MySQL with it unless you have purchased a license to do so. Your customer however could download MySQL free of charge and use it with your app.

However, you can not use MySQL as an embedded server in an application that is not licensed under the GNU public license.

An installation is a one off thing and you can create clear and concise instructions for your customer. I don't see the sense in compromising an app for that.

Over the last few months I have spent hours seaching the internet for database servers/engines, I've also downloaded and test driven quite a few demos but I think MySQL is clearly my favourite.

The new administrator and querybrowser utilities are really nice too.

If it's good enough for NASA, Suzuki, Yamaha, Toyota, Braun, Intel, Hewlett-Packard....

Weave

Here's a few others anyway:
SQL
http://www.picosoft.it/picosql/
http://www.postgresql.org/
http://www3.ca.com/Press/PressRelease.asp?CID=61597
Check out the Million Dollar Challenge on Ingres! (which is now OpenSource)
http://www.mimer.com/index.asp?secId=168
http://www.ocelot.ca/
http://www.hughes.com.au/products/msql/


xBase
https://www.c3compiler.com/En/Index.htm
http://www.xharbour.com/default.asp?s=leeg

More Database Stuff
http://www.downloaddatabase.com

Here's a catalogue of free database systems:
http://www.faqs.org/faqs/databases/free-databases/

Hi the.weavster,

Great links!

A couple more:

http://www.thefreecountry.com/sourcecode/database.shtml
http://www.freebyte.com/programming/#databases

Probably with tons of duplication. These are "free" in one sense or another (free should mean free!) and many have source.

Here's a few more I forgot:
TurboPower FlashFiler (Open Source):http://sourceforge.net/projects/tpflashfiler/
This is quite a nice one:http://www.elevatesoft.com/prodinfo.htm
http://www.simple-sw.com/index.html

From the Daffodil DB Web site:

One$DB is a free version of Daffodil DB.

One$DB is free for all types of usage including commercial use.

There are no hidden costs with One$DB. One$DB available at zero cost, with free support, zero migration costs and zero maintenance costs.

Does One$DB have ODBC support?

Yes. One$DB Open Database Connectivity (ODBC) Driver is a high-performance 32 Bit ODBC Driver that provides transparent access to remote databases from any ODBC-compliant application. It is based on the Call-Level Interface specifications from X/Open and ISO/IEC for database APIs and also uses Structured Query Language (SQL) as its language for accessing databases.

http://www.daffodildb.com/one-dollar-db.html