Database
A database is software that stores business data in an organised, reliable way, so many people and systems can read and update it at once without conflicts or loss. Most business applications keep customers, orders, stock and invoices in a relational database such as PostgreSQL or MySQL.
Key Facts
| Common choices | PostgreSQL, MySQL, Microsoft SQL Server; MongoDB for flexible documents |
|---|---|
| Versus spreadsheets | Enforces rules, handles many users at once, keeps history, scales to millions of rows |
| Must-haves | Automatic backups, tested restores, access control, encryption |
| Ownership | Your company should hold the account and credentials |
Signs you have outgrown spreadsheets
- Several versions of the same file.
- Formulas break when someone edits a column.
- More than a few people need to update data at the same time.
See moving from spreadsheets to a database.
Protect it
Daily automated backups, one copy off-site, and a restore test every quarter. See backups and disaster recovery.
Frequently Asked Questions
Which database should my application use?
For most business applications, PostgreSQL is a safe, well-supported default. Your developer should explain any different choice.
Can I access my own data directly?
You should be able to, through reports, exports or read-only access. Agree this in the contract.
Need help implementing this in your business?
Turbo Bytes Consulting helps businesses streamline operations and build custom software architectures that scale without chaos.