PostgreSQL 14 Released

1. walrus

   1 5 126 6.8 PLpgSQL

   Applying RLS to PostgreSQL WAL (by supabase)

   

   [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

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. postgrest

   2 112 25,249 9.5 Haskell

   REST API for any Postgres database

   

   [supabase cofounder] While we position ourselves as a Firebase alternative, it might be simpler for experienced techies to think of us as an easy way to use Postgres.

   We give you a full PG database for every project, and auto-generated APIs using PostgREST [0]. We configure everything in your project so that it's easy to use Postgres Row Level Security.

   As OP mentions, we also provide a few additional services that you typically need when building a product - connection pooling (pgbouncer) object storage, authentication + user management, dashboards, reports, etc. You don't need to use all of these - you can just use us as a "DBaaS" too.

   [0] https://postgrest.org/

4. pgvector

   3 110 15,502 9.4 C

   Open-source vector similarity search for Postgres

   

   I recall seeing some library that adds vector search to Postgres. Maybe https://github.com/ankane/pgvector?

   Also there's Pinecone (https://www.pinecone.io) which can sit alongside Postgres or any other data warehouse and ingest vector embeddings + metadata for vector search/retrieval.

5. postbird

   4 1 1,575 0.0 JavaScript

   Open source PostgreSQL GUI client for macOS, Linux and Windows

   

   I've been trying out Beekeeper Studio [https://www.beekeeperstudio.io/] recently, and like that it supports both MySQL and PostgreSQL (and others I don't use). The interface takes a little bit to get used to, but it's been pretty powerful for me.

   Before that, or when I'm in a rush to just get something done as I adjust to Beekeeper, I use Postbird (an Electron app) [https://github.com/Paxa/postbird]

6. beekeeper-studio

   5 65 18,798 9.9 TypeScript

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

   

   I've been trying out Beekeeper Studio [https://www.beekeeperstudio.io/] recently, and like that it supports both MySQL and PostgreSQL (and others I don't use). The interface takes a little bit to get used to, but it's been pretty powerful for me.

   Before that, or when I'm in a rush to just get something done as I adjust to Beekeeper, I use Postbird (an Electron app) [https://github.com/Paxa/postbird]

7. zombodb

   6 23 4,736 7.0 PLpgSQL

   Making Postgres and Elasticsearch work together like it's 2023

   

8. Milvus

   7 125 34,578 10.0 Go

   Milvus is a high-performance, cloud-native vector database built for scalable vector ANN search

   

   I need a self managed solution, so I'm not sure Pinecone is feasible and I don't think pgvector scales well enough for my use-case (hundreds of millions of vectors).

   So far I think I'm going to go with Milvus[1], ideally I'd just have a foreign data wrapper for Milvus or FAISS.

   [1] https://github.com/milvus-io/milvus

9. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

10. pg_tm_aux

    8 1 45 5.0 C

    Transfer manager auxiliary functions

    

11. nhost

    9 89 8,536 9.6 TypeScript

    The Open Source Firebase Alternative with GraphQL.

    

    Supabase looks nice. I’m also using Postgres hosted by https://nhost.io/ which also do auth and storage. It looks like Supabase is focused on REST and Nhost is focused on GraphQL?

12. squawk

    10 7 734 7.9 Rust

    🐘 Linter for Postgres migrations & SQL

    

    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)

13. patroni

    11 24 7,327 8.9 Python

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

    

14. stolon

    12 9 4,726 0.9 Go

    PostgreSQL cloud native High Availability and more.

    

15. mongo-java-driver

    13 1 2,634 9.3 Java

    The official MongoDB drivers for Java, Kotlin, and Scala

    

16. pgsanity

    14 1 317 0.0 Python

    Check syntax of postgresql sql files

    

    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

17. SaaSHub

    www.saashub.com featured

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    

Suggest a related project