A micro ORM for the python dbapi spec inspired by the Nuget package Dapper
Using SqlAlchemy and Pandas to access tables as properties of a database engine
A wrapper for pymssql (Microsoft Sql Server Package). I wrote this in the process of working with Sql Servers as a Data Scientist.
Demo ETL
Python PyQt6 project VS Code - generating report from DB (Oracle, MS SQL, Azure SQL, PostgreSQL, MySQL, MariaDB, Firebird, SQLite, Amazon Aurora MySQL, Amazon Aurora PostgreSQL, MongoDB, Cassandra). Creation of schedules of NBU exchange rates by year to monitor change trends.
A programing project concentrated on graphing frequency of cancer mention on Twitter & aggregating sample raw encounter data into yearly summary
A complete web application which crawls urls on the internet given a starting point, finds geographical information about the urls servers and graphically displays server locations on a map. Web crawler section is implemented here: https://github.com/bluedistro/crawley/tree/wsa-branch
A memory connector & enhancer for your clawbot using SQL
Making use of Python and SQL, this project establishes a comprehensive database for accessing Winnipeg bus schedules and weather information in the past, offering valuable insights into the impact of weather on public transportation efficiency in Winnipeg.
Python ETL pipeline: web scraping (BeautifulSoup) + SQL Server enrichment (pymssql) + multi-tab Excel output (openpyxl). 1,344 medal records across Tokyo 2020 and Beijing 2022.
I built Tech News using Python, creating a platform where users can discover, share, and discuss the latest tech articles. With Python at its core, it efficiently handles user posts and interactions, covering everything from cutting-edge innovations to industry trends, while fostering a vibrant community of tech enthusiasts.
A reference Python notebook demonstrating an orchestration pattern for running multiple SQL queries against multiple Oracle databases, combining results in different ways per query, and distributing the outputs by email — all wrapped in resilient error handling so a single database outage doesn't break the run.
Serverless SQL query playground on Azure — read-only interactive dashboard over 294K Washington EV registrations. Azure SQL free offer (star schema: 4 dims + fact) · Azure Functions (Python, pymssql) · Static Web Apps (React/Vite). Terraform IaC + GitHub Actions CI/CD (OIDC). $0/month.
API for given project : https://github.com/aliihsank/SuperPower
To associate your repository with the pymssql topic, visit your repo's landing page and select "manage topics."