My DB discovery and the game changer of 2021 was EdgeDB.
Oh wow. Thats what I've been looking for, for years at this point. Thanks for the shout-out, I know what I'm playing with for my next project!
What did you like about it?
Databases in 2021: A Year in Review
21–30 of 136 posts
Re: Databases in 2021: A Year in Review
#22Databases in 2030: SQL DB finally succumbs to Graph DB as #1
Does anyone else feel like a caveman when modeling a many to many relationship in a normalized schema, and then querying via SQL?
I’m surprised graph DBs aren’t more popular for this reason alone. Maybe it’s a far fetched dream, but perhaps a graph frontend can be slapped onto the Postgres backend.
Re: Databases in 2021: A Year in Review
#23I think PostgreSQL in an excellent general purpose solution specially for OLTP usecases but what it lacks behinds is that it's hard to scale horizontally (sharding). There are solutions for this ofcourse with citus but I haven't experimented with it however I have tried MySQL with Vitess which almost seems like dark wizardry. I hope one day vitess works with PostgreSQL.
Re: Databases in 2021: A Year in Review
#24The world moved away from Hadoop and MapReduce… onto what?
Cloud SQL data warehouses like Snowflake and BigQuery.
Re: Databases in 2021: A Year in Review
#25Postgres's dominance is well deserved, of course. My only concerns with it, both are actively worked on, are bloat management (significant for update heavy workloads and programmers used to the MySQL model of rollback segments) and the scaling of concurrency (going over 500 connections). Bloat was taken over by Cybertec[1] after stalling for a bit and is funded (yay), while concurrency was also enhanced out of Micros…
No post body was provided.
Re: Databases in 2021: A Year in Review
#26No post body was provided.
Re: Databases in 2021: A Year in Review
#27So a company that sells PostgreSQL services thinks PostgreSQL is dominating. Brilliant. The reality is that nothing is dominating. In 2021 there were more databases than ever each addressing a different use case. Companies don't have just one EDW they will have dozens even hundreds of siloed data stores. Startups will start with one for everything, then split out auth, user analytics, telemetry etc There is no eviden…
Couple of points: 1. Ottertune doesn't sell PostgreSQL services, they sell a database optimization service that happens to support PostgreSQL (and other databases like MySQL) 2. PostgreSQL is definitely gaining market shares and fast, see the db-engine graph [1], you can compare it to the oracle trend if you are not convinced [2] [1] https://db-engines.com/en/ranking_trend/system/PostgreSQL [2] https://db-engines.com…
[deleted]
Re: Databases in 2021: A Year in Review
#28Earlier quoted context omitted.
Oh wow. Thats what I've been looking for, for years at this point. Thanks for the shout-out, I know what I'm playing with for my next project!
What did you like about it?
I can tell you what I liked about it when I looked, and that's that it seems to allow you to easily encapsulate what your intent as a programmer creating a record to store data is, as well to query it that way. I imagine it obviates some of the reasons reach for ORMs for certain programmatic database needs.
Re: Databases in 2021: A Year in Review
#29The author is a professor at CMU who specializes in databases: https://www.cs.cmu.edu/~pavlo/
Not completely related, but his lectures on databases on YouTube are really good. Much better than the DB class I had at college.
Re: Databases in 2021: A Year in Review
#30So a company that sells PostgreSQL services thinks PostgreSQL is dominating. Brilliant. The reality is that nothing is dominating. In 2021 there were more databases than ever each addressing a different use case. Companies don't have just one EDW they will have dozens even hundreds of siloed data stores. Startups will start with one for everything, then split out auth, user analytics, telemetry etc There is no eviden…
Couple of points: 1. Ottertune doesn't sell PostgreSQL services, they sell a database optimization service that happens to support PostgreSQL (and other databases like MySQL) 2. PostgreSQL is definitely gaining market shares and fast, see the db-engine graph [1], you can compare it to the oracle trend if you are not convinced [2] [1] https://db-engines.com/en/ranking_trend/system/PostgreSQL [2] https://db-engines.com…
they sell a database optimization service that happens to support PostgreSQL (and other databases like MySQL)
A ML program that automatically tunes your production database in real-time. What could possibly go wrong?