Anko SQLite, a library to simplify working with SQLite on Android

Re:Anko SQLite, a library to simplify working with SQLite on... by asdfjklasdfjkl on Thursday September 21, 2017 @11:39AM (#15304542)

I'm running into a weird case where even within an application, concurrency has become relevant because of parallel processing that the application wants to do over the data stored in the database.

But, our desire for both simplicity and obscenely low latency means that SQLite is still the better choice for us at the moment. In the future, though, I can see robust concurrency support being important even in single application use-cases.

[ Parent | on HN ]

Re:Anko SQLite, a library to simplify working with SQLite on... by eropple on Thursday September 21, 2017 @11:49AM (#15304639)

If you're in-process, though, you can just lock when you need exclusive access to the datastore.

[ Parent | on HN ]

Re:Anko SQLite, a library to simplify working with SQLite on... by asdfjklasdfjkl on Thursday September 21, 2017 @12:14PM (#15304939)

Ideally, I'd have several separate threads each with fine grained (table-level, maybe even row-level with deferred index updating) control on reading and writing. I admit that I haven't gone sufficiently down this path to know exactly what I'd want though, as it isn't the top priority right now. (We are "fast enough" without concurrency, ... for now.)

[ Parent | on HN ]