Kysely SQL Files

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.

🚀 Features

🐞 Bugfixes

• fix: release controlled transaction connection when begin fails by @igalklebanov in https://github.com/kysely-org/kysely/pull/2080
• fix: share completion state between controlled transaction handles by @igalklebanov in https://github.com/kysely-org/kysely/pull/2090
• fix: release controlled transaction connection when rollback fails by @B4nan in https://github.com/kysely-org/kysely/pull/2136
• fix: serialize controlled transaction commands with queries by @igalklebanov in https://github.com/kysely-org/kysely/pull/2081

PostgreSQL 🐘

• fix(postgres): release the client when destroyed while acquiring a connection by @abebelagua & @igalklebanov in https://github.com/kysely-org/kysely/pull/2088

MSSQL 🥅

• fix(mssql): escape jsonBuildObject keys. by @igalklebanov in https://github.com/kysely-org/kysely/pull/2078
• fix(mssql): escape JSON in jsonBuildObject by @igalklebanov in https://github.com/kysely-org/kysely/pull/2079

📖 Documentation

• docs: add Langfuse to the built-into proof wall by @igalklebanov in https://github.com/kysely-org/kysely/pull/2054
• docs: add TrueForge to the built-into proof wall by @igalklebanov in https://github.com/kysely-org/kysely/pull/2055
• docs: add Open Mercato to the built-into proof wall by @igalklebanov in https://github.com/kysely-org/kysely/pull/2056
• docs: make homepage title descriptive by @igalklebanov in https://github.com/kysely-org/kysely/pull/2058
• fix(site): preload the homepage video poster with high priority by @igalklebanov in https://github.com/kysely-org/kysely/pull/2059
• fix(site): stabilize demo video dimensions by @igalklebanov in https://github.com/kysely-org/kysely/pull/2060
• docs: add a default social preview card by @igalklebanov in https://github.com/kysely-org/kysely/pull/2061
• docs: share the homepage description and refresh production examples by @igalklebanov in https://github.com/kysely-org/kysely/pull/2062
• docs: add descriptions to non-example pages by @igalklebanov in https://github.com/kysely-org/kysely/pull/2063
• fix(site): stabilize search label and center shortcut keys by @igalklebanov in https://github.com/kysely-org/kysely/pull/2064
• fix(site): serve Markdown for explicit Accept requests by @igalklebanov in https://github.com/kysely-org/kysely/pull/2066
• fix(site): expose agent documentation discovery hint by @igalklebanov in https://github.com/kysely-org/kysely/pull/2065
• fix(site): add agent discovery hints to Markdown pages by @igalklebanov in https://github.com/kysely-org/kysely/pull/2067
• fix(site): remove HTML comments from generated Markdown by @igalklebanov in https://github.com/kysely-org/kysely/pull/2068
• fix(site): include category pages in agent documentation by @igalklebanov in https://github.com/kysely-org/kysely/pull/2069
• fix(site): reduce homepage Markdown size by @igalklebanov in https://github.com/kysely-org/kysely/pull/2071
• docs(site): improve API reference discovery by @igalklebanov in https://github.com/kysely-org/kysely/pull/2072
• docs(site): publish robots.txt with sitemap by @igalklebanov in https://github.com/kysely-org/kysely/pull/2074
• docs(site): advertise agent index in homepage Link header by @igalklebanov in https://github.com/kysely-org/kysely/pull/2075
• docs(site): declare content usage preferences by @igalklebanov in https://github.com/kysely-org/kysely/pull/2076
• docs: audit the proof wall and refresh usage evidence by @igalklebanov in https://github.com/kysely-org/kysely/pull/2085
• fix(site): serve Markdown 404 responses to agents by @igalklebanov in https://github.com/kysely-org/kysely/pull/2089
• docs: add software identity and maintainer contact structured data by @igalklebanov in https://github.com/kysely-org/kysely/pull/2091
• docs: declare Open Graph website type by @igalklebanov in https://github.com/kysely-org/kysely/pull/2092
• docs: link organization identity profiles in JSON-LD by @igalklebanov in https://github.com/kysely-org/kysely/pull/2093
• docs: add LinkedIn to organization structured data by @igalklebanov in https://github.com/kysely-org/kysely/pull/2095
• docs: generate agent discovery catalogs by @igalklebanov in https://github.com/kysely-org/kysely/pull/2094
• docs: compress testimonial avatars by @igalklebanov in https://github.com/kysely-org/kysely/pull/2098
• docs: render each testimonial once by @igalklebanov in https://github.com/kysely-org/kysely/pull/2099
• perf(site): defer Prism until documentation is loaded by @igalklebanov in https://github.com/kysely-org/kysely/pull/2100
• perf(site): preload search when the browser is idle by @igalklebanov in https://github.com/kysely-org/kysely/pull/2101
• fix(site): improve hero audit text contrast by @igalklebanov in https://github.com/kysely-org/kysely/pull/2102
• docs(site): add A2A JavaScript SDK to proof wall by @igalklebanov in https://github.com/kysely-org/kysely/pull/2103
• fix(site): preserve testimonial avatar aspect ratios by @igalklebanov in https://github.com/kysely-org/kysely/pull/2106
• fix(site): enlarge theme toggle touch targets by @igalklebanov in https://github.com/kysely-org/kysely/pull/2105
• fix(site): show the demo poster before hydration by @igalklebanov in https://github.com/kysely-org/kysely/pull/2107
• fix(site): improve light-mode accent contrast by @igalklebanov in https://github.com/kysely-org/kysely/pull/2108
• perf(site): preload the demo poster before stylesheets by @igalklebanov in https://github.com/kysely-org/kysely/pull/2112
• perf(site): externalize proof-wall logo artwork by @igalklebanov in https://github.com/kysely-org/kysely/pull/2114
• fix(site): show brand names while the logo sprite loads by @igalklebanov in https://github.com/kysely-org/kysely/pull/2116
• docs: fix PostgreSQL pool in plugin example by @igalklebanov in https://github.com/kysely-org/kysely/pull/2117
• docs: consolidate Deno guidance in getting started by @igalklebanov in https://github.com/kysely-org/kysely/pull/2118
• docs: enable Bun SQLite with better-sqlite3 by @igalklebanov in https://github.com/kysely-org/kysely/pull/2124
• docs: describe the LogEvent union by @igalklebanov in https://github.com/kysely-org/kysely/pull/2121
• docs: qualify PGlite type generation support by @igalklebanov in https://github.com/kysely-org/kysely/pull/2120
• docs: add kysely-typegen to type generators by @theoludwig & @igalklebanov in https://github.com/kysely-org/kysely/pull/2126
• docs(site): remove duplicate intro help paragraph by @igalklebanov in https://github.com/kysely-org/kysely/pull/2133
• fix(site): respect reduced motion and add demo playback control by @igalklebanov in https://github.com/kysely-org/kysely/pull/2130
• docs: clarify shared pool and database instance lifecycles by @igalklebanov in https://github.com/kysely-org/kysely/pull/2143

📦 CICD & Tooling

• ci: replace llms text comparison with local afdocs checks by @igalklebanov in https://github.com/kysely-org/kysely/pull/2070
• chore(deps): bump afdocs to 0.22.2 by @igalklebanov in https://github.com/kysely-org/kysely/pull/2087
• ci: use non-Docker Hub images for PostgreSQL and MySQL. by @igalklebanov in https://github.com/kysely-org/kysely/pull/2127
• ci: add registry fallbacks and reuse the SQL Server image by @igalklebanov in https://github.com/kysely-org/kysely/pull/2140
• chore: bump deps. by @igalklebanov in https://github.com/kysely-org/kysely/pull/2142

⚠️ Breaking Changes

🐤 New Contributors

• @theoludwig made their first contribution in https://github.com/kysely-org/kysely/pull/2126
• @abebelagua made their first contribution in https://github.com/kysely-org/kysely/pull/2088

What's Changed

Full Changelog: https://github.com/kysely-org/kysely/compare/v0.29.6...v0.29.7