connect-sqlite-cloud.mdx

import Tab from '@mdx/Tab.astro'; import Tabs from '@mdx/Tabs.astro'; import Npm from "@mdx/Npm.astro"; import Callout from '@mdx/Callout.astro'; import Steps from '@mdx/Steps.astro'; import AnchorCards from '@mdx/AnchorCards.astro'; import Prerequisites from "@mdx/Prerequisites.astro"; import CodeTabs from "@mdx/CodeTabs.astro"; import Section from "@mdx/Section.astro"; import WhatsNextPostgres from "@mdx/WhatsNextPostgres.astro";

Drizzle <> SQLite Cloud

- Database [connection basics](/docs/connect-overview) with Drizzle - **SQLite Cloud database** - [docs](https://docs.sqlitecloud.io/docs/overview) - **SQLite Cloud driver** - [docs](https://docs.sqlitecloud.io/docs/sdk-js-introduction) & [GitHub](https://github.com/sqlitecloud/sqlitecloud-js)

According to the official website, SQLite Clouds is a managed, distributed relational database system built on top of the SQLite database engine.

Step 1 - Install packages

drizzle-orm@beta @sqlitecloud/drivers -D drizzle-kit@beta

Step 2 - Initialize the driver and make a query

import { drizzle } from 'drizzle-orm/sqlite-cloud';

const db = drizzle(process.env.SQLITE_CLOUD_CONNECTION_STRING);

const result = await db.all('select 1');

If you need to provide your existing drivers:

import { Database } from '@sqlitecloud/drivers';
import { drizzle } from 'drizzle-orm/sqlite-cloud';

const client = new Database(process.env.SQLITE_CLOUD_CONNECTION_STRING!);
const db = drizzle({ client });

const result = await db.all('select 1');

What's next?