SQLite Database

  1. Getting Started with SQLite
    1. Installation and Setup
      1. Downloading Precompiled Binaries
        1. Official Website Sources
          1. Platform-Specific Packages
          2. Integration with Operating Systems
            1. Windows Setup
              1. macOS Setup
                1. Linux Setup
                2. Verifying Installation
                3. The SQLite Command-Line Interface
                  1. Starting the CLI
                    1. Launching from Terminal or Command Prompt
                    2. Opening and Creating Database Files
                      1. Creating New Database Files
                        1. Opening Existing Databases
                          1. Using In-Memory Databases
                          2. Special Dot-Commands
                            1. .help for Command Reference
                              1. .databases to List Attached Databases
                                1. .tables to List Tables
                                  1. .schema to View Table Definitions
                                    1. .quit and .exit to Leave the CLI
                                      1. .output to Redirect Output
                                        1. .import for Importing Data
                                          1. .export for Exporting Data
                                            1. .mode for Output Formatting
                                              1. .headers for Column Headers
                                                1. .read for Executing SQL Scripts
                                                  1. .dump for Database Backup
                                                2. Creating Your First Database
                                                  1. Creating an In-Memory Database
                                                    1. Creating an On-Disk Database
                                                      1. Verifying Database Creation
                                                        1. Basic Database File Management

                                                      Previous

                                                      1. Introduction to SQLite

                                                      Go to top

                                                      Next

                                                      3. Core SQL Concepts and Data Definition