IoTが注目を集める中、端末から送られる情報を処理するサーバ側の仕組みの重要性が増しています。本記事では、Azure上に位置情報を格納するデータベースを構築し、Azure Functionsで定期的にデータベースを監視、条件に合致した場合にLINEで通知する仕組みを ...

PostgreSQL 14 added support for SQL-standard bodies in funcs and procs that are using BEGIN ATOMIC clauses. This function creation statement doesn't work in DBeaver: CREATE OR REPLACE FUNCTION ...

This is an SQL-only extension for PostgreSQL that provides uniform functions for generating SQL Data Definition Language (DDL) scripts for objects created in a database. It contains a bunch of SQL ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

One of the most anticipated new features in PostgreSQL 17 is native support for incremental backups. Previously, you had to use third-party programs for this; now, it's baked into the server. This ...