pike
bazel-postgres-sketch | pike | |
---|---|---|
2 | 2 | |
3 | 307 | |
- | - | |
0.0 | 0.0 | |
over 2 years ago | almost 2 years 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
pike
-
ImagineAI: A code generator that turns your app spec into a Node project
I've also taken a shot at a similar thing (no GUI though!) https://github.com/sashabaranov/pike
-
We Went All in on Sqlc/Pgx for Postgres and Go
> - Write custom query language (YAML or other), generate SQL schema, queries, and Go query interface (xo).
I've also tried to unify this approach with gRPC/Protobuf messages and CRUD operations: https://github.com/sashabaranov/pike/
What are some alternatives?
goyesql - Parse SQL files with multiple named queries and automatically prepare and scan them into structs.
rules_nixpkgs - Rules for importing Nixpkgs packages into Bazel.
better-sqlite3 - The fastest and simplest library for SQLite3 in Node.js.
gnorm - A database-first code generator for any language
proteus - A simple tool for generating an application's data access layer.
sqlparser-rs - Extensible SQL Lexer and Parser for Rust
SQLBoiler - Generate a Go ORM tailored to your database schema.
ccgo
pronto - Protobuf ORM
sqlc - Generate type-safe code from SQL