Community fork of Jennifer ORM?

[osbre]

Looks like the original author no longer maintains the library. There's a standing PR to support the newer Crystal version (imdrasil/jennifer.cr#464)

It can be a good idea to add a repo here, so that the community can maintain it.

I see that mjblack has already done the work:

• https://github.com/mjblack/jennifer.cr
• https://github.com/mjblack/jennifer_sqlite3_adapter

[crimson-knight]

I've made my own active record version called Grant. I still regularly maintain it to aim for feature parity with Active Record from Rails.

Currently supports PG, SQLITE and MySQL --- mostly sqlite and PG as those are my go-to libraries.

[osbre]

https://github.com/sdogruyol/crystal_community/blob/master/src/models/user.cr

Just came across this approach by the author of Kemal. There is something beautiful about not using any ORM at all.

A question I asked him:

How would you scale it when you need relationships? ie if the user has projects, would you make a new UserWithProjects struct?

Answer:

@osbre mostly defining a relationship method like projects on User model. then calling it like user.projects

you would also make it lazy load with some inline cache like @project || = idiom

I've built some medium DB-heavy systems with Kemal using raw SQL with crystal-db. It's a breeze 🤌