Posts

Showing posts from May, 2025

Building a Fully Local AI-Powered Assistant with Oracle APEX and Vector Search #APEXCONN2025 #orclAPEX

Image
👩 : Falls Sie nicht müde sind  :-| 👨 : Ich bin immer müde, aber das ist okay :-) I recently attended the APEX Connect 2025 conference from Syntegris Company.  One of the presentations that strongly caught my attention focused on the development of a personal assistant powered by Artificial Intelligence (AI), which runs completely offline,  with no reliance on cloud services . This assistant was implemented using technologies such as Oracle Database 23ai , Vector Search , and the RAG (Retrieval-Augmented Generation) approach. It was designed to manage personal information, emails, calendar entries, and project data. 👀Watch this short Video about  #ApexConn2025    https://youtube.com/shorts/UQmwwTEsJuk?si=WJUXdJ4jvh1Nmsap The presenter highlighted the challenges of his life, such as: High volumes of daily emails  Multiple overlapping meetings Fragmented and scattered information He proposed a personal AI assistant that could : Filter emails and ext...

Generating Test Data with Blueprint In Oracle APEX

Image
What is a Blueprint? The  Data Generator  in Oracle APEX is a powerful utility for automating the creation of test data.  Blueprint  is a key feature within this tool that allows you to define data structures and generate realistic test data   A  Blueprint  defines:  Table structure (columns and data types)  Data generation rules (random values, sequences, or predefined data)  Reusable templates for future projects Benefits of Blueprint Generate structured test data  for APEX applications Quickly build demo databases  without manual data entry Simulate real-world data  for reports, charts, and forms Performance testing  with large datasets 😃 Using Blueprint SQL Workshop > Utilities > Data Generator Click  Create > Blueprint Now you have 3 options, let's go ahead and check one by one 1. Use Existing Tables  2. From Scratch 3. Import JSON File 1. Use Existing Tables  Creates a Blueprint by ...