simscitizenOct 2016Recommends
"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
in “Ask HN: What's your favorite tech talk?” · View on HN
An Introduction to SQLite
An Introduction to SQLite on HackerTube: recommended by 1 Hacker News commenter across 1 month, 2011–2018.
Google TechTalks
Open on YouTubetalk · intro · 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.
Why Hacker News recommends it
Recommended as a first-hand intro from SQLite's creator that also teaches how a database engine is built.
- people recommended it
- 1
- separate months
- 1
- strong recommendations
- 0
- discussed on HN
- 2011–2018
“is actually a pretty good intro on to how to build your own DB engine.”
What HN commenters said
3 Hacker News comments link this video. Each one links back to its thread.
dahartAug 2018Cites it
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
in “Ask HN: Codebase at my work is a complete mess, what should I do?” · View on HN
hendlerApr 2011Cites it
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
in “IndexedDB has much to learn from SQLite” · View on HN