What is the best RDBMS and why is it MS SQL Server?

What is the best RDBMS and why is it MS SQL Server?

Pic unrelated

Attached: index.png (259x195, 7K)

Other urls found in this thread:

portal.hdfgroup.org/display/HDF5/HDF5
twitter.com/SFWRedditImages

Just kys pajeet.

You can shit on the street, you do not have to do it here.

Wow, racist much?

I like PostgreSQL, I wish it'd get the following it needs.

you do not matter and never will, streetshitternigger

>PostgreSQL
Postgres shills are rampant.

>Stable
>Runs in the cloud
>Has integrated analytics / AI
>Supported and developed by a corporation and not NEETs

Give me at least one reason not to use it

PostgreSQL is plenty fast, free and stable.

Sure it's not the best at anything, but it's a pretty nice package.

MySQL and MariaDB are pretty good.

Sure, if you want to lose your data, or don't want to do anything more complicated than a SELECT statement.

I learnt on MariaDB, and I think it's definitely one of the easiest RDBMS to use.
I use postgres at work now, which is apparently faster and handles data in a slightly safer way to avoid overwrites; but I'd still be tempted by MariaDB for a small personal project. It's super convenient to setup.

Pajeets prefer Oracle

This. Honestly MS SQL was A-OK for me when using Azure. Otherwise postgres

SQLite

I know. We should be paying exorbitant MS licensing fees instead of using an open source, ANSI SQL, rdbms.

Just don't ask like pg is any good for anything over 100M rows.

Postgres makes the attempt to adhere to standards (muh ACID), whereas others do not.

Tfw Couchbase is bananas for the overwhelming majority of applications, but almost no one mentions it.

Okay retards, here's the definitive tiering:

>Business tier (for when you need a support contract)
MS SQL
>90% Scenarios (use one of these for most projects)
Postgres
MariaDB
>Local Applications (trading ease of deployment for scalability)
Sqlite
>Deprecated tier (migrate from if using)
MySQL
>Radioactive tier (dump at any cost, good luck)
Oracle DB
DB2

Oracle is poison because of the insane licensing and regular "voluntary audits" their marketing department will force on you. They inevitably will determine you're underpaying by hundreds of thousands, and will scam you into buying their cloud shit or whatever.

Why would I bother with anything other than postgres? I don't actually know what the benefit would be. It's not like you're creating 50 different schemas a day and shit, you write your SQL shit once and you're good to go forever

Not sure how Postgres handles it, but I know SQL Server can easily handle analytical queries across 1.4 billion rows on 64 GB RAM and a Xeon1270v6 with SSD SAN storage.

The tables and query design also factor heavily into performance, but I know SQL Server is efficient and reliable. I've never lost a row in several years of this kind of use. That isn't really surprising though. Any database engine worth it's salt shold be as reliable, and most of the big ones are.

>not using a graph database

PostgreSQL is by far the best db system

sqlite3 is best for anything small

>mariadb
sqlite3 is way better. and postgresql is best for anything sqlite3 can't handle
mariadb needs to be dropped and mysql is literally useless

they are now. Mwahahahaha!

RDBMS can suck my balls. Time-series data in HDF5 for the win!

portal.hdfgroup.org/display/HDF5/HDF5

Firebird

Attached: Firebird.png (1024x1024, 81K)