simscitizenon Hacker News • Recommends
On “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. link to this video
0:00 / 0:00
An Introduction to SQLite
Google TechTalks
349K subscribers • 56 videos on Hallway
- Recommended by 1 person: 1 on Hacker News.
- Presented by Richard Hipp, creator of SQLite
Intermediate. Assumes working knowledge.
80K views19 years ago1 recommendation
Databases and dataSystems programmingSQLiteDatabase internalsC
Richard Hipp introduces SQLite, explaining its history, design as an embeddable C database library, and lessons learned from its development.
Google TechTalks May 31, 2006 Richard Hipp ABSTRACT SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. SQLite implements a large subset of SQL-92 and stores a complete database in a single disk file. The library footprint is less than 250 KB making is suitable for use in embedded devices and applications where memory space is scarce. This talk provides a quick overview of SQLite, its history, its strengths and weaknesses, and describes situations where it is much more useful than a traditional client/server database. The talk concludes with a discussion of the lessons learned from the development of SQLite and how those lessons...Why it's here
1 person recommends thisWhat people say. Recommended as an excellent introduction to SQLite's design and how to build a database engine.
hendleron Hacker News • Mentions
On “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 link to this video
daharton Hacker News • Mentions
On “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 link to this video