LinuxQuestions.org
Review your favorite Linux distribution.
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


Poll: Database of the Year
Poll Options
Database of the Year

You must log in and have one post to vote in this poll. If you don't have an account, you can register here.
Results will be available after the polls close.

The nominees are:

DB2
Firebird
MariaDB
MySQL
Oracle
Percona
PostgreSQL
sqlite
SQL Server

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,390

Rep: Reputation: 3954Reputation: 3954Reputation: 3954Reputation: 3954Reputation: 3954Reputation: 3954Reputation: 3954Reputation: 3954Reputation: 3954Reputation: 3954Reputation: 3954
Database of the Year


Always a hotly debated topic.

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

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: 103

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,348
Blog Entries: 3

Rep: Reputation: 2640Reputation: 2640Reputation: 2640Reputation: 2640Reputation: 2640Reputation: 2640Reputation: 2640Reputation: 2640Reputation: 2640Reputation: 2640Reputation: 2640
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: 103

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...
 
  


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 04:14 PM.

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