Conversation

Notices

1. Embed this notice
   Alex Gleason (alex@gleasonator.com)'s status on Wednesday, 27-Mar-2024 02:44:23 JST Alex Gleason
   Fun fact, SQLite is faster than an in-memory database with 1000 events for _certain_ queries.
   • Sexy Moon likes this.
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Wednesday, 27-Mar-2024 02:45:07 JST Alex Gleason

     in reply to
     Query by kind is much worse than I thought, though.
   • Embed this notice
     Sexy Moon (moon@shitposter.club)'s status on Wednesday, 27-Mar-2024 02:49:15 JST Sexy Moon

     in reply to
     @alex I am using SQLite for all my side projects now.
     Alex Gleason likes this.
   • Embed this notice
     Martti (mar77i@gleasonator.com)'s status on Wednesday, 27-Mar-2024 02:50:17 JST Martti

     in reply to

     @alex in-memory, is that SQLite :memory:? Or mappings native to the programming language? I can imagine SQLite's indexing being very efficient.

   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Wednesday, 27-Mar-2024 02:50:17 JST Alex Gleason

     in reply to

     • Martti
     @mar77i I should say, an in-memory SQLite with :memory: is faster than iterating all values in a LRUCache (which has a Map-like interface) for _some_ queries.
   • Embed this notice
     djsumdog (djsumdog@djsumdog.com)'s status on Wednesday, 27-Mar-2024 03:09:34 JST djsumdog

     in reply to

     • Sexy Moon
     There's also DuckDB:
     
     https://duckdb.org/
     Sexy Moon likes this.
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Wednesday, 27-Mar-2024 03:55:53 JST Alex Gleason

     in reply to

     • Sexy Moon
     • djsumdog
     @djsumdog @Moon What's the story behind this? Why haven't I heard of this before? Is this a fork of SQLite? Why? Is the performance good? Why did they make this?
   • Embed this notice
     Alex Gleason (alex@gleasonator.com)'s status on Wednesday, 27-Mar-2024 03:57:12 JST Alex Gleason

     in reply to

     • Sexy Moon
     • djsumdog
     @djsumdog @Moon It seems like the same niche as SQLite but slower and you can do a bunch of queries I would never do.
   • Embed this notice
     djsumdog (djsumdog@djsumdog.com)'s status on Wednesday, 27-Mar-2024 04:39:31 JST djsumdog

     in reply to

     • Sexy Moon
     I discovered it a while back and it seems like they wanted to make an sqlite like thing with better query support. I used it in a side project but got frustrated with library support and there were some other issues I found while trying to store binary data. Not sure if it's gotten better; just throwing it out there as an alternative if anyone wants to look at it.
     Sexy Moon and Alex Gleason like this.