· software
Why Did You Choose That Database For Your Application?
A confession regarding Resume-Driven Development, the “Google Scale” fallacy, and why we always just end up using Postgres anyway. You pour a fresh cup of coffe...
-
- · software
Supabase with PowerBI Dashboard
Real-Time Sales & Inventory Dashboard A full‑stack Business Intelligence demo integrating Supabase PostgreSQL as the cloud backend and Microsoft Power BI for f...
- · software
PostgreSQL Log Viewing
!Forem Logohttps://media2.dev.to/dynamic/image/width=65,height=,fit=scale-down,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%...
- · software
PostgreSQL Merge Into
sql UPDATE PSMT_INVOICE_M SET SHIPPING_COUNTRY_ID = SRC.COUNTRY_ID, SHIPPING_CITY_ID = SRC.CITY_ID, SHIPPING_TOWN_ID = SRC.TOWN_ID FROM SELECT PM.INVOICE_M_ID,...
- · software
Locks in PostgreSQL
Article URL: https://habr.com/en/companies/postgrespro/articles/504498/ Comments URL: https://news.ycombinator.com/item?id=46182496 Points: 8 Comments: 0...
- · software
Database ID Design: Choosing ID Methods and Primary Key Strategies
This is Day 7 of Building SaaS Solo – Design, Implementation, and Operation Advent Calendar 2025. Yesterday I wrote about “Schema Design with Supabase.” Today I...
- · software
Schema Design with Supabase: Partitioning and Normalization
Day 6 – Schema Design with Supabase PostgreSQL supports schemas, which act as namespaces for grouping tables. Typical uses include: Multi‑tenancy – separate sc...
- · software
What is better: a lookup table or an enum type?
Article URL: https://www.cybertec-postgresql.com/en/lookup-table-or-enum-type/ Comments URL: https://news.ycombinator.com/item?id=46154892 Points: 9 Comments: 4...
- · software
Top 10 pg_dump Options You Should Know for Reliable PostgreSQL Backups
PostgreSQL's pg_dump utility is the go‑to tool for creating logical backups, but its true power lies in the dozens of command‑line options that let you customiz...
- · software
PGlite – Embeddable Postgres
Article URL: https://pglite.dev/ Comments URL: https://news.ycombinator.com/item?id=46146133 Points: 80 Comments: 13...
- · software
🗄️ Build an MCP Server for PostgreSQL: Query Your Database with Claude & Any AI ClientHappy building
Introduction The Model Context Protocol MCP is transforming how AI applications interact with data sources. While weather servers and basic examples are great...
- · software
How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven
Power BI doesn’t ship with a native PostgreSQL connector out of the box — but with the right setup, it becomes a clean, reliable pipeline for analytics. In this...