Flink CDC for database replication to big data Posted on September 30, 2026 , Modified on October 23, 2026 , by Yannick JaquierTable of contents Preamble Iceberg installation in Spark Flink installation Flink CDC installation PostgreSQL source database configuration Iceberg sink configuration MariaDB source database configuration Oracle source database configuration Issues encountered Connection refused /tmp in noexec REST/Web UI upload handler still in /tmp References Read more Hadoop, MariaDB, MySQL, Oracle, PostgreSQL Development 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
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
Handle time series data with TimescaleDB Posted on July 20, 2025 , Modified on October 1, 2026 , by Yannick JaquierTable of contents Preamble TimescaleDB installation as a container TimescaleDB extension installation TimescaleDB development environment setup TimescaleDB database setup Simulating multiple equipments sending temperature information Loading NYC yellow cab information TimescaleDB performance versus PostgreSQL Without compression With compression References Read more PostgreSQL Time Series 1 comment
Transparent Data Encryption (TDE) with PostgreSQL Posted on June 30, 2025 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble PostgreSQL without Transparent Data Encryption (TDE) PostgreSQL with Transparent Data Encryption (TDE) I have downloaded the pg_tde source from GitHub and tried to compile them: Downloading a compiled version of pg_tde Using the ready-to-use pg_tde container Pg_tde additional features Key rotation WAL encryption Remove TDE from tables References Read more PostgreSQL Security, Transparent Data Encryption (TDE) Leave a comment