3 ms·
I see the idea of sql lite, but a mysql / Postgres store a lot in memory so no disk access required (if not the data the indexes stay memory resident) We have
by acomjean 3y ago
I see the idea of sql lite, but a mysql / Postgres store a lot in memory so no disk access required (if not the data the indexes stay memory resident)
We have an old web based tool that uses Java and luncene indexed file system based database. It’s a pain to work with frankly.
https://lucene.apache.org/ https://lucene.apache.org/
- dham 3y agoTrue but the new hotness is edge and your database can be really far from where you actually deploy. This is what this article is trying to push back against. Mainly because Kent is all about Remix and Remix is more about just deploying to traditional servers.
- willsmith72 3y agoremix is actually great for the edge. Lots of people run it on cloudflare workers in particular https://remix.run/docs/en/main/guides/performance#this-website--flyio https://remix.run/docs/en/main/guides/performance#this-websi...
- _joel 3y ago> We have an old web based tool that uses Java and luncene indexed file system based database. It’s a pain to work with frankly. Elasticsearch waves
- RedShift1 3y agoNote that your operating system caches file system reads so SQLite doesn't need to put anything extra in RAM. Most reads will be from RAM, so no disk access required.