本文介绍 RDS Supabase 数据库函数：可用 SQL 或 PL/pgSQL 将聚合统计、跨表事务、流程控制等逻辑封装进数据库，弥补 Data API 仅支持单表 CRUD 的不足。函数支持 sql 与 plpgsql 语言，返回类型包括标量、SETOF、TABLE 和 trigger；SECURITY DEFINER 可绕过 RLS，但须通过 REVOKE/GRANT 收紧权限。可在 SQL Editor 或图形界面创建，前端通过 .rpc() 调用，触发器函数可自动刷新 updated_at、记录审计日志。
本文介绍华为云RDS Supabase的Database Data API：建表后自动生成增删改查接口，无需手写后端。以产品定价管理为例，说明获取地址与API Key、安装SDK、建表、启用RLS并配置策略、授予表级权限及刷新缓存，再用前端SDK直连实现查询、新增、更新、Upsert、删除和关联查询。强调Publishable Key仅用于前端、Secret Key仅限服务端，写操作须登录，更新删除必带过滤条件，并先判错再用数据。
Key Takeaways Signal 1 (SIGHUP) normally tells PostgreSQL to reload its configuration. A log line saying a process was terminated by signal 1 means that process didn’t handle the signal and...
What a 4 TiB Azure Disk Taught Us about Slow Reads One of our customers spent most of a week tuning PostgreSQL to fix slow reads. They worked through shared_buffers, effective_cache_size,...
Zeabur 更新环境变量不会自动修改 PostgreSQL 密码，因为数据存储在持久卷中，重启仅重新拉取容器。需在容器内使用 psql 执行 ALTER USER 修改密码，并同步更新应用连接串，否则服务会因密码不匹配而失败。
Key takeaways A routine OS patch can take Postgres offline even when Postgres itself was never touched. Here’s what rolling OS patching on a proper HA cluster changes: OS-level patches (kernel,...
Note: I am presenting a tutorial for those who want to learn SQL at this year's Texas Linuxfest (https://pretalx.com/txlf2026/talk/DQ3XW7/) on November 6th. This is a great opportunity at a...
Google Cloud has introduced AI-powered Database Operations Agents, featuring an Onboarding Agent that streamlines database setup and an Observability Agent that helps automate troubleshooting,...
The engineering team at Stripe recently described how they automated database incident recovery by modeling their global infrastructure as a graph. Using graph search algorithms together with...
作者自称“PostgreSQL数据库恢复专家”，指出该领域缺乏方法论和商业激励，多数工具仅展示功能而不重准确性和可靠性。他开发了PDU工具，已开源前两项功能，保留核心的碎片扫描和无数据字典恢复技术，并欢迎同行交流切磋。
Giving an external team access to your PostgreSQL database is one of those decisions that deserves a little thought. The easiest option is to hand over a superuser account, but it’s rarely the...
Nessus启动失败，提示数据库损坏。解决步骤：先停止Nessus服务（通过任务管理器或services.msc），再根据官方文档定位数据文档路径进行修复或处理。文章记录了该故障排查过程。
本文介绍如何使用CodeQL创建OpenJDK/JDK8数据库。步骤包括：下载源码、配置编译环境（安装依赖、降级gcc至4.9）、执行configure和make images编译，最后用codeql database create命令构建数据库。若内存不足，可加-M参数限制。整个过程需参与编译，成功后可生成数据库。
DoltHub has recently released Dolt 2.0, a major update to the open source version-controlled SQL database. The latest major version adds automatic storage optimization, including garbage...
本文介绍了创建OpenJDK/JDK8数据库的步骤，包括安装依赖、配置编译选项、管理GCC版本以及编译过程中的注意事项。强调了内存不足可能导致的错误，并建议在编译时增加内存限制。
Nessus无法启动可能是由于数据库损坏。解决方法是停止Nessus服务，并根据官方文档查找数据文档路径。
Google shipped AlloyDB AI functions GA with a proxy model architecture that trains a lightweight local model from LLM outputs, then runs queries at database speed without external calls. Smart...
Recently open-sourced by Microsoft, pg_durable is a PostgreSQL extension that enables durable workflows to run natively inside the database, eliminating the need for external orchestration...
Azure's managed PostgreSQL differs from competitors by putting the standby in the commit path—every write waits for synchronous replication to a second server…
PostgreSQL 19 adds GRAPH_TABLE, letting you query property graphs with Cypher-like pattern matching over your existing relational tables.
完成下面两步后，将自动完成登录并继续当前操作。
