ksqlDB to load and transform in SQL your data and flows Posted on May 10, 2026 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble Confluent Kafka cluster configuration Kafka server Schema Registry server Basic testing Python environment and script ksqlDB configuration ksqlDB testing ksqlDB joining other tables ksqlDB Rest API Issues encountered Snappy temp folder SQL queries return empty result Tune auto.offset.reset Missing KEY keyword Unable to obtain lock as state directory No rows in complex queries No suitable driver found for jdbc:mariadb References Read more Linux Kafka Leave a comment
Compile PostgreSQL from source and create your own package Posted on April 30, 2026 , Modified on March 27, 2026 , by Yannick JaquierTable of contents Preamble PostgreSQL Compilation and Installation Building pgvector and TimescaleDB extensions Deployment on other servers Bintar RPM References Read more PostgreSQL Administration Leave a 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
DuckDB to query Excel file in SQL Posted on April 10, 2026 , Modified on March 27, 2026 , by Yannick JaquierTable of contents Preamble DuckDB installation and configuration DuckDB test case Read more Linux Development, DuckDB 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 Database API for MongoDB with ORDS testing Posted on March 20, 2026 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble ORDS installation Oracle Database API for MongoDB setup Oracle Database API for MongoDB testing ORDS central installation Errors encountered Jansi native library loading issue ORDS installation with non-SYS account References Read more MongoDB, Oracle Development, NoSQL Leave a comment