eggjs / egg

🥚 Born to build better enterprise frameworks and apps with Node.js & Koa

https://eggjs.org

MIT License

18.87k stars 1.81k forks source link

eggjs orm plugin specification #388

Closed jtyjty99999 closed 7 years ago

jtyjty99999 commented 7 years ago

Now there are more and more orm framework requirements, most orm framework are Active-record-pattern-like(https://en.wikipedia.org/wiki/Active_record_pattern), similar to the view plugin(https://eggjs.org/zh-cn/advanced/view-plugin.html), we need a specification for egg orm plugin.

Orm framework generally has the following features:

transform table to object, and use files under app/models to define.
Relationship between several tables.
Syntactic sugar for query, update, delete etc. ...

So let us discuss whether a specification is needed or not?

atian25 commented 7 years ago

currently, we got:

@popomore should we need proposal label?

popomore commented 7 years ago

@atian25 maybe RFC

popomore commented 7 years ago

Current we have https://github.com/eggjs/egg-labels/blob/master/labels.json

jtyjty99999 commented 7 years ago

Now we see some points in specification:

Directory for defining data models like app/model or app/models
File name specification for data model
How to access data model, by ctx/app
plugin pattern
- config
- heartbeat request
- tracelog
- event handle like onerror, ondisconnect, onconnect

atian25 commented 7 years ago

only use app/model, not s

popomore commented 7 years ago

https://github.com/tgriesser/bookshelf

StoneRen commented 7 years ago

https://github.com/balderdashy/waterline Waterline is a next-generation storage and retrieval engine, and the default ORM used in the Sails framework It provides a uniform API for accessing stuff from different kinds of databases, protocols, and 3rd party APIs. That means you write the same code to get and store things like users, whether they live in Redis, MySQL, MongoDB, or Postgres.

guzuomuse commented 7 years ago

@atian25 @popomore how is going about this topic? we need an offical orm. is there a roadmap or timeline for this?

popomore commented 7 years ago

We recommend use egg-sequelize, see https://github.com/eggjs/egg/issues/388

hyurl commented 6 years ago

I have developed an ORM, Modelar, I recommend have a look at it, may satisfy egg needs, support MySQL/MariaDB, PostgreSQL, SQLite, MsSQL, OracleDB and DB2, similar to TypeORM, but written in pure JavaScript. https://github.com/hyurl/modelar Give me notice if you'd like it or have any suggests.

A demo has been published at cnode.org, please visit: https://cnodejs.org/topic/5a27b1add92f2f5b185acc68