LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   2020 LinuxQuestions.org Members Choice Awards (https://www.linuxquestions.org/questions/2020-linuxquestions-org-members-choice-awards-131/)
-   -   Database of the Year (https://www.linuxquestions.org/questions/2020-linuxquestions-org-members-choice-awards-131/database-of-the-year-4175687346/)

jeremy 12-23-2020 10:19 AM

Database of the Year
 
Always a hotly debated topic.

--jeremy

YesItsMe 12-25-2020 11:08 AM

For embedded systems, SQLite is hard to beat. If actual database servers are involved, PostgreSQL is the clear winner in terms of features, scalability, price (sorry Oracle) and performance. I'll choose PostgreSQL because it's what I use the most right now.

Tux! 01-06-2021 02:20 AM

PostgreSQL is the least annoying, ergo the best.
There is no perfect database.

wagnerbianchi 01-06-2021 04:43 AM

Database of the year
 
MariaDB.

teatime 01-06-2021 04:51 AM

MariaDB has every feature the others wish they had and it actually scales, using a plethora of different replication technologies.

* Online schema changes! People always get stuffy about transactional DDL, but it's only for a single server. Where is that transaction running on a scaled solution?
* The columnstore is here for everyone as of 10.5. And now it can back onto bucket storage.
* Xpand/clustrix is still commercial, but it's actually horizonally scalable sql.
* Mariabackup! Learn it, use it, love it.
* You can have your JSON I guess...I prefer dynamic columns.
* Spider and Galera are immense. There are some huge installations of them both from hundres of terabytes per-cluster and beyond.
* InnoDB is now going through a big rewrite, because, you know, the InnoDB guys actually work at MariaDB. They have actually done well to poach a several engineers from the likes of sybase, ms, and ibm over the years. Maxscale didn't happen by accident!

Turbocapitalist 01-06-2021 05:18 AM

Is this only for SQL databases? YottaDB has been doing a lot of interesting things this year and though it is not SQL itself it now has an SQL front-end, Octo since mid-September.

Tux! 01-06-2021 06:37 AM

Quote:

Originally Posted by teatime (Post 6204586)
MariaDB has every feature the others wish they had and it actually scales, using a plethora of different replication technologies.

It also has the worst defaults of all databases I ever worked with, making it extremely hard to migrate existing databases from Windows to Linux or HP-UX.

It also has the worst possible user-management options, which makes me stay away from it as long as possible. dbeaver helps, but still.

bogeyman2007 01-11-2021 06:45 AM

Maria... Maria...

faisalee 01-22-2021 03:08 AM

MariaDB with it's complete solution of HA, Extreme OLTP Scale with Xpand engine, Extreme scale on the OLTP side with ColumnStore engine and MaxScale at the top to bring it all together in a beautiful and the most powerful package that makes it handle every typo of workload that one can throw at it! :)

Tux! 01-22-2021 06:21 AM

I forgot to add that EnterpriseDB is missing from this list, which brings the horrid world of Oracle to be bearable on a PostgreSQL database with the addition of easy db-administration and better support. And it is waaaaaaay cheaper than Oracle.
EnterpriseDB essentially being PostgreSQL under the hood, I'm not asking to add it, but it might be worth adding it next year.

dtrivi 01-26-2021 09:09 AM

Vote : MariaDB

wizard_ 01-28-2021 06:18 AM

Quote:

Originally Posted by dtrivi (Post 6212189)
Vote : MariaDB

Agree

shyukri 02-01-2021 02:01 PM

MariaDB

nilnandan 02-02-2021 02:23 AM

It must be MariaDB

goldleviathan 02-02-2021 09:48 PM

Do any of these work with arm64 on a raspberry pi 4?

danblack 02-03-2021 12:55 AM

Quote:

Originally Posted by goldleviathan (Post 6215387)
Do any of these work with arm64 on a raspberry pi 4?

MariaDB has amd64 support.

danblack 02-03-2021 12:56 AM

Hi Tux,

Quote:

Originally Posted by Tux! (Post 6204639)
It also has the worst defaults of all databases I ever worked with, making it extremely hard to migrate existing databases from Windows to Linux or HP-UX.

I'm struggling to understand how defaults relate to migration (sql_mode?). Do you have time to provide me with more details? Which source databases do you consider here?

Quote:

Originally Posted by Tux! (Post 6204639)
It also has the worst possible user-management options, which makes me stay away from it as long as possible. dbeaver helps, but still.

If dbeaver (feature request 10070) exposed the roles functionality that has been there since 10.0.5 would this be acceptable?

Other notable user-management options that have existed for a while, that can easily get missed are: account locking was added in 10.4.2 and password expiry in 10.4.3. The SUPER privilege was split up in 10.5.2.

With these it looks almost comparable to Postgres in terms of user management features. Or have I missed a key feature that still is required?

Tux! 02-03-2021 02:59 AM

Quote:

Originally Posted by danblack (Post 6215414)
I'm struggling to understand how defaults relate to migration (sql_mode?). Do you have time to provide me with more details? Which source databases do you consider here?

1. On windows file names are case insensative and tables are created the way the user used capitalisation on typing the "create table" SQL command. I've seen more than once that migration to file systems that are not case insensative will FAIL on the ANSI standard the typing table names in SQL commands is ought to be case insensative does not work. Likewise for compiled programs that use all lowercase vs all uppercase in SQL commands.

2. The default installation for mysql was (and I fear still is) prohibits spaces on places that will make end users curse: "select count (*) from foo;" is (was) not allowed in a default installation. (a space between count and (*)). This is for all functions.

So I need to add two lines to /etc/my.cnf to be able to work with MySQL/MariaDB at all

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,IGNORE_SPACE
lower_case_table_names=1

Easy on my own boxes, but not on servers or other peoples boxes

Quote:

Originally Posted by danblack (Post 6215414)
If dbeaver (feature request 10070) exposed the roles functionality that has been there since 10.0.5 would this be acceptable?

Other notable user-management options that have existed for a while, that can easily get missed are: account locking was added in 10.4.2 and password expiry in 10.4.3. The SUPER privilege was split up in 10.5.2.

With these it looks almost comparable to Postgres in terms of user management features. Or have I missed a key feature that still is required?

I *LOVE* DBeaver! It takes away most of my user-management issues for MySQL and Oracle.
Thanks for the extra links, I'm going to store them in my mysql notes

acgx 02-03-2021 08:31 PM

Maria

gus3 02-03-2021 08:52 PM

I vote SQLite, simply because it works out of the box, for all users. No admin privs required, no network setup, it just works.

Pagonis 02-05-2021 07:50 AM

Quote:

Originally Posted by YesItsMe (Post 6199880)
For embedded systems, SQLite is hard to beat. If actual database servers are involved, PostgreSQL is the clear winner in terms of features, scalability, price (sorry Oracle) and performance. I'll choose PostgreSQL because it's what I use the most right now.

PostgreSQL and performance in one sentence? Very cool. Performance is better than in 9.X versions, but query optimizer is still pretty primitive, at least compared to MS SQL Server. On SQL Server I write my query however and it's fast. On PostgreSQL - write however and it's slow, so then google, ask around for every trick imaginable - way faster than initial quickly written query, still slower than SQL Server.

YesItsMe 02-07-2021 11:16 AM

You can even write inefficient code in Assembly... ;-)

actionhanky 02-09-2021 03:42 AM

MariaDB

gadnium 02-09-2021 11:00 AM

Gotta vote for MariaDB

Sgi 02-17-2021 05:56 AM

MariaDB agree
 
Quote:

Originally Posted by wagnerbianchi (Post 6204582)
MariaDB.

Yes agree MariaDB

danblack 02-17-2021 10:33 PM

Quote:

Originally Posted by danblack (Post 6215413)
MariaDB has amd64 support.

Blah, meant to say arm64 support. And armhf/armel are packaged by Debian and others.

dr-m 02-18-2021 12:06 AM

Quote:

Originally Posted by danblack (Post 6221530)
Blah, meant to say arm64 support. And armhf/armel are packaged by Debian and others.

Not all ARMv8 (Aarch64) are created equal. All currently supported MariaDB server releases should work on the Raspberry Pi. Early 10.5 releases crashed on 64-bit Raspberry Pi models, but that was addressed by https://github.com/MariaDB/server/pull/1645.


All times are GMT -5. The time now is 01:34 AM.