ELI5, why do people still choose to use mongo?
[deleted]
Databases in 2021: A Year in Review
131–136 of 136 posts
Re: Databases in 2021: A Year in Review
#132ELI5, why do people still choose to use mongo?
The continuous availability and horizontal scalability of the distributed system coupled with developer experience--document model, secondary indexes, all of that certainly has captivated a large and growing developer community… you could boil it down to a confluence of ease of use with the advanced capabilities that you may need if you are successful… still they would have petered out if it wasn't for Atlas which makes all of the above that much more accessible
Re: Databases in 2021: A Year in Review
#133Databases 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.
Nonsense. Graph databases pre-date SQL. The relational model was created to overcome the limitations of graph databases.
Re: Databases in 2021: A Year in Review
#134Earlier quoted context omitted.
If you want to be even more overwhelmed, see my encyclopedia of database systems: https://dbdb.io/
Which database do you use to store your database of databases?
Re: Databases in 2021: A Year in Review
#135Earlier quoted context omitted.
Larry Ellison is seriously underestimated as a database leader. I worked at Sybase. Oracle beat us fair and square. The Oracle DBMS team is outstanding.
Didn’t Microsoft take sybase’s customers
Not really--MS SQL Server was Windows only and took a while to grow. Oracle ran everywhere and was simply a better database by the mid-90s. (Previously Sybase was quite far ahead.) Oracle had row-level locking and MVCC at a time when Sybase was still stuck with a cumbersome page locking model. Oracle was also more reliable at least in my experience. I used to hit page corruption pretty regularly on Sybase but almost never on Oracle.
Disclaimer: I worked at Sybase. It was an outstanding company in the early days.
Re: Databases in 2021: A Year in Review
#136Postgres'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…
I wish Postgres was more SQL standards compliant. Stuff like using `nextval()` instead of `NEXT VALUE` in SQL sequences is a pain.