sqlschm
A SQLite Schema Parser (by coast-team)
pgsqlite
Load sqlite databases into Postgres databases (by bitdotioinc)
| sqlschm | pgsqlite | |
|---|---|---|
| 2 | 2 | |
| 5 | 116 | |
| - | 1.7% | |
| 2.4 | 1.7 | |
| about 1 year ago | about 1 month ago | |
| Python | Python | |
| MIT License | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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
Posts with mentions or reviews of sqlschm.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-03.
-
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
pgsqlite
Posts with mentions or reviews of pgsqlite.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-03.
-
Writing a Python SQL engine from scratch
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):
```
- pgsqlite: a pure python module to import sqlite databases into postgres
What are some alternatives?
When comparing sqlschm and pgsqlite you can also consider the following projects:
duckdb - DuckDB is an in-process SQL OLAP Database Management System
tree-sitter-sql - SQL syntax highlighting for tree-sitter
lezer-snowsql