Writing a Python SQL engine from scratch

• sqlglot

  56 5,573 9.9 Python

  Python SQL Parser and Transpiler

• sqlschm

  2 5 2.4 Python

  A SQLite Schema Parser

  

> 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

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• bplustree

  2 758 0.0 Python

  An on-disk B+tree for Python 3

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

• pgsqlite

  2 116 1.7 Python

  Load sqlite databases into Postgres databases

  

We (bit.io) use SQLGlot and love it! We use it in our open-source sqlite->postgres tool, pgsqlite:https://github.com/bitdotioinc/pgsqlite, and in our general SQL parser where we can translate between dialects (https://docs.bit.io/docs/query-translation):

```

Suggest a related project