Postgres Page 44 - DEV Community

Skip to content

DEV Community

👋 Sign in for the ability to sort posts by relevant, latest, or top.

kevindev

Oct 19

A REST API State Machine for Email Verification

#backend #restapi #postgres #authentication

5 min read

Oct 19

Our second process carries its own copy of the schema: nine of twelve tables, five of them ever queried, and not one write

#architecture #postgres #node #typescript

5 min read

Oct 19

Our data export contains the log of our data exports, so each copy is one row longer than the last

#privacy #postgres #typescript #webdev

5 min read

Parinita Kapoor

Nov 11

Postgres to Snowflake Replication Without Kafka or Airflow

#backend #data #database #postgres

12 min read

Arbaz

Oct 19

How to Build an IT Asset Assignment and Return System (SQL + REST API)

#programming #backend #postgres #tutorial

11 min read

Oct 19

Our ULID is twenty lines, and the id it generates is deliberately not a secret

#typescript #postgres #security #webdev

7 min read

Oct 19

Drizzle turns a JS array into ($1, $2), so our batch updates were sending Postgres a record cast

#postgres #typescript #database #webdev

5 min read

Son Tran

Oct 19

What Breaks When a Database Diagram Reaches 1,000 Tables, and What We Redesigned

#database #performance #postgres #erd

13 min read

Son Tran

Oct 19

PostgreSQL: Changing an Integer Column to Boolean - In Place or a New Column, and the Four Errors on the Way

#postgres #database #sql #webdev

10 min read

Son Tran

Oct 19

Foreign Keys Between Modules in a Modular Monolith: Keep, Restrict, or Drop?

#postgres #architecture #database #softwareengineering

10 min read

Oct 19

Deleting a discount programme: 930 lines of files, two dropped tables, and a reservation lifecycle nobody needed

#postgres #typescript #webdev #refactoring

4 min read

Oct 19

One jsonb column, and three places where losing it has to be cheaper than losing the score

#postgres #zod #typescript #webdev

4 min read

delay.run

Nov 11

Quick tip: one Postgres advisory lock stops your scheduled job running twice

#postgres #cron #backend #devops

5 min read

Son Tran

Oct 19

PostgreSQL: Cannot Alter Type of a Column Used by a View - How to Change It, and How to Find Every View in the Way

#postgres #database #sql #webdev

9 min read

Bonny Mark

Oct 19

SQL Window Functions, Joins, CTEs and Subqueries: A Hospital Data Guide

#database #postgres #sql #tutorial

25 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.