Multi-threaded SQLite without the OperationalErrors (2017)

Re:Multi-threaded SQLite without the OperationalErrors (2017) by siscia on Thursday May 30, 2019 @02:27AM (#20048879)

I use a similar approach in RediSQL (http://RediSQL.com, fats in-memory SQL on redis protocol).

There is a single thread that reads from a queue of statement.

The downside is that is hard to hold a lock on the db while doing application level operations, but that is a really advanced use case that I see rarely on the wild.

[ Parent | on HN ]

Re:Multi-threaded SQLite without the OperationalErrors (2017) by le-mark on Thursday May 30, 2019 @10:42AM (#20051642)

Redisql sounds interesting, are you getting any customers/tranction?

[ Parent | on HN ]

Re:Multi-threaded SQLite without the OperationalErrors (2017) by siscia on Thursday May 30, 2019 @11:02AM (#20051910)

Thanks!

Some, not as much as I would hope. Definitely still need a job!

I believe is a quite though sale, there are many open source databases that you can use for free, but very few (if any?) offer in-memory as first class feature.

And databases are worse than marriages, quite difficult to migrate out so a new player need to sell itself very well before to even be considered.

If you are interested, or you would like to consider some form of partnership feel free to drop me few lines at [email protected]

[ Parent | on HN ]