py-mysql-type-plugin
Mypy plugin to type sql (by antialize)
squiller
Generate boilerplate from annotated SQL queries (by ruuda)
| py-mysql-type-plugin | squiller | |
|---|---|---|
| 2 | 1 | |
| 0 | 4 | |
| - | - | |
| 5.4 | 6.3 | |
| 26 days ago | 6 months ago | |
| Python | Rust | |
| - | 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.
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
squiller
Posts with mentions or reviews of squiller.
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
One challenge working with SQL from statically typed languages (including Python + Mypy) is that you have to convert the query inputs/outputs to/from types and it's a lot of boilerplate. I started an experiment to generate this from annotated queries. [1] Python support is still incomplete, but I'm using it somewhat successfully for using SQLite from Rust so far.
[1]: https://github.com/ruuda/squiller
What are some alternatives?
When comparing py-mysql-type-plugin and squiller you can also consider the following projects:
pugsql - A HugSQL-inspired database library for Python
sqlc-gen-python
powderkeg - Live-coding the cluster!
yesql - A Clojure library for using SQL.
mini_sql - a minimal, fast, safe sql executor
typed-sql
sql-type
py-mysql-type-plugin vs pugsql
squiller vs sqlc-gen-python
py-mysql-type-plugin vs powderkeg
squiller vs yesql
py-mysql-type-plugin vs yesql
squiller vs pugsql
py-mysql-type-plugin vs mini_sql
squiller vs mini_sql
py-mysql-type-plugin vs typed-sql
squiller vs powderkeg
py-mysql-type-plugin vs sql-type
squiller vs typed-sql