py-mysql-type-plugin
sqlc-gen-python
| py-mysql-type-plugin | sqlc-gen-python | |
|---|---|---|
| 2 | 1 | |
| 0 | 72 | |
| - | - | |
| 5.4 | 6.6 | |
| 26 days ago | about 1 month ago | |
| Python | Go | |
| - | 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.
py-mysql-type-plugin
-
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
sqlc-gen-python
-
Python: Just Write SQL
If you want to try out something cool, check out
https://github.com/sqlc-dev/sqlc
It's written in Go and used to convert sql migrations and queries into a typesafe code that you use access your database.
It currently has a plugin for Python that's in Beta, but what essentially does something similar to what this post is saying.
https://github.com/sqlc-dev/sqlc-gen-python
You write your migrations, and queries and a config file and it does the rest.
What are some alternatives?
pugsql - A HugSQL-inspired database library for Python
powderkeg - Live-coding the cluster!
mini_sql - a minimal, fast, safe sql executor
yesql - A Clojure library for using SQL.
squiller - Generate boilerplate from annotated SQL queries
Sequel - Sequel: The Database Toolkit for Ruby
sqlx - general purpose extensions to golang's database/sql
typed-sql
sql-template-tag - ES2015 tagged template string for preparing SQL statements, works with `pg`, `mysql`, and `sqlite`