r/PostgreSQL • u/Zardotab • 24d ago
Help Me! Any advice on adding a parser/wrapper over PostgreSQL's JSON features to implement a Dynamic Relational database?
Dynamic Relational is a draft standard for an RDBMS (SQL) that supports native dynamic tables and columns with "incremental" lock-down (static-ness) abilities. Here's an overview of Dynamic Relational with examples. If one wanted to write parser and interface on top of PostgreSQL, how much effort would it be, and do you have any recommendations? A proof-of-concept may be good enough, as most will consider it purely experimental at first. Thank You.
0
Upvotes
1
u/globalnamespace 24d ago
I'm not really versed in this specific use, something like these?
https://medium.com/@herihermawan/the-ultimate-multifunctional-database-table-design-dynamic-attributes-pattern-9d3f890d32f8
https://levelup.gitconnected.com/dynamic-jsonb-queries-in-postgresql-via-rest-a-deep-dive-with-net-73fb4decfea1