attr_json VS Marten

https://github.com/jrochkind/attr_json (by me)

I myself maintain one solution meant for rails attributes stored in a json column, at https://github.com/jrochkind/attr_json

One of these two should do the trick: https://github.com/jrochkind/attr_json https://github.com/DmitryTsepelev/store_model

I also have a similar "competing" in some ways gem at: https://github.com/jrochkind/attr_json

Some relational databases like Postgres and MySQL support JSON columns. This is useful if, for example, you want to create an ecommerce application with a products table with many variations - what is called Single Table Inheritance (STI). You can have some regular columns for the common attributes, and a JSON column for the specific ones.

If your app is built with Rails, you can use this library to help you on that (I'm not affiliated with it): https://github.com/jrochkind/attr_json

Id recommend trying out MartenDb. It's not really a PostgreSQL ORM, it actually uses Postgres more as a document database via jsonb. But it's excruciatingly easy to use and schema updates are a breeze (and largely automatic)

Check out Marten for a fully fleshed out implementation https://github.com/JasperFx/marten

We are using ExtCore here to make our app modular: https://extcore.net/, and MartenDB for event store (which is surprisingly VERY simple) : https://martendb.io/

I always loved Marten, it is so simple to use and yet powerful. If you are unfamiliar with it, it is a data access library (like an ORM) that is using JSON serialization and LINQ to store and query data from/to Postgres. It basically turns Postgres into document DB. Comparing it to EF, Marten doesn't require migrations since it stores documents.

You're better off using Postgres (has JSON columns.) If you want a more "document" oriented experience, use Marten: https://martendb.io/

For that part, the samples use EventStoreDB (https://www.eventstore.com/), which is the only mature event store I know in Node.js land. Event Sourcing allows using any database as backing storage. I'm co-maintainer of the Marten (https://martendb.io/), which is a .NET library that allows using Postgres as event store and document db.

Then you should check out Marten (https://martendb.io/). Our intention is to remove the boilerplate, we're using Postgres e having the built-in projections.

Not to be confused with the C# document database built on Postgres.

https://martendb.io/