okay, so, from the relational .json for the different districts of ya-Don, you can get the map, and from the map plus the relational .json, you can get people walking into the city along the canal which heads into St. Oreli's Shade, the Amber Quarter visible on the bluffs to the left
September 19, 2026 at 2:45 AM
okay, so, from the relational .json for the different districts of ya-Don, you can get the map, and from the map plus the relational .json, you can get people walking into the city along the canal which heads into St. Oreli's Shade, the Amber Quarter visible on the bluffs to the left
Having fun with Oracle JSON-Relational Duality Views
December 21, 2024 at 12:59 PM
Having fun with Oracle JSON-Relational Duality Views
Using Oracle JSON-Relational Duality Views with Spring Boot. The ORM Killer?
Using Oracle JSON-Relational Duality Views with Spring Boot. The ORM Killer? - Keep IT Simple with Simon Martinelli
Oracle Database 23ai introduced a powerful feature called JSON-Relational Duality Views. These views let you work with relational data in a document-oriented way. In this post, I'll show you how to…
buff.ly
December 24, 2024 at 7:00 AM
Using Oracle JSON-Relational Duality Views with Spring Boot. The ORM Killer?
I designed a utility procedure to turn a JSON object into a bunch of relational tables in SQL Server, along with a new procedure that loads those tables.
Should work on SQL 2019 and newer.
Your thoughts or feedback is appreciated. :)
Should work on SQL 2019 and newer.
Your thoughts or feedback is appreciated. :)
GitHub - sqlsunday/json-to-relational: T-SQL to dynamically build a stored procedure to load a JSON blob into relational tables
T-SQL to dynamically build a stored procedure to load a JSON blob into relational tables - sqlsunday/json-to-relational
github.com
July 9, 2025 at 1:11 PM
I designed a utility procedure to turn a JSON object into a bunch of relational tables in SQL Server, along with a new procedure that loads those tables.
Should work on SQL 2019 and newer.
Your thoughts or feedback is appreciated. :)
Should work on SQL 2019 and newer.
Your thoughts or feedback is appreciated. :)
TIL @micronautfw.bsky.social Data added support for Oracle JSON-Relational Duality View: blogs.oracle.com/java/post/js...
blogs.oracle.com
December 28, 2024 at 1:26 PM
TIL @micronautfw.bsky.social Data added support for Oracle JSON-Relational Duality View: blogs.oracle.com/java/post/js...
With JSON relational duality views in 23ai you can
Use graphQL style syntax to generate JSON from tables
Insert JSON into the view & the database converts it to tables for you
@alexnuijten.bsky.social at #DOAG2024
Use graphQL style syntax to generate JSON from tables
Insert JSON into the view & the database converts it to tables for you
@alexnuijten.bsky.social at #DOAG2024
November 20, 2024 at 4:03 PM
With JSON relational duality views in 23ai you can
Use graphQL style syntax to generate JSON from tables
Insert JSON into the view & the database converts it to tables for you
@alexnuijten.bsky.social at #DOAG2024
Use graphQL style syntax to generate JSON from tables
Insert JSON into the view & the database converts it to tables for you
@alexnuijten.bsky.social at #DOAG2024
Key benefits of the Oracle JSON-Relational Duality View: blogs.oracle.com/database/pos...
blogs.oracle.com
December 28, 2024 at 11:56 AM
Key benefits of the Oracle JSON-Relational Duality View: blogs.oracle.com/database/pos...
There are many enhancements coming in upcoming 23ai patches for
Vector search
GPU offload on Autonomous
JSON relational duality views
Property graph queries
@domgiles.bsky.social showing us at #ukoug2024
Vector search
GPU offload on Autonomous
JSON relational duality views
Property graph queries
@domgiles.bsky.social showing us at #ukoug2024
December 3, 2024 at 9:41 AM
There are many enhancements coming in upcoming 23ai patches for
Vector search
GPU offload on Autonomous
JSON relational duality views
Property graph queries
@domgiles.bsky.social showing us at #ukoug2024
Vector search
GPU offload on Autonomous
JSON relational duality views
Property graph queries
@domgiles.bsky.social showing us at #ukoug2024
I think this is the Oracle database weekend ;-)
Now playing with ORDS and JSON-Relational Duality views. Awesome stuff!
Now playing with ORDS and JSON-Relational Duality views. Awesome stuff!
December 22, 2024 at 5:07 PM
I think this is the Oracle database weekend ;-)
Now playing with ORDS and JSON-Relational Duality views. Awesome stuff!
Now playing with ORDS and JSON-Relational Duality views. Awesome stuff!
January 12, 2025 at 8:34 AM
TinyJoin is a tiny, worker-first relational database for the browser. The new TinyJoinPersister saves a TinyBase Store into it, in JSON or tabular form, and follows TinyJoin's own table subscriptions rather than polling.
tinybase.org/api/persiste...
tinybase.org/api/persiste...
September 25, 2026 at 6:48 AM
TinyJoin is a tiny, worker-first relational database for the browser. The new TinyJoinPersister saves a TinyBase Store into it, in JSON or tabular form, and follows TinyJoin's own table subscriptions rather than polling.
tinybase.org/api/persiste...
tinybase.org/api/persiste...
I have stumbled across some implicit data conversions that I was unaware of, causing poor performance when querying JSON-relational duality views.
I demonstrate what I mean using a simplified example in this blog post.
www.salvis.com/blog/2025/01...
I demonstrate what I mean using a simplified example in this blog post.
www.salvis.com/blog/2025/01...
Avoid Implicit Type Conversion in JSON Access - Philipp Salvisberg's Blog
Discover why explicit JSON value conversion in SQL is essential for best performance and how to apply it in your code.
www.salvis.com
January 28, 2025 at 5:08 PM
I have stumbled across some implicit data conversions that I was unaware of, causing poor performance when querying JSON-relational duality views.
I demonstrate what I mean using a simplified example in this blog post.
www.salvis.com/blog/2025/01...
I demonstrate what I mean using a simplified example in this blog post.
www.salvis.com/blog/2025/01...
Please join me for our first Oracle ACE Virtual conference on Dec. 11th! ♠️
With sessions from our amazing ACE speakers on:
🔥 Gen AI
🏆 Java
💥 Oracle Database@Azure
🎉 JSON Relational Duality
✨ Fusion Apps
⚡ OCI
Register for this FREE event here: apex.oracle.com/go/oracleace...
With sessions from our amazing ACE speakers on:
🔥 Gen AI
🏆 Java
💥 Oracle Database@Azure
🎉 JSON Relational Duality
✨ Fusion Apps
⚡ OCI
Register for this FREE event here: apex.oracle.com/go/oracleace...
December 4, 2024 at 5:15 PM
Please join me for our first Oracle ACE Virtual conference on Dec. 11th! ♠️
With sessions from our amazing ACE speakers on:
🔥 Gen AI
🏆 Java
💥 Oracle Database@Azure
🎉 JSON Relational Duality
✨ Fusion Apps
⚡ OCI
Register for this FREE event here: apex.oracle.com/go/oracleace...
With sessions from our amazing ACE speakers on:
🔥 Gen AI
🏆 Java
💥 Oracle Database@Azure
🎉 JSON Relational Duality
✨ Fusion Apps
⚡ OCI
Register for this FREE event here: apex.oracle.com/go/oracleace...
Think of this as Claude Artifacts reimagined for Datasette - you get all the power of artifacts but with a JSON API to a full relational database, allowing your HTML+JS apps to access and store data in all shapes and sizes
June 19, 2026 at 12:03 AM
Think of this as Claude Artifacts reimagined for Datasette - you get all the power of artifacts but with a JSON API to a full relational database, allowing your HTML+JS apps to access and store data in all shapes and sizes
Oracle PMs @bhammers.bsky.social and Tirthankar Lahiri are showing us how to have our cake and eat it too!
The best of both worlds with JSON Document Relational Duality.
#doag2024
The best of both worlds with JSON Document Relational Duality.
#doag2024
November 19, 2024 at 10:31 AM
Oracle PMs @bhammers.bsky.social and Tirthankar Lahiri are showing us how to have our cake and eat it too!
The best of both worlds with JSON Document Relational Duality.
#doag2024
The best of both worlds with JSON Document Relational Duality.
#doag2024
EAV is a way of storing arbitrary data in a relational way as (id, string, string) records. Good for "rare" data
Why not just use a JSON column? Because EAV evolved when relational databases didn't *have* JSON types. Now that we have them, JSON columns are more optimal than EAV in *some* situations
Why not just use a JSON column? Because EAV evolved when relational databases didn't *have* JSON types. Now that we have them, JSON columns are more optimal than EAV in *some* situations
April 30, 2025 at 7:18 PM
EAV is a way of storing arbitrary data in a relational way as (id, string, string) records. Good for "rare" data
Why not just use a JSON column? Because EAV evolved when relational databases didn't *have* JSON types. Now that we have them, JSON columns are more optimal than EAV in *some* situations
Why not just use a JSON column? Because EAV evolved when relational databases didn't *have* JSON types. Now that we have them, JSON columns are more optimal than EAV in *some* situations
📣 Presenting at #apexconn25: Non-APEX App Dev with JSON Duality Views
Join @hartenfeller.dev to see how Oracle 23ai's JSON Duality Views enable MongoDB-like simplicity with relational DB benefits. Live JavaScript frontend demo compared to traditional ORMs!
my.doag.org/events/apex-...
#orclapex
Join @hartenfeller.dev to see how Oracle 23ai's JSON Duality Views enable MongoDB-like simplicity with relational DB benefits. Live JavaScript frontend demo compared to traditional ORMs!
my.doag.org/events/apex-...
#orclapex
May 5, 2025 at 7:52 AM
📣 Presenting at #apexconn25: Non-APEX App Dev with JSON Duality Views
Join @hartenfeller.dev to see how Oracle 23ai's JSON Duality Views enable MongoDB-like simplicity with relational DB benefits. Live JavaScript frontend demo compared to traditional ORMs!
my.doag.org/events/apex-...
#orclapex
Join @hartenfeller.dev to see how Oracle 23ai's JSON Duality Views enable MongoDB-like simplicity with relational DB benefits. Live JavaScript frontend demo compared to traditional ORMs!
my.doag.org/events/apex-...
#orclapex
48 bytes of JSON vs 665 KB of Wasm SQLite is a brutal tradeoff on paper — curious what broke first when you dropped relational queries for .daobase.
September 25, 2026 at 4:27 PM
48 bytes of JSON vs 665 KB of Wasm SQLite is a brutal tradeoff on paper — curious what broke first when you dropped relational queries for .daobase.
The convergence of SQL and NoSQL combines the simplicity of JSON document development and the power of relational databases within a single database.
To SQL or Not To SQL: That Is Not the Question
The convergence of SQL and NoSQL combines the simplicity of JSON document development and the power of relational databases within a single database.
bit.ly
May 8, 2025 at 3:00 AM
The convergence of SQL and NoSQL combines the simplicity of JSON document development and the power of relational databases within a single database.
Achieve #Developer's Nirvana with the new #JSON-#Relational #Duality! Register at: apexadb.oracle.com/ords/r/tech/...
#Oracle #Database #23ai combines the simplicity of the JSON document model with the power of the relational model
#AutonomousDatabase #ADB #LearningLounge #ADBLearningLounge
#Oracle #Database #23ai combines the simplicity of the JSON document model with the power of the relational model
#AutonomousDatabase #ADB #LearningLounge #ADBLearningLounge
March 14, 2025 at 2:54 PM
Achieve #Developer's Nirvana with the new #JSON-#Relational #Duality! Register at: apexadb.oracle.com/ords/r/tech/...
#Oracle #Database #23ai combines the simplicity of the JSON document model with the power of the relational model
#AutonomousDatabase #ADB #LearningLounge #ADBLearningLounge
#Oracle #Database #23ai combines the simplicity of the JSON document model with the power of the relational model
#AutonomousDatabase #ADB #LearningLounge #ADBLearningLounge
the "file over app" people are somewhat unserious in their dismissal of relational DB-based data structures, but i think an acceptable compromise would be for modern apps to start standardising things
it can be JSON blobs for all i care, but well-defined JSON blobs please
it can be JSON blobs for all i care, but well-defined JSON blobs please
May 20, 2025 at 9:44 AM
the "file over app" people are somewhat unserious in their dismissal of relational DB-based data structures, but i think an acceptable compromise would be for modern apps to start standardising things
it can be JSON blobs for all i care, but well-defined JSON blobs please
it can be JSON blobs for all i care, but well-defined JSON blobs please
PostgreSQL and the Resurgence of Relational SQL Databases
Native JSON, pgvector, PostGIS - why SQL won again.
🔗 https://blog.ismaeltech.com/2026-09-22-postgresql-e-o-renascimento-dos-bancos-sql-relacionais-en
Native JSON, pgvector, PostGIS - why SQL won again.
🔗 https://blog.ismaeltech.com/2026-09-22-postgresql-e-o-renascimento-dos-bancos-sql-relacionais-en
September 25, 2026 at 5:57 PM
PostgreSQL and the Resurgence of Relational SQL Databases
Native JSON, pgvector, PostGIS - why SQL won again.
🔗 https://blog.ismaeltech.com/2026-09-22-postgresql-e-o-renascimento-dos-bancos-sql-relacionais-en
Native JSON, pgvector, PostGIS - why SQL won again.
🔗 https://blog.ismaeltech.com/2026-09-22-postgresql-e-o-renascimento-dos-bancos-sql-relacionais-en