PYTHON + SQL

THERE ARE TONS OF DATABASES OUT THERE

AND THEY ARE ALL A BIG PAIN TO INSTALL

SQLITE3

  • Comes pre-installed on many machines
  • Very simple syntax, not overly complicated(or especially powerful)
  • SQLITE3 python module part of Standard Library

INSTALLING SQLITE3

BASIC SQLITE SYNTAX

CREATE TABLE

BASIC SQLITE SYNTAX

INSERTING

BASIC SQLITE SYNTAX

SELECTING

GETTING PYTHON INVOLVED

PYTHON + SQL

By colt

PYTHON + SQL

  • 3,281