The Database Choice: Why Bigger is Not Always Better
When building tools, engineers often choose complex databases like PostgreSQL. But for small team tools, these databases add unnecessary configuration and overhead. A SQLite-powered attendance system is fast, requires zero configuration, and is easy to back up, making it ideal for small teams.
The benefit of SQLite is simplicity. The entire database is stored in a single file (e.g. `fintasko.sqlite`). This makes backups simple: we just copy the file. For small teams under 100 users, SQLite handles database queries in milliseconds.
To learn how this database structure supports compliance, review our guide on GDPR compliance in project tools. Additionally, for schedule tracking guidelines, read our article on ditching Excel scheduling templates.
3 Benefits of a SQLite Database
- Zero Configuration: No database server to manage or configure.
- Simple Backups: The database is a single file, making backup scripts simple.
- High Speed: Handles thousands of queries per second for small teams.
Database Comparison for Small Teams
| Task | Traditional DB Server (PostgreSQL) | Single-File DB (SQLite) |
|---|---|---|
| Configuration | Requires configuring ports, users, and server instances. | Zero configuration; reads directly from a local file. |
| Backups | Requires database dump tools and storage configuration. | Simple file copy; easy to automate and secure. |
| Server Cost | Requires a dedicated server or additional memory. | Zero cost; runs inside the application process. |
Frequently Asked Questions
Is SQLite secure?
Yes, the file is stored in a secure server directory, and access permissions are managed by the operating system.
Can SQLite handle multiple users?
Yes, SQLite handles concurrent reads and write queues efficiently, making it ideal for teams under 100 users.
How do we back up the database?
Fintasko runs daily backup scripts that copy the database file to a secure directory, keeping history safe.