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.
Optimizing full-text search with Postgres materialized view in Rails

Optimizing full-text search with Postgres materialized view in Rails

6
Comments
6 min read
Yggdrasil and PostgreSQL Notifications

Yggdrasil and PostgreSQL Notifications

7
Comments
2 min read
Knex ❤️ PSQL: updating timestamps like a pro

Knex ❤️ PSQL: updating timestamps like a pro

28
Comments 2
3 min read
Is there a compatibility issue with Postgres and python UUID ?

Is there a compatibility issue with Postgres and python UUID ?

5
Comments
1 min read
Async iterators in JS - database iteration in NodeJS

Async iterators in JS - database iteration in NodeJS

15
Comments
6 min read
Using Domain-Driven Design(DDD)in Golang

Using Domain-Driven Design(DDD)in Golang

192
Comments 26
7 min read
Storing JSON in Postgres using Node.js

Storing JSON in Postgres using Node.js

18
Comments 2
3 min read
How to: use jsonb_set function in PostgreSQL

How to: use jsonb_set function in PostgreSQL

30
Comments 2
1 min read
Update jsonb Columns Using The Rails Active Record Native Methods

Update jsonb Columns Using The Rails Active Record Native Methods

8
Comments 2
1 min read
Fullstack Engineering Mistakes to Avoid

Fullstack Engineering Mistakes to Avoid

120
Comments
16 min read
Intro to Postgres + GraphQL with PostGraphile

Intro to Postgres + GraphQL with PostGraphile

46
Comments 2
9 min read
How to build production-ready application with Django and PostgreSQL

How to build production-ready application with Django and PostgreSQL

26
Comments 2
4 min read
Postgres Arrays: JOIN table with matching ids

Postgres Arrays: JOIN table with matching ids

6
Comments
1 min read
Full Rich Text Search with Slate and PostgreSQL 12

Full Rich Text Search with Slate and PostgreSQL 12

15
Comments 1
3 min read
Database triggers not working

Database triggers not working

9
Comments 2
1 min read
An introduction to Prisma 2

An introduction to Prisma 2

51
Comments 1
14 min read
How to use Change Data Capture (CDC) with Postgres

How to use Change Data Capture (CDC) with Postgres

23
Comments 5
3 min read
Mocking PostgreSQL queries in Node.js

Mocking PostgreSQL queries in Node.js

13
Comments 1
2 min read
What may cause an SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected error mean?

What may cause an SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected error mean?

5
Comments 1
1 min read
Introducing Hasura Pro

Introducing Hasura Pro

8
Comments
4 min read
First steps to caching PostgreSQL queries with Redis

First steps to caching PostgreSQL queries with Redis

61
Comments
5 min read
Postgres For Those Who Can’t Even, Part 2 – Working with Node and JSON

Postgres For Those Who Can’t Even, Part 2 – Working with Node and JSON

16
Comments
14 min read
SQL Story of unbroken chains of events (daily/weekly streaks)

SQL Story of unbroken chains of events (daily/weekly streaks)

21
Comments 2
7 min read
Introduction to Profiling and Optimizing SQL Queries for Software Engineers

Introduction to Profiling and Optimizing SQL Queries for Software Engineers

14
Comments 2
11 min read
Preparing your Postgres data for scale-out

Preparing your Postgres data for scale-out

15
Comments 2
6 min read
loading...