News
Releasing Helios Proxy, The programmable Postgres data-plane
16+ min ago (169+ words) Happy to announce Helios Proxy! ! Far beyond a pooling tool, Helios Proxy ** is a next-gen programmable Postgres data-plane. **Works with Postgre SQL-compatible databases, not only Helios DB. It starts as a Pg Bouncer-compatible wedge, then adds the operational surface teams…...
Simple SQL Tool
6+ hour, 24+ min ago (276+ words) I am a full stack dev but randomly got interested in SQL. Something about combining queries felt like an interesting challenge, like piecing together a puzzle. Then I thought, why not make a tool which uses SQL somehow. At that…...
SQL Window Functions: A Practical Guide to ROW_NUMBER, RANK, LAG, and LEAD
5+ hour, 14+ min ago (304+ words) Window functions are one of SQL's most powerful features, but many developers avoid them because the syntax looks unfamiliar. This guide explains when to use them and how to write them correctly. A window function performs a calculation across a…...
Normalization Is Where Reliable Inbound Email Starts
9+ hour, 19+ min ago (19+ words) Most teams building inbound email systems start with extraction. They focus on parsing headers, .. . Tagged with idempotence, replay, deduplication....
Great Stack to Doesn't Work Bonus: 10 Postgre SQL Features You Didn't Know Existed
11+ hour, 30+ min ago (538+ words) You've used Postgre SQL for years. SELECT, INSERT, JOIN, INDEX. Maybe you've partitioned a table or two. But Postgre SQL has been quietly shipping features that most engineers never discover until they're deep in a Stack Overflow thread at 2 AM....
Enabling Evolutionary Database Development: database branching with Lakebase
16+ hour, 53+ min ago (1087+ words) Join us at the world's largest data, apps and AI event. A (mostly) three part series by Pramod Sadalage and Kevin Hartman The methodology described in'Evolutionary Database Design and operationalized in'Refactoring Databases: Evolutionary Database Design has been clear for twenty…...
Oracle ORA-00055 " " " " " "
20+ hour, 28+ min ago (87+ words) ORA-00055 " Oracle " DML(Data Manipulation Language) "(Lock)" " " " " " " ". Oracle" INSERT, UPDATE, DELETE, MERGE " DML " " " " " " " DML "(TM Lock)" " ", " " " "(Enqueue)" " " " " ". " " "~" " " " " " DML" " " OLTP " " " " ", " " " " " " ". 1. DML_LOCKS " " " " " " 2. " " " " " " " " " " " "~" " " " DML" ", " "(COMMIT " ROLLBACK)" " " " " DML " " " ". " " " ERP " " " ", " " " " " " " " " ". " " " " " " " ORA-00055" " ". 3. " " " " " "(Long-Running Transaction) " COMMIT " " " " " DML " " " ". " " " " " ", " " " " " " " " ", " " " " " " " ". " "(Zombie) " " " " DML " " " ". " " " " " ". " " " " " " ". DML_LOCKS" " " " SPFILE " " " ". " ": DML_LOCKS = 0" " DML " " " ", " DROP TABLE, TRUNCATE " DDL " " " " " " ". " " " " " ", " " COMMIT" ". 1. DML_LOCKS " " " " " " DML " " "(": 80%)" " " " " " " ". " " " " OEM…...
Postgre SQL 08000 " " " " " "
20+ hour, 28+ min ago (73+ words) Postgre SQL " " 08000" Connection Exception ", " " " " " " " " " " " " " ". " " " " " " " " " ", " DB" " " " " " " " " ". " 08000 " " 08001(" "), 08006(" ") " " " " " " " " ", " " " " " " " ". 1. Postgre SQL " pg_hba. conf " " " pg_hba. conf" " ", " ", " " " " " " " " ". " IP" " " ", " "(md5, scram-sha-256 ") " " " " " " " 08000 " ". " " " " IP " " " " " " " " " ". 2. " " " " " " Postgre SQL " " 5432" " " " "(AWS Security Group, iptables ")" " " ", " " TCP " " " " ". " "(AWS RDS, GCP Cloud SQL ")" " " " ", " " OS " " " " " ". " " " "Connection refused" " " " " " " ". listen_addresses" localhost" " ", " IP" " " " ". " max_connections " " ", " " " " " " " " " ". " " " " " " " " " " " ", " " " " " " " " ". " pg_hba. conf " " ", " " " IP" " " ". pg_hba. conf " " " (OS "): " " " Postgre SQL" " (" " " "): Postgre SQL" " " " " " " " ": postgresql. conf " " (OS…...
Optimize Recurring Queries with Snowflake Optima Planning
20+ hour, 11+ min ago (641+ words) Query optimization is the foundation of every modern data platform. The choice of plan shape and join order can determine whether a dashboard query returns in seconds or stalls for an hour. These decisions underpin everything from BI exploration to…...
What is Nested Table Parsing?
1+ day, 6+ hour ago (472+ words) OSS repos trusted by millions of developers Nested Tables: Structure and Format Breakdown A nested table is a table that exists inside a cell of another table. The outer table is the parent; the table embedded within one of its…...