fileconst
bazel-postgres-sketch | fileconst | |
---|---|---|
2 | 1 | |
3 | 2 | |
- | - | |
0.0 | 0.0 | |
over 2 years ago | over 1 year ago | |
Shell | Go | |
MIT License | Apache License 2.0 |
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.
bazel-postgres-sketch
-
We Went All in on Sqlc/Pgx for Postgres and Go
I uploaded most of our Workspace setup here: https://github.com/jschaf/bazel-postgres-sketch. The tooling is a bunch of Go to manage the Postgres process. Basically, give it schema files and receive a running database with a tear down command.
We make temp instances of Postgres quickly by:
- avoiding Docker, especially on Mac
- keeping the data dir on tmpfs
- Disable initdb cleanup
- Disable fsync and other data integrity flags
- Use unlogged tables.
- Use sockets instead of TCP localhost.
For a test suite, it was 12x faster to call createdb with the same Postgres cluster for each test than than to create a whole new db cluster. The trick was to create a template database after loading the schema and use that for each createdb call.
-
In Praise of PostgreSQL
Sure, here's sketch of how it works: https://github.com/jschaf/bazel-postgres-sketch
fileconst
-
We Went All in on Sqlc/Pgx for Postgres and Go
I like SQL queries as strings but I also like my IDE to syntax check them ... Since there are already so many kinds to projects in this thread I'll happily introduce fileconst which provides the best of both worlds - https://github.com/PennState/fileconst.
What are some alternatives?
goyesql - Parse SQL files with multiple named queries and automatically prepare and scan them into structs.
ccgo
pike - Generate CRUD gRPC backends from single YAML description.
gnorm - A database-first code generator for any language
better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js.
pggen - A database first code generator focused on postgres
proteus - A simple tool for generating an application's data access layer.
SQLBoiler - Generate a Go ORM tailored to your database schema.
pronto - Protobuf ORM
sqlparser-rs - Extensible SQL Lexer and Parser for Rust