Best of PostgreSQL — April 2024
- 1
- 2
- 3
- 4
- 5
TigerData (Creators of TimescaleDB)·2y
Building the Best PostgreSQL GUI: PopSQL Joins Timescale
Timescale has acquired PopSQL to enhance the PostgreSQL developer experience. PopSQL is a modern SQL editor and visualization tool that supports collaboration, version history, and multiple data sources. Timescale aims to make PostgreSQL the go-to database for developers.
- 6
Dreams of Code·2y
Testcontainers have forever changed the way I write tests
The post discusses how the test containers package has improved the author's testing process by automating the deployment of service containers for integration testing. It explains how test containers can reduce flaky tests and highlights some pre-built modules provided by the package.
- 7
Community Picks·2y
Build and deploy a REST API with Postgres database in TypeScript
This post provides a tutorial on how to build and deploy a REST API with a Postgres database in TypeScript using Encore. It covers topics such as installing Encore, creating REST APIs, using PostgreSQL databases, and deploying to the cloud.
- 8
Stop going to the cloud and getting scammed. $200 infra to serve your startup till 100k monthly users in 15 minutes. Self-hosted Postgres, caddyserver and docker-compose FTW.
This post discusses the drawbacks of relying on the cloud for startup infrastructure and suggests using self-hosted solutions like Postgres, caddyserver, and docker-compose. It provides a step-by-step guide on setting up a self-hosted Postgres instance and demonstrates how to achieve scalability and load balancing using docker-compose. The post also explains how to use Caddyserver as a reverse proxy for automatic SSL management. The setup allows startups to serve up to 100k monthly users at a cost of $200 per month.
- 9
Hacker News·2y
Neon: A New Approach to Database Development
Neon is a new approach to database development that aims to solve scalability and data restoration issues with Postgres. It separates storage and compute, allowing for independent scaling, instant database branching, and fast restore times. Neon is built for modern developers looking to iterate quickly.
- 10
restore 5 times faster?
Learn how to make pg_dump and pg_restore faster using the concept of Parallel Snapshotting. PeerDB's implementation of Parallel Snapshotting enables faster migrations from one Postgres database to another, reducing downtime. Migrating a 1.5TB table took only 7 hours with Parallel Snapshotting, compared to 1.5 days with pg_dump and pg_restore.
- 11
Why PostgreSQL Is the Bedrock for the Future of Data
PostgreSQL is emerging as the de facto database standard due to its rock-solid foundation, versatility, and the ability to replace multiple backend technologies. It offers simplicity, reliability, and scalability, making it a popular choice among developers of all sizes. As everything becomes more computerized, the volume of data and the number of specialized databases has grown, leading to complexity and less development time. PostgreSQL is the solution to these challenges, providing a reliable and versatile platform for developers to build the future.
- 12
- 13
Deno·2y
How we built JSR
JSR is a new JavaScript and TypeScript registry that offers a better experience than npm. It supports publishing TypeScript source code, is secure-by-default, and rates packages using the JSR Score. JSR must meet npm interoperability requirements and uses Postgres for data storage. The jsr.io website is built with Fresh to minimize latency and optimize performance. A modern publishing flow is implemented to simplify package publishing. Reliability is ensured by using Google Cloud infrastructure.
- 14
stackframe-projects/pgmock: In-memory Postgres for unit/E2E tests
pgmock is an in-memory PostgreSQL mock server for unit and E2E tests. It runs entirely within WebAssembly on both Node.js and the browser. You can run it in a browser and it provides a recommended configuration for `node-postgres`. It is considered good practice to destroy the mock server after use. `pgmock` fully supports browser environments.
- 15
Wawandco·2y
Blog: Deploying a Go Application using HTMX and Digital Ocean
This post discusses the process of deploying a Go + HTMX application using Digital Ocean as the cloud platform. It highlights the advantages of Digital Ocean, the steps for deploying the application, and the use of Docker and Postgres. The post also mentions the importance of health checks and creating a database for the application.
- 16
- 17
- 18
Towards Dev·2y
Kafka + NiFi + Clickhouse in Docker PART-I
Learn how to create a data pipeline using Kafka, NiFi, and ClickHouse in Docker. The project involves processing real-time vehicle entry/exit data from multiple parking lots and creating a dashboard for managers and business developers using the stored data.
- 19
