Serializable Isolation level for SQLite Databases

[ClaudeTO80]

Hi all.

I am working on a personal project using DB connection both to SQLite and PostgreSQL. Due to nature of some insert statements, serializable transactions are required.

As far as I understood by reading Poco source code, PostgreSQL session implementation handles all kinds of transactions, while SQLite session implementation handles only Read committed one.
Moreover I read SQLite project documentation and it seems (if I didn't misunderstood) that SQLite handles serializable transactions if proper compile-time and run-time options are used.

I was wondering:

1. if limitations to SQLite transactions in Poco library are due to historical or security reasons
2. should it be possible handling all types of transactions in SQLite session implementation?

Thanks in advance.
Best things.

[aleks-f]

As far as I can remember, the reason for weaker transaction support in SQLite is because nobody so far had a need for those. I see no reason why it shouldn't be supported, but I can't promise when that would be done; you can do the work yourself and send pul request.