The Python db-api is a full-featured common interface for various database engines. The SQLite database engine is included in the default Python installation.
- [Instructor] The Python database API…provides a common interface for various database engines,…to the extent that it's possible to do so.…Here in Kamodo I've opened a working copy of db-api.py,…from chapter 15 of the exercise files.…The Python db api is a consolidated interface…for a number of database systems.…It's important to understand that every database engine…has its own interface, its own requirements,…and really its own paradigm, so no single interface…will ever serve all of them equally.…
Understand the Python db api will not be exactly the same…for every database system.…Like many scripting languages,…Python ships with SQL lite.…SQL lite is a fully functional, cross-platform,…database system that's suitable for many online…and mobile applications.…For more about SQL lite,…see my course SQL essential training…and SQL lite three with PHP essential training.…If we look here in the main function,…the first thing we do is we connect to the database…and that's done with the SQL lite three dot connect method.…
- Python anatomy
- Types and values
- Conditionals and operators
- Building loops
- Defining functions
- Python data structures: lists, tuples, sets, and more
- Creating classes
- Handling exceptions
- Working with strings
- File input/output (I/O)
- Creating modules
- Integrating a database with Python db-api
Skill Level Intermediate
Python: Programming Efficiently (2017)with Michele Vallisneri2h 15m Intermediate
2. Language Overview
3. Types and Values
8. Structured Data
11. String Objects
12. File I/O
13. Built-in Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.