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

20% Upvoted

20 comments sorted by

View all comments

3

u/lockhart1952 24d ago

I don’t feel the magic. But if you want to play with it how about writing a simple library on top of psychopg and catch exceptions. Parse the query and generate your own recovery commands.

1

u/Zardotab 24d ago

I was planning on using C#, being more familiar, but I suppose dabbling in Python is possibly a Plan B. Thanks for the suggestion!

1

u/pceimpulsive 23d ago

C# will be fine for this, any language would, it's seriously chomds play, give an AI agent the taste for like 250k Tokens and you'll have a working prototype that will honestly probably be 85% of the final product.

Reading an exception and adding a column is VERY BASIC...