pg_tm_aux vs squawk

pg_tm_aux

Transfer manager auxiliary functions (by x4m)

Suggest topics

Source Code

Suggest alternative

Edit details

squawk

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

Rust Postgres SQL Linter Postgresql

Source Code

squawkhq.com

Suggest alternative

Edit details

InfluxDB - Power Real-Time Data Analytics at Scale

Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

www.influxdata.com

featured

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

featured

pg_tm_aux		squawk
	Project
1	Mentions	5
40	Stars	454
-	Growth	-
2.4	Activity	6.5
11 months ago	Latest Commit	about 2 months ago
C	Language	Rust
GNU General Public License v3.0 or later	License	GNU General Public License v3.0 only

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.

pg_tm_aux

Posts with mentions or reviews of pg_tm_aux. 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

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.

Squawk – A Linter for Postgres Migrations
1 project | news.ycombinator.com | 30 Apr 2024
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

What are some alternatives?

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

nhost - The Open Source Firebase Alternative with GraphQL.

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

walrus - Applying RLS to PostgreSQL WAL

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

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

pgsanity - Check syntax of postgresql sql files

mongo-java-driver - The official MongoDB drivers for Java, Kotlin, and Scala

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

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