typeorm

TypeScript & JavaScript ORM for Node.js — supports PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, and more.

What is typeorm?

TypeScript & JavaScript ORM for Node.js — supports PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, and more.

Overview of typeorm

What it is

TypeORM is an ORM that can run in Node.js, Browser, Cordova, Ionic, React Native, NativeScript, Expo, and Electron platforms and can be used with TypeScript and JavaScript (ES2023). It supports Google Spanner, Microsoft SqlServer, MySQL/MariaDB, MongoDB, Oracle, Postgres, SAP HANA and SQLite, as well as derived databases and different drivers. TypeORM supports both Active Record and Data Mapper patterns, unlike all other JavaScript ORMs currently in existence, which means you can write high-quality, loosely coupled, scalable, maintainable applications in the most productive way. TypeORM is highly influenced by other ORMs, such as Hibernate, Doctrine and Entity Framework.

Key features

  • Supports both DataMapper and ActiveRecord patterns.
  • Entities and columns with database-specific column types.
  • Associations (relations) including eager and lazy, unidirectional, bidirectional, and self-referenced.
  • Migrations and automatic migrations generation.
  • Elegant-syntax, flexible and powerful QueryBuilder with left and inner joins, proper pagination, query caching, and streaming raw results.
  • Listeners and subscribers (hooks).
  • Works in Node.js / Browser / Ionic / Cordova / React Native / NativeScript / Expo / Electron platforms.

Use cases

TypeORM can be used to develop any kind of application that uses databases, from small applications with a few tables to large-scale enterprise applications with multiple databases. It supports multiple database instances and cross-database/cross-schema queries.

Getting started

See the repository README for installation and quick-start instructions.

License and pricing

License: MIT. Pricing: open source (free).

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/typeormtypeorm.svg)](https://yunodb.com/tools/typeormtypeorm?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/typeormtypeorm?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/typeormtypeorm.svg" alt="Featured on YunoDB" height="20"></a>