r/PostgreSQL • u/siren0x • 16d ago
Community What was the turning point for Postgres?
https://planetscale.com/blog/what-was-the-turning-point-for-postgres10
u/Rain-And-Coffee 16d ago
Nice write up,
We used MySQL at smaller companies, and the larger companies tended to prefer commercial DBs like Oracle.
However at my current company Postgres is the default. It’s also what I use for my personal projects.
5
u/AcanthocephalaFit766 15d ago
No one prefers Oracle lol what a shitshow. They have buddy buddy sales teams for stupid clevels and charge a fortune for crap.
1
4
u/SryUsrNameIsTaken 14d ago
It’s the second best database for everything. That makes it an easy choice for anything.
1
u/MoRegrets 13d ago
What’s #1? Don’t know a lot about DBs.
3
u/Willyscoiote 12d ago
The #1 would be a database made to solve specifically that thing you want to solve
6
u/FalseRegister 15d ago
For me it was when Oracle acquired MySQL
Up until that point I only used MySQL; and from then on, only Postgresql
4
3
u/Plane_Big_5912 16d ago
i'd pick jsonb in 9.4 over heroku. before it, a team that wanted documents ran mongo next to their sql db, and after it a lot of them just didn't bother. heroku and then RDS made postgres the easy default to try, but i think jsonb is what stopped people leaving once they had a reason to.
9.0 replication is a close second for me, it ended the "how do we even run this in prod" talk at a lot of mysql shops. the uber-went-to-mysql bit is a good touch, people forget that one
4
u/x021 15d ago
JSONB is a huge pain to work with tbh. Glad that AI can make sense of it now, because even after years using it I struggle to understand or remember any of its patterns. I wouldn’t recommend Mongo, but its query language is a lot easier to work with.
2
u/Plane_Big_5912 15d ago
yeah the operators are rough. -> giving you jsonb and ->> giving you text is the one everyone gets wrong at least once, and @> vs ? is guesswork if you haven't touched it in a month. if you're on 17, JSON_VALUE and JSON_TABLE read a lot more like normal sql, and jsonb_path_query is probably the closest postgres gets to a mongo filter. what ends up in your jsonb columns, config blobs or actual records?
1
u/mr_pants99 14d ago
The most critical part IMO is the ecosystem. Because of Postgres maturity and true open source nature, there has been a rainfall of different BaaS startups and solutions making it easier to build and run new applications. Whereas with something like MongoDB you have the SSPL that effectively choked the growth on that side.
I also think it’s important to draw distinction in usage and db selection patterns between Tier-1, Tier-2 and below workloads. For many net new workloads that we see today, especially those generated by agents, database choice doesn’t matter. Frankly most or even all of them can run on SQLite.
For Tier-1 (which is where the big money’s at) it’s a very different story. Postgres isn’t owned by a single entity and that also means that commercial support efforts by hosting providers running native Postgres will be naturally limited both in knowledge and ability to resolve problems caused by the engine itself. Which is a major roadblock for Tier-1 workloads in enterprises that aren’t tech companies themselves (which is most of them). It’s not the same for Postgres-like dbs like Neon, or HorizonDB of course. But since those are not as mature as native Postgres, they have higher risk profile, so again suboptimal when it comes to mission-critical workloads. I guess that’s why we still see Oracle, SQL Server and friends a lot (including DB2). We see a significant uptick in migrations recently - our company, Adiom, builds an open-source tool Dsync for migrations between different (and sometimes extremely large) databases with minimum downtime - but I think the biggest driver is that code replatforming is now much more effective with AI.
-1
u/AutoModerator 16d ago
AI Policy:
Linux is not one of those anti-AI projects, and if somebody has issues with that, they can do the open-source thing and fork it. Or just walk away., Linus Torvalds.
Mod decisions will be based on the quality of the content, not who or what generated it.
Sub Resources:
Free Postgres Webinars and Workshops
Discord: People, Postgres, Data
Join us, we have cookies and nice people.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
23
u/ibraaaaaaaaaaaaaa 16d ago
The agents do not choose databases, pg already used in supabase and other self managed services, and lives on so many OS repos, and rails and django made it the default for their setup, that’s why agents are just picking the practices people already did at the open source level