Virtual DBA application – part 3 Posted on August 30, 2026 , Modified on August 31, 2026 , by Yannick JaquierTable of contents Preamble Embeddings FAISS Reciprocal Rank Fusion (RRF) Next steps Read more Oracle, Python Artificial intelligence (AI) Leave a comment
Virtual DBA application – part 2 Posted on August 15, 2026 , Modified on August 24, 2026 , by Yannick JaquierTable of contents Preamble Chunking of markdown files Keyword search (BM25) First version of the application Read more Oracle, Python Artificial intelligence (AI) 1 comment
Virtual DBA application – part 1 Posted on July 30, 2026 , Modified on August 14, 2026 , by Yannick JaquierTable of contents Preamble Ollama installation and configuration Python setup Python environment Ollama package Streamlit package SQLcl MCP Server Oracle DB Skills Read more Oracle, Python Artificial intelligence (AI) 1 comment
Sqlglot as a backup for your database migration Posted on April 20, 2026 , Modified on March 27, 2026 , by Yannick JaquierTable of contents Preamble Sqlglot installation Sqlglot testing References Read more MariaDB, MySQL, Oracle, PostgreSQL, Python, SQL Server Development Leave a comment
Vector embeddings in MariaDB by self-supervised data models Posted on March 30, 2026 , Modified on June 10, 2026 , by Yannick JaquierTable of contents Preamble Miniconda and Linux setup The different self-supervised learning classes Autoencoder SimCLR BYOL Main program to use the classes and train Main program to use the classes and inference Flask application to display retrieved similar images References Read more MariaDB, Python Artificial intelligence (AI), Development 1 comment
Oracle Machine Learning for Python (OML4Py) setup and usage Posted on February 10, 2026 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble OML4Py installation OML4Py Machine Learning testing OML4Py Automated Machine Learning testing Algorithm selection Feature selection Model selection Model tuning With JupyterLab Issues encountered scikit-learn 1.2.1 g++ missing Freetype 2.6.1 missing Duplicate version of NumPy ORA-65254: invalid path specified for the directory Oml does not understand Oracle directories PYQSYS.PYQELIB library has error ValueError: automl connection is not enabled References Read more Oracle, Python Development, Machine Learning Leave a comment