[ryanworl]

There is a more recent lecture on the same topic from 2015 at CMU: https://youtu.be/gpxnbly9bz4

[_wmd]

this video is a 100ft overview, original link is about SQL internals

[netgusto]

Detailed explanations start at 26m40s:

https://youtu.be/gpxnbly9bz4?t=26m40s

[okket]

Much better quality, thank you.

[prudhvis]

At 34:30 mark he goes on to say that there are some buggy implementations for mmap. Is that in anyway related to how Linux handles pages marked as free?

[codetrotter]

Mods please update link to this and change title to reflect the year of the replacement video

[dang]

Does it cover the same material though? I don't want to deprive people of the original survey.

[ryanworl]

I don’t think it is worth changing the link. They are not the exact same material and anyone interested in SQLite should just watch both.

[wilburlikesmith]

And wow, there I thought programmers know it all... Best practices, instances and implementations... Suppose we must get a Google / Tesla AI bot to create and write us an effecient and suitable database (plus structure and auto AI joins :p) haha, what do I know...

Hey: @ryanworl wasn't aimed at your comment, you're right, they should watch and learn it all..

[provlem]

This requires more upvote to remain on top.