Objection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while keeping magic to a minimum.Objection.js is built on an SQL query builder called knex. All databases supported by knex are supported by objection.js. SQLite3, Postgres and MySQL are thoroughly tested.

Objection.js - An SQL-friendly ORM for Node.js

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

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

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite3, Microsoft SQL Server, and other databases.The below is a demonstration using usql with xo's booktest simple test database, showcasing the release version v0.5.0. In the demonstration, usql connects to a PostgreSQL database, executes some queries, with variable interpolation, connects to a SQLite3 database file, and does some more queries, before then connecting to a Microsoft SQL database and ending the session.

usql - universal command-line interface for SQL databases

Knex.js is a "batteries included" SQL query builder for Postgres, MSSQL, MySQL, MariaDB, SQLite3, and Oracle designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.

knex - A SQL query builder that is flexible, portable, and fun to use!


rqlite is a lightweight, distributed relational database, which uses SQLite as its storage engine. Forming a cluster is very straightforward, it gracefully handles leader elections, and tolerates failures of machines, including the leader. rqlite gives you the functionality of a rock solid, fault-tolerant, replicated relational database, but with very easy installation, deployment, and operation. With it you've got a lightweight and reliable distributed relational data store. Think etcd or Consul, but with relational data modelling also available.
 
if you're interested in understanding how distributed systems actually work, rqlite is a good example to study. Much thought has gone into its design and implementation, with clear separation between the various components, including storage, distributed consensus, and API. rqlite uses Raft to achieve consensus across all the instances of the SQLite databases, ensuring that every change made to the system is made to a quorum of SQLite databases, or none at all.

rqlite is a lightweight, distributed relational database, which uses SQLite as its storage engine. Forming a cluster is very straightforward, it gracefully handles leader elections, and tolerates failures of machines, including the leader. rqlite gives you the functionality of a rock solid, fault-tolerant, replicated relational database, but with very easy installation, deployment, and operation. With it you've got a lightweight and reliable distributed relational data store. Think etcd or Consul, but with relational data modelling also available.


rqlite - The lightweight, distributed relational database built on SQLite

Squirrel is not an ORM, It helps you build SQL queries from composable parts and also supports executing queries directly. Squirrel works well with PostgreSQL.

Squirrel - Fluent SQL generation for golang

rdb is a ORM for Nodejs. It has support for postgres, mySql and sqlite. It is Simple, flexible mapper and Based on promises. It supports transaction with commit and rollback.

rdb - Javascript ORM

gobang is a cross-platform TUI (terminal UI) database management tool. It supports multiple Database (MySQL, PostgreSQL, SQLite), Intuitive keyboard only control.

gobang - A cross-platform TUI database management tool written in Rust

Discover open source projects across all platforms

Projects