HackerTube
HomeLongsLikedHistoryWatch laterCategoriesPlaylistsSettings

An Introduction to SQLite

Google TechTalks1 HN recommender · recommended in 1 month, 2011-2018
YouTube
80K views · 19 years ago · talk · dated

A 2006 Google TechTalk in which SQLite's author Richard Hipp introduces the embeddable, zero-configuration C database library. He covers its history, strengths and weaknesses, and where it beats client/server databases.

Recommended as a first-hand intro from SQLite's creator that also teaches how a database engine is built.

Databases & storage#sqlite#embeddeddatabases#sql#databaseengines#googletechtalk

3 comments from Hacker News

@dahart2018 · in “Ask HN: Codebase at my work is a complete mess, what should I do?”

First start writing automated tests, for example Selenium & unit tests. You'll learn what all the code does, you'll learn a new skill, you'll have a safety net of regression tests for rewriting the code, and you'll be adding value to the company. If you have good test coverage, you'll be able to rewrite the code very quickly. There are a ton of resources for how and why to do testing. One that stands out in my mind is SQLite. They've talked about being able to refactor the core of their engine in a weekend, only because they had the test coverage to know they did it right. link link ▶ this video

CitesView on HN
@simscitizen2016 · in “Ask HN: What's your favorite tech talk?”

"An Introduction to SQLite" by Richard Hipp (who wrote the library) is actually a pretty good intro on to how to build your own DB engine. ▶ this video

RecommendsView on HN
@hendler2011 · in “IndexedDB has much to learn from SQLite”

I've also worked with SQLite, and one project was the using the C API. It's also why I really liked Google Gears. Here's the Google Tech Talk on SQLite from 2006 ▶ this video

CitesView on HN
SQLite: The Database at the Edge of the Network with Dr. Richard Hipp59:58

SQLite: The Database at the Edge of the Network with Dr. Richard Hipp

Method
82K views • 11 years ago
SQLite: Protégé of PostgreSQL39:00

SQLite: Protégé of PostgreSQL

Andrea Ross
8K views • 12 years ago
Introduction to NoSQL • Martin Fowler • GOTO 201254:52

Introduction to NoSQL • Martin Fowler • GOTO 2012

GOTO Conferences
1M views • 13 years ago
01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)1:06:44

01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019)

CMU Database Group
248K views • 7 years ago
How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder50:31

How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder

Devoxx
55K views • 9 years ago
Event Sourcing • Greg Young • GOTO 201454:25

Event Sourcing • Greg Young • GOTO 2014

GOTO Conferences
102K views • 11 years ago
Rust at speed — building a fast concurrent database52:54

Rust at speed — building a fast concurrent database

Jon Gjengset
225K views • 7 years ago
Avi Bryant demos Dabble db8:37

Avi Bryant demos Dabble db

Tavis Rudd
5K views • 14 years ago
"Datafun: a functional query language" by Michael Arntzenius42:31

"Datafun: a functional query language" by Michael Arntzenius

Strange Loop Conference
9K views • 9 years ago
Rich Hickey: Deconstructing the Database1:06:24

Rich Hickey: Deconstructing the Database

InfoQ
106K views • 14 years ago
AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)59:56

AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)

Amazon Web Services
468K views • 7 years ago
Modern SQL: A lot has changed since SQL-92 by Markus Winand55:06

Modern SQL: A lot has changed since SQL-92 by Markus Winand

Devoxx
6K views • 8 years ago
Greg Young - CQRS and Event Sourcing - Code on the Beach 20141:03:48

Greg Young - CQRS and Event Sourcing - Code on the Beach 2014

Code on the Beach
170K views • 12 years ago
Richard Hipp - Git: Just Say No1:01:15

Richard Hipp - Git: Just Say No

southeastlinuxfest
16K views • 11 years ago
AWS re:Invent 2019: [REPEAT 1] Amazon DynamoDB deep dive: Advanced design patterns (DAT403-R1)59:13

AWS re:Invent 2019: [REPEAT 1] Amazon DynamoDB deep dive: Advanced design patterns (DAT403-R1)

AWS Events
115K views • 6 years ago
Dabble DB demo6:46

Dabble DB demo

krueggen
10K views • 19 years ago
DuckDB – The SQLite for Analytics (Mark Raasveldt, CWI)1:08:01

DuckDB – The SQLite for Analytics (Mark Raasveldt, CWI)

CMU Database Group
28K views • 6 years ago
NYC Tech Talk Series: How Google Backs Up the Internet1:14:19

NYC Tech Talk Series: How Google Backs Up the Internet

Google TechTalks
41K views • 12 years ago
Lucas Cavalcanti & Edward Wible - Exploring four hidden superpowers of Datomic40:42

Lucas Cavalcanti & Edward Wible - Exploring four hidden superpowers of Datomic

ClojureTV
29K views • 11 years ago
"Turning the database inside out with Apache Samza" by Martin Kleppmann47:43

"Turning the database inside out with Apache Samza" by Martin Kleppmann

Strange Loop Conference
205K views • 12 years ago