[jclevy]

I have to look deeper at SQLite4 spec...

I would say that my objective with ChocoDB is to make it accessible and useful to people who want to manage database structures and queries in a more natural way.

I want the database to help manage different types of relations: inclusion, group, structure, association...

Key/value is simple but it does not help to manage relations. Relational DB don't either help to manage different types of relations.

[zeckalpha]

Would a graph database be closer to what you are looking to do?

[jclevy]

Probably, but I haven't found yet my dreamed graph DB (serverless, Node.js compatible...).

[andrewcooke]

what relations does a relational db not help with? (i thought they were basically an implementation of the relational model).

[jclevy]

Being a child of, being included in...

You can of course manage all those relations in a relational database but the job is done by you, not by the database.

[andrewcooke]

but isn't the point of being able to implement any relationship you want rather than having a few particular kinds (child of, included in) "built in" a feature? are you going to extend your database every time someone wants a different kind of relationship?

[jclevy]

Yes, but usual relations could be implemented by default and generic relation still be available.

I just want to test this and see if the database can do more and my code less.