Based on feedback in this thread, the official LQ polls continue. Next up, Which Is Your Preferred MySQL Variant?

--jeremy

I generally use MariaDB

Is drizzle even active anymore? Last release was 2 years ago, and the last bug was reported 1/2013.

Edit: They lost corporate sponsorship. They say that it is a spare time project. So,.. Not sure I would use it in production FWIW.

They still consider themselves an active project from what I understand, although both commits and usage seem quite low.

--jeremy

1 members found this post helpful.

Mariadb - is there any other?

1 members found this post helpful.

I've given serious thought to converting to Mariadb, especially now that Oracle has MySql. Just haven't found compelling reasons to do so...yet. I have a couple production servers running MySql, and it gets the job done. I would, however, be willing to consider any encouragement to move to Mariadb. I have a system in development right now, and now would be a good time to switch. Switching my stable production systems would be more effort than I have time for right now.

1 members found this post helpful.

I seriously try to avoid MySQL as much as possible for a lot of reasons, but when I am forced to use it, I prefer MariaDB.

Given that no single database is perfect and all have their annoyances, PostgreSQL is my database of choice when some serious database is required and for simple single-process fast-and-easy stuff, I'd use SQLite.

My preference is standard - MySql

It offers a lot many new features.

I have two headless data base servers, one MariaDB, the other PostgreSQL that sit in a closet mumbling to themselves, doing what they're supposed to do. They're on a pair of Dell Dimension 8400s (now about 10 years old, running Slackware 32-bit stable).

I come from Informix, starting with RDBMS in the early 80's and worked exclusively with Informix on a big Sun farm up until I retired about five years ago and I run Informix, MariaDB and PostgreSQL on my main work station keeping my fingers in the pie -- frankly, Informix is my favorite as a development platform and I tend to build data bases in Informix and then port them to both MariaDB and PostgreSQL (easy enough if you stick to ANSI-SQL standards). Informix turns out to be the easiest development platform I've ever used, MariaDB/MySQL is a good engine but a pain in the butt to work with (in too many ways), PostgreSQL is somewhere between Informix and MariaDB, leaning more toward Informix.

I do a lot of work with C. The MariaDB/MySQL C API is... well, unpleasant might be the word. PostgreSQL comes with a port of Informix' ESQL/C pre processor, ECPG (which simply translates your embedded SQL into C code (lots of structures and pointers and the like), then hands the code off to the compiler. It's simple, it's elegant and it works just fine for me.

But, to the question, I can't tell the difference between MySQL and MariaDB (thanks to Slackware's switch to MariaDB and that everything "just works"). I've had no problems with LAMP, no problems with any incompatibilities, off with the old, on with the new and away you go.

And, no, I do not trust Larry Ellison one teensy tiny bit so I'll stick with MariaDB.

I had a problem with MySQL - it simply wouldn't start. In pure desperation I swapped it with MariaDB as I read somewhere it was it was a drop-in-replacement. Heureka, it worked from the first second. A month or two later openSUSE replaced MySQl with MariaDB anyway and naturally I kept it.

---
Many regards ...
Peter Jespersen
Linux User #221493

“My software never has bugs. It just develops random features ...”

Official MySQL

I usually use MariaDB

PostgreSQL, or SQLite for "lite" duty stuff.

would BusyBox pro as a reply be considered a troll post on this forum?