Database connection with Waddler

Waddler runs SQL queries on your database via database drivers.

index.ts

import { waddler } from "waddler/duckdb-neo"

const sql = waddler({ url: process.env.DATABASE_URL });
const usersCount = await sql`select count(*) from ${sql.identifier('users')};`;

          ┌─────────────────────────────────────────────────────────┐
          │  sql`select count(*) from ${sql.identifier('users')};`  │ <--- waddler query
          └─────────────────────────────────────────────────────────┘     
                               │               ʌ
select count(*) from "users"; -│               │
                               │               │- [{ count: 0 }]
                               v               │
                            ┌─────────────────────┐
                            │     duckdb-neo      │ <--- database driver
                            └─────────────────────┘
                               │               ʌ
01101000 01100101 01111001    -│               │
                               │               │- 01110011 01110101 01110000
                               v               │
                            ┌────────────────────┐
                            │      Database      │ 
                            └────────────────────┘

Under the hood, Waddler has a pool that creates a duckdb-neo driver instance when needed.

import { DuckDBInstance } from '@duckdb/node-api';

const instance = await DuckDBInstance.create(url, {
	accessMode: 'read_write', // default value
  maxMemory: '512MB', // default value
  threads = '4' // default value
});
const connection = await instance.connect();
// The connection can then be used to query your database

Waddler is by design natively compatible with every edge or serverless runtime, whenever you’d need access to a serverless database - we’ve got you covered

Neon HTTP

Neon with websockets

Vercel Postgres

PlanetScale HTTP

Cloudflare d1

import { waddler } from "waddler/neon-http";

const sql = waddler(process.env.DATABASE_URL);

import { waddler } from "waddler/neon-serverless";

const sql = waddler(process.env.DATABASE_URL);

import { waddler } from "waddler/vercel-postgres";

const sql = waddler();

import { waddler } from "waddler/planetscale";

const sql = waddler(process.env.DATABASE_URL);

import { waddler } from "waddler/d1";

const sql = waddler({ connection: env.DB });

And yes, we do support runtime specific drivers like Bun SQLite or Expo SQLite:

import { waddler } from "waddler/bun-sqlite"

const sql = waddler(); // <--- will create an in-memory db
const sql = waddler("./sqlite.db");

import { waddler } from "waddler/expo-sqlite";
import { openDatabaseSync } from "expo-sqlite";

const expo = openDatabaseSync("db.db");
const sql = waddler({ client: expo });