News for hackers. Stuff that matters.
Re:Datasette’s new JSON write API: The first alpha of Datase... by fbdab103 on Friday December 02, 2022 @08:00PM (#33839107)
Very satisfied Datasette user here. There is no better way to immediately share structured data with a minimum of infrastructure. I have personally used it on tables with 20-50 million rows without issue.

As hinted in the opening, I am wondering if I could utilize the new API as a low-performance alternative to Redis. All of the SQLite guarantees, easy network access, and optionally backups through Litestream.

Re:Datasette’s new JSON write API: The first alpha of Datase... by simonw on Friday December 02, 2022 @08:19PM (#33839258)
I'd never really thought about it as an alternative for Redis, but yeah if you can handle the huge performance decrease (which for many projects I imagine wouldn't matter in the slightest) that could maybe work pretty well!
Re:Datasette’s new JSON write API: The first alpha of Datase... by fbdab103 on Saturday December 03, 2022 @12:43PM (#33845391)
Heh, well I am a solo developer with very low performance requirements so fewer moving pieces is the name of the game. Redis Just Works, but is yet another thing to manage. I know how to query SQL – I interface with Redis so infrequently I have to lookup the commands every time.

If/when the “library” feature gets incorporated, I could even imagine something crazy like using a library of SQLite databases to handle different backing services. ‘Redis’ cache server, job scheduler, log endpoint. Madness, but these are the idle thoughts before the caffeine has fully circulated.