News for hackers. Stuff that matters.
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...