Expert Insights: 10 - Comprehensive Guide

Skip to content

DEV Community

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

StoreFlux

Oct 26

Building a "Sell Anything" Product Catalog in Postgres: JSONB + a Typed Shadow Index

#postgres #database #architecture #ecommerce

6 min read

Oct 26

I built CloudHike: a backend your AI coding agent can set up over MCP

#ai #webdev #postgres #mcp

4 min read

Oct 30

Stop Indexing Boolean Columns in PostgreSQL. Do This Instead.

#postgres #database #sql #performance

3 min read

StoreFlux

Oct 30

JSONB, Dynamic Columns, or a Search Engine — How Do You Store Tenant-Defined Fields?

#discuss #postgres #architecture #database

2 min read

AK D

Oct 26

pg_dump on Supabase: "query would be affected by row-level security policy"

#supabase #postgres #database #backup

2 min read

VLAD

Oct 27

Your database says "saved" before it touches the table. Here's why that's safe.

#database #postgres #sql #backend

5 min read

Oct 27

ChatGPT serves 800 million users from one Postgres primary. Here's how 🐘

#showdev #postgres #systemdesign #database

3 min read

BuiltSafely for BuiltSafely

Oct 26

42501 permission denied for table

#supabase #postgres #security #database

4 min read

Wahyu Andika Putra

Oct 26

Optimasi Arsitektur Database PostgreSQL dan Redis Caching untuk Menangani Beban Jutaan Kueri

#postgres #database #backend #redis

3 min read

Alexandra de Lima Diniz

Oct 30

The last month is always a lie: lessons from querying 1 billion rows of Brazilian crime data

#postgres #dataengineering #opendata #sql

3 min read

Denys Zaichenko for Denys

Oct 26

Supabase 42501 permission denied is a grant problem, not RLS

#database #postgres #security #sql

4 min read

Matt

Oct 26

A strategy game that keeps running while nobody is online

#gamedev #typescript #postgres #architecture

7 min read

Oct 26

All 59 timestamp columns in our schema are without time zone, and the public API still appends a Z

#postgres #typescript #webdev #programming

5 min read

Oct 26

Our updated_at is maintained by the ORM, not the database, and 10 of 25 tables have one

#postgres #typescript #database #webdev

4 min read

Oct 26

Why My Pagination Got Slower Every Page: Field Notes on OFFSET, Keyset Cursors, and Stable Sort Keys

#postgres #webdev #performance #api

7 min read

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