All Projects → PhilWaldmann → Openrecord

PhilWaldmann / Openrecord

Licence: mit
Make ORMs great again!

Programming Languages

javascript
184084 projects - #8 most used programming language

Projects that are alternatives of or similar to Openrecord

Walkable
A Clojure(script) SQL library for building APIs: Datomic® (GraphQL-ish) pull syntax, data driven configuration, dynamic filtering with relations in mind
Stars: ✭ 384 (-18.99%)
Mutual labels:  graphql, sql, orm, mysql, postgresql, sqlite3
Qb
The database toolkit for go
Stars: ✭ 524 (+10.55%)
Mutual labels:  sql, orm, mysql, postgresql, sqlite3
Xo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
Stars: ✭ 2,974 (+527.43%)
Mutual labels:  oracle, sql, orm, mysql, postgresql
Lucid
AdonisJS official SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more
Stars: ✭ 613 (+29.32%)
Mutual labels:  sql, orm, mysql, postgresql, sqlite3
Sworm
a write-only ORM for Node.js
Stars: ✭ 128 (-73%)
Mutual labels:  sql, orm, mysql, postgresql, sqlite3
Jooq
jOOQ is the best way to write SQL in Java
Stars: ✭ 4,695 (+890.51%)
Mutual labels:  oracle, sql, orm, mysql, postgresql
Mormot
Synopse mORMot ORM/SOA/MVC framework
Stars: ✭ 607 (+28.06%)
Mutual labels:  oracle, orm, mysql, postgresql, sqlite3
Sqlcheck
Automatically identify anti-patterns in SQL queries
Stars: ✭ 2,062 (+335.02%)
Mutual labels:  oracle, sql, mysql, postgresql, sqlite3
Smartsql
SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
Stars: ✭ 775 (+63.5%)
Mutual labels:  oracle, sql, orm, mysql, postgresql
Rom Sql
SQL support for rom-rb
Stars: ✭ 169 (-64.35%)
Mutual labels:  oracle, sql, mysql, postgresql, sqlite3
Linq2db
Linq to database provider.
Stars: ✭ 2,211 (+366.46%)
Mutual labels:  oracle, sql, orm, mysql, postgresql
Sqlfiddle3
New version based on vert.x and docker
Stars: ✭ 242 (-48.95%)
Mutual labels:  oracle, sql, mysql, postgresql
E Commerce Db
Database schema for e-commerce (webstores) sites.
Stars: ✭ 245 (-48.31%)
Mutual labels:  oracle, sql, mysql, postgresql
Freesql
🦄 .NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, Click house orm, MsAccess orm.
Stars: ✭ 3,077 (+549.16%)
Mutual labels:  oracle, orm, mysql, postgresql
Pony
Pony Object Relational Mapper
Stars: ✭ 2,762 (+482.7%)
Mutual labels:  oracle, orm, mysql, postgresql
Dbeaver
Free universal database tool and SQL client
Stars: ✭ 23,752 (+4910.97%)
Mutual labels:  oracle, sql, mysql, postgresql
Graphjin
GraphJin - Build APIs in 5 minutes with GraphQL. An instant GraphQL to SQL compiler.
Stars: ✭ 1,264 (+166.67%)
Mutual labels:  graphql, sql, mysql, postgresql
Entityframework.exceptions
Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql
Stars: ✭ 266 (-43.88%)
Mutual labels:  oracle, mysql, postgresql, sqlite3
Qxorm
QxOrm library - C++ Qt ORM (Object Relational Mapping) and ODM (Object Document Mapper) library - Official repository
Stars: ✭ 176 (-62.87%)
Mutual labels:  oracle, orm, mysql, postgresql
Directus
Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.
Stars: ✭ 13,190 (+2682.7%)
Mutual labels:  graphql, oracle, mysql, postgresql

OpenRecord

Build Status Coverage Status npm package version Package Quality Code Quality: Javascript Total Alerts

OPENRECORD is an ActiveRecord inspired ORM for nodejs.

Currently it supports the following databases/datastores: SQLite3, MySQL, Postgres, Oracle, REST and LDAP (+ ActiveDirectory)
If you want to build a GraphQL endpoint for any of these databases, OPENRECORD has some built in features to support you!

As the name imply, it's open and very easy to extend. The whole package was build that way.

It has a lot of features, just take a look at the docs!

Usage example

Here is an example how to get a single post from an existing sqlite3 file (by primary key).

const Store = require('openrecord/store/sqlite3')

const store = new Store({
  file: './my-posts-db.sqlite3',
  autoLoad: true
})

store.ready(async () => {
  const post = await store.Model('Post').find(1)
  console.log(post)
})

You don't have to define your model (optional) and you also don't have to define your model's attributes (optional).
Take a look at the docs to get started!

Contributing

If you've found a bug please report it via the issues page.
Before you submit a pull request, please make sure all tests still pass.


Sponsored by digitalbits.at

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].