How the SQLite virtual machine works

Re:How the SQLite virtual machine works by gigatexal on Wednesday September 07, 2022 @03:59PM (#32755915)

How often is attach really used though?

[ Parent | on HN ]

Re:How the SQLite virtual machine works by chasil on Wednesday September 07, 2022 @04:34PM (#32756431)

How often are distributed transactions used elsewhere with two-phase commit?

All the time. I suspect this is similar.

[ Parent | on HN ]

Re:How the SQLite virtual machine works by gigatexal on Wednesday September 07, 2022 @05:52PM (#32757493)

Right but that’s bending SQLite a lot no? I mean it’s meant to be used as a file that has a sql interface. But I digress.

[ Parent | on HN ]

Re:How the SQLite virtual machine works by taberiand on Thursday September 08, 2022 @01:40AM (#32761606)

I wonder how many times SQLite has been passed over for a more complex solution because people thought they needed highly scalable distributed two phase commit or whatever when all they really needed was a file with an SQL interface

[ Parent | on HN ]

Re:How the SQLite virtual machine works by gigatexal on Friday September 09, 2022 @04:59AM (#32776992)

I'm guessing your response was sarcastic. I don't get it, though. If you need a distributed two-phase commit DB get one like CockroachDB or something like that. SQLite is not that.

[ Parent | on HN ]