TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap and Ionic platforms and can be used with TypeScript and JavaScript (ES5, ES6, ES7). Its goal to always support latest JavaScript features and provide features that help you to develop any kind of applications that use databases - from small applications with a few tables to large scale enterprise applications with multiple databases.
 
TypeORM supports both Active Record and Data Mapper patterns, unlike all other JavaScript ORMs currently exist, which means you can write high quality, loosely coupled, scalable, maintainable applications the most productive way.

TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap and Ionic platforms and can be used with TypeScript and JavaScript (ES5, ES6, ES7). Its goal to always support latest JavaScript features and provide features that help you to develop any kind of applications that use databases - from small applications with a few tables to large scale enterprise applications with multiple databases.

Typeorm - Amazing ORM for TypeScript and JavaScript (ES7, ES6, ES5)

Bookshelf is a JavaScript ORM for Node.js, built on the Knex SQL query builder. Featuring both promise based and traditional callback interfaces, providing transaction support, eager/nested-eager relation loading, polymorphic associations, and support for one-to-one, one-to-many, and many-to-many relations. It is designed to work well with PostgreSQL, MySQL, and SQLite3.
 
Bookshelf aims to provide a simple library for common tasks when querying databases in JavaScript, and forming relations between these objects, taking a lot of ideas from the the Data Mapper Pattern.

 Bookshelf is a JavaScript ORM for Node.js, built on the Knex SQL query builder. Featuring both promise based and traditional callback interfaces, providing transaction support, eager/nested-eager relation loading, polymorphic associations, and support for one-to-one, one-to-many, and many-to-many relations. It is designed to work well with PostgreSQL, MySQL, and SQLite3.

Bookshelf - A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

SQLite JDBC is a library for accessing and creating SQLite database files in Java. The library requires no configuration since native libraries for major OSs, including Windows, Mac OS X, Linux etc., are assembled into a single JAR (Java Archive) file. 

Sqlite JDBC - SQLite JDBC Driver

rbatis is a highly Performant,Safe,Dynamic SQL(Compile time) ORM framework written in Rust, inspired by Mybatis and MybatisPlus. It provides high performance, Based on Future, with async_std/tokio, single threaded benchmark can easily achieve 200,000 QPS. 

rbatis - Rust High Performance compile-time ORM(JSON based)

DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands.
 
Its feature include: 
<ul dir="auto">
<li>Create and compact database files</li>
<li>Create, define, modify and delete tables</li>
<li>Create, define, and delete indexes</li>
<li>Browse, edit, add, and delete records</li>
<li>Search records</li>
<li>Import and export records as text</li>
<li>Import and export tables from/to CSV files</li>
<li>Import and export databases from/to SQL dump files</li>
<li>Issue SQL queries and inspect the results</li>
<li>Examine a log of all SQL commands issued by the application</li>
<li>Plot simple graphs based on table or query data</li>
</ul>

DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands.

SQLiteBrowser- DB Browser for SQLite (DB4S) project

Xorm is a simple and powerful ORM for Go. Its features include:
<ul>
<li>
Struct &lt;-&gt; Table Mapping Support
</li>
<li>
Chainable APIs
</li>
<li>
Transaction Support
</li>
<li>
Both ORM and raw SQL operation Support
</li>
<li>
Sync database schema Support
</li>
<li>
Query Cache speed up
</li>
<li>
Database Reverse support, See <a href="https://github.com/go-xorm/cmd/blob/master/README.md">Xorm Tool README</a>
</li>
<li>
Simple cascade loading support
</li>
<li>
Optimistic Locking support
</li>
<li>
SQL Builder support via <a href="https://github.com/go-xorm/builder">github.com/go-xorm/builder</a>
</li>
</ul>

Xorm is a simple and powerful ORM for Go.

 XORM - eXtra ORM for Go

