🚀 New book release: GeoAI with Python: A Practical Guide to Open-Source Geospatial AI The full PDF edition (423 pages) is now available on Leanpub: leanpub.com/geoai All code examples are freely available: book.opengeoai.org
The new features guide for Oracle AI Database 23.26.2 is out: docs.oracle.com/en/database/... One interesting addition is the join_to_one clause, which uses integrity constraints to simplify joins.
How do you enforce temporal data integrity? With SQL Assertions in Oracle AI Database, we can now implement constraints such as: ✅ Non-overlapping validity periods ✅ Temporal referential integrity Here's a practical example using an extended DEPT-EMP model. www.salvis.com/blog/2026/03...
Using SQL Assertions to Enforce Temporal Data Integrity
Introduction More than twelve years ago, I described the multi-temporal features of Oracle Database in this blog post. In the conclusion, I wrote that I missed a temporal DML API, temporal integrity c...
salvis.com
Checks of a small Flutter-developed desktop app on Oracle REST and Oracle Cloud Autonomous DB in Google's new @antigravity IDE, incl. the Flutter Devtools Inspector.
The best JavaScript book for me is by Dr Axel RauschMayer: exploringjs.com/js/index.html
Exploring JavaScript (ES2024 Edition)
exploringjs.com
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...
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.
salvis.com
The JSON Duality View Builder in the Oracle SQL Developer Extension for VSCode is really cool. A unique feature in VS Code. I wish it had been available when I wrote my blog post about flexible schemas in JSON duality views. www.salvis.com/blog/2024/06...
SQL/PGQ is part of the 2023 SQL standard and available in Oracle Database 23ai Using this you can define graph relationships over your tables Then use GRAPH_TABLE to search it @gianniceresa.bsky.social explains at #ukoug2024
@niallmcp.bsky.social showing how to use vector_distance to do semantic search with #SQL This enables you to compare vector embeddings to find rows related to your search #DOAG2024
