mano78

7 ms·

31.
by mano78 5y ago
I didn't find any concurrency issue; it isn't based on sqlite alone, the underlying layer (go-sqlite3) has a connection pool that I set to 1. I have a test case on this, and it works fine (as far as I can see). If you care to take
32.
by mano78 5y ago
Thanks for the comment. Some great points here. - Precondition: this is a goal, once I find a good balance between allowing to do things and not to reinvent a scripting language. But yes, it's on the roadmap. - Userspace transaction ba
33.
by mano78 5y ago
Performances here https://germ.gitbook.io/ws4sqlite/features/performances , multiple read and writes are serialized under the hood, but concurrency is allowed if the db is in read only mode and WAL is not disabled.
34.
by mano78 5y ago
Very true, thanks. It's on my to-do list.
35.
by mano78 5y ago
Not much different than a remote invocation of any other database (ok, this is more "tool-friendly" so it may open up to more attacks). But your point stands.
36.
by mano78 5y ago
(author) Yes, it's a tradeoff. ws4sqlite was meant to give an unstructured way to access sqlite, that cannot be accessed on the net; while I see PostgREST (a wonderful product that I also use) as a way to implement persistence for a mo
37.
by mano78 5y ago
Author here. This is a pet project of mine, and what a surprise to see on HN! :-) Your discussions on PostgREST and on using SQLite for different use cases are what motivated me for this. So thanks!
38.
by mano78 5y ago
(author) Different use case, but thanks, I'll take a look
39.
by mano78 5y ago
Author here. Thank you for this comment! Yes, it's probably a bad idea at this stage of maturity; there are security provisions put in place, please see https://germ.gitbook.io/ws4sqlite/security and of course nev
40.
by mano78 6y ago
I don't think so: it's open ended indeed, and the wikipedia article I linked matches the latin name
41.
by mano78 6y ago
These are... nespole. I have a tree in my garden and we, in Italy, commonly eat them. A bit disappointed after the intriguing opening of the article. https://it.m.wikipedia.org/wiki/Mespilus_germanica