Would you consider implementing server side statements about sqlitex HOT 3 OPEN

I like this idea and have never considered it before. I haven't had a ton of time to work on this project lately, but when i get some time i'd love to take a crack at it. I've added the help wanted tag to it, so anyone reading this in the future should feel free to try their hand at implementing it as well.

from sqlitex.

Hi,

I'm glad that you like the idea!

I will give it a try in the near future too, but I was thinking of writing a complete alternative server module instead of modifying the current one. I am not sure I would not break the current one.

from sqlitex.

I made a proof of concept here with a simple statement cache for well-known queries.

It works in transactions too. Though I changed a little bit the way transactions work in my version, but that should not make a a difference if you want to implement the same thing in the current server implementation. It was because at some point I had a throw in some transaction, and I discovered that throws make a genserver's handle_call return early. I was not aware of that and it took me some time to figure that out.

from sqlitex.