Version 2.0 - whats new?
Bulk loading
Relations got rewritten with optional bulk loading:
const user = await User.limit(3)
const posts = await Promise.all(users.map(user => user.posts))
will only execute 2 queries! To disable bulk loading see bulkFetch.
However, in this case it's better to use const user = await User.include('posts').limit(3)
Faster preloading
include was rewritten to load relations in parallel, if possible (SQL only!)
const users = await User.find(1).include('posts')
/*
will execute `SELECT * FROM users WHERE id=1`
and `SELECT * FROM posts WHERE user_id = 1` in parallel
*/
In V1 the above example would have loaded the data in series.
Of course this is only possible if the conditions for the first query will contain all information needed to execute the second query!
Model autoload (SQL only)
Similar to autoloading model attributes, it's now possible to autoload models.
const Store = require('openrecord/store/sqlite3')
const store = new Store({
file: './my-posts-db.sqlite3',
autoLoad: true // enable autoload
})
store.ready(async () => {
const post = await store.Model('Post').find(1) // Post model is automatically available, if a table `posts` is defined in the sqlite3 database before.
console.log(post)
})
Classes
Defining a model via ES6 classes is now possible
class User extends Store.BaseModel{
fullName(){
return `${this.first_name} ${this.last_name}`
}
}
GraphQL
Support for GraphQL with automatic relation loading and more.
Webpack
It's now possible to bundle your store via webpack (Version 3 and 4)
There is also a Webpack Plugin to cache your data structure inside your bundle. (Faster startup for serverless apps)
Custom operators
It's now possible to define custom operators and use the whole power of knex
// the new operator is called `regexp`
store.addOperator('regexp', function(field, value, query, condition){
query.where(field, '~', value.toString().replace(/(^\/|\/$)/g, '')) // naiv conversion of js regexp to postgres regexp!
})
// and it will be appended to the `string` type
store.appendOperator('string', 'regexp')
Query via:
const user = await User.where({login_regexp: /open.*/})
Everything Promise!
The whole core was rewritten to use Promises instead of async.
Docs
Docs are now available via https://openrecord.js.org
Breaking Changes to V1
plugins and models store config does not take paths anymore. To get the old behavior back, use the automatic model loading pluginparanoid plugin scope to get all records was renamed to withDeleted instead of with_deletedjoin() does an inner join by default (instead of a left join)- Failed validations will now throw an error! Therefore
save, delete, create,... won't return success anymore. Instead it will return the record on success
- Hooks must return a promise or undefined. The
done callback was removed.
create, save, destroy, ... won't take callbacks any more. use e.g. record.save().then(callback)- Relation records wont be saved anymore. except you set autoSave to
true (store or per relation)
- Accessing a relation via e.g.
user.posts will return a then-able object. To access loaded data directly use user._posts (Will return null if not loaded)
limit(1) does not return a single record anymore. Use first() or singleRecord() insteadlogger option on store is no longer available. openrecord now uses the debug module- Drop support for NodeJS lower version 4
Source code(tar.gz)
Source code(zip)
26 Dec 12, 2022
7 May 21, 2022
20 Sep 13, 2022
28 Oct 17, 2022
8 Oct 31, 2022
7 Jul 30, 2022
159 Dec 10, 2022
15 Dec 23, 2022
4 Oct 28, 2022
10 Sep 20, 2022
4 Oct 20, 2022
2.8k Dec 26, 2022
5.7k Jan 6, 2023
2.8k Jan 4, 2023
341 Dec 26, 2022
7k Jan 9, 2023
21 Oct 12, 2022
17 Nov 1, 2022
72 Sep 30, 2022