wxWidgets Discussion Forum

Thanks Frank! I feel confident enough now to start playing with SQLite
Regards,
- Jorgen

leio wrote:I really shouldn't open my mouth here, but I'll do that regardless
I can't understand what's the hype about MySQL. There is PostgreSQL - it has had stored procedures and triggers for a long time. It outperforms MySQL in every proper benchmark I have read. It is comparable to Oracle regarding functionality, with the major difference that it doesn't support master-master replication yet (but something similar is achievable with python scripts and such).
I don't get it

Database servers are almost like Linux distros, everyone has their favorite and some take it to an almost religous level.

PostgreSQL is under a BSD license where MySQL is now under GPL. PostgreSQL development is more independant, MySQL is largely controlled by MySQL AB.

There is a multi master replication solution as well (see
PGCluster).

I sometimes wish an embeddable version of PostgreSQL was available but there probably wouldn't be much benefit other than not needing to support multiple database engines.

Interestingly the Firebird database server is pretty powerful and has an emeddable version.

I didn't see you listing anything that would be in favor of MySQL compared to PostgreSQL. So, that's what I mean by not "getting it"

And you know what the most ironic part is? I am using SQLite and it works perfectly for me

I am learning some DB programming. Well, not exactly learning as I am already programming ADO in Delhpi, but I never used it in my own applications. So my latest app uses a DB to see how difficult it is, and it is working perfectly for me.

I just gave in that my DB layer is my data layer, and with classes I control the behavior of the grouped data. Meaning when I for example want to schedule something based upon criteria, I perform a query with that criteria. When I need to update data, I rather do that through the classes interface as they can control what datya is written back. But for reading it seems perfectly safe to perform queries directly if needed.

- Jorgen

This may be a bit of a tangent, but Firebird can also be used as an embedded database without the GPL license restrictions. You just need to link to the fbembed library rather than the fbclient library to use the embedded version.

To be honest though, SQLite and PostgreSQL were the least problematic to code in my experience.


To take this tangent as far as possible... what interface do you like best for setting up your SQLite database? SQLite Admin, knoda, sqlite3.exe shell?

leio wrote:I didn't see you listing anything that would be in favor of MySQL compared to PostgreSQL. So, that's what I mean by not "getting it"

I agree with you. Postgres is better than MySQL in every possible scenario I can think of. Sure, you can be happy with MySQL right now, but once your requirements start to grow, you'll start having trouble using hacks to keep your system running with this DB. The reason people chooses this DB is because it's popularity, nothing more. Most people just ignore how good postgres is, kinda like wxWidgets