The smoothest, best looking, and easiest to use SQL client for MySQL, Postgres, SQLite, SQL Server, Red shift, MariaDB, CockroachDB and more.

Beekeeper Studio - Open Source SQL Editor and Database Manager

sql.js is a javascript SQL database. It allows you to create a relational database and query it entirely in the browser. It uses a virtual database file stored in memory, and thus doesn't persist the changes made to the database. However, it allows you to import any existing sqlite file, and to export the created database as a JavaScript typed array. sql.js uses emscripten to compile SQLite to webassembly (or to javascript code for compatibility with older browsers). It includes contributed math and string extension functions.
 
sql.js can be used like any traditional JavaScript library. If you are building a native application in JavaScript (using Electron for instance), or are working in node.js, you will likely prefer to use a native binding of SQLite to JavaScript. A native binding will not only be faster because it will run native code, but it will also be able to work on database files directly instead of having to load the entire database in memory, avoiding out of memory errors and further improving performances.

sql.js is a javascript SQL database. It allows you to create a relational database and query it entirely in the browser.  It uses a virtual database file stored in memory, and thus doesn't persist the changes made to the database. However, it allows you to import any existing sqlite file, and to export the created database as a JavaScript typed array. sql.js uses emscripten to compile SQLite to webassembly (or to javascript code for compatibility with older browsers). It includes contributed math and string extension functions.

sql.js - A Javascript library to run SQLite on the web

NocoDB is an open source Airtable alternative. NocoDB works by connecting to any relational database and transforming them into a smart spreadsheet interface! This allows you to build no-code applications collaboratively with teams. NocoDB currently works with MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Amazon Aurora & MariaDB databases.
 
Also NocoDB's app store allows you to build business workflows on views with combination of Slack, Microsoft Teams, Discord, Twilio, Whatsapp, Email & any 3rd party APIs too. Plus NocoDB provides programmatic access to APIs so that you can build integrations with Zapier / Integromat and custom applications too.

NocoDB is an open source Airtable alternative. NocoDB works by connecting to any relational database and transforming them into a smart spreadsheet interface! This allows you to build no-code applications collaboratively with teams. NocoDB currently works with MySQL, PostgreSQL, Microsoft SQL Server, SQLite, Amazon Aurora & MariaDB databases.





NocoDB - The Open Source Airtable alternative

MikroORM is a TypeScript ORM for Node.js based on Data Mapper, Unit of work and Identity Map patterns. It supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases. Heavily inspired by Doctrine and Nextras ORM.
 
It allows handling transactions automatically. When you call em.flush() all computed changes are wrapped inside a database transaction. It uses source code analysis so you do not have to repeat yourself when defining entities. Simply define correct TypeScript types and you are good to go.
 
Its features include:
<ul>
<li>Clean and Simple Entity Definition</li>
<li>Identity Map</li>
<li>Entity References</li>
<li>Using Entity Constructors</li>
<li>Modelling Relationships</li>
<li>Collections</li>
<li>Unit of Work</li>
<li>Transactions</li>
<li>Cascading persist and remove</li>
<li>Composite and Foreign Keys as Primary Key</li>
<li>Filters</li>
<li>Using QueryBuilder</li>
<li>Preloading Deeply Nested Structures via populate</li>
<li>Property Validation</li>
<li>Lifecycle Hooks</li>
<li>Vanilla JS Support</li>
<li>Schema Generator</li>
<li>Entity Generator</li>
</ul>

MikroORM is a TypeScript ORM for Node.js based on Data Mapper, Unit of work and Identity Map patterns. It supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases. Heavily inspired by Doctrine and Nextras ORM.

MikroORM - TypeScript ORM for Node

Prisma helps app developers build faster and
make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders. 
 
Prisma is the perfect companion for building web APIs. It saves repetitive CRUD boilerplate and provides a flexible API for common use cases such as pagination and filtering. Based on the Prisma Schema, Prisma Migrate automatically generates SQL database migrations, that are fully customizable.

