Using SQLite3 databases

Everything in SQLite Expert starts with a database. This section covers the whole life cycle of a SQLite 3 database — creating one, opening and closing it, keeping it healthy, and the more advanced operations such as encryption, attaching several databases at once, loading extensions, comparing schemas, and making backups.

Each database you work with appears in the tree panel on the left, identified by an alias — a friendly name you choose. SQLite Expert remembers the databases you have registered, so they are ready for you the next time you start the program.

In this section

• Creating databases
• Opening an existing database
• Closing a database
• Renaming a database alias
• Displaying database information and internal parameters
• Performing maintenance operations
• Using encrypted databases
• Attaching and detaching databases
• Loading and unloading SQLite extensions
• Comparing two databases
• Performing an online backup of a database