Yes, exactly as @outlog says. Basically, think about transactions similarly to how you use Elixir maps or other immutable data structures: you apply operations on them and get a mutated copy, as opposed to imperatively mutating them in place. That’s the same with CubDB transactions.
1 Like
doh 
sometimes it doesn’t even help to read the manual 
I was quite sure the problem was somewhere between my chair and the keyboard 
2 Likes
Thank you! 
I knew it was a me problem.
1 Like
You may be happy to learn that as of v3.37 SQLite supports STRICT tables STRICT Tables which will not do this.
1 Like
Yeah I know, thanks for making it visible here.
Sadly I still don’t have time to make my mythical Rust-based strict SQLite Elixir library. Yet.
