A Blog on Oracle and Stuff

Oracle Spatial Studio is a bit like a music studio. It is a place to explore things and get new ideas in the process. With this tool you can explore data on maps and discover new connections between various datasets. You don’t need a lot of data before a viualization becomes useful, especially for spatial data. First session with Oracle Spatial Studio With Spatial Studio it is easy to load, verify and visualize spatial data. Data you want to put on a map are often distributed in special format like GeoJSON and ESRI spatial files. I am not aware of any other simple tool that makes it easier to load this kind of data into the Oracle database. ...

This is part 0 in a series on Oracle Spatial Studio. There are a few ways to run Oracle Spatial Studio, this post shows you how to run Oracle Spatial Studio from your PC and from a stack in Oracle Cloud. Get started with Oracle Spatial Studio - Installation It has been a while… I have looked into Oracle Spatial Studio and decided to blog about it. Run it from your PC Also known as on-prem. You can choose between: ...

I wrote about UUIDs in the Oracle database two months back in this post , but it turns out that UUID v4 is so… 2005 . You probably need UUID v7 Head over to How UUIDv7 makes your (database) life easier to understand why you want v7. As mentioned in the article there is no native support for v7 in Oracle, neither a function to generate it or a proper datatype for UUIDs like PostgreSQL has. But the article shows an implementation of v7 generation in a PL/SQL function called generate_uuid_v7 that I used in some testing. ...

The problem I just got a new iPhone, I have had the old one for four years and I hope the new one will last even longer; moving all those 2FA apps and all the rest is a big hassle. Pro tip: Don’t reset or give away your old phone right after the new one seems to be working. You will need the old one for much longer than you think. ...

This is an update of previous post on How to install OML4Py Client on Ubuntu , this time Oracle Linux 9. Install OML4Py on Oracle Linux The goal here is to have OML4Py 2.1 available in order to export embedding models to ONNX format. To follow this procedure you need to have a free Oracle Account, you will be offered to create one when you try to access https://edelivery.oracle.com/ later. This installation is divided in parts: ...

Update: I wrote another post about UUID v7 with some alternative solutions. UUIDs are useful, especially when you expose data in REST APIs, but there are cases where you may want to stick to the good old sequence-based primary key. UUIDs in Oracle Database #JoelKallmanDay UUID, short for universally unique identifier, are also known as globally unique identifier (GUID). You can use the function sys_guid() in the Oracle database to generate it: ...

Foursquare open sourced over 104 million points of interest (POIs) collected over several years. This is a large dataset perfect for testing and learning more about Spatial in the database. Oracle APEX has what you need to explore and display these places in your own browser. Meet Foursquare OS Places Foursquare used to be very popular. People where checking in everywhere with their mobile phones. In November last year Foursquare made these POIs available for download. You can read more about the dataset here, and you can explore the places with Foursquare Studio where the graphics above is taken from. ...

Embed data in Python and store the vector in Oracle 23ai I wrote about Vector search in Oracle 23ai in Oracle Database 23ai and Vector Search. Part of the process was embedding chunks of data in the database and add the embeddings as a VECTOR data type in a new table. In this part I use Python to do the embedding outside the database and store the result as a VECTOR in the database using the oracledb module. The Python code does not call any external API, but performs the embedding on my computer using downloaded models from HuggingFace. ...

Oracle Flashback Time Travel aka Flashback Data Archive ensures you can track changes to the data and the structure of a table. Flashback Time Travel #JoelKallmanDay Flashback Time Travel previously called Total Recall lets you track all changes to the data in a table and even structural changes like added or removed columns. This means you can use it in various scenarios from detecting illegal state-transitions caused by bugs in application to compliance where full control of sensitive data is required. ...

Extend the boot device on OCI compute VM with Oracle Linux 9 I needed more space in my boot volume on a compute instance. The VM is using Oracle Linux 9. This involves three steps: Increase the boot volume from the cloud.oracle.com page Make the OS detect this change Grow the file system Increase the boot volume Log into your cloud account and find your compute instance from Compute ➡️ Instances ➡️ your instance from the list. In the menu on the left side called Resources click on the Boot volume link. Then click on the link for the boot volume. Then finally click the hot Edit button, and set the new volume size, and hit save. There is some information displayed along the way that may be useful. ...