Database
A database is a system that stores, manages and quickly retrieves structured data — such as customers, orders, products or a website’s content.
Almost every website, shop and software uses a database. Common are relational databases such as MySQL, MariaDB or PostgreSQL, which store data in tables with defined relationships.
A well-planned database is fast, avoids duplicate data and can grow with the business. Poorly planned databases lead to slow pages, contradictions and costly rebuilds.
Because databases often hold the most valuable and sensitive information, access protection, encryption, regular backups and tested restoration are essential.
What to look out for
- Plan the data structure carefully before development.
- Limit access to the essentials — each application with its own credentials.
- Regular automatic backups with tested restoration.
- Monitor and optimise slow queries.
- Store personal data only as long as it is needed.
Common mistakes
- All applications use the same access with full rights.
- The database is directly reachable from the internet.
- Data is maintained twice and contradicts itself.
Frequently asked questions
For most websites and business applications, proven relational databases such as MySQL or PostgreSQL are a good choice. Special cases like very large data volumes or search can justify additional systems.
With custom software, usually yes — it is important to settle this contractually and technically from the start so data can be taken along when switching.