LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > 2020 LinuxQuestions.org Members Choice Awards
User Name
Password
2020 LinuxQuestions.org Members Choice Awards This forum is for the 2020 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite projects/products of 2020. This is your chance to be heard! Voting ends on February 17th.


Notices


View Poll Results: Database of the Year
DB2 0 0%
Firebird 2 0.91%
MariaDB 117 53.18%
MySQL 17 7.73%
Oracle 2 0.91%
Percona 1 0.45%
PostgreSQL 50 22.73%
sqlite 29 13.18%
SQL Server 2 0.91%
Voters: 220. You may not vote on this poll

Reply
  Search this Thread
Old 12-23-2020, 11:19 AM   #1
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 13,406

Rep: Reputation: 3979Reputation: 3979Reputation: 3979Reputation: 3979Reputation: 3979Reputation: 3979Reputation: 3979Reputation: 3979Reputation: 3979Reputation: 3979Reputation: 3979
Database of the Year


Always a hotly debated topic.

--jeremy
 
Old 12-25-2020, 12:08 PM   #2
YesItsMe
Member
 
Registered: Oct 2014
Posts: 705

Rep: Reputation: 262Reputation: 262Reputation: 262
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.
 
Old 01-06-2021, 03:20 AM   #3
Tux!
Member
 
Registered: May 2011
Location: Netherlands
Distribution: openSUSE
Posts: 108

Rep: Reputation: 32
PostgreSQL is the least annoying, ergo the best.
There is no perfect database.
 
Old 01-06-2021, 05:43 AM   #4
wagnerbianchi
LQ Newbie
 
Registered: Jan 2021
Distribution: Debian
Posts: 1

Rep: Reputation: Disabled
Database of the year

MariaDB.
 
Old 01-06-2021, 05:51 AM   #5
teatime
LQ Newbie
 
Registered: Nov 2004
Location: England
Distribution: Ubuntu
Posts: 5

Rep: Reputation: 0
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!
 
Old 01-06-2021, 06:18 AM   #6
Turbocapitalist
LQ Guru
 
Registered: Apr 2005
Distribution: Linux Mint, Devuan, OpenBSD
Posts: 5,425
Blog Entries: 3

Rep: Reputation: 2691Reputation: 2691Reputation: 2691Reputation: 2691Reputation: 2691Reputation: 2691Reputation: 2691Reputation: 2691Reputation: 2691Reputation: 2691Reputation: 2691
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.
 
Old 01-06-2021, 07:37 AM   #7
Tux!
Member
 
Registered: May 2011
Location: Netherlands
Distribution: openSUSE
Posts: 108

Rep: Reputation: 32
Quote:
Originally Posted by teatime View Post
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.
 
Old 01-11-2021, 07:45 AM   #8
bogeyman2007
Member
 
Registered: Jul 2015
Distribution: Arch, Mint, Gentoo, Tiny Core
Posts: 30

Rep: Reputation: Disabled
Maria... Maria...
 
Old 01-22-2021, 04:08 AM   #9
faisalee
LQ Newbie
 
Registered: Jan 2020
Posts: 2

Rep: Reputation: Disabled
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!
 
Old 01-22-2021, 07:21 AM   #10
Tux!
Member
 
Registered: May 2011
Location: Netherlands
Distribution: openSUSE
Posts: 108

Rep: Reputation: 32
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.
 
Old 01-26-2021, 10:09 AM   #11
dtrivi
LQ Newbie
 
Registered: Jan 2021
Posts: 1

Rep: Reputation: Disabled
Vote : MariaDB
 
Old 01-28-2021, 07:18 AM   #12
wizard_
LQ Newbie
 
Registered: Jan 2019
Posts: 1

Rep: Reputation: Disabled
Quote:
Originally Posted by dtrivi View Post
Vote : MariaDB
Agree
 
Old 02-01-2021, 03:01 PM   #13
shyukri
LQ Newbie
 
Registered: Feb 2021
Posts: 1

Rep: Reputation: Disabled
MariaDB
 
Old 02-02-2021, 03:23 AM   #14
nilnandan
LQ Newbie
 
Registered: Feb 2020
Posts: 2

Rep: Reputation: Disabled
It must be MariaDB
 
Old 02-02-2021, 10:48 PM   #15
goldleviathan
LQ Newbie
 
Registered: Feb 2021
Posts: 2

Rep: Reputation: Disabled
Do any of these work with arm64 on a raspberry pi 4?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Programming (database to database transaction) johncsl82 Programming 7 02-02-2007 09:20 AM
LXer: New Year 2007 - The year of GNU/Linux LXer Syndicated Linux News 0 01-01-2007 04:21 AM
LXer: EE Times Announces Recipients of the Educator of the Year and Student of the Year ACE Awards LXer Syndicated Linux News 0 03-29-2006 03:21 AM

LinuxQuestions.org > Forums > 2020 LinuxQuestions.org Members Choice Awards

All times are GMT -5. The time now is 03:17 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration