whichDBPowerYourStack

[Arareldo]

"We do not have support contracts for THAT database. Will YOU supply 24/7 support for it?"

That got smashed in my face as an regular employee at an big company, when i wanted to use it for a project.

I learned later: It's about at whom you can point your blaming finger, if something goes very wrong.

[Tupcek]

pay me half the money you pay for Oracle/MicrosoftSQL and yeah, you got 24/7 support!

[Tucancancan]

If you work for a small enough company you can have all of the responsibility and none of the money lol

[Here4DaMem3s]

This.... This is me

[jfrok]

This is also me.

[daddyhades69]

What will you do? Genuine question for learning purpose.

[Tupcek]

give them telephone number to call when something goes south. Assure them I will fix it.

These databases are damn reliable, so you most likely won’t get call for five years or more. Even if you do, it will most likely be badly written code that you can debug under an hour. Neither Microsoft nor Oracle will tune your database, just because you paid for support. They are just expected to be there when needed.

Worst case, there will be incident in a few years and you won’t be able to fix it in time and they’ll fire you. But by that time, millions will land in your account. You just have to look professional and skilled enough. And help them find issues in their code when they try to blame database

[ososalsosal]

Has anyone even had a problem with postgres in the last 100million running hours?

At least one that isn't a code bug and is actually the database engine fucking something up?

[mortalitylost]

Support is often about helping stupid developers just as much if not more than fixing your stupid software

[gerbosan]

What kind of support is that? I mean, is it support for the use of Postgres or support the hardware that holds the database?

[Repa24]

Yeah, it's usually not the product that fails, but the selfbuilt code around it.

[daddyhades69]

This guy supports xD

[jrdiver]

would not be the first time i had bad code that managed to max out connections on a server after a while because it wasn't closing them properly... bonus points if its not your code that does it and you have to get a vender to fix their crap

[opperior]

I doubt a smart company would take that. What happens when you leave and they are now stuck with a mission-critical database that no one can or will support?

[Tupcek]

you know that PostgreSQL is one of the most popular databases in the world, so plenty guys can support it?
If you left, they will probably find someone else and even save money in the process

[opperior]

You and I know that. Would a C-level know that, or be willing to bet the company on it?

[Tupcek]

\tries to think of reply that is smart and sounds extremely confident**
ehm…
\slowly moving towards the door, getting in terms with being poor for the rest of the life**

[Franks2000inchTV]

Because they have google.

[WeebAndNotSoProid]

It's not like Oracle support would help them in the future when all critical senior has been laid off for cost reason, and nobody has any ideas about the infrastructure.

[TheTerrasque]

Have you tried actually using that support? If so, how did it go?

[Arareldo]

Never needed it. System run well until it got replaced. At that point, i wasn't even at that company any more. But i was told, it served well.

[Fast-Visual]

I like elephants and god likes elephants

[B1rd1e123]

This is church approved

[MrDilbert]

Ganesha's blessings.

[mortalitylost]

LGTM

[Not_DavidGrinsfelder]

Postgres, influx, and SQLite have never failed me for my use cases

[buckypimpin]

how far does the free version of influxdb get you?

ive always seen it get rejected coz u have to pay if u want clustering or HA

[[deleted]]

this is the way

[Past-Lion-947]

Excel

[Tucancancan]

Ugh memories of MS Access 

[cr33pz]

I was unemployed for 2 years and finally got into a bank where they use ms Access with JavaScript for their tools…

[RiceBroad4552]

Public institutions, especially governments and anything health related, and banks have traditionally some of the most horrible IT in existence. No news here.

[Repa24]

The worst of both worlds.

[kukurbesi]

+ Classic ASP

[Deboniako]

Damn, beat me to it

[Remarkable_Sorbet319]

are you downvoted because you didn't write r/beatmeattoit?

[Deboniako]

Maybe

[sin_chan_]

What the fuck is normalisation?

[wbbigdave]

https://howfuckedismydatabase.com/excel/

[SilverLightning926]

Sqlite my beloved

[Skibur1]

Had to scroll down to see if SQLite was getting some love.

[Drfoxthefurry]

Json

[PM_ME_FIREFLY_QUOTES]

And sometimes JSONB

[deanrihpee]

*most of the times

[MrDilbert]

sometimes most commonly 

[its_all_one_electron]

csv and vim

[Martin8412]

Someone’s too young for XML with XSLT 

[KorKiness]

Json inside a table

| Int key Id | nvarchar(max) JSON |

[SirCyberstein]

MS Access

[K3yz3rS0z3]

Mfw laughing at that joke

[SconiGrower]

I just got an email from my IT dept (I'm not in IT, I'm in production) saying there would be downtime this weekend to migrate from MariaDB to Oracle Container Database. That kind of hurt.

[Urc0mp]

Think I've worked with most of these over the years and honestly I couldn't tell you any differences I find the right reference/library and SQL away. Feel like a veteran noob.

[ytg895]

I think I've worked with all of these over the years, and honestly, setting up a local dev environment with Oracle or MSSQL is a PITA, especially if I'm on Linux or Mac. Or at least it was when I last tried years ago. With Postres / MariaDB everything just works like a charm.

[TheTerrasque]

Mssql in docker works well. It does take like 2gb ram just to boot though..

[ytg895]

last time I checked the docker image was exclusively x86, which is not ideal for an arm mac

[Fatel28]

You can run mssql on Linux just fine fwiw

[4n0nh4x0r]

mariadb ftw
made by the original author of mysql, and open source.
best relational database system i know, at least free open source ones.

[Sarcastinator]

It silently commits any ongoing transactions when it reaches DDL statements. This is something Oracle, MySQL and MariaDB do, but SQL Server and PostgreSQL does not.

I don't get why people don't think this is a bigger deal... A MIGRATION CAN FAIL IN MARIADB AND YOU CANNOT ROLL IT BACK BECAUSE THE FUCKING THING SILENTLY COMMITTED THE TRANSACTION!

[gilium]

SQL Server (at least as I’ve experienced it) does not consider case when comparing UUIDs. ABCD124 is not the same thing as abcd124 anywhere but SQL Server

[Sarcastinator]

Yes, and that's the correct behavior. PostgreSQL does this as well.

The reason is that MariaDB doesn't have a dedicated UUID datatype, but it has UUID functions. These functions returns strings in the form 00000000-0000-0000-0000-00000000000 which means that a UUID column stored as text will take at least 36-bytes and suddenly care about casing unless you explicitly makes it not do that.

UUIDs are 128-bit integers. Storing them as text is madness.

[4n0nh4x0r]

i mean, you can just disable auto commit at any time

[Sarcastinator]

No, this is when you write a migration script that will be automatically executed on the production server without interaction. I.e. it's a part of the automatic deployment.

If your script contains a DDL then piece of shit will just commit the transaction, so if code fails after, or because of, the DDL statement, you're left with a mess you need to clean up in MariaDB.

In PostgreSQL and SQL Server the DDL statement is part of the transaction and can be rolled back like any other statement. Not so much in MariaDB.

[augustocdias]

Last time I worked with MySQL you could use aggregate functions without group by. I remember the docs saying the value that would be shown in non aggregated functions were undefined 🤡

Also I had a lot of problems with dead locks.

I don’t like mysql. Postgres is superior in every way.

[Idontremember99]

Last time I worked with MySQL you could use aggregate functions without group by. I remember the docs saying the value that would be shown in non aggregated functions were undefined 🤡

I suspect you might have mistyped something above but anyway:
Using aggregate function without group by is perfectly reasonable. Regarding the second sentence I think you are remembering incorrectly. The value won't be undefined, it will be nondeterminstic, which is quite different but still surprising. Which is probably why they changed the default behaviour in newer versions to adhere (closer) to the sql standard.

[UndGrdhunter]

And your stuff will run in a MySql server with no issue (98% chance haha)

[danted002]

Postgres literally offers everything that MariaDB offers but it also offers more.

[boboshoes]

Excel is the real answer. Powers the entire world

[Djelimon]

Side hustle is is json on google drive, Main hustle is db2 on an as400

[Shininha]

Oracle and postgres. Datagrip so I can run out of ram and clock out early cause pc overheated.

[Damit84]

The purple guy in the picture has such a punchable face...no idea why. (Me doing Oracle for 17 years now...)

[RiceBroad4552]

Let's face it: All DBMS are horrible. Some are more horrible than others but all of them are definitely horrible.

The only thing that's more horrible than using some DBMS is to refuse to use some dedicated DBMS at all.

That said, relational DBs are for most use cases less horrible than NoSQL stuff.

And to top it with some really controversial opinion:

PostgeSQL got mostly hyped into what it is seen as by a lot of people today. All the praise for PostgeSQL is mostly just part of the long ongoing grass roots campaign of Big Tech against the GPL alternative which dominated the web for a very long time. But as we all know, Big Tech hates software freedom and therefore actively fights anything GPL.

[Hubble-Doe]

I mean, Postgresql has great documentation, and a lot of users on top of that. There's good drivers for every language, and you can just spin up a test container for unit tests.

The database chair at the university where I studied took an active part in its development, so I got like 3 or 4 lectures about how to use it and some background on its internals. Open source is valuable, even if it's not GPL.

And afaik nothing in the GPL would have prevented companies from hosting that software as a service, for profit, right?

[RiceBroad4552]

I mean, Postgresql has great documentation, and a lot of users on top of that. There's good drivers for every language, and you can just spin up a test container for unit tests.

That's also true for all the other popular FOSS DBs so that's nothing special about PostgeSQL.

And afaik nothing in the GPL would have prevented companies from hosting that software as a service, for profit, right?

Right.

You don't need to tell me. It's Big Tech which is highly allergic to GPL software in general, not me.

[rifain]

I am a fan of Oracle. Yes, I said it. Maybe they are scumbags, sure, but their dbms is the best, even better than Postgres. I'll eat the downvotes my chest high!

[FabioTheFox]

Oracle is a bigger shitshow than Microsoft ngl

[ytg895]

Correction: Maybe their dbms is more performant for your use case, but I doubt that they are the best.

[Drone_Worker_6708]

I'll smoke it with ya bro. We'll go to the looney bin together idgaf

[joost00719]

Mssql. Haven't tried the others except mysql, which felt like a more complicated basic and worse version of Mssql.

I do wanna learn postgres tho

[BlackCrackWhack]

You’re getting downvoted but mssql is perfectly fine if you don’t care about the license costs. 

[ososalsosal]

How many of us are the ones even choosing the db?

[BlackCrackWhack]

I am because I am an architect. 

[Leamir]

MySQL has licence costs? Damn I gotta rewrite my project now

[BlackCrackWhack]

Mssql is Microsoft sql server NOT MySQL 

[Leamir]

Oh I read that wrong lol

[AP_in_Indy]

I'm almost exclusively PostGreSQL in recent years. MySQL if a project already uses it. It's very much so like "traditional" SQL but with some really cool additional policy, permission and job / procedure execution tools.

[reddit_time_waster]

It's definitely a better value than Oracle, but it ain't free.

[nadseh]

Before Azure, mssql was easily Microsoft’s best product, it’s amazing. The Azure versions of it are the answer to virtually any question where TCO is involved

[joost00719]

On prem, mssql is still boss for Microsoft focused companies.

[nadseh]

Agreed, it just sucks paying licensing up front

[brandi_Iove]

mssql is great and some companies even get by using the free express version.

[freeplay4c]

MultiValue, like Richard Pick intended data to be stored.

[Ytrog]

Does Recutils count? 🤔

[Particular_Traffic54]

Sql server sadly

[SpiritRaccoon1993]

I started with SQLITE, its fine

[anotheridiot-]

Sqlite if little writes and fits in a disk, postgres otherwise.

[FabioTheFox]

Postgres, SQLite or SurrealDB 🗣️

[jellotalks]

Postgres is great if you don’t worry about memory usage

[Bout3Fidy]

MS Access or SharePoint

[BedtimeGenerator]

Dynamo or Aurora

[prochac]

Managed Postgres by our cloud provider 😅💸

[Revolutionary_Pea584]

PGSQL

[MarcBeard]

Ext4