How the SQLite virtual machine works

Re:How the SQLite virtual machine works by resoluteteeth on Wednesday September 07, 2022 @12:12PM (#32752516)

I'm not sure the problem is the name.

I think there has been a lot of recognition in the last 10 years that sqlite is actually quite robust, but it still hasn't been considered suitable for serious use is based on how software and database servers have traditionally operated.

It seems like what's changing that now is the recognition that other approaches may make more sense given modern software architecture.

[ Parent | on HN ]

Re:How the SQLite virtual machine works by kevincox on Wednesday September 07, 2022 @12:50PM (#32753057)

I don't think stability is the main concern. However for the longest time SQLite didn't have great support for multiple writers and it is still pretty basic. So it works really well for smallish numbers of clients or write-light workloads but if you want to pound it with inserts and updates it still isn't as good of a choice as other RDBMSes.

[ Parent | on HN ]