cloud

How to Use Python UDF Logging for Pipeline Observability

Ensure data pipeline reliability and troubleshoot issues fast by using standard Python logging directly in BigQuery UDFs for real-time observability.

How Identical Are 'Identical Characters' in Japanese? Measuring MySQL and PostgreSQL Collations and Full-Width Character Handling to Create a Duplicate Insp…

When applying UNIQUE constraints to Japanese names or addresses, or matching them via JOIN, the database collation determines ...

Backups must be restored and verified—I measured the conditions under which SQLite, PostgreSQL, and MySQL fail to restore and created a verification script

When judging whether a backup can be restored based solely on exit codes and integrity checks, I found conditions in SQLite, ...
GitHub

python-automation

This script allows you to automate the creation of Gmail accounts using the Selenium automation framework with the Chrome WebDriver. It navigates through the Gmail ...

Control Databases with Java, AI and MCP: Google’s MCP Toolbox

Java developers can use Google’s toolbox to address their databases via AI using MCP – currently with limitations.
GitHub

mysql-database

MySQL is an open source relational database management system. Based in Structured Query Language (SQL), MySQL can run on most platforms and is mainly used for web-based applications. It is written in ...
HackerNoon

Clean Architecture in Python: Building Maintainable APIs Without the Overkill

Learn how to apply Clean Architecture in Python without overengineering, using domain entities, use cases, Protocols, and lightweight infrastructure layers.