pugsql
sqlc-gen-python
pugsql | sqlc-gen-python | |
---|---|---|
3 | 1 | |
663 | 79 | |
- | - | |
0.0 | 6.6 | |
5 months ago | 6 days ago | |
Python | Go | |
Apache License 2.0 | 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.
pugsql
-
Python: Just Write SQL
I've had good experience using PugSQL to write SQL in Python [1]. You write the SQL inside SQL files so you can actually benefit from syntax highlighting, static analysis, etc. At the different of writing strings of SQL inside Python files.
[1] https://pugsql.org
-
Repeating Yourself Thrice Doesn’t Turn You into a 3x Developer
There's a tool called PugSQL that looks promising for Python, but it seems that async isn't directly supported yet[0]. If I ever find time, I'd love to jump on this and make it work, but nobody should hold their breath for that.
[0] https://github.com/mcfunley/pugsql/issues/44
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?
SQLpage - SQL-only webapp builder, empowering data analysts to build websites and applications quickly
mini_sql - a minimal, fast, safe sql executor
yesql - A Clojure library for using SQL.
squiller - Generate boilerplate from annotated SQL queries
powderkeg - Live-coding the cluster!
Sequel - Sequel: The Database Toolkit for Ruby
sqlx - general purpose extensions to golang's database/sql
py-mysql-type-plugin - Mypy plugin to type sql
sql-template-tag - ES2015 tagged template string for preparing SQL statements, works with `pg`, `mysql`, and `sqlite`
sqlz - Simple struct/slice/chan mapper for SQL rows.