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

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

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

Tale's English meaning for the Story, I believe that every person who insists on writing a blog is a story; Chinese you call it Collapse does not matter.Tale uses a lightweight mvc framework Blade for development, the default theme using a beautiful pinghsu, if you think this project is good, please support it star.
<ul>
<li>Simple design, beautiful interface</li>
<li>Markdown article published</li>
<li>Custom article links</li>
<li>Support multiple themes</li>
<li>Support plugin extension</li>
<li>Support Emoji</li>
<li>Support Netease cloud music player</li>
<li>Support for attachments and database backups</li>
<li>Deployment is simple, do not rely on Tomcat</li>
<li>No database, sqlite embedded</li>
</ul>

Tale's English meaning for the Story, I believe that every person who insists on writing a blog is a story; Chinese you call it Collapse does not matter.Tale uses a lightweight mvc framework Blade for development, the default theme using a beautiful pinghsu, if you think this project is good, please support it star.

Tale - Best beautiful java blog, worth a try

Isso is a lightweight commenting server similar to Disqus. It allows anonymous comments, maintains identity and is simple to administrate. It uses JavaScript and cross-origin ressource sharing for easy integration into (static) websites.

Isso - a Disqus alternative

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.

Projects

MikroORM - TypeScript ORM for Node

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

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

Tale - Best beautiful java blog, worth a try

Isso - a Disqus alternative

usql - universal command-line interface for SQL databases

TechStack

Tagcloud

License

Suggested keywords:

Projects

MikroORM - TypeScript ORM for Node

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

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

Tale - Best beautiful java blog, worth a try

Isso - a Disqus alternative

usql - universal command-line interface for SQL databases

TechStack

Tagcloud

License