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.
[ Parent
| on HN ]
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.