PostgreSQL 14 Released

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • Scout APM - Less time debugging, more time building
  • SonarLint - Deliver Cleaner and Safer Code - Right in Your IDE of Choice!
  • OPS - Build and Run Open Source Unikernels
  • walrus

    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

    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/

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

  • pgvector

    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

    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

    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

    Making Postgres and Elasticsearch work together like it's 2021

  • milvus

    An open-source vector database for embedding 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

  • SonarLint

    Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.

  • pg_tm_aux

    Transfer manager auxiliary functions

  • nhost

    Serverless backend for web and mobile apps.

    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

    🐘 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

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

  • stolon

    PostgreSQL cloud native High Availability and more.

  • mongo-java-driver

    The Java driver for MongoDB

  • pgsanity

    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

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts