Contents Menu Expand Light mode Dark mode Auto light/dark, in light mode Auto light/dark, in dark mode Skip to content
Python Basics
Logo
Python Basics
  • Introduction
  • What’s new?
  • Installation
  • Editors
  • Exploring Python
  • Style
  • Variables and expressions
  • Data types
    • Numbers
      • Complex numbers
      • Boolean values
    • Sequences and Sets
      • Lists
      • Tuples
      • Sets
    • Dictionaries
    • Strings
      • Unicode and character encodings
      • Operators and functions
      • Built-in modules for strings
        • String methods
          • Regular expressions
        • re
      • print()
      • input()
    • None
  • Control flow
    • Boolean values and expressions
    • Conditional statements
    • Loops
    • Exceptions
    • Context management with with
  • Functions
    • Parameters
    • Variables
    • Decorators
    • Lambda functions
  • Modules
  • Libraries
    • „Batteries included“
    • Adding more Python libraries
  • Packages and programmes
    • Creating a distribution package
    • Templating
      • CookieCutter features
      • Available templates
      • Overview
      • Installation
      • Advanced usage
      • cruft
    • Publish package
    • GitLab Package Registry
    • cibuildwheel
    • Binary Extensions
    • Apps
  • Object Orientation
    • Classes
    • Variables
    • Methods
    • Classes and inheritance
    • Coherent example
    • Private variables and methods
    • @property decorator
    • Data types as objects
    • Namespaces
    • dataclasses
  • Save and access data
    • Files
    • File system
    • Modules for files
    • 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
  • Logging
    • Logging examples
  • Testing
    • pytest
      • Examples
      • Writing test functions
      • Structure test suite
      • Test fixtures
      • Built-in fixtures
      • Test parameterisation
      • Markers
      • Plugins
      • Configuration
      • Debugging test failures
      • Coverage
    • Unittest
    • Mock
    • Hypothesis
    • tox
  • Document
    • Sphinx
      • Create a Sphinx project
      • reStructuredText
      • Convert
      • Code blocks
      • Placeholder
      • UI elements and interactions
      • Directives
      • Docstrings
      • Intersphinx
      • Unified Modeling Language (UML)
      • Extensions
      • Testing
    • Doctest
    • Badges
    • shot-scraper
  • Appendix
    • Glossary
    • Checks
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