Python and SQLite, installing and setting up. + Course Code

About Python

Python is a widely used high-level programming language for general-purpose programming, created by Guido van Rossum and first released in 1991. An interpreted language, Python has a design philosophy that emphasizes code readability (notably using whitespace indentation to delimit code blocks rather than curly brackets or keywords), and a syntax that allows programmers to express concepts in fewer lines of code than might be used in languages such as C++ or Java. It provides constructs that enable clear programming on both small and large scales.

Python features a dynamic type system and automatic memory management. It supports multiple programming paradigms, including object-oriented, imperative, functional and procedural, and has a large and comprehensive standard library.

About SQLite

SQLite is a relational database management system contained in a C programming library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.

SQLite is ACID-compliant and implements most of the SQL standard, using a dynamically and weakly typed SQL syntax that does not guarantee the domain integrity.

SQLite is a popular choice as embedded database software for local/client storage in application software such as web browsers. It is arguably the most widely deployed database engine, as it is used today by several widespread browsers, operating systems, and embedded systems (such as mobile phones), among others.[6] SQLite has bindings to many programming languages.

Installing Python and SQLite

Head on to this link and download latest version of python, your python will start downloading, once it is done downloading double click the exe file that has been downloaded, check Add to System path and press continue, once the python done installing, launch the Python IDLE, application will open up like what you see below.

Video tutorial for installing Python



Python app

As we can see above I am using python 3.6.2 64bit on windows operating systems.

Our SQLite library is pre-installed in my version of python as well as all versions from python 3 and above. To check the installation of SQLITE, type import sqlite3 and press enter, if you see no error, we are ready to go, else try reinstalling latest version of python. Below is my output for importing sqlite3, and you should get the same.


Python app

Code our entire tutorial series