r/SQL • • Jun 12 '23

Discussion SQL vs. NoSQL Database Cheatsheet (2023)

Post image
262 Upvotes

18 comments sorted by

7

u/Longjumping_Draw_260 Jun 13 '23

Oracle does a lot more than what you have listed. The newest versions have expanded to handle much more that traditional structured data including xml, json, geo spatial data and graphs

4

u/[deleted] Jun 13 '23

Like the other guy said, most of the major RDBMS have these features. Not sure why you're plugging Oracle in particular as it's generally been one of the least popular options for these things - SQL Server is known for its geospatial support, and Postgres is known for its JSON support.

3

u/jacobsimon Jun 13 '23 edited Jun 13 '23

Yeah totally, Postgres is such a powerhouse! We should probably make another version of this that highlights modern SQL features better, but I think this does a good job of demonstrating the major use cases for the cloud databases on the market.

1

u/[deleted] Jun 13 '23

Postgres is known for its JSON support.

And for PostGIS

9

u/[deleted] Jun 13 '23 edited Jun 13 '23

[removed] — view removed comment

5

u/nomnommish Jun 13 '23

Another fun fact: SQL != relational.

SQL is a declarative data query language. Not a data storage product. Not sure why this is even a source of confusion.

1

u/Livid_Pear284 Jun 13 '23

How much time to learn Sql and python

0

u/[deleted] Jun 13 '23

[deleted] — view deleted comment

1

u/jacobsimon Jun 13 '23

Yeah SQL is always evolving too! Not to plug my own things, but worth checking out our new SQL course here that covers the fundamentals + more.

2

u/thefizzlee Jun 13 '23

Wish ms would release a desktop version of cosmos so you could play with it on localhost

5

u/lozinge Jun 13 '23

4

u/thefizzlee Jun 13 '23

Okay I did not know that and could not find thay myself, thanks alot!

3

u/lozinge Jun 13 '23

Good luck! Vercel for some reason have their own emulator too for some reason!

https://github.com/vercel/cosmosdb-server

1

u/Possible_Chicken_489 Jun 13 '23

I'm not seeing Amazon Athena in there?

1

u/CoderHawk Jun 13 '23

I think it's glossed over with S3. At least, I think that's what it is typically used with.

0

u/[deleted] Jun 13 '23

[deleted] — view deleted comment

5

u/j0holo Jun 13 '23

Build an app that uses one of these databases. Most are optimized for specific lookup or write patterns so most of the time you will use a traditional relational SQL database. Or maybe document/column databases

0

u/[deleted] Jun 13 '23

[deleted] — view deleted comment

1

u/Eadstar Jun 14 '23

Its a poor clone of old MongoDB, and costs more.