dbdev: PostgreSQL Package Manager

Summary

database.dev is a public preview of dbdev, a PostgreSQL package manager whose registry is currently read-only and preloaded with packages demonstrating packaging and discovery possibilities. It aims to provide repeatable deployment of libraries and applications, with third-party publishing tools planned after community feedback, and uses organization- or user-namespaced package names to address name and typo squatting. The in-database client installs packages, which PostgreSQL then exposes as native extensions; dbdev adds major.minor.patch version constraints, while compatibility currently requires Supabase new projects or PostgreSQL with pg_tle and pgsql-http. Examples include a hybrid document-search backend, an index advisor that reports a sample total-cost reduction from 25.88 to 6.40, and administration views for database diagnostics. The preview depends on Trusted Language Extensions, and the post invites reports, feature ideas, and contributions while noting that pl/rust had not yet reached Supabase.

Takeaways

1. 1

   The registry is read-only during the public preview, with third-party publishing tooling planned after community feedback.

2. 2

   Namespaced packages use the owning organization or user handle, so a fork published by another account receives that account's namespace.

3. 3

   olirice-index_advisor recommends indexes from query explain plans and showed total cost decreasing from 25.88 to 6.40 for the sample query.