On: Prolog language for PostgreSQL proof of concept

[naasking]

> If your entire database can be lifted into the application's heap, it's probably small enough that I wonder why you've got it stored in an RDBMS

I think he meant lifting the database schema, not the whole database. This would help with auto completion and other static checks before trying to run queries.

[Izkata → naasking]

Much much more important would be the foreign keys. If I remember my prolog correctly, this:

  parent(alice,bob).

is duplicating information that could already be found in the schema's relationships.

[madsbuch → Izkata]

Something like this! So that you can naturally query your data defining relationships and constraints

(This can already be done using joins, but that is not very ergonomical, especially when a lot of relations are at play)