Provide easy to use buffer for writes

[timClicks]

SQLite does not support concurrent writes. It would be great if erlang-sqlite3 provided an easy-to-use queue that INSERT commands could be sent to via multiple processes, but that would be written sequentially to the database...

[alexeyr]

The gen_server process is already acting like such a buffer. Do you mean that you call sqlite3:open (or start_link) multiple times for the same database? Or that you want an async API for writing to the database in addition to the current one?

[timClicks]

An async API would be really nice.

[alexeyr]

In this case, pull requests are welcome :) Otherwise, I'll add it eventually, but I am not sure when I'll have time. Do you just want fire-and-forget or for a message to be sent when the write is done? I'd prefer the second option (and it's easy to ignore the reply if you don't need it).