Show HN: I wrote a RDBMS (SQLite clone) from scratch in pure Python

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  1. learndb-py

    Learn database internals by implementing it from scratch.

    Especially the VM part: https://github.com/spandanb/learndb-py/blob/master/learndb/v...

    Compare it with this: https://github.com/sqlite/sqlite/blob/master/src/vdbe.c

    That's said, I'm curious how complete this LearnDB is. SQLite is hard to read not only it's old but also it covers a lot of SQL and following SQL spec makes hings complicated. SQLite has great test suite so it's nice if you run the suit against this implementation.

  2. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  3. CsharpSQLite

    Windows, Linux, Mono C# port of the SQLite library

    Long long time ago someone rewrote/ported SQLite from C to C# -> https://code.google.com/archive/p/csharp-sqlite/wikis/Letter... - note how welcome Dr. Richard Hipp was on the effort!

    Probably here on github -> https://github.com/CsharpDatabase/CsharpSQLite - and possibly some more clones after that.

  4. evadb

    Database system for AI-powered apps

  5. parse

    Monadic parsing for Common Lisp (by massung)

  6. parsec

    A monadic parser combinator library

  7. SQLite

    Official Git mirror of the SQLite source tree

    Especially the VM part: https://github.com/spandanb/learndb-py/blob/master/learndb/v...

    Compare it with this: https://github.com/sqlite/sqlite/blob/master/src/vdbe.c

    That's said, I'm curious how complete this LearnDB is. SQLite is hard to read not only it's old but also it covers a lot of SQL and following SQL spec makes hings complicated. SQLite has great test suite so it's nice if you run the suit against this implementation.

  8. Lark

    Lark is a parsing toolkit for Python, built with a focus on ergonomics, performance and modularity.

    Lark supports, and recommends, writing and storing the grammar in a .lark file. We have syntax highlighting support in all major IDEs, and even in github itself. For example, here is Lark's built-in grammar for Python: https://github.com/lark-parser/lark/blob/master/lark/grammar...

    You can also test grammars "live" in our online IDE: https://www.lark-parser.org/ide/

    The rationale is that it's more terse and has less visual clutter than a DSL over Python, which makes it easier to read and write.

  9. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Oops, I wrote yet another SQLAlchemy alternative (looking for contributors!)

    4 projects | /r/pythoncoding | 8 May 2023
  • Build your next AI Tech Startup with DeepSeek

    6 projects | dev.to | 3 Feb 2025
  • Advice for a friend who wants to start a blog

    3 projects | news.ycombinator.com | 29 Jan 2025
  • Modern Polars – A side-by-side comparison of the Polars and Pandas libraries

    1 project | news.ycombinator.com | 23 Jan 2025
  • The definitive guide to using Django with SQLite in production 💡

    13 projects | dev.to | 18 Jan 2025

Did you know that Python is
the 2nd most popular programming language
based on number of references?