Discussion about this post

User's avatar
Nicolas Duminil's avatar

Storing JSON serialized objects in datastores, that's a long running story. It started, as far as I remember, back to Y2K, when Oracle 8 introduced a new SQL type, the XMLType.

It wasn't JSON, of course, but XML. One could CRUD XMLType data in / from tables or create tables of XMLType.

Another new type supported by Oracle SQL and PL/SQL was the Object type. One could define object types (classes), like in Java, and CRUD them. Or write polymorphe SQL query returning different object types and taling advantage ofcthe XMLType automatic marshalling/unmarshalling.

Very advanced functions for that epoch. Where are these functions today ? Did anyone use them in real enterprise grade applications ? The SQL standard has never approved, adopted and included the associated extensions and they remained just as technological curiosities.

History has this particularity of repeating itself.

Expand full comment

No posts

Ready for more?