All Projects → ForbesLindesay → Atdatabases

ForbesLindesay / Atdatabases

Licence: mit
TypeScript clients for databases that prevent SQL Injection

Programming Languages

javascript
184084 projects - #8 most used programming language
typescript
32286 projects

Projects that are alternatives of or similar to Atdatabases

Migrate
Database migrations. CLI and Golang library.
Stars: ✭ 2,315 (+1403.25%)
Mutual labels:  sql, mysql, sqlite, postgres, databases
Migrate
Database migrations. CLI and Golang library.
Stars: ✭ 7,712 (+4907.79%)
Mutual labels:  sql, mysql, sqlite, postgres, databases
Requery
requery - modern SQL based query & persistence for Java / Kotlin / Android
Stars: ✭ 3,071 (+1894.16%)
Mutual labels:  sql, mysql, sqlite, postgres
Goqu
SQL builder and query library for golang
Stars: ✭ 984 (+538.96%)
Mutual labels:  sql, mysql, sqlite, postgres
Electrocrud
Database CRUD Application Built on Electron | MySQL, Postgres, SQLite
Stars: ✭ 1,267 (+722.73%)
Mutual labels:  sql, mysql, sqlite, postgres
Sqhell.vim
An SQL wrapper for vim
Stars: ✭ 113 (-26.62%)
Mutual labels:  sql, mysql, sqlite, postgres
Ebean
Ebean ORM
Stars: ✭ 1,172 (+661.04%)
Mutual labels:  sql, mysql, sqlite, postgres
Sqlx
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL.
Stars: ✭ 5,039 (+3172.08%)
Mutual labels:  sql, mysql, sqlite, postgres
Vscode Sqltools
Database management for VSCode
Stars: ✭ 741 (+381.17%)
Mutual labels:  sql, mysql, sqlite, postgres
Goose
A database migration tool. Supports SQL migrations and Go functions.
Stars: ✭ 2,112 (+1271.43%)
Mutual labels:  sql, mysql, sqlite, postgres
East
node.js database migration tool
Stars: ✭ 53 (-65.58%)
Mutual labels:  mysql, sqlite, postgres
Sql
MySQL & PostgreSQL pipe
Stars: ✭ 81 (-47.4%)
Mutual labels:  sql, mysql, postgres
Xeus Sql
xeus-sql is a Jupyter kernel for general SQL implementations.
Stars: ✭ 85 (-44.81%)
Mutual labels:  sql, mysql, sqlite
Eosio sql plugin
EOSIO sql database plugin
Stars: ✭ 21 (-86.36%)
Mutual labels:  sql, mysql, sqlite
Qtl
A friendly and lightweight C++ database library for MySQL, PostgreSQL, SQLite and ODBC.
Stars: ✭ 92 (-40.26%)
Mutual labels:  sql, mysql, sqlite
Fizz
A Common DSL for Migrating Databases
Stars: ✭ 92 (-40.26%)
Mutual labels:  mysql, sqlite, postgres
Xorm
Simple and Powerful ORM for Go, support mysql,postgres,tidb,sqlite3,mssql,oracle, Moved to https://gitea.com/xorm/xorm
Stars: ✭ 6,464 (+4097.4%)
Mutual labels:  mysql, sqlite, postgres
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Stars: ✭ 18,168 (+11697.4%)
Mutual labels:  mysql, postgres, sqlite
Go Structured Query
Type safe SQL query builder and struct mapper for Go
Stars: ✭ 101 (-34.42%)
Mutual labels:  sql, mysql, postgres
Sql Kit
*️⃣ Build SQL queries in Swift. Extensible, protocol-based design that supports DQL, DML, and DDL.
Stars: ✭ 115 (-25.32%)
Mutual labels:  sql, mysql, sqlite

Safe From HTML Injection

Using tagged template literals for queries, e.g.

db.query(sql`SELECT * FROM users WHERE id=${userID}`);

makes it virtually impossible for SQL Injection attacks to slip in un-noticed. All the @databases libraries enforce the use of the sql tagged template literals, so you can't accidentally miss them.

The query is then passed to your database engine as a separate string and values:

{text: 'SELECT * FROM users WHERE id=?', values: [userID]}

Promises

All the @databases APIs are designed with promises in mind from the get go.

TypeScript

Written in TypeScript, so every module has type safety and type definitions built in.

Modular

Each database driver is published to npm as a separate module, so you don't need to install the ones you don't need.

Package Name Version Docs
@databases/connection-pool NPM version https://www.atdatabases.org/docs/connection-pool
@databases/escape-identifier NPM version https://www.atdatabases.org/docs/escape-identifier
@databases/expo NPM version https://www.atdatabases.org/docs/websql
@databases/lock NPM version https://www.atdatabases.org/docs/lock
@databases/mysql NPM version https://www.atdatabases.org/docs/mysql
@databases/mysql-test NPM version https://www.atdatabases.org/docs/mysql-test
@databases/pg NPM version https://www.atdatabases.org/docs/pg
@databases/pg-migrations NPM version https://www.atdatabases.org/docs/pg-migrations
@databases/pg-test NPM version https://www.atdatabases.org/docs/pg-test
@databases/queue NPM version https://www.atdatabases.org/docs/queue
@databases/split-sql-query NPM version https://www.atdatabases.org/docs/split-sql-query
@databases/sql NPM version https://www.atdatabases.org/docs/sql
@databases/sqlite NPM version https://www.atdatabases.org/docs/sqlite
@databases/validate-unicode NPM version https://www.atdatabases.org/docs/validate-unicode
@databases/websql NPM version https://www.atdatabases.org/docs/websql
@databases/migrations-base NPM version Not documented yet
@databases/mysql-config NPM version Not documented yet
@databases/pg-config NPM version Not documented yet
@databases/pg-connection-string NPM version Not documented yet
@databases/pg-create NPM version Not documented yet
@databases/pg-data-type-id NPM version Not documented yet
@databases/pg-errors NPM version Not documented yet
@databases/pg-schema-cli NPM version Not documented yet
@databases/pg-schema-introspect NPM version Not documented yet
@databases/pg-schema-print-types NPM version Not documented yet
@databases/pg-typed NPM version Not documented yet
@databases/push-to-async-iterable NPM version Not documented yet
@databases/shared NPM version Not documented yet
@databases/websql-core NPM version Not documented yet
@databases/with-container NPM version Not documented yet

Check out the website to learn more: https://www.atdatabases.org/

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].