News for hackers. Stuff that matters.

A comment on What I Learned from Making the Python Back End for My New Webapp. Parent comment

Re:What I Learned from Making the Python Back End for My New... by eigenvalue on Friday October 18, 2024 @04:22PM (#41883113)
There is a JSON column type in SQLite now, and it's supported by SQLModel/SQLalchemy:

https://www.sqlite.org/json1.html

[ Parent | on HN ]
Re:What I Learned from Making the Python Back End for My New... by bb88 on Friday October 18, 2024 @11:49PM (#41885513)
There's a JSONB column type in postgres for a while now too with the arrow syntax.

I think my point is that the structure of the data in a relational database is tree-like. Yet we can only get tabular data out of the queries.

[ Parent | on HN ]