squiller
sqlc-gen-python
squiller | sqlc-gen-python | |
---|---|---|
1 | 1 | |
4 | 82 | |
- | - | |
6.3 | 6.6 | |
6 months ago | 14 days ago | |
Rust | 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.
squiller
-
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
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?
yesql - A Clojure library for using SQL.
pugsql - A HugSQL-inspired database library for Python
mini_sql - a minimal, fast, safe sql executor
Sequel - Sequel: The Database Toolkit for Ruby
powderkeg - Live-coding the cluster!
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`
Django - The Web framework for perfectionists with deadlines.
sqlz - Simple struct/slice/chan mapper for SQL rows.