# spandanb/learndb-py

Learn database internals by implementing it from scratch.

Repository: https://github.com/spandanb/learndb-py
Canonical: https://ross.abutalabs.com/products/learndb-py
Language: Python
License: NOASSERTION
License Family: other
Topics: database
Last push: 2023-08-13T20:28:59+00:00

## Health v2 (maintenance only)
Score: 32/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 1933, "days_push": 1116, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1326, forks 62 (observed 2026-08-28T04:04:22.637726+00:00)

## What it is
LearnDB is an educational project that teaches database internals by guiding users through implementing a simplified SQLite-like relational database from scratch in pure Python. It includes a working RDBMS with a custom SQL lexer/parser, on-disk B-tree storage, and a REPL, but is explicitly not suitable for production storage.

## Use cases
- learn how databases work internally
- implement a relational database from scratch
- study btree storage engine implementation
- understand sql parsing and lexing
- tinker with a simple rdbms codebase
- follow a database internals tutorial

## When to choose
- you want to learn database internals by reading and modifying real code
- you prefer a simple, pure-Python codebase with zero configuration
- you want a guided tutorial plus reference docs for building an RDBMS

## When to avoid
- you need a production-ready database for storing real data
- you need full SQL support like wildcard selects or IEEE754 float arithmetic
- you need Windows support since it relies on fcntl

## Facets
- artifact type: learning-resource
- maturity: maintenance
- function: database, parser, interpreter
- domain: databases, education, developer-tools
- platform: python, cli
- tags: sqlite-clone, btree, sql-engine, learn-by-building, educational-project, linux, macos

## Member repositories
- spandanb/learndb-py (main) score 32

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:22.637726+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T04:46:24.544435+00:00, confidence not recorded.
  - readme: https://github.com/spandanb/learndb-py (fetched 2026-08-28T04:04:22.637726+00:00, sha 4994c356561e)
- Data as of 2026-08-30T08:39:29.467469+00:00.