Which database servers are real freeware? lazarus / 16-Databases ---------------------------------------------------------------------- tr_escape · 2013-11-12 14:11 Hello everyone, I am looking for freeware database server.Which database servers are real freeware? What is your advices? Best regards, ---------------------------------------------------------------------- taazz · 2013-11-12 14:28 PosgreSQL, Firebird are free to use and share no strings attached at any level. MySQL requiers a commercial license to be included with your own commercial software and installation but as long as your clients download and install MySQL them selves there is no problem. I heard that Ingres has a community edition that can be used but I never used it or dig deep enough to have an opinion about the product. Hope that helps a bit. ---------------------------------------------------------------------- Leledumbo · 2013-11-12 16:47 SQLite is the most liberal dbms ever, its license is public domain ---------------------------------------------------------------------- mangakissa · 2013-11-13 12:37 MariaDB is 99% the same as MySQL and it a spin off. Sometimes they do something more on the database. And it is 100% free. ---------------------------------------------------------------------- exdatis · 2013-11-14 12:24 For serious projects: Firebird or PostgreSQL. Regards ---------------------------------------------------------------------- cpalx · 2013-11-14 15:38 i am agree with @exdatis, PostgreSQL and Firebird. Both are great DBMS, but i think PostgreSQL is better. ---------------------------------------------------------------------- bigeno · 2013-11-14 18:08 Just starting work on my new db project but I I can recommend SQLite. Very liberal license, fast, and single file db. ---------------------------------------------------------------------- taazz · 2013-11-14 18:26 1) SQLite is not a database, its an ultra CSV file nothing more. 2) SQLite does not support protected multi process access only single user access and exclusive lock 3) SQLite does not have a server concurrent access, transactions or anything else that a server should have. 4) as for stored procedure, functions, triggers, checks and all the base bells an whistles you find today in all databases SQLite falls lower than Paradox or DBase3 So based on the question SQLite does not qualify for a position on the list. ---------------------------------------------------------------------- bigeno · 2013-11-14 19:12 Quote from: taazz on November 14, 2013, 07:26:09 pm1) SQLite is not a database, its an ultra CSV file nothing more. LOL Quote from: taazz on November 14, 2013, 07:26:09 pm2) SQLite does not support protected multi process access only single user access and exclusive lock 3) SQLite does not have a server concurrent access, transactions or anything else that a server should have. 4) as for stored procedure, functions, triggers, checks and all the base bells an whistles you find today in all databases SQLite falls lower than Paradox or DBase3 Yes, SQLite does not have TCP/IP server,etc. differences are described here http://www.sqlite.org/serverless.html all depends what is needed, if "local/disk" db, then is ok. And SQLite have transactions. Quote from: taazz on November 14, 2013, 07:26:09 pmSo based on the question SQLite does not qualify for a position on the list. I think you have complex to SQLite, not even comparing it to the dbase3 ?! only to CSV ? come one. ---------------------------------------------------------------------- goodname · 2013-11-14 20:37 SQLite is a embedded database engine. It has basic database features such as transactions, views, and triggers as well as advanced features like full text search. It is arguably the most widely used database engine in use today. If you need a embedded database then SQLite should be near the top of your list of choices regardless of open/closed source considerations. Since the original question was about server based engines SQLite does not qualify. http://sqlite.org/famous.html For open source server based database engines I suggest PostgreSQL, Firebird, then MariaDB the MySQL branch. ---------------------------------------------------------------------- taazz · 2013-11-14 21:15 Quote from: bigeno on November 14, 2013, 08:12:24 pmI think you have complex to SQLite, not even comparing it to the dbase3 ?! only to CSV ? come one. Read this http://www.sqlite.org/faq.html#q3 this alone drops SQLite's status from database to data container, there was a document that was explaining the comparison of integers and how it worked in sqlite that it gave the distinct impression that the comparison was string based, but I can't find at the moment. DBase3 supported shared access through lan as well as through multiple applications on the same computer and true data types. I have nothing against SQLite but except the sql commands that it can run it has the same abilities as the typed files in FPC with a custom BTree implementation for indices. If that is all you want then do try to use the ported turbopower btree filer which has true data types and shared access, you will be far better off than with sqlite. Now that I said all that let me remind you the question the original poster made. QuoteWhich database servers are real freeware? SQlite is not a server so even if it had everything I expect from a database today it does not qualify on the grounds of not being a server. ---------------------------------------------------------------------- bigeno · 2013-11-14 21:46 Quote from: taazz on November 14, 2013, 10:15:16 pmRead this http://www.sqlite.org/faq.html#q3 this alone drops SQLite's status from database to data container, there was a document that was explaining the comparison of integers and how it worked in sqlite that it gave the distinct impression that the comparison was string based, but I can't find at the moment. Yes, that is unusual, but if application work with simple data entry based only on edit form controls without "scientific calculations" then in that case, it may some sens at least for compatibility reasons and simplicity, in many cases it is a good solution. Quote from: taazz on November 14, 2013, 10:15:16 pmSQlite is not a server so even if it had everything I expect from a database today it does not qualify on the grounds of not being a server. This word (server) has many meanings, depending on usage ---------------------------------------------------------------------- taazz · 2013-11-14 22:20 Quote from: bigeno on November 14, 2013, 10:46:05 pmYes, that is unusual, but if application work with simple data entry based only on edit form controls without "scientific calculations" then in that case, it may some sens at least for compatibility reasons and simplicity, in many cases it is a good solution. Yes there are valid uses of sqlite including usage embedded systems and mobile devices where space is limited but it can't be used as the main database of any mid or high level application. I guess some types of applications like code librarian todo lists  or even scheduling could be based on sqlite but it will make for a very fat client application. Quote from: bigeno on November 14, 2013, 10:46:05 pmThis word (server) has many meanings, depending on usage  Enlighten me, what are the various server meanings? In my experience server is any software that can serve multiple clients and this usually is done through a tcp/ip stack these days but various protocols can be considered. ---------------------------------------------------------------------- bigeno · 2013-11-14 22:33 Quote from: bigeno on November 14, 2013, 10:46:05 pmEnlighten me, what are the various server meanings? In my experience server is any software that can serve multiple clients and this usually is done through a tcp/ip stack these days but various protocols can be considered. I was thinking more about meanings for the author of this thread, like CIF/NFS/other disk share or localhost, of course you're right that sqlite is not a database "server".  of course I may guess wrong what the author had in mind.