SQLite

Connect to SQLite so you can browse schemas, build queries, and (where supported) render spatial maps.

Goal

Create a working SQLite / GeoPackage connection in Connection Manager.

Prerequisites

• Host name, port, database name, and credentials
• Firewall access from your workstation

Steps

1. Open Data → Connection Manager….
2. Add a connection and choose SQLite / GeoPackage.
3. Enter connection details (host, port, database/service, user, password, and provider-specific options).
4. Click Test (or equivalent) to verify connectivity.
5. Save the connection.
6. On the Data tab, select the connection and open Query Builder to start a query.

[ Screenshot: SQLite connection settings ]

Notes

Note

Point the connection at a .sqlite / .db file or a GeoPackage, using the GeoPackage option when appropriate.

Tip

SQLite / GeoPackage connections are ideal for portable local datasets.

Result

The connection appears in Connection Manager and can be selected for queries and compatible map sources.

See Also

• Data Sources overview
• Query Builder
• Parameters
• Maps overview