0 views collected around this technical thread.
Learn how to efficiently configure and manage database connections in FastAPI, covering synchronous and asynchronous setups, dependency injection, session handling, and testing strategies, to prevent leaks, boost performance, and ensure scalable, reliable applications.
This article explains mock technology for software testing, demonstrates how to implement a mock service using Flask and MySQL, and provides code examples for setting up mock data and handling requests.
This tutorial demonstrates how to connect to a MySQL database with pymysql or SQLAlchemy and use pandas' read_sql_query, read_sql_table, read_sql, and to_sql functions to read from and write data to database tables, including sample code and output.
SQLAlchemy 2.0.7 has been released, addressing a critical caching bug in custom operator expressions, fixing typing issues with composite(), adding the PostgreSQL CITEXT type, and improving dialect compatibility, with all changes back‑ported to earlier stable releases.
This guide demonstrates how to perform asynchronous CRUD operations on MySQL, PostgreSQL, and Redis using Python libraries such as aiomysql, asyncpg, and SQLAlchemy, covering connection setup, querying, inserting, updating, deleting, and handling result objects with practical code examples.
This article demonstrates two approaches for efficiently importing massive CSV data into MySQL using Python: a direct pymysql method with chunked inserts and a concise pandas‑SQLAlchemy method, comparing performance, code complexity, and offering tips for further speed improvements.
This article explains how to replace raw PyMySQL usage with SQLAlchemy ORM in Python, covering environment setup, database connection initialization, MVC‑style project structure, model class definitions, field attributes, session handling with context managers, and practical code examples for saving and querying data.
Apache Superset is a modern, enterprise‑ready open‑source business intelligence web application that offers rich data visualizations, an easy‑to‑use interface, dashboard sharing, robust security, a semantic layer, and integration with a wide range of relational and analytical databases.
This guide explains how to install the MySQL driver for Python, establish a connection to a MySQL database using MySQLdb, execute queries, and optionally use ORM libraries such as SQLAlchemy or Peewee for higher‑level database interactions.
This article explains Python's context manager mechanism, covering the basic with statement, custom __enter__/__exit__ classes, the contextlib.contextmanager decorator, nesting, combining multiple managers with ExitStack, and practical applications such as SQLAlchemy session handling, exception management, and persistent HTTP requests.
This tutorial explains how to perform asynchronous MySQL operations in Python using aiomysql, covering basic connections, CRUD actions, safe parameter handling to prevent SQL injection, connection pooling, transaction management, integration with SQLAlchemy for ORM queries, and a custom reconnection wrapper for resilient database access.
This article analyzes the intermittent “Instance XXX is not bound to a Session” error that occurs after converting a Flask‑SQLAlchemy endpoint from serial to multithreaded/gevent concurrency, reproduces the issue with test code, explains the root cause in session handling, and provides a concrete fix by patching gevent before session initialization.
This article demonstrates how to automate e‑commerce test data creation by retrieving schema information with SQLAlchemy ORM, defining mapping classes, generating realistic data using Faker, and submitting it via HTTP requests with the Requests library, covering database interactions, data assembly, and API communication.
This tutorial explains how to install Flask‑SQLAlchemy, configure a Flask app to connect to MySQL, define ORM models, perform queries, handle pagination, update records, and execute join queries, providing code examples and best‑practice tips for backend development.