Skip to content
Tagged articles

SQL Injection Prevention

2 articles · Page 1 of 1
Xiaolin Talks Programming
Xiaolin Talks Programming
Oct 31, 2026 · Backend Development

Embedding DuckDB in Spring Boot: Ad-hoc Parquet/CSV Analytics with Multi-tenant Isolation

This article details integrating DuckDB into Spring Boot for embedded OLAP analytics, covering tenant-isolated connection pools, secure view-based file access, streaming exports via COPY and cursors, SQL injection guards, and performance tuning for ad-hoc Parquet/CSV queries without a separate cluster.

CSVDuckDBEmbedded Analytics
0 likes · 48 min read
Embedding DuckDB in Spring Boot: Ad-hoc Parquet/CSV Analytics with Multi-tenant Isolation
Python Programming Learning Circle
Python Programming Learning Circle
Aug 15, 2022 · Databases

Using Python DB‑API to Operate MySQL: PyMySQL Basics, Connection Pooling, and Safe SQL Practices

This article introduces Python's DB‑API, lists supported databases, demonstrates how to install and use PyMySQL for basic CRUD operations, shows techniques for preventing SQL injection, and explains two connection‑pooling models with DBUtils, including code examples and a brief promotional note at the end.

DB-APIDatabase Connection PoolPyMySQL
0 likes · 17 min read
Using Python DB‑API to Operate MySQL: PyMySQL Basics, Connection Pooling, and Safe SQL Practices