SQLite Database

7.

Database Administration and Optimization

7.1.

7.1.1.

Purpose and Benefits of Indexes

7.1.2.

Creating Indexes with CREATE INDEX

7.1.3.

Creating Unique Indexes

7.1.4.

Multi-Column Indexes

7.1.5.

Partial Indexes using WHERE Clause

7.1.6.

Expression Indexes

7.1.7.

Dropping Indexes with DROP INDEX

7.1.8.

Index Maintenance

7.1.9.

Index Performance Analysis

7.2.

Query Optimization

7.2.1.

Query Execution Plans

7.2.2.

Using EXPLAIN QUERY PLAN

7.2.3.

Query Rewriting Techniques

7.2.4.

Index Selection Strategies

7.2.5.

Performance Bottleneck Identification

7.3.

7.3.1.

ACID Properties in Practice

7.3.2.

Starting Transactions with BEGIN

7.3.3.

Committing Transactions with COMMIT

7.3.4.

Rolling Back Transactions with ROLLBACK

7.3.5.

Using Savepoints for Nested Transactions

7.3.6.

Transaction Modes

7.3.6.1.

7.3.6.2.

7.3.6.3.

7.3.7.

Transaction Isolation Levels

7.3.8.

Deadlock Prevention

7.4.

Database Maintenance

7.4.1.

The VACUUM Command for Database Compaction

7.4.2.

The ANALYZE Command for Statistics

7.4.3.

Database Integrity Checking

7.4.4.

Corruption Detection and Recovery

7.4.5.

Regular Maintenance Procedures

7.5.

PRAGMA Statements

7.5.1.

Enabling Foreign Key Constraints

7.5.2.

Setting Journal Mode

7.5.3.

Configuring Synchronization

7.5.4.

Checking Database Integrity

7.5.5.

Memory Management Settings

7.5.6.

Cache Size Configuration

7.5.7.

Page Size Settings

7.5.8.

Auto-Vacuum Configuration

7.6.

Backup and Recovery

7.6.1.

Online Backup API Usage

7.6.2.

Using the .backup Command in CLI

7.6.3.

File-Based Backup and Restore Methods

7.6.4.

Incremental Backup Strategies

7.6.5.

Point-in-Time Recovery

7.6.6.

Best Practices for Backup and Recovery

Previous

6. Advanced SQL Features

Go to top

Next

8. Using SQLite with Programming Languages