DEV Community

# postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Yet Another PostgreSQL-REGEX Article 🤺

Yet Another PostgreSQL-REGEX Article 🤺

7
Comments
4 min read
Demystifying Materialized Views in PostgreSQL

Demystifying Materialized Views in PostgreSQL

11
Comments 2
7 min read
Ruby Dive in the C: Make a Ruby-Pg lite extension

Ruby Dive in the C: Make a Ruby-Pg lite extension

4
Comments
4 min read
Ubuntu 20.x, 22.x PostgreSQL 15 Yedekli Yapı - Patroni, ETCD, HA - Patroni Yeni Node Ekleme

Ubuntu 20.x, 22.x PostgreSQL 15 Yedekli Yapı - Patroni, ETCD, HA - Patroni Yeni Node Ekleme

5
Comments
5 min read
Is co-partition or interleave necessary in Distributed SQL?

Is co-partition or interleave necessary in Distributed SQL?

Comments
8 min read
Communicating with PostgreSQL Using LibPQ

Communicating with PostgreSQL Using LibPQ

1
Comments
2 min read
Building a vector similarity search app with Azure AI Vision and PostgreSQL

Building a vector similarity search app with Azure AI Vision and PostgreSQL

Comments
5 min read
@DynamicUpdate with column-level locking in YugabyteDB and how to avoid write skew anomalies

@DynamicUpdate with column-level locking in YugabyteDB and how to avoid write skew anomalies

1
Comments
4 min read
Foreign Key validation in YugabyteDB when created in NOT VALID

Foreign Key validation in YugabyteDB when created in NOT VALID

Comments
4 min read
Simplifying architecture for a hotel management SaaS solution

Simplifying architecture for a hotel management SaaS solution

1
Comments
4 min read
Supercharge Your Rails App: Inserting 1 Million Records in 15s

Supercharge Your Rails App: Inserting 1 Million Records in 15s

13
Comments 3
6 min read
How to use PostgreSQL with Haskell: beam

How to use PostgreSQL with Haskell: beam

Comments
7 min read
How to use PostgreSQL with Haskell: selda

How to use PostgreSQL with Haskell: selda

Comments
5 min read
Postgres Order By: the resultset is sorted differently

Postgres Order By: the resultset is sorted differently

1
Comments
1 min read
Lightweight implementation of Event Sourcing using PostgreSQL as an event store 🚀🕗🔙🕘

Lightweight implementation of Event Sourcing using PostgreSQL as an event store 🚀🕗🔙🕘

26
Comments
2 min read
Database GitOps with Bytebase for PostgreSQL

Database GitOps with Bytebase for PostgreSQL

11
Comments 1
3 min read
Spatial Data in Graph Databases: Geographical Applications

Spatial Data in Graph Databases: Geographical Applications

Comments
2 min read
Graph Databases for Supply Chain Optimization with Apache AGE

Graph Databases for Supply Chain Optimization with Apache AGE

Comments
2 min read
Graph Databases for IoT: Managing Complex Relationships

Graph Databases for IoT: Managing Complex Relationships

Comments
1 min read
Database Horror Stories

Database Horror Stories

Comments
8 min read
Docker Image for YugabyteDB Developers

Docker Image for YugabyteDB Developers

4
Comments
3 min read
PostgreSQL for Time-Series Data: Harnessing Temporal Insights

PostgreSQL for Time-Series Data: Harnessing Temporal Insights

5
Comments
2 min read
Machine Learning: Supervised, Unsupervised, and Semi-Supervised Learning

Machine Learning: Supervised, Unsupervised, and Semi-Supervised Learning

Comments
3 min read
Dockerizing a NestJS app and persisting data

Dockerizing a NestJS app and persisting data

2
Comments
3 min read
Can writes be blocked by reads in YugabyteDB?

Can writes be blocked by reads in YugabyteDB?

Comments
6 min read
loading...