walrus
squawk
walrus | squawk | |
---|---|---|
5 | 5 | |
116 | 454 | |
0.0% | - | |
2.2 | 6.5 | |
5 months ago | about 2 months ago | |
PLpgSQL | Rust | |
Apache License 2.0 | 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.
walrus
-
Realtime: Multiplayer Edition
Wen Bo from the Supabase Realtime team here!
We actually use https://github.com/supabase/walrus to get the database changes and we're planning on moving to a Rust worker (https://github.com/supabase/walrus/tree/worker/worker) for better performance especially in the RLS-enabled use case.
I promised José that I would check out Postgrex.ReplicationConnection and we might add it in to our Supabase Realtime some time in the future.
-
Multiplayer Demo Built with Elixir
[0] https://supabase.com [1] https://github.com/supabase/realtime [2] https://github.com/eulerto/wal2json [3] https://github.com/supabase/walrus [4] https://gsd.di.uminho.pt/members/cbm/ps/delta-crdt-draft16ma... [5] https://supabase.com/blog/2022/04/01/supabase-realtime-with-... [6] https://fly.io [7] https://github.com/supabase/realtime/tree/multiplayer [8] https://github.com/supabase/supabase/tree/master/docker
- Show HN: Multiplayer Demo Built with Elixir
-
PostgreSQL 14 Released
[Supabase cofounder] thanks for the kind words.
We're about to wrap up Row Level Security on our real-time APIs too[0] - soon you'll be able to use Policies universally on all APIs.
[0] https://github.com/supabase/walrus
-
Supabase limitations ? Any reasons not to use?
We are adding this to the database now: https://github.com/supabase/walrus
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
What are some alternatives?
symmetric-ds - SymmetricDS is database replication and file synchronization software that is platform independent, web enabled, and database agnostic. It is designed to make bi-directional data replication fast, easy, and resilient. It scales to a large number of nodes and works in near real-time across WAN and LAN networks.
zombodb - Making Postgres and Elasticsearch work together like it's 2023
pgvector - Open-source vector similarity search for Postgres
gh-ost - GitHub's Online Schema-migration Tool for MySQL
wal2json - JSON output plugin for changeset extraction
pgsanity - Check syntax of postgresql sql files
realtime - Broadcast, Presence, and Postgres Changes via WebSockets
postbird - Open source PostgreSQL GUI client for macOS, Linux and Windows
pg_tm_aux - Transfer manager auxiliary functions
mria - Asynchronously replicated Mnesia-like database for Erlang/Elixir
sqlx - 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite.