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
How to protect your database code from SQL injections Posted on December 30, 2025 , Modified on January 5, 2026 , by Yannick JaquierTable of contents Preamble Data model MariaDB SQL injections No SQL injections If the parameter is for a varchar column Isn't it better to work dirty ? Oracle SQL injections No SQL injections If the parameter is for a varchar2 column Read more MariaDB, Oracle Development, Security 1 comment
Pgvector to store vector embeddings computed by a data model Posted on October 10, 2025 , Modified on August 28, 2026 , by Yannick JaquierTable of contents Preamble Pgvector installation and configuration Choosing a free picture dataset Miniconda setup Vector embeddings computation and storage with pgvector Flask application to display retrieved pgvector similar images Pytorch with CUDA using your GPU Other Python AI framework TensorFlow Scikit-learn References Read more PostgreSQL Artificial intelligence (AI), Development 4 comments
Transparent Application Continuity (TAC) hands-on Posted on March 2, 2025 , Modified on February 20, 2025 , by Yannick JaquierTable of contents Preamble Transparent Application Continuity (TAC) setup Transparent Application Continuity (TAC) testing with SQL*Plus TAC compatible service Transparent Application Continuity (TAC) testing with Java Errors encountered Service not automatically started References Read more Oracle Data Guard, Development, Transparent Application Continuity (TAC) Leave a comment
Is JSON datatype performance really faster than BLOB datatype ? Posted on January 20, 2025 , Modified on June 12, 2026 , by Yannick JaquierTable of contents Preamble Loading JSON into Oracle with Python JSON queries and performance comparison JSON basic queries JSON performance comparison To go further with JSON performance References Read more Oracle Development, SQL Leave a comment
Spark Structured Streaming for incremental ingestion flows Posted on January 20, 2024 , Modified on January 19, 2024 , by Yannick JaquierTable of contents Preamble Spark Structured Streaming first test case Spark Structured Streaming second test case Spark Structured Streaming third test case to prepare further ingestion References Read more Databricks Development Leave a comment