Prisma helps app developers build faster and
make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders.

Prisma - Next-generation ORM for Node.js and TypeScript

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and MariaDB.
 
Its features include: 
<ul>
<li>Table data editing, with SQL change script preview</li>
<li>Edit table schema, indexes, primary and foreign keys</li>
<li>Compare and synchronize database structure</li>
<li>ER diagram</li>
<li>Light and dark theme</li>
<li>Master/detail views, foreign key lookups</li>
<li>Query designer</li>
<li>Form view for comfortable work with tables with many columns</li>
<li>JSON view on MongoDB collections</li>
<li>Explore tables, views, procedures, functions, MongoDB collections</li>
<li>SQL editor
<ul dir="auto">
<li>execute SQL script</li>
<li>SQL code formatter</li>
<li>SQL code completion</li>
<li>Add SQL LEFT/INNER/RIGHT join utility</li>
</ul>
</li>
<li>Mongo JavaScript editor, execute Mongo script (with NodeJs syntax)</li>
<li>Redis tree view, generate script from keys, run Redis script</li>
<li>Runs as application for Windows, Linux and Mac. Or in Docker container on server and in web Browser on client.</li>
<li>Import, export from/to CSV, Excel, JSON, XML</li>
<li>Free table editor - quick table data editing (cleanup data after import/before export, prototype tables etc.)</li>
<li>Archives - backup your data in JSON files on local filesystem (or on DbGate server, when using web application)</li>
<li>Charts, export chart to HTML page</li>
<li>For detailed info, how to run DbGate in docker container, visit <a href="https://hub.docker.com/r/dbgate/dbgate" rel="nofollow">docker hub</a></li>
<li>Extensible plugin architecture</li>
<li>Perspectives - nested table view over complex relational data</li>
</ul>

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and  MariaDB.

DbGate- Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others

Diesel is the most productive way to interact with databases in Rust because of its safe and composable abstractions over queries. Diesel offers a high level query builder and lets you think about your problems in Rust, not SQL. Its focus on zero-cost abstractions allows Diesel to run your query and load your data even faster than C. Unlike Active Record and other ORMs, Diesel is designed to be abstracted over. Diesel enables you to write reusable code and think in terms of your problem domain and not SQL.

Diesel - A safe, extensible ORM and Query Builder for Rust

The fastest and simplest library for SQLite3 in Node.js. It has Full transaction support, High performance, efficiency, and safety, Support for user-defined functions, aggregates, and extensions.
 
Why should I use this instead of node-sqlite3? 
node-sqlite3 uses asynchronous APIs for tasks that are either CPU-bound or serialized. That's not only bad design, but it wastes tons of resources. It also causes mutex thrashing which has devastating effects on performance.

The fastest and simplest library for SQLite3 in Node.js. It has Full transaction support, High performance, efficiency, and safety, Support for user-defined functions, aggregates, and extensions.

better-sqllite3 - The fastest and simplest library for SQLite3 in Node.js

SQLx is an async, pure Rust SQL crate featuring compile-time checked queries without a DSL. It is truly Asynchronous. Built from the ground-up using async/await for maximum concurrency. It has support for PostgreSQL, MySQL, SQLite, and MSSQL. 
 
SQLx supports compile-time checked queries. It does not, however, do this by providing a Rust API or DSL (domain-specific language) for building queries. Instead, it provides macros that take regular SQL as an input and ensure that it is valid for your database. The way this works is that SQLx connects to your development DB at compile time to have the database itself verify (and return some info on) your SQL queries.

SQLx is an async, pure Rust SQL crate featuring compile-time checked queries without a DSL. It is truly Asynchronous. Built from the ground-up using async/await for maximum concurrency. It has support for PostgreSQL, MySQL, SQLite, and MSSQL. 

SQLx - The Rust SQL Toolkit

Discover open source projects across all platforms

Projects