Database connection with Waddler

Waddler runs SQL queries on your database via database drivers.

index.ts

import { waddler } from "waddler/node-mysql"

const sql = waddler(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               │
                            ┌─────────────────────┐
                            │        mssql        │ <--- database driver
                            └─────────────────────┘
                               │               ʌ
01101000 01100101 01111001    -│               │
                               │               │- 01110011 01110101 01110000
                               v               │
                            ┌────────────────────┐
                            │      Database      │ 
                            └────────────────────┘

Under the hood Waddler will create a mssql driver instance

// above is equivalent to
import { waddler, AutoPool } from "waddler/node-mssql";

// under the hood AutoPool creates mssql driver instance
const pool = new AutoPool(process.env.DATABASE_URL);

const sql = waddler({ client: pool });

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 });

Database connection URL

Just in case if you’re not familiar with database connection URL concept

Server=localhost,55567;Database=master;User Id=SA;Password=drizzle123PASSWORD!;Encrypt=true;TrustServerCertificate=true;
       └───────┘ └───┘          └────┘         └┘          └─────────────────┘  
            ʌ      ʌ              ʌ             ʌ                   ʌ
  hostname -│      │              │- database   │                   │- password
                   │                            │- user
                   │- port

Next steps

Feel free to check out per-driver documentations

PostgreSQL drivers

PostgreSQL Neon Vercel Postgres Supabase Xata PGLite

Duckdb drivers

Duckdb-neo

ClickHouse drivers

ClickHouse

Gel drivers

Gel

MySQL drivers

MySQL PlanetsScale TiDB

MsSQL drivers

MsSQL

SQLite drivers

SQLite Turso Cloudflare D1 Bun SQLite

Native SQLite

Expo SQLite OP SQLite