Master Python Database Access: From DB‑API to Connection Pools

This article introduces Python's DB‑API for interacting with various databases, explains how to use PyMySQL and SQLAlchemy for MySQL, demonstrates basic CRUD operations, safeguards against SQL injection, and shows how to implement thread‑safe connection pools with DBUtils for scalable backend applications.

Connection PoolDBAPIDBUtils

0 likes · 17 min read

Master Python Database Access: From DB‑API to Connection Pools

Sohu Tech Products

May 13, 2020 · Databases

Understanding JDBC: Basics, Core Interfaces, PreparedStatement, Connection Pools, Pagination, and DBUtils

This article provides a comprehensive guide to JDBC, covering its definition, core interfaces (Connection, Statement, ResultSet), the advantages of PreparedStatement, the need for connection pools, pagination techniques for Oracle and MySQL, and practical usage of DBUtils with full code examples.

Connection PoolDBUtilsJDBC

0 likes · 10 min read

Understanding JDBC: Basics, Core Interfaces, PreparedStatement, Connection Pools, Pagination, and DBUtils