News for hackers. Stuff that matters.
Re:Rearchitecting: Redis to SQLite by meowface on Wednesday September 25, 2024 @11:18AM (#41648460)
Was interested and considering switching until I saw this part:

>According to the benchmarks, Redka is several times slower than Redis.

Still a cool project, don't get me wrong. But this kind of doesn't give me any incentive to switch.

Re:Rearchitecting: Redis to SQLite by anonzzzies on Wednesday September 25, 2024 @11:40AM (#41648630)
We (keydb users; it's much faster than redis for all our cases) use redka for our dev machines; we develop everything on sqlite so there is no install of anything and in prod, we just switch to our mysql, clickhouse, redis etc cluster and it all works while having a light experience for dev.
Re:Rearchitecting: Redis to SQLite by mikeshi42 on Wednesday September 25, 2024 @12:51PM (#41649353)
How are you guys using sqlite in dev instead of clickhouse? (Afaik there's a good bit of difference between the two dialects so I'm surprised it's possible without hurting dx through one compromise or another)
Re:Rearchitecting: Redis to SQLite by anonzzzies on Wednesday September 25, 2024 @03:41PM (#41651094)
We have our own query language based on prolog which compiles to efficient queries depending on the underlying db. We haven't caught any cases for about half a decade where humans could do better queries. We are in a niche market so this is not a catch all solution; it is specifically for our market.
Re:Rearchitecting: Redis to SQLite by pdimitar on Wednesday September 25, 2024 @04:06PM (#41651309)
And I assume you have no intention of open-sourcing that query language and its compiler? Because it sounds pretty awesome...
Re:Rearchitecting: Redis to SQLite by eastern on Wednesday September 25, 2024 @10:45PM (#41654030)
The slowness would be inevitable because the architecture combines the weak point of Redis (network stack) with the weak point of sqlite (disk access).

It abandons Redis' in-memory data and sqlite's in-process speed... for what?