Query SQL Databases using Node.js and TypeScript

Time 2022-09-26 18:55:55

Web Name: Query SQL Databases using Node.js and TypeScript

WebSite: http://www.atdatabases.org

ID:330301

Keywords:

Databases,using,Query,SQL

Description:

Close menuBuilding SQL QueriesDocumentation

Query SQL Databases using Node.js and TypeScript

@databases lets you read and write data to Postgres, MySQL, SQLite and other databases in Node.js using ordinary SQL, with parameters automatically escaped to prevent SQL injection.

Get started

100% free and open source

Used in production at these companies, and more

Type safe API for simple operations

await tables.users(db).insert({  email: `janet@example.com`,  active: true,});

emailactiveadam@example.comtrueforbes@example.comtruedee@example.comtrue+janet@example.comtrue

await tables.users(db).update(  {email: `dee@example.com`},  {active: false},);

emailactiveadam@example.comtrueforbes@example.comtrue⇄dee@example.comfalsejanet@example.comtrue

await tables.users(db).delete({  email: `forbes@example.com`,});

emailactiveadam@example.comtrue-forbes@example.comtruedee@example.comfalsejanet@example.comtrue

Type safe single-table queries

await tables.users(db)  .find({    email: anyOf([      `adam@example.com`,      `janet@example.com`,    ]),  })  .all();

emailactive·adam@example.comtruedee@example.comfalse·janet@example.comtrue

Use the full power of SQL to write complex queries

await db.query(sql`  SELECT    users.email,    count(*) AS posts  FROM users  INNER JOIN posts  ON (users.email = posts.author)  GROUP BY users.email  WHERE users.active = true`);

emailpostsadam@example.com4janet@example.com16

Wrap any operations into an atomic transaction

await db.tx(async (db) => {  await tables.users(db).update(    {email: `dee@example.com`},    {active: true},  );  return await db.query(sql`    SELECT      users.email,      count(*) AS posts    FROM users    INNER JOIN posts    ON (users.email = posts.author)    GROUP BY users.email    WHERE users.active = true  `);});

emailpostsadam@example.com4dee@example.com3janet@example.com16

We support your database

Each supported database engine has a separate driver. This means that @databases can take advantage of the features unique to each database. Core elements are shared. This makes it quick to add support for a new database engine.

PostgresMySQLSQLiteExpoBigQueryMore Soon...

Key features

Type Safe

@databases is written in TypeScript, so every module has type safety and type definitions built in. In addition to that, we also have CLIs that let you generate types for your database tables.

Modular

Each database driver is published as a separate module. Each problem we solve get its own reusable package. This means that even if you don't want to use @databases to connect to your SQL database, you can still use our locking implementation, or our queue implementation.

Promises

All the @databases APIs are designed with promises in mind from the get go. You won't need to mess around with old callback styles. This keeps your code clean and simple.Get started

TAGS:Databases using Query SQL

<<< Thank you for your visit >>>

Hot Websites