SQLite

This section describes the SQLite DatabaseManager SQLiteDb.

Table of contents

• Initialization
  • Require the database to exist
• The execute method
  • Parametrized SQL statements
  • Using transactions
• Save a DataFrame to a table
• Load a DataFrame from a table
  • Working with datetimes and timezones
• Update and insert data into a table (upsert)
  • Using the dry_run parameter
• Using the SQLContainer
  • Replace placeholders