postgres.md

postgres

Let's learn about Postgres via these 71 free blog posts. They are ordered by HackerNoon reader engagement data. Visit the /Learn or LearnRepo.com to find the most read blog posts about any technology.

A common shorthand for PostgreSQL, a powerful open-source relational database system, widely adopted for its advanced features and data integrity.

1. Using Postgres Effectively in Spring Boot Applications

Spring Boot supports Postgres. Just add dependencies, create a database, connect to it, and create an entity, repository, and controller.

2. Your Guide To Schema-based, Multi-Tenant Systems and PostgreSQL Implementation

There are several architectures that could be followed to achieve multi-tenancy at the database layer.

3. How to Connect Your Bastion Server to a PostgreSQL Server with an SSH Tunnel

In this article, you'll learn how to connect to an RDS server through a bastion server in Bash using an SSH tunnel.

4. PostgreSQL Transaction Isolation Levels with Go Examples

Illustration composed from MariaLetta/free-gophers-pack, original gopher by Renee French.

5. Don’t OFFSET Your SQL Query’s Performance

To implement pagination without unexpected performance issues on large sets of data, use "WHERE id > N" instead of "OFFSET N”.

6. How to Efficiently Generate Test Data With SQL

There are a large number of utilities for generating test data. Here are some examples of using SQL queries to generate test data.

7. Creating a Node.js Server With Postgres and Knex on Express

Learn how to build a robust Node.js server using Express, and connect it to a PostgreSQL database with Knex, in this comprehensive guide.

8. PostgreSQL vs. MongoDB: Evaluating Database Structure, Speed, and More

Choosing a database can be scary as it’s nearly impossible to change once you’ve built on one. So which will you choose? PostgreSQL or MongoDB?

9. How To Create and Load Test Data in PostgreSQL

Learn what tools and approaches are available to create and load test data for webapps without an ORM.

10. How to Securely Backup Your Postgres Database With Docker and Cron

Learn how to automate PostgreSQL database backups with Docker and PostgreSQL. Keep your data safe with this step-by-step guide. #Docker #PostgreSQL

11. From Materialized Views to Continuous Aggregates: Enhancing PostgreSQL With Real-Time Analytics

Discover how PostgreSQL's materialized views have evolved into dynamic, real-time analytical tools called continuous aggregates.

12. Multi-tenant Postgres In The Real World

Back in the days when MySQL was the undisputed open source database champion, there was a sense that people who took their databases seriously would choose PostgreSQL instead. Everyone else chose MySQL; it was fast and it was easy.

13. Postgres TOAST: Understanding the Data Compression Mechanism and Its Limitations

Discover the challenges of PostgreSQL's traditional TOAST mechanism for data compression and storage optimization.

14. PGSync Introduction: Real-time Integration Tool For PostgreSQL And Elasticsearch

PGSync is a change data capture tool for moving data from Postgres to Elasticsearch. It allows you to keep Postgres as your source-of-truth and expose structured denormalized documents in Elasticsearch.

15. PostgreSQL Table Partitioning: Boosting Performance and Management

Partitioning is a powerful way to boost your PostgreSQL performance, but it's not a one-size-fits-all. Learn if PostgreSQL partitioning is a solution for you.

16. How To Decode Django Sessions in PostgreSQL

When solving a problem that requires you to link a user's session data to their actual user object, Postgres comes in handy.

17. Connecting GraphQL with Java Spring Boot and Postgres or MySQL

GraphQL is revolutionising the way developers build APIs. It lets you query precisely what you want. Nothing more, nothing less! It also gives you the flexibility to query related objects in a single round trip, unlike the REST APIs.

18. Introducing Agentic Postgres, the Database for AI Agents

Tiger Data launches Agentic Postgres, the database built for agents. Instant database forks, native vector + BM25 search, MCP for AI agents. Start Free.

19. Streamlining Your Django Development Environment with Docker Containers

Learn how to containerize an entire Django project from the ground up, including a Postgres database, Redis cache server, Caddy, and Celery instances.

20. Django SaaS Architecture: Single-Tenant vs Multi-Tenant - Which Is Right for You?

Single Tenant vs Multi-Tenant SaaS application example using Django

21. How to Stream Data from MySQL to Postgres

Stream MySQL data to PostgreSQL in real-time. Any changes made to your source immediately applies them to the target database.

22. Unlock the Power of ACID Properties in Databases: A Comprehensive Guide for Developers

ACID stands for Atomicity, Consistency, Isolation and Durability and each of these have a specific purpose when it comes to databases.

23. Using a Relational Database to Query Unstructured Data

Using Relational Database to search inside unstructured data

