SQLite does not cut it .. other small solutions? Topic is solved

This forum is reserved for everything you want to talk about. It could be about programming, opinions, open source programs, development in general, or just cool stuff to share!
Jorg
Moderator
Moderator
Posts: 3971
Joined: Fri Aug 27, 2004 9:38 pm
Location: Delft, Netherlands
Contact:

Post by Jorg » Sat Oct 15, 2005 7:53 am

Thanks Frank! I feel confident enough now to start playing with SQLite ;-)
Regards,
- Jorgen
Forensic Software Engineer
Netherlands Forensic Insitute
http://english.forensischinstituut.nl/
-------------------------------------
Jorg's WasteBucket
http://www.xs4all.nl/~jorgb/wb

jsheets
Earned a small fee
Earned a small fee
Posts: 22
Joined: Wed Oct 19, 2005 1:21 pm

Post by jsheets » Mon Oct 31, 2005 6:05 am

leio wrote:I really shouldn't open my mouth here, but I'll do that regardless :twisted:
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.

leio
Can't get richer than this
Can't get richer than this
Posts: 802
Joined: Mon Dec 27, 2004 10:46 am
Location: Estonia, Tallinn
Contact:

Post by leio » Mon Oct 31, 2005 12:37 pm

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" ;)
Compilers: gcc-3.3.6, gcc-3.4.5, gcc-4.0.2, gcc-4.1.0 and MSVC6
OS's: Gentoo Linux, WinXP; WX: CVS HEAD

Project Manager of wxMUD - http://wxmud.sf.net/
Developer of wxGTK;
gtk+ port maintainer of OMGUI - http://www.omgui.org/

Jorg
Moderator
Moderator
Posts: 3971
Joined: Fri Aug 27, 2004 9:38 pm
Location: Delft, Netherlands
Contact:

Post by Jorg » Mon Oct 31, 2005 12:58 pm

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
Forensic Software Engineer
Netherlands Forensic Insitute
http://english.forensischinstituut.nl/
-------------------------------------
Jorg's WasteBucket
http://www.xs4all.nl/~jorgb/wb

jb_coder
Super wx Problem Solver
Super wx Problem Solver
Posts: 267
Joined: Mon Oct 18, 2004 10:55 am

Post by jb_coder » Mon Oct 31, 2005 1:18 pm

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?

buildere
Super wx Problem Solver
Super wx Problem Solver
Posts: 358
Joined: Thu Oct 28, 2004 3:45 pm
Location: Costa Rica

Post by buildere » Mon Oct 31, 2005 7:10 pm

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 :wink:

Post Reply