MySql vs Firebird lazarus / 16-Databases ---------------------------------------------------------------------- DeBritto · 2016-12-15 23:48 Hi folks, I know that this could be a relative question, but in terms of internet performance what is the best database MySql or Firebird? Could tell me your experiences? Best regards ---------------------------------------------------------------------- mangakissa · 2016-12-16 07:11 Some people say: MySQL is not a real database. Good with working on websites. If you want to work with transactions, Firebird is yours. It's a standard procedure and for MySQL you have to regulated yourself. I'm working with MySQL with transactions (innoDB) now without problems for several years. Firebird is for me the best way to use it local (embedded). I created a few applications without problemns. Only have to take care of the transactions (but SQLdb alsways uses it and depends on it) ---------------------------------------------------------------------- Girlbrush · 2016-12-16 07:19 Here's a comparison of functionalities http://db- engines.com/en/system/Firebird%3BMySQL%3BPostgreSQL MySQL is fine for websites, otherwise it wouldn't be so widely used. We use Firebird 3.0, because we also need local embedded databases in some locations. It has it's own quirks, and to use the newest version, you might (probably) need commercial components for development. ---------------------------------------------------------------------- Thaddy · 2016-12-16 11:39 Quote from: mangakissa on December 16, 2016, 08:11:41 amSome people say: MySQL is not a real database. Good with working on websites.Yes, 10 years ago or more. Nowadays this is not the case anymore. Old news and incorrect. QuoteIf you want to work with transactions, Firebird is yours. It's a standard procedure and for MySQL you have to regulated yourself. I'm working with MySQL with transactions (innoDB) now without problems for several years. Firebird is for me the best way to use it local (embedded). I created a few applications without problemns. Only have to take care of the transactions (but SQLdb alsways uses it and depends on it) Don't under-estimate Sqlite3 for embedded applications. THAT is the industry standard for embedded, not Firebird. My personal opinion for commercial applications is to NEVER use Firebird, because development knowledge and market penetration lacks a lot. Which makes maintenance by others than me, myself and I expensive or undoable. If I see it suggested, you won't get the job or order. That said: it is a good platform for embedded, it is just not widely used on any serious scale..Even 99% Sqlite to 1% FB doesn't do Sqlite justice. That kind of scale. I have written this many times: if you want to do your customers a favor, stick to the industry standards. People who claim MySQL is only good for websites really live in the past. Archaic opinionated nonsense. ---------------------------------------------------------------------- marcov · 2016-12-16 12:13 Quote from: Thaddy on December 16, 2016, 12:39:45 pmMy personal opinion for commercial applications is to NEVER use Firebird, because development knowledge and market penetration lacks a lot. That rant totally bypasses the fact that this is a Lazarus/FreePascal forum, and Delphi/Lazarus users are much more likely to encounter firebird or interbase than industry average. Personally I avoid Mysql as the plague due to the license shenigans and the client library constantly breaking compatibility. So I settled for Postgres, though at the time that choice was firebird was excluded because it was x86, and I used an old PPC mac as server in our home. ---------------------------------------------------------------------- Groffy · 2016-12-16 12:58 Quote from: DeBritto on December 16, 2016, 12:48:28 am... in terms of internet performance what is the best database MySql or Firebird? The OP didn't aks for embedded. I have absolutely no experience with MySQL but I have a long list in my mind NOT to use it. Starting with who owns it and about the licence model, the numerous engines where (AFAIK) only the InnoDB engine makes something like a RDBMS out of MySQL. The questions is, whether the OP is looking for a database server for a commercial or non commercial application? When looking for a solid open source RDBMS without any licence hassle I personally would look for PostgreSQL or Firebird, where PostgreSQL is more powerful in terms of build in functionality. Its just because the development is several years ahead. Best regards ---------------------------------------------------------------------- valdir.marcos · 2016-12-16 13:57 Quote from: Thaddy on December 16, 2016, 12:39:45 pmI have written this many times: if you want to do your customers a favor, stick to the industry standards. So, you are saying we shoud not use Free Pascal and Lazarus as they are not "industry standards" for programming? http://www.tiobe.com/tiobe-index/ http://spectrum.ieee.org/computing/software/the-2015-top-ten- programming-languages I have been using and seeing many people and companies using dBase, Interbase and then Firebird (since its birth) for the last 30 years here in Brazil. https://en.wikipedia.org/wiki/DBase https://en.wikipedia.org/wiki/InterBase https://en.wikipedia.org/wiki/Firebird_(database_server) Even though Firebird is not the industry standard, we can see many big companies such as Banco do Brasil (considered the biggest bank of Brazil, and the 44th biggest of the world) and Santander Bank (14th biggest of the world) using it: http://exame.abril.com.br/negocios/dos-43-maiores-bancos-do- mundo-3-sao-do-brasil-veja-lista/ http://exame.abril.com.br/negocios/os-20-maiores-bancos-do-brasil-em- valor-de-ativos/ http://www.bb.com.br/portalbb/page56,3766,500584,0,0,1,2.bb?codigoNoti cia=10918&codigoMenu=18831 http://www.santandernegocios.com.br/G4_Gerenciador/asp/G4_CodebaseFire birddll47.asp I don't stick to "industry standards", I believe that we should find the best solution for each need of each client. There is no silver bullet that solves all problems of everybody. ---------------------------------------------------------------------- DeBritto · 2016-12-16 16:54 Hi Folks, Thank you so much for all considerations. My initial concern is about internet speed. My first impression is that Firebird is easier to embed and MySQL faster for web use. ---------------------------------------------------------------------- valdir.marcos · 2016-12-16 23:57 Quote from: DeBritto on December 16, 2016, 05:54:37 pmHi Folks, Thank you so much for all considerations. My initial concern is about internet speed. My first impression is that Firebird is easier to embed and MySQL faster for web use. These two links might help you: http://www.firebirdnews.org/firebird-3-protocol-benchmark/ http://db-engines.com/en/system/Firebird%3BMySQL What do you want to achieve? What kind of application (client/server, multi-tier, web hosted) do you want to build? ---------------------------------------------------------------------- mangakissa · 2016-12-17 07:26 Quote from: marcovPersonally I avoid Mysql as the plague due to the license shenigans and the client library constantly breaking compatibility. Well, I can't use the client library of firebird 3 on firebird 2.5 AFAIK. Isn't that the same? ---------------------------------------------------------------------- Graeme · 2016-12-19 00:24 Quote from: Thaddy on December 16, 2016, 12:39:45 pmQuote from: mangakissa on December 16, 2016, 08:11:41 amSome people say: MySQL is not a real database. Good with working on websites.Yes, 10 years ago or more. Nowadays this is not the case anymore. Old news and incorrect. I'm sorry, but MySQL is still a joke - TODAY. Nothing has changed my opinion from 10 years ago til now. Search this form about my MySQL tests and how ridiculous that "database server" actually is. It's a joke! I wouldn't touch it with a 10 foot pole. edited... To save you the trouble, here is my post. Use Firebird or PostgreSQL instead. http://forum.lazarus.freepascal.org/index.php/topic,20826.msg121187.ht ml#msg121187 ---------------------------------------------------------------------- TraumTaenzerDieter · 2016-12-19 08:10 Just 2 points why I prefer Firebird: 1. the license-policy of MySql 2. in the releases of the 2.5 series you always can use    the latest (svn) client without any problems because    the main thing (ODS) does NOT CHANGE! but you sometimes might have problems with MySql in that place (I often had!) ---------------------------------------------------------------------- JD · 2016-12-19 09:52 SQLite, Firebird & PostgreSQL are my personal favourites. Whenever I meet the MySQL argument (popularity, web standard, cloud presence etc), I just bring out MariaDB or better still PostgreSQL and all debate stops. Concerning MySQL/Maria DB, I've often wondered why a simple installation of the database server has to take almost 1GB of disk space. Firebird 2.5.5 occupies 21MB while PostgreSQL 9.5 occupies 180MB. I've tried them all and apart from MySQL Workbench, I don't see what great advantage MySQL has over PostgreSQL. Whenever I have to work with BIG DATA, I immediately opt for PostgreSQL. SQLite & Firebird have served me well for all other use cases. JD ---------------------------------------------------------------------- Groffy · 2016-12-19 10:06 Quote from: mangakissa on December 17, 2016, 08:26:16 amWell, I can't use the client library of firebird 3 on firebird 2.5 AFAIK. Isn't that the same? Firebird 3 is a new major realease which brings new functionality and a new ODS 12 (on disk structure) of the database file. With every ODS change the suggested procedure is to make a backup (old Firebird server version) followed by a restore (new Firebird server version). Then you are ready to work. Why you are thinking about to use Firebird3 with an old ODS which do not contain the necessary information Firebird 3 needs to work fully fuctional? The release notes for Firebird 3.01 says "A legacy provider for databases with ODS 8 to 11.2 is planned for a future sub-release." I guess that makes only sense to have at least read access for executing the backup release cycle. In my opinion it really makes no sense to use the Firebird 3 Server with a pre ODS 12 database version. Anybody here who knows more reasons? - maybe there are reasons I'm not aware of. With best regards