ephemeralpg を Homebrew, Nix でインストール

プロジェクトリンク

• ホームページ

コマンドとエイリアス

• getsocket
• pg_tmp

プロジェクトの歴史

The NEWS file records version 1.0 on January 7, 2015 as an initial Bitbucket release and describes it as a cross-platform implementation in fewer than one hundred lines of code. Later releases added TCP binding through the bundled `getsocket` utility, better cleanup behavior, PostgreSQL-version compatibility fixes, extra server options, and a test framework.

The project moved hosting from Bitbucket to GitHub in version 2.8 on September 25, 2019. Its public project page was still maintained in 2025 and documents `pg_tmp` as a compact shell script for unit and integration testing with PostgreSQL in any language.

採用の歴史

ephemeralpg is not a mass-market database package, but it has a clear testing niche: teams that need PostgreSQL-specific behavior in tests without shared state. Homebrew and Nix packaging make the tool easy to install in developer workstations and CI images.

使われ方

A common workflow is `uri=$(pg_tmp)` followed by running `psql` or an application test suite against that connection URI. The tool can start a database on a random TCP port, keep it alive for a specified window, pass server options such as disabling autovacuum, and garbage-collect temporary databases automatically.

The project page explains several performance techniques: avoiding fully sequential init/start/stop work, disabling runtime fsync, spinning for the first connection, pre-initializing a background database under `/tmp`, and shutting down asynchronously.

パッケージ好きにとっての重要性

ephemeralpg is interesting because it solves a common developer-tools problem with shell and standard PostgreSQL tools instead of a service daemon. It is small, inspectable, and very package-manager-friendly: install it, call `pg_tmp`, and get a disposable database URI.

タイムライン

• 2015-01-07: Version 1.0 initially released on Bitbucket.
• 2015-12-12: Version 1.7 added a more extensive `make test` framework.
• 2016-03-29: Version 2.0 allowed temporary directories with initdb/start/stop arguments.
• 2019-09-25: Version 2.8 moved hosting from Bitbucket to GitHub.
• 2025-02-06: Version 3.4 adjusted startup behavior and Mac OS locale handling.

Related projects

• ephemeralpg depends on the standard PostgreSQL toolchain, especially `initdb`, `pg_ctl`, `postgres`, and `psql`, and includes helper utilities such as `getsocket` plus optional contrib scripts.

ソース

• https://eradman.com/ephemeralpg/
• https://github.com/eradman/ephemeralpg
• https://raw.githubusercontent.com/eradman/ephemeralpg/master/NEWS