https://kysely.dev/assets/js/739f69ce.89e0689d.js

1"use strict";(globalThis.webpackChunkkysely_site=globalThis.webpackChunkkysely_site||[]).push([[6511],{4556(e,t,s){s.r(t),s.d(t,{assets:()=>c,contentTitle:()=>d,default:()=>o,frontMatter:()=>h,metadata:()=>i,toc:()=>n});const i=JSON.parse('{"id":"dialects","title":"Dialects","description":"Find built-in and community Kysely dialects for PostgreSQL, MySQL, SQL Server, SQLite, and other databases.","source":"@site/docs/dialects.md","sourceDirName":".","slug":"/dialects","permalink":"/docs/dialects","draft":false,"unlisted":false,"editUrl":"https://github.com/kysely-org/kysely/tree/master/site/docs/dialects.md","tags":[],"version":"current","frontMatter":{"description":"Find built-in and community Kysely dialects for PostgreSQL, MySQL, SQL Server, SQLite, and other databases."},"sidebar":"tutorialSidebar","previous":{"title":"Browser","permalink":"/docs/runtimes/browser"},"next":{"title":"Generating types","permalink":"/docs/generating-types"}}');var l=s(1058),r=s(4801);const h={description:"Find built-in and community Kysely dialects for PostgreSQL, MySQL, SQL Server, SQLite, and other databases."},d="Dialects",c={},n=[{value:"Core dialects",id:"core-dialects",level:2},{value:"Organization dialects",id:"organization-dialects",level:2},{value:"Community dialects",id:"community-dialects",level:2}];function a(e){const t={a:"a",h1:"h1",h2:"h2",header:"header",p:"p",table:"table",tbody:"tbody",td:"td",th:"th",thead:"thead",tr:"tr",...(0,r.R)(),...e.components};return(0,l.jsxs)(l.Fragment,{children:[(0,l.jsx)(t.header,{children:(0,l.jsx)(t.h1,{id:"dialects",children:"Dialects"})}),"\n",(0,l.jsxs)(t.p,{children:["A dialect is the glue between Kysely and the underlying database engine. Check the ",(0,l.jsx)(t.a,{href:"https://kysely-org.github.io/kysely-apidoc/interfaces/Dialect.html",children:"API docs"})," to learn how to build your own."]}),"\n",(0,l.jsx)(t.h2,{id:"core-dialects",children:"Core dialects"}),"\n",(0,l.jsxs)(t.table,{children:[(0,l.jsx)(t.thead,{children:(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.th,{children:"Dialect"}),(0,l.jsx)(t.th,{children:"Link"})]})}),(0,l.jsxs)(t.tbody,{children:[(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"PostgreSQL"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://kysely-org.github.io/kysely-apidoc/classes/PostgresDialect.html",children:"https://kysely-org.github.io/kysely-apidoc/classes/PostgresDialect.html"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"MySQL"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://kysely-org.github.io/kysely-apidoc/classes/MysqlDialect.html",children:"https://kysely-org.github.io/kysely-apidoc/classes/MysqlDialect.html"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Microsoft SQL Server (MSSQL)"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://kysely-org.github.io/kysely-apidoc/classes/MssqlDialect.html",children:"https://kysely-org.github.io/kysely-apidoc/classes/MssqlDialect.html"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"SQLite"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://kysely-org.github.io/kysely-apidoc/classes/SqliteDialect.html",children:"https://kysely-org.github.io/kysely-apidoc/classes/SqliteDialect.html"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"PGlite"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://kysely-org.github.io/kysely-apidoc/classes/PGliteDialect.html",children:"https://kysely-org.github.io/kysely-apidoc/classes/PGliteDialect.html"})})]})]})]}),"\n",(0,l.jsx)(t.h2,{id:"organization-dialects",children:"Organization dialects"}),"\n",(0,l.jsxs)(t.table,{children:[(0,l.jsx)(t.thead,{children:(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.th,{children:"Dialect"}),(0,l.jsx)(t.th,{children:"Link"})]})}),(0,l.jsxs)(t.tbody,{children:[(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Postgres.js"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/kysely-org/kysely-postgres-js",children:"https://github.com/kysely-org/kysely-postgres-js"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"SingleStore Data API"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/kysely-org/kysely-singlestore",children:"https://github.com/kysely-org/kysely-singlestore"})})]})]})]}),"\n",(0,l.jsx)(t.h2,{id:"community-dialects",children:"Community dialects"}),"\n",(0,l.jsxs)(t.table,{children:[(0,l.jsx)(t.thead,{children:(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.th,{children:"Dialect"}),(0,l.jsx)(t.th,{children:"Link"})]})}),(0,l.jsxs)(t.tbody,{children:[(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"PlanetScale Serverless Driver"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/depot/kysely-planetscale",children:"https://github.com/depot/kysely-planetscale"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Cloudflare D1"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/aidenwallis/kysely-d1",children:"https://github.com/aidenwallis/kysely-d1"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Cloudflare Durable Objects"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/benallfree/kysely-do",children:"https://github.com/benallfree/kysely-do"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Cloudflare Durable Objects"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/jeffwilde/kysely-durable-objects",children:"https://github.com/jeffwilde/kysely-durable-objects"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"AWS RDS Data API"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/serverless-stack/kysely-data-api",children:"https://github.com/serverless-stack/kysely-data-api"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"SurrealDB"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/igalklebanov/kysely-surrealdb",children:"https://github.com/igalklebanov/kysely-surrealdb"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Neon"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/seveibar/kysely-neon",children:"https://github.com/seveibar/kysely-neon"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Xata"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/xataio/client-ts/tree/main/packages/plugin-client-kysely",children:"https://github.com/xataio/client-ts/tree/main/packages/plugin-client-kysely"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"AWS S3 Select"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/igalklebanov/kysely-s3-select",children:"https://github.com/igalklebanov/kysely-s3-select"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"libSQL/sqld"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/libsql/kysely-libsql",children:"https://github.com/libsql/kysely-libsql"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Fetch driver"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/andersgee/kysely-fetch-driver",children:"https://github.com/andersgee/kysely-fetch-driver"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"SQLite WASM"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/DallasHoff/sqlocal",children:"https://github.com/DallasHoff/sqlocal"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Deno SQLite"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://gitlab.com/soapbox-pub/kysely-deno-sqlite",children:"https://gitlab.com/soapbox-pub/kysely-deno-sqlite"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Deno SQLite3"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/marshift/kysely-deno-sqlite3",children:"https://github.com/marshift/kysely-deno-sqlite3"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Node SQLite"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/wolfie/kysely-node-native-sqlite",children:"https://github.com/wolfie/kysely-node-native-sqlite"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"TiDB Cloud Serverless Driver"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/tidbcloud/kysely",children:"https://github.com/tidbcloud/kysely"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Capacitor SQLite Kysely"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/DawidWetzler/capacitor-sqlite-kysely",children:"https://github.com/DawidWetzler/capacitor-sqlite-kysely"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"BigQuery"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/maktouch/kysely-bigquery",children:"https://github.com/maktouch/kysely-bigquery"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Clickhouse"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/founderpathcom/kysely-clickhouse",children:"https://github.com/founderpathcom/kysely-clickhouse"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"PGLite"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/czeidler/kysely-pglite-dialect",children:"https://github.com/czeidler/kysely-pglite-dialect"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Oracle"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/griffiths-waite/kysely-oracledb",children:"https://github.com/griffiths-waite/kysely-oracledb"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"Firebird"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/benkoppe/kysely-firebird",children:"https://github.com/benkoppe/kysely-firebird"})})]}),(0,l.jsxs)(t.tr,{children:[(0,l.jsx)(t.td,{children:"MariaDB"}),(0,l.jsx)(t.td,{children:(0,l.jsx)(t.a,{href:"https://github.com/awaludinar/kysely-mariadb",children:"https://github.com/awaludinar/kysely-mariadb"})})]})]})]})]})}function o(e={}){const{wrapper:t}={...(0,r.R)(),...e.components};return t?(0,l.jsx)(t,{...e,children:(0,l.jsx)(a,{...e})}):a(e)}}}]);