PostgreSQL 14 Released

• walrus

  3 100 6.4 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

• postgrest

  42 20,195 8.7 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/

• InfluxDB

  www.influxdata.com

  sponsored

  Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.

  

• pgvector

  14 1,570 7.0 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.

• postbird

  0 1,377 3.2 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]

• beekeeper-studio

  23 12,611 9.6 Vue

  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]

• zombodb

  8 4,299 7.4 PLpgSQL

  Making Postgres and Elasticsearch work together like it's 2022

• Milvus

  37 15,353 9.9 Go

  Vector database for scalable similarity search and AI applications.

  

  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

• Sonar

  www.sonarsource.com

  sponsored

  Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.

  

• pg_tm_aux

  0 32 0.0 C

  Transfer manager auxiliary functions

• nhost

  46 6,381 10.0 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?

• squawk

  0 211 7.6 Rust

  🐘 linter for PostgreSQL, focused on migrations

  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)

• patroni

  6 5,311 8.5 Python

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

  

• stolon

  3 4,115 0.0 Go

  PostgreSQL cloud native High Availability and more.

  

• mongo-java-driver

  0 2,535 9.5 Java

  The official Java driver for MongoDB

  

• pgsanity

  0 286 3.8 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

• SaaSHub

  www.saashub.com

  sponsored

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

  

Suggest a related project