SQLite Forum

Can Richard do some YouTube videos explaining transaction implementation?
Login
> Does googling for "how do database transactions work?" not tell you what you're wanting to know?

No because SQLite is embedded so the implementation details are different from a typical server db (that implements isolation by controlling all the clients in a central process).

I'm more interested in how SQLite implements transactions specifically.

I think Richard could also provide a lot of historical context as to why it was implemented the way it was.

> and it seems a shame to waste time documenting, in a "permanent" video, any internal implementation details

Well, commenting and writing code isn't "wasting time", so I would consider the video as code comments encoded in video and audio. Also the time spent is work towards the goal of supporting SQLite until 2050 - any programmers working on the code base could watch the video.