kysely

Hey 👋

A small batch of bug fixes. Please report any issues. 🤞😰🤞

Controlled transactions get fixes for connection leaks, shared completion state, and commands racing with ongoing queries:

• Commit, rollback, and savepoint commands now wait for ongoing queries and streams to finish.

• Close or exhaust active streams before awaiting these commands.

• A failed rollback now releases the connection and marks the transaction as rolled back.

Bugfixes

• release controlled transaction connection when begin fails

• share completion state between controlled transaction handles

• release controlled transaction connection when rollback fails

• serialize controlled transaction commands with queries

PostgreSQL

• postgres: release the client when destroyed while acquiring a connection by @abebelagua & @igalklebanov

MSSQL

• mssql: escape jsonBuildObject keys.

• mssql: escape JSON in jsonBuildObject

Documentation

• site: preload the homepage video poster with high priority

• site: stabilize demo video dimensions

• site: stabilize search label and center shortcut keys

• site: serve Markdown for explicit Accept requests

• site: expose agent documentation discovery hint

• site: add agent discovery hints to Markdown pages

• site: remove HTML comments from generated Markdown

• site: include category pages in agent documentation

• site: reduce homepage Markdown size

• site: serve Markdown 404 responses to agents

• site: defer Prism until documentation is loaded

• site: preload search when the browser is idle

• site: improve hero audit text contrast

• site: preserve testimonial avatar aspect ratios

• site: enlarge theme toggle touch targets

• site: show the demo poster before hydration

• site: improve light-mode accent contrast

• site: preload the demo poster before stylesheets

• site: externalize proof-wall logo artwork

• site: show brand names while the logo sprite loads

• site: respect reduced motion and add demo playback control

Hey 👋

A small batch of bug fixes. Please report any issues. 🤞😰🤞

Bugfixes

PostgreSQL 🐘 / SQLite

• allow immutable columns in doUpdateSet's where.

Documentation

• site: grow the proof wall from npm's dependents (Cypress, Canton, Tailor, Supabase Lite) + verify every pin

Hey 👋

A small batch of bug fixes. Please report any issues. 🤞😰🤞

TypeScript 7 is allowing for deeper computations which now cause way more instantiations and wall clock times in various scenarios. We're diving deep into our types and finding optimizations. In this version @koskimas brought some nice wins for builder vs. builder assignability checks.

We're also revamping the docs site, working on style, message and usefulness. Swing by our Discord and share your opinions/ideas. We got docs->apidocs search now. The playground is back supporting short links and will allow saving short links very soon.

Bugfixes

• fix infinite type check recursion

• Add missing beforeThrow calls in getInflightQueryAbortHandler

Documentation

• site: various issues with stats section.

• site: migrate to pagefind for cross-site search we own.

• site: grow the proof wall (Replicas, EmbedPDF) + fix production hover

• site: add AirTrail, bknd, Civitai, Corsair.dev, Hot Updater, Profilarr and Tunarr to the proof wall.

• site: proof-strength gauges, query-module evidence, and new wall names

• site: explain the proof gauge behind a (?) on the production wall

• site: align docs code blocks with the landing page's VS Code themes

Hey 👋

A small batch of bug fixes. Please report any issues. 🤞😰🤞

This maintenance release backports bug fixes and documentation improvements from the 0.29 line.

Controlled transactions get fixes for connection leaks, shared completion state, and commands racing with ongoing queries:

• Commit, rollback, and savepoint commands now wait for ongoing queries and streams to finish.

• Close or exhaust active streams before awaiting these commands.

• A failed rollback now releases the connection and marks the transaction as rolled back.

PostgreSQL and MSSQL now use session-level migration locks, including with disableTransactions: true. PostgreSQL migrations through PgBouncer transaction pooling need a direct connection, session pooling, or custom migration locking.

Bugfixes

• allow explicit undefined in Updateable with exactOptionalPropertyTypes.

• fix infinite type check recursion

• release controlled transaction connection when begin fails

• share completion state between controlled transaction handles

• release controlled transaction connection when rollback fails

• serialize controlled transaction commands with queries

PostgreSQL 🐘 / MSSQL

• PostgreSQL and MSSQL migrations are not running exclusively when disableTransactions: true. by @morgan-coded & @igalklebanov

PostgreSQL 🐘 / SQLite

• allow immutable columns in doUpdateSet's where.

On-conflict WHERE predicates now use column select types, including for columns that cannot be updated.

PostgreSQL

• postgres: release the client when destroyed while acquiring a connection by @abebelagua & @igalklebanov

SQLite

• sqlite: output RETURNING before ORDER BY and LIMIT in delete queries.

MSSQL

• mssql: escape jsonBuildObject keys.

• mssql: escape JSON in jsonBuildObject