sql-parse
Sql parser for rust (by antialize)
py-mysql-type-plugin
Mypy plugin to type sql (by antialize)
sql-parse | py-mysql-type-plugin | |
---|---|---|
1 | 2 | |
16 | 0 | |
- | - | |
6.7 | 5.4 | |
29 days ago | 25 days ago | |
Rust | Python | |
Apache License 2.0 | - |
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.
sql-parse
Posts with mentions or reviews of sql-parse.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-08-22.
-
Parsing SQL
Parsing SQL can solve many problems, but before writing/choosing a parser you need to know what your goal is. For example, at work we wanted to have statically-typed SQL statements in Python/mypy to statically identify syntax errors, misspelled column names and bad type mixes. We came up with a home-grown SQL parser [1] and type checker [2] in Rust and a mypy plugin [3]. If someone knows of other solutions for obtaining SQL/mypy integration I'd love to know about it, since parsing SQL is not exactly supposed to be our field of work.
[1] https://github.com/antialize/sql-parse/blob/7869595aa92aed0b...
py-mysql-type-plugin
Posts with mentions or reviews of py-mysql-type-plugin.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-08-14.
-
Python: Just Write SQL
It's fine advice - if you can type check your queries. My colleague wrote a mypy plugin for parsing SQL statements and doing type checking against a database schema file, which helps to identify typos and type errors early: https://github.com/antialize/py-mysql-type-plugin
- Parsing SQL
What are some alternatives?
When comparing sql-parse and py-mysql-type-plugin you can also consider the following projects:
hasql-th - Template Haskell utilities for Hasql
pugsql - A HugSQL-inspired database library for Python
js-miniquery - SQL Where like filter expression for sequelize
powderkeg - Live-coding the cluster!
go-mysql-server - A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go.
yesql - A Clojure library for using SQL.
sql-type
mini_sql - a minimal, fast, safe sql executor
zetasql - ZetaSQL - Analyzer Framework for SQL
squiller - Generate boilerplate from annotated SQL queries
typed-sql
sql-parse vs hasql-th
py-mysql-type-plugin vs pugsql
sql-parse vs js-miniquery
py-mysql-type-plugin vs powderkeg
sql-parse vs go-mysql-server
py-mysql-type-plugin vs yesql
sql-parse vs sql-type
py-mysql-type-plugin vs mini_sql
sql-parse vs zetasql
py-mysql-type-plugin vs squiller
py-mysql-type-plugin vs typed-sql
py-mysql-type-plugin vs sql-type