Skip to content

Working with SQL Databases

BK Jackson edited this page May 9, 2020 · 4 revisions

Postgres databases

Becoming the Full Stack Data Scientist: Setting up and Connecting to a Postgres Database - Dec. 3, 2019

pyodbc

Connecting to SQL Server from Mac OSX

SQLAlchemy

SQLAlchemy SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. SQLAlchemy considers the database to be a relational algebra engine, not just a collection of tables. SQLAlchemy is most famous for its object-relational mapper (ORM), an optional component that provides the data mapper pattern, where classes can be mapped to the database in open ended, multiple ways - allowing the object model and database schema to develop in a cleanly decoupled way from the beginning.
SQLAlchemy Cheat Sheet March 18, 2015
SQLAlchemy Tutorials Including "Introduction to SQLAchemy."
SQLAlchemy Documentation Documentation, Blog Posts, and Tutorials.

Microsoft Docs for SQL Server

Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS

Clone this wiki locally