News for hackers. Stuff that matters.
Re:How the SQLite virtual machine works by benbjohnson on Wednesday September 07, 2022 @10:48AM (#32751362)
Author here. Thank you for the kind words! I'm glad to hear it's been helpful.
Re:How the SQLite virtual machine works by tpetry on Wednesday September 07, 2022 @11:22AM (#32751840)
Are you still planning to write the article about cases when SQLite is not a good fit? Would be really interesting because we only hear stories when someone believes it is the best fit.
Re:How the SQLite virtual machine works by benbjohnson on Wednesday September 07, 2022 @11:31AM (#32751973)
Yes, I am still planning on writing about when SQLite is not a good fit. Folks on Twitter were helpful in listing use cases where it doesn't well. :)
Re:How the SQLite virtual machine works by orangepurple on Wednesday September 07, 2022 @11:25AM (#32751885)
I am under the impression that sqlite may struggle with many concurrent writers
Re:How the SQLite virtual machine works by samatman on Wednesday September 07, 2022 @11:11AM (#32751684)
I'm having a great time with it. SQLite's documentation is so good that it's difficult to usefully add to it, but you've managed that.

Some else said this, but I'd also love to see a deeper dive into the query plan, if you get to it.

Re:How the SQLite virtual machine works by adamrezich on Wednesday September 07, 2022 @11:14AM (#32751739)
hey, while you're here, the links to the other articles from this one are broken
Re:How the SQLite virtual machine works by benbjohnson on Wednesday September 07, 2022 @11:29AM (#32751950)
Oh shoot, thanks for letting me know. I'm getting them fixed up right now!