How SQL Database Engines Work, by the Creator of SQLite (2008) [video]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by ryanworl on Sunday June 24, 2018 @03:58PM (#17388110)

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

[ Parent | on HN ]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by _wmd on Sunday June 24, 2018 @09:08PM (#17389277)

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

[ Parent | on HN ]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by netgusto on Monday June 25, 2018 @04:32AM (#17390826)

Detailed explanations start at 26m40s:

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

[ Parent | on HN ]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by okket on Sunday June 24, 2018 @04:05PM (#17388143)

Much better quality, thank you.

[ Parent | on HN ]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by prudhvis on Sunday June 24, 2018 @08:08PM (#17389047)

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?

[ Parent | on HN ]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by codetrotter on Sunday June 24, 2018 @05:54PM (#17388579)

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

[ Parent | on HN ]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by dang on Sunday June 24, 2018 @08:57PM (#17389233)

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

[ Parent | on HN ]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by ryanworl on Sunday June 24, 2018 @09:18PM (#17389324)

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.

[ Parent | on HN ]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by wilburlikesmith on Monday June 25, 2018 @07:31PM (#17396723)

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..

[ Parent | on HN ]

Re:How SQL Database Engines Work, by the Creator of SQLite (... by provlem on Sunday June 24, 2018 @08:11PM (#17389056)

This requires more upvote to remain on top.

[ Parent | on HN ]