v0.4.2-rc2 - pg_kalam - PostgreSQL Extension for KalamDB
Pre-release
Pre-release
·
83 commits
to main
since this release
This release adds first-class PostgreSQL extension support to KalamDB through the new pg_kalam extension. PostgreSQL can now connect to a running KalamDB server over gRPC, query and modify KalamDB data through SQL, and create Kalam-backed tables directly from PostgreSQL.
- New
pg_kalamextension and FDW support, withCREATE EXTENSION pg_kalam;and PostgreSQL 13 through 18 support viapgrx0.17. - New PostgreSQL-side SQL bridge functions, including
kalam_exec(...),kalam_version(),kalam_compiled_mode(), session user helpers, andsnowflake_id()for generated IDs. - New
CREATE TABLE ... USING kalamdbpath, so PostgreSQL can create and mirror KalamDB tables directly instead of relying only on manual FDW setup. - DDL propagation between PostgreSQL and KalamDB now covers create, alter, and drop flows, including add/drop column changes and mirrored defaults,
NOT NULL, and primary key metadata. - Improved transaction handling for PostgreSQL clients, with stronger batch validation, better cleanup after remote errors, and more reliable commit/rollback behavior.
- New PostgreSQL session visibility in
system.sessions, plus stale session pruning and idle trimming to keep long-lived PG-connected deployments healthier. - Better handling of internal/system column behavior for mirrored tables, including automatic column injection where required and
SERIAL/IDENTITYnormalization throughSNOWFLAKE_ID(). - Expanded build and packaging support with multi-version PostgreSQL Docker builds, updated release workflow, and
pgvectorpreinstalled in the PostgreSQL images. - Broader end-to-end and performance coverage for DDL, transactions, proxy/disconnect failures, sync stress, and PG extension test bootstrapping.
Notes
IMPORT FOREIGN SCHEMAis still not supported in remote mode.- The extension requires a running KalamDB server and a configured
kalam_serverforeign server.
What's Changed
- Release/0.4.1 beta by @jamals86 in #166
- Release/0.4.1 beta by @jamals86 in #167
- Release/0.4.1 beta by @jamals86 in #168
- Add vector search and websocket auth by @jamals86 in #170
- Feature/vector search by @jamals86 in #171
- Refactor live subscriptions and health metrics by @jamals86 in #172
- Add DBA crate, cleanup & metrics improvements by @jamals86 in #173
- Enhance SQL parsing, agent tests, bench, and CI by @jamals86 in #175
- removed unneeded files by @jamals86 in #177
- Embed OCI metadata, switch to debian13 base by @jamals86 in #178
- Add trusted-proxy support; Docker & CI updates by @jamals86 in #179
- Feature/vector search by @jamals86 in #180
- Update release.yml by @jamals86 in #182
- Feature/pg extension by @jamals86 in #183
- 027 pg transactions by @jamals86 in #185
- 027 pg transactions by @jamals86 in #187
- 027 pg transactions by @jamals86 in #188
- Stable version with pg extension and stable sdk's for typescript and dart by @jamals86 in #189
- Extract SDK CI to sdks.yml by @jamals86 in #190
- 027 pg transactions by @jamals86 in #191
- Include pgvector in pg Docker images by @jamals86 in #192
- 027 pg transactions by @jamals86 in #193
- A stable version with number of improvements to memory consuption and light weight subscription by @jamals86 in #195
- Bug fixes and improvements to transactions,pg extension and admin ui by @jamals86 in #197
- Increase and stabilize test timeouts and waits by @jamals86 in #198
- Fixed failed build extension and test by @jamals86 in #199
- Update test.sh by @jamals86 in #204
Full Changelog: v0.4.1-beta...v0.4.2-rc2
What's Changed
- Release/0.4.1 beta by @jamals86 in #166
- Release/0.4.1 beta by @jamals86 in #167
- Release/0.4.1 beta by @jamals86 in #168
- Add vector search and websocket auth by @jamals86 in #170
- Feature/vector search by @jamals86 in #171
- Refactor live subscriptions and health metrics by @jamals86 in #172
- Add DBA crate, cleanup & metrics improvements by @jamals86 in #173
- Enhance SQL parsing, agent tests, bench, and CI by @jamals86 in #175
- removed unneeded files by @jamals86 in #177
- Embed OCI metadata, switch to debian13 base by @jamals86 in #178
- Add trusted-proxy support; Docker & CI updates by @jamals86 in #179
- Feature/vector search by @jamals86 in #180
- Update release.yml by @jamals86 in #182
- Feature/pg extension by @jamals86 in #183
- 027 pg transactions by @jamals86 in #185
- 027 pg transactions by @jamals86 in #187
- 027 pg transactions by @jamals86 in #188
- Stable version with pg extension and stable sdk's for typescript and dart by @jamals86 in #189
- Extract SDK CI to sdks.yml by @jamals86 in #190
- 027 pg transactions by @jamals86 in #191
- Include pgvector in pg Docker images by @jamals86 in #192
- 027 pg transactions by @jamals86 in #193
- A stable version with number of improvements to memory consuption and light weight subscription by @jamals86 in #195
- Bug fixes and improvements to transactions,pg extension and admin ui by @jamals86 in #197
- Increase and stabilize test timeouts and waits by @jamals86 in #198
- Fixed failed build extension and test by @jamals86 in #199
- Update test.sh by @jamals86 in #204
Full Changelog: v0.4.1-beta...v0.4.2-rc2