24. Database Connection Pooling With pgbouncer

Introduction: The Postgres Connection Pool Problem

25. Timescale is now TigerData: Building the Modern PostgreSQL for the Analytical and Agentic Era 🐯 🚀

Timescale is now TigerData: the fastest PostgreSQL for AI, analytics & real-time apps. Built for speed, scale & the agentic future. Join us. 🐯🚀

26. Node.js Streams in Action

Ever wondered how streams are working in Node.js? I had. So far I know that using streams will most certainly reduce memory usage on the server when processing large files. Instead of reading whole file into memory we stream it in chunks to whoever requested it and apply transformations to that stream if needed. That's huge benefit as it allows to avoid vertical scaling. Processing files is common task but not as common as interacting with databases and that's going to be my focus now. I'll build simple API with 2 endpoints. Both will be returning large amount of records from Postgres DB. One endpoint will stream data to the client and another will read whole data into memory and return in one chunk.

27. Which Database Is Right For You? HarperDB vs. MongoDB vs. PostgreSQL

The purpose of this article is not to determine which database is the best but to help determine which is a fit for your specific project.

28. How To Create A User Portal On Airtable With Sync Inc And React

In this tutorial, you’ll see how to build a scalable, secure, and flexible client portal on Airtable using Sync Inc, Cotter, and Next.js.

29. Introduction to RDS Proxy: Exploring with Benchmarks in Go

A deep dive into the performance characteristics of RDS Proxy vs RDS

30. An In-depth Look Into MySQL Vs. PostgreSQL

PostgreSQL and MySQL are both reliable, secure and scalable databases that have been around for years.

31. Time For Me To Fly… To Render

Heroku has eliminated their free plans, so I’m migrating to Render for my prototype products and services. Let’s see how easy it is to convert to Render PaaS.

32. PostgreSQL Change Data Capture and Golang Sample Code

PostgreSQL offers Logical Decoding Method to make log-based change data capture possible. Setup and run CDC in several steps.

33. Build a Data-Scraping App Using Puppeteer, Node.js, PostgreSQL and Aptible

How to build a data scrapping application using Puppeteer, Node.js, PostgreSQL, and Aptible.

34. Delhivery’s Data Marts - Migration Journey from OLTP to HTAP

As the leading fulfilment platform for digital commerce in India, Delhivery fulfils a million packages a day, 365 days a year.

35. Building a CRUD App with Node.js, PostgreSQL, and Prisma

Learn how to streamline database management by building a CRUD app with Node.js, PostgreSQL, and Prisma in this comprehensive guide.

36. Percentile Approximation Vs. Averages

Get a primer on percentile approximations and why they're useful for time-series data analysis.

37. Top 12 FAQs About PostgreSQL

PostgreSQL is an open-source, object-relational database management system (ORDBMS) available for all major platforms including Linux, UNIX, Windows, and OS X. It allows you to add custom functions developed using different programming languages such as C/C++, Java, etc. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server.

38. Changing Database Column in Rails 5

While working on a Rails application, we all have had to change the database column in some way. You can change the column name and the column type, as well as changing the column with the type conversion.

39. How To Run PostgreSQL as a Build Requirement in TeamCity Build

We use different Continuous Integration tools in our projects. One of them is TeamCity software. A pipeline for TeamCity can be configured easily and has two steps, such as run tests and build a docker image for further deployment. However, I needed to run Postgres before running tests. I made a research, I read the documentation and this article may be useful to close a gap for team city’s documentation.

40. Securely connect a web app to a remote Postgres database

Learn how to connect a traditional web app to a Postgres database, in a way with requires minimal/no code changes and no firewall management

41. Take your Materialized Views to the Next Level by Joining MySQL and Postgres

42. Enhancing PostgreSQL Backup Efficiency: Leveraging pgBackRest and EBS Snapshot

pgBackRest is awesome, but it can be quite slow. We mitigated this problem via incorporating EBS snapshots to our backup creation/restore strategy for Postgres.

43. Taking a Closer Look into Google's AlloyDB Architecture for PostgreSQL

An exploration of AlloyDB's architecture and design, focussing on its storage engine, with descriptions of how it handles reads and writes

44. A Mistake That Could Cost You Millions: What it Is and How to Fix It

This small golang mistake could cost your business a million-dollar problem. You could easily avoid the mistake read the blog

45. Debugging with Render: Two Effective Methods

When you use Render to deploy your Node.js application with Postgres database, you can debug easily with integrated tools like Datadog and Log Streams.

46. Here's How Developers Can Ensure Sensitive Data Does Not Accidentally Reach Another Device

This tutorial will walk you through how to build a Remix app using Clerk as an authentication layer.

