How to use new sql/postgres in SvelteKit?

[m4rcelpl]

This is my first attempt at using a runtime other than Node. I have several projects in SvelteKit with Postgres, and I wanted to try migrating to the latest version of Bun. But I don’t really understand how I can do this.

The examples from the documentation don’t work at all. They throw errors.

The only thing that works is a global definition using Bun.sql, but strangely, only the first query returns correct data. On subsequent queries, there’s a numeric read error instead. In the database, these fields have the numeric type.

Is using global declarations the correct approach, and will it have any impact on performance?
Is the incorrect data return a bug in Bun, or am I missing something?

SvelteKit 5.19.2
Bun 1.2
Vite: 6.0.11
Postgres 17
@types/bun 1.2.0

To start server i use: bunx --bun vite dev

[lukeramljak]

Also getting the same issue using bun sql with drizzle ORM and numeric columns.

Curious to know how to fix it.