A List of db's that are supported on all platforms.

[LA.Center]

I am doing some R&D on DB's and Lazarus, my equation is: create a list of database engines that are supported on x86 and x64 Windows, Linux, and Mac.

So far I have confirmed:

1. JanSQL
2. DBF, and MemDS, BufDS ...
3. Firebird

surprisingly there are no others that actually work on all platforms.
I have also tried 3rd party libs, Zeos and UniDac (UniDac is heavily depended on Libc, could not make it even work Laz 9.30), and they have also failed to support all platforms.

And the most surprise is I could not find a working x64 sqlite3.dll that works on windows and mac. (linux was ok)

does anyone know any other DB's or libs that work on all platforms?

Thx

[otorres]

an application x64 need libraries x64, if you try to connect 64  bits application to Firebird client 32 bits get a error.

[LA.Center]

Thx for the info, but Firebird works x86 and x64

[otorres]

Thx for the info, but Firebird works x86 and x64

Sure, for this cause is works fine for you =)

[Leledumbo]

surprisingly there are no others that actually work on all platforms.

what? that's bad to hear...
I don't have mac, so I can only confirm on Win and Lin. These works fine:

• SQLite 3 (on Mac too, a client asked me once, and he allowed me to use his Mac)
• MySQL
• PostgreSQL

[Arbee]

For Windows and Mac I can confirm

• PostgreSQL
• Firebird
• SQLite
• H2 (a Java database that can be accessed using PostgreSQL ODBC driver)

Somehow - and I can't explain why - Firebird is my favorite.

I thereby assume that with "supported" you mean that the database server is running on the same platform - or even as localhost - as the Lazarus machine.  I have - for instance - been able to access a DB2 server running on Windows from my Mac with Lazarus.

[LA.Center]

thank you all guys, have you tried x86 and x84 on those platforms?

@Arbee
Have you tried SQLite x64? If yes, do you have a SQLite3.dll that you can share, I have not found one.

The list should contain db connections that were successful on all x86/x64 on Windows, Linux, and Mac. the server can be anywhere, just a proven list of laz db connections that work truly cross.

You will be surprised there are not much, so if your really want to write a true cross app with db support then you have no choice but to go with Firebird, because thats the only one I was able to confirm to work on all platforms.

BTW, I love Firebird!

[marcov]

Somehow - and I can't explain why - Firebird is my favorite.

It depends much on what you are used to. Around 2000, I was looking for a database, and I had an old (powerpc) Mac as always-on machine. Firebird was still x86 only at that time, so I ended up with Postgresql.

[LA.Center]

Confirmed: SQLite works on all platforms x86/x64

@dll sender
Thank you very much. May I ask which compiler you used, and did you have any special switches?

[jwdietrich]

Do you know the Wiki article about databases (http://wiki.lazarus.freepascal.org/Databases)?

It may be a good idea to integrate the results of your investigations there.

[LA.Center]

yes, thats a good idea. I will update the Wiki as soon I am done with my list.

[Tankard]

@dll sender
Thank you very much. May I ask which compiler you used, and did you have any special switches?

just used the gcc 64bit compiler from http://mingw-w64.sourceforge.net/
no special switches

greetings
tankard

[LA.Center]

@tankard

OK, thats strange, we have tried to compile it with VS and it became like 1.2 MB big and we could not use it with lazarus.

Cool, I will download gcc now, thank you very much for this info