Contents Menu Expand Light mode Dark mode Auto light/dark, in light mode Auto light/dark, in dark mode Skip to content
Python Basics 24.3.0
Logo
Python Basics 24.3.0
  • Introduction
  • Installation
  • Editors
  • Exploring Python
  • Style
  • Variables and expressions
  • Data types
    • Numbers
    • Lists
    • Tuples
    • Sets
    • Dictionaries
    • Strings
    • Files
    • None
  • Input
  • Control flows
    • Boolean values and expressions
    • if-elif-else statement
    • Loops
    • Exceptions
    • Context management with with
  • Functions
    • Parameters
    • Variables
    • Decorators
    • Lambda functions
  • Modules
  • Programme libraries
    • „Batteries included“
    • Adding more Python libraries
    • Packages and programmes
    • Creating a distribution package
    • GitLab Package Registry
    • Templating
      • CookieCutter features
      • Available templates
      • Overview
      • Installation
      • Advanced usage
      • cruft
    • Upload package
    • cibuildwheel
    • Binary Extensions
    • Glossary
  • Apps
  • Object Orientation
    • Classes
    • Variables
    • Methods
    • Classes and inheritance
    • Summary
    • Private variables and methods
    • @property decorator
    • Namespaces
    • Data types as objects
    • Object-orientated designs
      • SOLID principles
      • Abstract Factory
      • Decorator
      • Strategy pattern
      • Command design pattern
  • Save and access data
    • File system
    • The pickle module
    • The xml module
    • The sqlite module
    • Create a database
    • Create data
    • Create data from csv
    • Query data
    • Update data
    • Delete data
    • Normalising the data
    • Query normalised data
    • The psycopg module
  • dataclasses
  • Testing
    • Unittest
    • Example: Testing an SQLite database
    • Doctest
    • Hypothesis
    • pytest
      • Examples
      • Writing test functions
      • Structure test suite
      • Test fixtures
      • Built-in fixtures
      • Test parameterisation
      • Markers
      • Plugins
      • Configuration
      • Debugging test failures
    • Coverage
    • Mock
    • tox
    • unittest2
    • Glossary
  • Document
    • Create a Sphinx project
    • reStructuredText
    • Code blocks
    • Placeholder
    • UI elements and interactions
    • Directives
      • Create a Sphinx project
      • Docstrings
    • Docstrings
    • Intersphinx
    • Unified Modeling Language (UML)
      • Sequence diagram
      • Use Case diagram
      • Activity diagram
      • Class diagram
    • Extensions
    • Testing
    • shot-scraper
  • Appendix
    • Checks
    • Regular expressions
    • Unicode and character encodings
Back to top
View this page

The sqlite module¶

The most important features of SQLite are:

  • self-contained

  • serverless

  • config free

  • transactional

SQLite is used to save data locally, e.g. in mobile phones (Android, iOS) and in browsers (Firefox, Safari, Chrome), and many other applications.

See also

  • sqlite home

  • sqlite3 — DB-API 2.0 interface for SQLite databases

  • W3Schools SQL tutorial

Next
Create a database
Previous
The xml module
Copyright © 2021–2024, Veit Schiele
Made with Sphinx and @pradyunsg's Furo