Best of PostgreSQL — December 2022

1. 1
   Article

   Community Picks·3y

   The complete guide to System Design in 2022

   System Design is the process of defining the architecture, interfaces, and data for a system that satisfies specific requirements. System design meets the needs of your business or organization through coherent and efficient systems. The complete guide to System Design Interview in 2022 is available.

   220

   9
2. 2
   Article

   freeCodeCamp·3y

   How to Build Your Own SaaS – PagerDuty Clone

   Ania Kubów creates popular software tutorials on both the freeCodeCamp channel and her own channel. In this course, Ania will teach you how to build a dashboard to let you know if your app is down. This is a clone of the popular software as a service app called PagerDuty.

   89

   1
3. 3
   Article

   Hacker News·3y

   Just Use Postgres for Everything

   Use Postgres for everything is a tradeoff, says Stephan As a CTO, Interim CTO and CTO Coach. Postgres can replace - up to millions of users - many backend technologies, such as Kafka, RabbitMQ, Mongo and Redis among them.

   73

   4
4. 4
   Article

   Supabase·3y

   What's new in Postgres 15?

   The Postgres community released version 15 (stable) in October 2022. The permission model is more secure permission is revoked from all users except the database owner. It makes permission assigning more tunable ( details) Sorting rows of data is a frequent operation inside the Postgres code.

   60

   1
5. 5
   Article

   Supabase·3y

   New Supabase Docs, built with Next.js

   New Supabase Docs, built with Next.js, are a new version of Supabase's documentation tool. For a developer tool, documentation is more than a resource - it’s part of the product. For the past two years at Supabase, this part of our product hasn't been great.

   40
6. 6
   Article

   Supabase·3y

   graphql v1.0

   pg_graphql is a Postgres extension that allows you to query your database using GraphQL. It is the foundation of GraphQL support in the Supabase stack. Since our first platform release, v0.2.1, the feature set of Postgres has steadily grown and stabilized.

   37

   1
7. 7
   Article

   DZone·3y

   The Right Database for You Project's Success

   The Right Database for You Project's Success Maximize Your Project's success with the Right Database Selection Learn the key considerations for choosing the right database for your project. The database management system is chosen depending on the tasks of the business.

   30

   3
8. 8
   Article

   TigerData (Creators of TimescaleDB)·3y

   12 Days of PostgreSQL Tools and Projects

   PostgreSQL was voted this year’s most loved database in the Stack Overflow Developer Survey. The open-source enterprise relational database has over 35 years of active development. We have surveyed it, contributed to it, encouraged others to do the same, and even commented on it. We put together a list of 12 database extensions.

   22
9. 9
   Article

   Pointer·3y

   HydrasDB/hydra: The open source Snowflake alternative. OLAP Postgres

   Hydra is an open source data warehouse built on Postgres. Hydra serves analytical reporting with parallelized query execution and vectorization on columnar storage. Hydra Docker image is a drop-in replacement for postgres Docker image. You can also try out Hydra locally using docker-compose.

   13