Database Security Assessment Tool (DBSAT) 3.1 follow-up Posted on May 31, 2024, updated on June 18, 2024 by Yannick JaquierTable of contents Preamble DBSAT Installation DBSAT Collection DBSAT Report DBSAT Result References Continue reading
How to load JSON into MariaDB Posted on May 20, 2024, updated on May 21, 2024 by Yannick JaquierTable of contents Preamble Preparation Load JSON into MariaDB only with SQL Load JSON into MariaDB with Python References Continue reading
In-Memory OLTP for rapid data ingestion Posted on April 20, 2024, updated on April 22, 2024 by Yannick JaquierTable of contents Preamble In-Memory OLTP preparation In-Memory OLTP testing In-Memory OLTP to durable tables INSERT INTO disk_based_table SELECT FROM memory_optimized_table Temporal memory-optimized table Issues encountered References Continue reading
PostgreSQL LDAP client authentication implementation Posted on March 20, 2024, updated on March 25, 2024 by Yannick JaquierTable of contents Preamble PostgreSQL LDAP client authentication implementation PostgreSQL LDAP client authentication testing References Continue reading
Citus as a distributed database plugin hands-on Posted on February 20, 2024, updated on February 21, 2024 by Yannick JaquierTable of contents Preamble Citus distributed database installation Citus distributed database configuration Citus distributed database testing Citus distributed database cluster management Handle node failure Removing nodes Adding nodes References Continue reading
Spark Structured Streaming for incremental ingestion flows Posted on January 20, 2024, updated 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 Continue reading