Skip to content
Hallway
0:00 / 0:00

#sqlite#cmudatabaseology#databasedesign

D. Richard Hipp - SQLite [The Databaseology Lectures - CMU Fall 2015]

CMU Database Group

92K subscribers • 29 videos on Hallway • University channel

YouTube
  • One of the most-watched uploads on CMU Database Group, a conference or university channel Hallway lists. Nobody has recommended it in the communities yet, so it ranks below community picks.
  • Presented by D. Richard Hipp, creator of SQLite

Intermediate. Assumes working knowledge.

40K views10 years ago

Databases and dataSystems programmingSQLiteDatabase internals

D. Richard Hipp discusses the design, history, and internal architecture of SQLite.

D. Richard Hipp (SQLite) More Info: db.cs.cmu.edu/seminar2015/ The Databaseology Lectures (Fall 2015) Carnegie Mellon University Sponsored by Yahoo! Labs

Why it's here

A top upload from a listed channel

CMU Database Group is on Hallway's list of conference and university channels, and this upload is one of its most-watched talks or lectures. Nobody has recommended it in the communities yet, so it ranks below community picks.

u/permeakrain r/compsci • Mentions

On “where do the concepts of "record" and "block" exist in database, filesystem, and disk?”

Yes, database page. I described what it is in the post above. Not sure. They use terminology that at least somewhat different from one I'm familiar with. It is a separate abstraction. ..... I seriously suggest to look into SQLite architecture as an example. It is briefly described here https://www.sqlite.org/arch.html with references to well-commented sources, or you can watch a lecture link to this video . A few DB people I knew suggested it to be an excellent example of RDBMS design that one person can actually comprehend.
1View on Reddit