An Introduction to SQLite
Channel:Google TechTalks · Length:51:02 · Published:2007-10-09 · Views:80214
Summary
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.
Why HN recommends it
Recommended as a first-hand intro from SQLite's creator that also teaches how a database engine is built.
is actually a pretty good intro on to how to build your own DB engine. — HN, 2016
Subtitles (excerpt)
Let's introduce our speaker today, Dr. Richard Hipp. Richard is the primary author of SQLite, which most of you have heard of. Presumably it's a small open source relational database engine that has really skyrocketed in popularity in the last four or five years. It seems like pretty much every week or two, I hear about a new project either inside Google or outside that's using SQLite. So we're real happy Richard's been able to join us today to tell us more about it. I'll also mention that this talk is been recorded and will actually be available externally. So, if anyone has any questions that involves information confidential to Google, please wait until after the talk to ask Richard individually. Great. -- So, without further ado, Richard Hipp. Hi everybody, my name is Richard and I'm going to give you a brief talk on SQLite. I understand that we have 35 to 40 minutes, so I can't go into a lot of technical details. I'm going to give you a high level overview. Now the way this is normally works is that I have the slides here which if you're lucky it will be roughly correlated to what I'm going to be saying. But -- I must have hit the wrong button here. Got it. So -- Edward, are you left-handed?
On Hacker News
"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. [VIDEO] — simscitizen, 2016-10
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 st… — dahart, 2018-08
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 [VIDEO] — hendler, 2011-04
Related videos
- "Testing Distributed Systems w/ Deterministic Simulation" by Will Wilson · Strange Loop Conference · 40:20
- The Value of Values with Rich Hickey · InfoQ · 31:43
- AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401) · Amazon Web Services · 59:56
- "Turning the database inside out with Apache Samza" by Martin Kleppmann · Strange Loop Conference · 47:42
- Conflict Resolution for Eventual Consistency • Martin Kleppmann • GOTO 2016 · GOTO Conferences · 51:35
- 01 - Course Introduction & Relational Model (CMU Databases Systems / Fall 2019) · CMU Database Group · 1:06:44
- Introduction to NoSQL • Martin Fowler • GOTO 2012 · GOTO Conferences · 54:51
- Rich Hickey rants about HttpServletRequest in 1080p: Death By Specificity from Clojure Made Simple · Fred Overflow · 4:56
- TigerStyle! (Or How To Design Safer Systems in Less Time) by Joran Dirk Greef · TigerBeetle · 1:01:59
- Bryan Cantrill from Joyent on Manta: internet-facing object storage facility that features compute · AI Council · 1:31:05
- Michael Stonebraker | Big Data is (at least) Four Different Problems · Michigan Engineering · 55:53
- "I See What You Mean" by Peter Alvaro · Strange Loop Conference · 52:29
- Zebras All the Way Down - Bryan Cantrill, Uptime 2017 · Code & Supply · 46:36
- ZFS: The Last Word in File Systems Part 1 · Deirdré Straughan · 1:01:26
- Breakout Session Presented by Dan Robinson of Heap at PGConf Silicon Valley 2015 · Citus Data · 54:53
- How We've Scaled Dropbox · Stanford · 1:08:16