learn

Azure SQL Database libraries for Python

import pyodbc server = 'your_server.database.windows.net' database = 'your_database' username = 'your_username' password = 'your_password' driver= '{ODBC Driver 13 ...
learn

Container and local development with mssql-django

This guide covers environment setup for Django developers working with the mssql-django backend across Windows, Linux, macOS, Docker containers, devcontainers, and CI pipelines. The mssql-python path ...
GitHub

Real-Time Data Pipeline | Python, Kafka, SQL

Real-Time Data Pipeline | Python, Kafka, SQL Built streaming pipeline ingesting 10k+ events/day via Kafka producers/consumers; processed with filtering & enrichment.
GitHub

3-Station Hydraulic Machine Data Collector & Fault Analytics System

An industrial-grade telemetry and alarm logging system for 3-Station Hydraulic Press machines running Siemens S7 PLCs. Automatically captures PLC Boolean tags, machine pressures/positions, and fault ...
blog.csdn

Python连接ODBC数据及sql与Dataframe转换：用TaoToken统一Key打通pyodbc取数与DataFrame回写

1. 从一次取数翻车说起：pyodbc 连接 ODBC 数据源到底难在哪 先说结论：Python 通过 pyodbc 连接 ODBC 数据源，本质是把「驱动管理器 + 驱动 + 连接串」三件事拼对，再用 cursor 执行 SQL，最后用 pandas 把结果集接成 DataFrame。听起来简单，但真正落到项目里，翻车点集中在四个地方：连接串写错、参数化查询 ...
blog.csdn

Python+tkinter+SQL Server图书管理系统实战课设

图书管理系统是高校Python课程设计的经典选题，本质是GUI界面开发、关系型数据库操作与业务逻辑集成的综合实践。其核心原理在于通过tkinter构建稳定响应的桌面界面，利用pyodbc驱动安全连接SQL Server，实现增删改查等ACID事务操作。技术价值体现在环境兼容性把控、中文编码与连接池等 ...