47. How to Build a Decoupled Microservice Using Materialize

One way to handle data in microservice architectures is to use decoupled microservices architecture. This form of architecture can bring many benefits.

48. Location, Location, Location! PostGIS and Heroku Postgres

In this article, I’ll show you how to get a PostGIS-enabled Postgres instance running on Heroku. Then, I’ll run some sample queries on the database,

49. Efficient Database Migration with Dynamic Queries

50. How to Set up a Heroku Postgres Database with Librato

In this article, you will learn how to set up a Heroku Postgres database with Librato for automated monitoring.

51. SQL Data Modification Commands With Examples: A Quick and Simple Guide

In this article, we’ll explore these commands with practical examples.

52. Postgres and MySQL: Performance Comparisson

What workload analysis and running queries can teach us about the performance differences in JSON, indexing, and concurrency.

53. How to Master SQL Joins - Inner, Outer, Cross, and Self-Joins With Examples

In this article, we’ll explore various SQL join types with clear explanations and practical examples.

54. SaaS Database Migration To Heroku Postgres

The next step in my fitness application journey is to migrate to Heroku Postgres. Check out how easy this turned out to be too.

55. 6 Reasons You Should Transition to PostgreSQL from Oracle

As opposed to proprietary solutions (like Oracle), you won’t get locked in with ever-escalating license fees. Here are 6 reasons you should move to PostgreSQL.

56. What is the Significance of Time-Weighted Averages in Data Analysis

Learn how time-weighted averages are calculated, why they’re so powerful for data analysis, and how to use TimescaleDB hyperfunctions to calculate them faster.

57. Finessing Postgres into an Insane 200x Faster Query Plan

This article will show you a real-life optimization story and how PostgreSQL row count estimation can go very wrong when trying to get a faster query plan

58. SQL Databases Vs. NOSQL Databases

The decision to choose a database for project is not that simple. But when it comes to choosing a database, the biggest decisions is picking a relational (SQL) or non-relational (NoSQL) data structure.

59. How to Test Your Postgres Business Logic with Jest Plugin

With great power comes great responsibility and the bigger the project gets the easier it is to break something. Therefore you should test Postgres logic!

60. Tutorial: Build AdonisJS API to store your Raspberry Pi Temperature

In this tutorial we will use AdonisJS to build a simple API that will collect the data from the sensors and store it in a Postgres database

61. Hunting for Customers With PostgreSQL

Now more than ever, you have to hold onto every customer you can. Customers don’t love your product one minute, then fall out of love with it the next. Normally there’s a declining trend in usage of your product over time.

62. I Tried Every Open Source Database and Found Only One That is Actually Useful

Let's walk through this journey. My journey. Maybe it helps someone else avoid the same database-induced headache.

63. How to Add Knex to ExpressJS Apps and Connect to a Postgres Database

Express is one of the most popular JavaScript frameworks for building backend APIs and Postgres is a really popular relational database. How do we connect them?

64. SQL Data Modification Commands With Examples: A Fast and Easy Guide

In this article, we’ll explore these commands with practical examples.

65. Scaling Ory Hydra to Two Billion Monthly OAuth2 Flows on a Single PostgreSQL DB

Ory Hydra is a popular open-source OAuth2 and OpenID Connect server that provides secure authentication and authorization for applications.

66. New WAL Archiving Tool ‘pgrwl’ Delivers Zero Data Loss for PostgreSQL in Containerized Environments

pgrwl enables zero data loss (RPO=0) PostgreSQL backups via streaming WAL archiving, built for containers with S3/SFTP support, compression, and encryption.

67. SQL Recursive Queries - How to Understand Common Table Expressions (CTEs)

This article introduces the WITH clause and demonstrates how recursive CTEs can simplify these operations.

68. Why I Ditched JavaScript and Built a SaaS Stack With HTMX, Go & Postgres That Just Works

I have now built two apps using this stack.

69. Database Monitoring and Alerting with n8n 📡

In the past few months, I have been playing around with different kinds of IoT devices and sensors. I quite enjoy how these can be used to monitor different things like humidity, temperature, pressure among other things in the house. In this tutorial, I want to show you how you can monitor sensor readings in a database and send alerts when it crosses a threshold value using n8n workflows.

70. Log Slow Postgres Query Plans Automatically: An Introduction to auto-explain

Automatically log slow query plans with auto_explain and learn how to fix the problematic PostgreSQL queries that are slowing you down.

71. How to Use Postgres to Recreate YikYak

YikYak was an anonymous social network that used your location to show you posts 5km around you. Users of the app could create new posts and the people around them could view the posts and vote up or down.