3 ms·
I don't understand this. How can you want SQL for something that you are using because it's faster than SQL? If your dataset fits in memory and you want relati
by Xeoncross 3y ago
I don't understand this. How can you want SQL for something that you are using because it's faster than SQL?
If your dataset fits in memory and you want relations then just use PostgreSQL/MySQL. Why would you pick the unique data structures and performance of redis sets/lists/pubsub/HLL and want SQL in front of it?
- rezonant 3y agobecause it's web scale
- MenhirMike 3y agoNo, that's MongoDB. (Not as webscale as /dev/null though)
- Xeoncross 3y agoFor those that missed the joke: https://www.youtube.com/watch?v=b2F-DItXtZs https://www.youtube.com/watch?v=b2F-DItXtZs
- MenhirMike 3y agoShards are the secret ingredient in the Web Scale sauce!
- djbusby 3y agoMemory only sqlite is a (rad) thing. Redis for KV things but one can have a shared, multi GB sqlite thing when you want fast sql things.
- whalesalad 3y agoSQL is a query language. It has no real bearing on the underlying implementation.
- thrixton 3y agoSQL the language of choice for data manipulation, to me at least, although I wonder if I’m one of the dinosaurs after 20+ years. After working with MongoDb, CosmosDb and DynamoDb, I’m very happy to be back in a proper SQL world with Postgres.