/cotton

SQL Database Toolkit for Deno

Primary LanguageTypeScriptMIT LicenseMIT

Cotton

ci GitHub release (latest by date)

SQL Database Toolkit for Deno.

  • Well-tested
  • Type-safe
  • Supports MySQL, SQLite, and PostgreSQL
  • Semantic versioning

Documentation

Getting Started

Here's an example of a Deno project that uses Cotton.

import { connect } from "https://deno.land/x/cotton@v0.7.2/mod.ts";

const db = await connect({
  type: "sqlite",
  database: "db.sqlite3",
});

To use Cotton in your project, you can import cotton package from deno.land/x in your file. We highly recommend you to use semantic versioning by explicitly tell Deno which version you want to use in the import URL.

Typically, the first thing you want to do is to create a connection to a database. Here, we're using connect and pass our database configuration. You can read more about connection here.

Once our database is connected, do anything with it such as performing an SQL query.

const users = await db.query("SELECT * FROM users");

for (const user of users) {
  console.log(user); // { email: 'a@b.com', age: 16, ... }
}

You can learn more about Cotton through these links. Have fun! 😃