squawk vs pgsanity

squawk

🐘 linter for PostgreSQL, focused on migrations (by sbdchd)

Source Code

squawkhq.com

Suggest alternative

Edit details

pgsanity

Check syntax of postgresql sql files (by markdrago)

Suggest topics

Source Code

Suggest alternative

Edit details

Our great sponsors

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

SaaSHub - Software Alternatives and Reviews

Our great sponsors

squawk		pgsanity
	Project
4	Mentions	1
454	Stars	306
-	Growth	-
6.5	Activity	0.0
about 2 months ago	Latest Commit	10 months ago
Rust	Language	Python
GNU General Public License v3.0 only	License	MIT License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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

Posts with mentions or reviews of squawk. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-12-08.

Postgres Language Server: Implementing the Parser
5 projects | news.ycombinator.com | 8 Dec 2023

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
2 projects | news.ycombinator.com | 6 Nov 2023

> 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
14 projects | news.ycombinator.com | 30 Sep 2021

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
3 projects | news.ycombinator.com | 12 Mar 2021

pgsanity

Posts with mentions or reviews of pgsanity. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-09-30.

PostgreSQL 14 Released
14 projects | news.ycombinator.com | 30 Sep 2021

I used pgsanity at the CLI for a while when I had coding and testing split between two machines. Can be used with any editor. https://github.com/markdrago/pgsanity

What are some alternatives?

When comparing squawk and pgsanity you can also consider the following projects:

zombodb - Making Postgres and Elasticsearch work together like it's 2023

postgrest - REST API for any Postgres database

gh-ost - GitHub's Online Schema-migration Tool for MySQL

postbird - Open source PostgreSQL GUI client for macOS, Linux and Windows

pgvector - Open-source vector similarity search for Postgres

pg_tm_aux - Transfer manager auxiliary functions

nhost - The Open Source Firebase Alternative with GraphQL.

walrus - Applying RLS to PostgreSQL WAL

patroni - A template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes

sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.

beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.