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.
Paginating hybrid search on Postgres, and why the obvious fix is worse
pavangupta352 profile

Paginating hybrid search on Postgres, and why the obvious fix is worse

#postgres #sql #database #search
Comments
4 min read
How I Ran the Full Supabase Stack Locally in 100 MB of RAM (No Docker)
chris_fa_8fca9f4ba09d963 profile

How I Ran the Full Supabase Stack Locally in 100 MB of RAM (No Docker)

#supabase #postgres #docker #localdev
Comments
4 min read
I Designed Multi-Tenancy Wrong. Then I Fixed It Before It Mattered.
eu_ti_f127c5b5d7535b7174f profile

I Designed Multi-Tenancy Wrong. Then I Fixed It Before It Mattered.

#architecture #postgres #saas #python
Comments
3 min read
Inside PostgreSQL MATCH Queries: Syntax, Paths, and Parameters with pg_igraph
ineron profile

Inside PostgreSQL MATCH Queries: Syntax, Paths, and Parameters with pg_igraph

#database #postgres #sql
Comments
3 min read
Turn any SQL schema into an interactive ER diagram
patu profile
Patu

Turn any SQL schema into an interactive ER diagram

#sql #database #postgres #tools
Comments
2 min read
I broke my own database with an infinite loop, and here's what I learned about Row Level Security
ashtondev1164 profile

I broke my own database with an infinite loop, and here's what I learned about Row Level Security

#database #postgres #saas #security
1
Comments
4 min read
A read-only SQL check for the 3 Supabase mistakes AI app builders leave behind
cuarteromario5commits profile

A read-only SQL check for the 3 Supabase mistakes AI app builders leave behind

#supabase #security #postgres #webdev
1
Comments 1
3 min read
Full-Text vs pgvector vs Hybrid Search, Measured
devopsdaily profile

Full-Text vs pgvector vs Hybrid Search, Measured

#postgres #neon #search #pgvector
10
Comments 1
11 min read
20 years of IT operations, and why my side projects have no build step
fonoro profile

20 years of IT operations, and why my side projects have no build step

#discuss #programming #webdev #postgres
Comments
3 min read
Your Supabase anon key can probably read your whole users table
mohibakhon profile

Your Supabase anon key can probably read your whole users table

#supabase #postgres #security #webdev
Comments
5 min read
CDC without Kafka: keeping Postgres, OpenSearch, and Redis in sync with one binary
bashiru98 profile

CDC without Kafka: keeping Postgres, OpenSearch, and Redis in sync with one binary

#postgres #rust #database #opensource
Comments
8 min read
How to Build a Production-Grade RAG Agent with Hybrid Search in 30 Minutes
yevhen_shaforostov_5a73a4 profile

How to Build a Production-Grade RAG Agent with Hybrid Search in 30 Minutes

#ai #programming #postgres #python
Comments
4 min read
Snowflake IDs de 64-bits em Elixir e Ecto: Como Otimizar ĂŤndices e Eliminar UUIDs em Sistemas DistribuĂ­dos
web-engenharia profile

Snowflake IDs de 64-bits em Elixir e Ecto: Como Otimizar ĂŤndices e Eliminar UUIDs em Sistemas DistribuĂ­dos

#elixir #ecto #postgres #arquitetura
Comments
3 min read
My security test was green for six weeks because it could not turn red
guidondor profile

My security test was green for six weeks because it could not turn red

#postgres #testing #sql #security
Comments
3 min read
The Safe Way to Add a NOT NULL Column to a Large Postgres Table
sayonilmitra profile

The Safe Way to Add a NOT NULL Column to a Large Postgres Table

#database #sql #webdev #postgres
1
Comments 1
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.