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)

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

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

Patroni is a template for you to create your own customized, high-availability solution using Python and - for maximum accessibility - a distributed configuration store like ZooKeeper, etcd, Consul or Kubernetes. Database engineers, DBAs, DevOps engineers, and SREs who are looking to quickly deploy HA PostgreSQL in the datacenter-or anywhere else-will hopefully find it useful.

Patroni - A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul

Non-blocking PostgreSQL client for Node.js. Pure JavaScript and optional native libpq bindings. It supports Connection pooling, PostgreSQL data-type coercion, Parameterized queries, Named statements with query plan caching, Async notifications with LISTEN/NOTIFY and lot more.

node-postgres - PostgreSQL client for node.js

<div>
<div>
Payload is a headless CMS and application framework. It&rsquo;s meant to provide a massive boost to your development process, but importantly, stay out of your way as your apps get more complex. Payload is a config-based, code-first CMS and application framework. The Payload config is central to everything that Payload does. It scaffolds the data that Payload stores as well as maintains custom React components, hook logic, custom validations, and much more.
Payload dynamically generates a beautiful, fully functional React admin panel to manage your data. It's extremely powerful and can be customized / extended upon easily by swapping in your own React components. Payload supports <a href="mongodb.com/" target="_blank" rel="noopener">MongoDB</a> and <a href="https://www.postgresql.org/" target="_blank" rel="noopener">PostgreSQL</a> database and it uses database adaptor to interact with database. &nbsp;MongoDB is a preferred choice but if you want a relational database then choose Postgres.
Its other features include Rich text editor, Web hooks, Live preview, Authentication, GraphQL, Rest API and lot more.
</div>
</div>

Payload is a headless CMS and application framework. It’s meant to provide a massive boost to your development process, but importantly, stay out of your way as your apps get more complex.

Payload -  Headless CMS and Application Framework

The Marten library provides .NET developers with the ability to use the proven PostgreSQL database engine and its fantastic JSON support as a fully fledged document database. The Marten team believes that a document database has far reaching benefits for developer productivity over relational databases with or without an ORM tool.Marten also provides .NET developers with an ACID-compliant event store with user-defined projections against event streams.

Marten - Postgresql as a Document Database and Event Store for .Net Applications

Web-based PostgreSQL database browser written in Go.Pgweb is a web-based database browser for PostgreSQL, written in Go and works on OSX, Linux and Windows machines. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL databases.
 
<ul>
<li>Cross-platform support OSX/Linux/Windows 32/64-bit</li>
<li>Simple installation (distributed as a single binary)</li>
<li>Zero dependencies</li>
<li>Works with PostgreSQL 9.1+</li>
<li>SSH Connections</li>
<li>Multiple database sessions</li>
<li>Simple database browser</li>
<li>Execute and analyze custom SQL queries</li>
<li>Table and query data export to CSV/JSON/XML</li>
<li>Query history</li>
<li>Server bookmarks</li>
</ul>

Pgweb is a web-based database browser for PostgreSQL, written in Go. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL databases.

pgweb - Web-based PostgreSQL database browser written in 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

PostGraphile is an instant, highly-performant GraphQL API for your PostgreSQL database, extensible via a powerful plugin system.  It allows you to access the power of PostgreSQL through a well designed, extensible, customisable and incredibly performant GraphQL server. It automatically detects tables, columns, indexes, relationships, views, types, functions, comments, and more - providing a GraphQL server that is highly intelligent about your data, and that automatically updates itself without restarting when you change your database schema.

PostGraphile - High-performance GraphQL API for your PostgreSQL database

PostgREST serves a fully RESTful API from any existing PostgreSQL database. The structural constraints and permissions in the database determine the API endpoints and operations. It is an alternative to manual CRUD programming. Custom API servers suffer problems. Writing business logic often duplicates, ignores or hobbles database structure. Object-relational mapping is a leaky abstraction leading to slow imperative code. The PostgREST philosophy establishes a single declarative source of truth: the data itself.

PostgREST - RESTful API from any existing PostgreSQL database

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

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

PostHog provides open-source product analytics, built for developers. Automate the collection of every event on your website or app, with no need to send data to 3rd parties. It provides event-based analytics at a user level, capture your product's usage data to see which users are doing what in your application. It automatically capture clicks and pageviews to analyze what your users are doing without pushing events manually. PostHog supports session recording to watch videos of your user behavior, with fine-grained privacy controls. It also has plugins to integrate your product usage data with other systems, like your CRM, or data lakes.
Its features include:
<ul>
<li>Event based analytics</li>
<li>User and Group Tracking</li>
<li>Data Visualization</li>
<li>Session Recording</li>
<li>Feature Flag</li>
<li>Heatmap</li>
<li>Correlation analysis</li>
</ul>
If you want to test or play with PostHog, try installing in Linux using Docker
<pre class="language-bash"><code> /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/posthog/posthog/HEAD/bin/deploy-hobby)" </code></pre>
&nbsp;

PostHog provides open-source product analytics, built for developers. Automate the collection of every event on your website or app, with no need to send data to 3rd parties. It provides event-based analytics at a user level, capture your product's usage data to see which users are doing what in your application. It automatically capture clicks and pageviews to analyze what your users are doing without pushing events manually.

PostHog - Product analytics, built for developers

pq is a pure Go postgres driver for Go's database/sql package. Its features include
<ul>
<li>SSL</li>
<li>Handles bad connections for <code>database/sql</code></li>
<li>Scan <code>time.Time</code> correctly (i.e. <code>timestamp[tz]</code>, <code>time[tz]</code>, <code>date</code>)</li>
<li>Scan binary blobs correctly (i.e. <code>bytea</code>)</li>
<li>Package for <code>hstore</code> support</li>
<li>COPY FROM support</li>
<li>pq.ParseURL for converting urls to connection strings for sql.Open.</li>
<li>Many libpq compatible environment variables</li>
<li>Unix socket support</li>
<li>Notifications: <code>LISTEN</code>/<code>NOTIFY</code></li>
<li>pgpass support</li>
</ul>

pq is a pure Go postgres driver for Go's database/sql package.

pq - Pure Go Postgres driver for database/sql

Discover open source projects across all platforms

Projects