Hacker News new | ask | show | jobs
by whalesalad 971 days ago
> One main criticism of Redis had been its lack of support for SQL, the ubiquitous query language. Trollope said that was fixed now. A module RediSQL is available on GitHub.

I think redisql has been supplanted by zeesql - https://zeesql.com/

3 comments

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?

SQL is a query language. It has no real bearing on the underlying implementation.
because it's web scale
No, that's MongoDB. (Not as webscale as /dev/null though)
For those that missed the joke: https://www.youtube.com/watch?v=b2F-DItXtZs
Shards are the secret ingredient in the Web Scale sauce!
SQL 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.

Memory 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.
Ahahah

Author of zeesql/redisql here!

Unfortunately I was not able to figure out a clear business model for the module.

If any of you guys need it also the PRO version, just write me.

Pay $7/month for the license for each index/db after the first 3. I bet oracle ends up being cheaper.