squawk
superscribe
| squawk | superscribe | |
|---|---|---|
| 5 | 1 | |
| 479 | 2 | |
| - | - | |
| 6.5 | 3.8 | |
| about 2 months ago | 3 months ago | |
| Rust | TypeScript | |
| GNU General Public License v3.0 only | GNU General Public License v3.0 only |
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.
squawk
- Squawk – A Linter for Postgres Migrations
-
Postgres Language Server: Implementing the Parser
that is definitely the goal, both a formatter and a linter. we want to add something like squawk directly to the language server, so you get eslint-like dx. with the ast and the database schema in the data model, you can basically add any rule you like.
[0] https://github.com/sbdchd/squawk/tree/master
-
Bluesky migrates from pg to single-tenant SQLite
> I wish there were ways to enforce this on the db so you never accidentally grabbed a table lock during these operations.
You can use a linter for PostgreSQL migrations https://squawkhq.com/
-
PostgreSQL 14 Released
We've had good success with https://github.com/sbdchd/squawk to lint migrations. It tells you if a query is going to lock your table (as long as it's written in SQL, not some ORM DSL)
- GitHub has Degraded Availability
superscribe
-
Postgres Language Server: Implementing the Parser
Sure, still a WIP but it's getting there [1]
[1] https://github.com/superscribe-io/superscribe/blob/developme...
What are some alternatives?
zombodb - Making Postgres and Elasticsearch work together like it's 2023
gh-ost - GitHub's Online Schema-migration Tool for MySQL
pgsanity - Check syntax of postgresql sql files
postbird - Open source PostgreSQL GUI client for macOS, Linux and Windows
pg_tm_aux - Transfer manager auxiliary functions
walrus - Applying RLS to PostgreSQL WAL
sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.
patroni - A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
stolon - PostgreSQL cloud native High Availability and more.
postgrest - REST API for any Postgres database
shorty - High-performance link shortener
asn1rs - Generates Rust Code and optionally compatible Protobuf schema files from ASN.1 definitions.