sqlschm
bplustree
| sqlschm | bplustree | |
|---|---|---|
| 2 | 2 | |
| 5 | 758 | |
| - | - | |
| 2.4 | 0.0 | |
| about 1 year ago | about 5 years ago | |
| Python | Python | |
| MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqlschm
-
Writing a Python SQL engine from scratch
> The main reason why I ended up building a SQL engine was...just for entertainment. It's been fun learning about all the things
I also wrote an SQL parser [1] for SQLite schema. This was mainly for fun, but also to support the specificities of SQLite schema. I was not happy with the result of other parsers (including sqlglot).
[1] https://github.com/coast-team/sqlschm
-
Open Source SQL Parsers
SQL is a mess. It is difficult to find a parser that fulfills your needs.
A month ago, I needed a parser to parse SQLite schemas. SQLite has some edge case and I needed a lossless parsing to detect these edge cases.
I finally wrote my own parser [1] to fullfill my needs and to have some fun. This is for a POC project.
[1] https://github.com/coast-team/sqlschm
bplustree
-
Writing a Python SQL engine from scratch
Very cool! A while ago I wrote a B+ tree in Python[0] to learn how databases work under the hood. I left it there but it seems that this project could allow me to quickly add full SQL support for it.
[0] https://github.com/NicolasLM/bplustree
-
B-Trees: More Than I Thought I'd Want to Know
I got interested in the topic a few years ago and wrote an implementation in Python[0] for myself. It's just a toy but the funny thing is that I regularly get waves of students staring the repository, probably when a teacher gives a similar assignment.
[0] https://github.com/NicolasLM/bplustree
What are some alternatives?
duckdb - DuckDB is an in-process SQL OLAP Database Management System
btree - a simple python btree
pgsqlite - Load sqlite databases into Postgres databases
sqlglot - Python SQL Parser and Transpiler
tree-sitter-sql - SQL syntax highlighting for tree-sitter
learndb-py - Learn database internals by implementing it from scratch.
lezer-snowsql