Sqlite

Category: Database Connectors

Introduction

This document is created to help setup a mindzieDataDesigner connector to SQLite database. The mindzieDataDesigner is the ETL tool used by mindzieStudio to convert database tables to process mining event logs. The purpose of this document is to help creating the connection string and opening ports on the firewall if required.

Overview

The SQLite connector allows mindzieDataDesigner to connect to SQLite database files directly. SQLite is ideal for development, testing, and small-to-medium sized applications where a lightweight, serverless database solution is needed.

System Requirements

Database System: SQLite 3.x
File Access: Read/write permissions to SQLite database files
Platforms: Windows, Linux, macOS
Dependencies: Built into .NET - no additional drivers required

Connection String Format

Basic Format

Data Source=C:\path\to\database.db

Standard Parameters

Parameter	Description	Required	Example
`Data Source`	Path to SQLite database file	Yes	`C:\data\mydatabase.db`
`Version`	SQLite version (usually 3)	No	`3`
`Password`	Database password (if encrypted)	No	`mypassword`
`Read Only`	Open in read-only mode	No	`true` or `false`
`Cache`	Cache mode setting	No	`Shared` or `Private`

Connection Examples

Basic Connection

Data Source=C:\MyProject\database.db;Version=3;

Read-Only Connection

Data Source=C:\MyProject\database.db;Version=3;Read Only=true;

Password-Protected Database

Data Source=C:\MyProject\database.db;Version=3;Password=mypassword;

Relative Path Connection

Data Source=.\database.db;Version=3;

In-Memory Database

Data Source=:memory:;Version=3;New=true;

Troubleshooting

Common Issues

"Database is locked" Error

Ensure no other applications have the database file open
Check for proper connection disposal in your application
Consider using WAL mode for better concurrency

"Unable to open the database file" Error

Verify the file path is correct and accessible
Check read/write permissions on the database file and directory
Ensure the directory structure exists

Performance Issues

Check database size and consider VACUUM operations
Review indexing strategy
Monitor concurrent connections and implement connection pooling

Connection String Validation

Test your connection string with a simple query:

SELECT sqlite_version();

Official Documentation: SQLite.org
System.Data.SQLite: Official .NET Provider
SQL Syntax: SQLite supports most standard SQL operations
Tools: DB Browser for SQLite, SQLiteStudio

💡 Tip: SQLite databases are single files, making them easy to backup, share, and deploy with your applications.