Database
A database is an organized collection of structured data stored electronically, designed to be easily accessed, managed, and updated by applications and users.
Databases are the storage backbone of virtually every software application. They store user accounts, product catalogs, transaction records, content, settings, and any other data an application needs to persist between sessions. There are two main categories.
They enforce data integrity through relationships, constraints, and ACID transactions (Atomicity, Consistency, Isolation, Durability). They're ideal for structured data with clear relationships. NoSQL databases like MongoDB, Redis, DynamoDB, and Firebase offer more flexibility.
In practice
- An e-commerce startup chose PostgreSQL for transactions and product data, and Redis for session management and caching, handling 10x traffic spikes during sales events
- A content platform migrated from MySQL to MongoDB when their content structure became too varied for rigid table schemas, reducing development time for new content types by 50%
- A financial services company uses PostgreSQL with strict ACID compliance for transaction records and a separate Elasticsearch cluster for powering their search and analytics features
- A real-time chat application uses Firebase (NoSQL) for message delivery and PostgreSQL for user accounts and billing, each database optimized for its specific use case
More in Web development
- Responsive Design
- Progressive Web App (PWA)
- Single-Page Application (SPA)
- Server-Side Rendering (SSR)
- Static Site Generation (SSG)
- API (Application Programming Interface)
- CMS (Content Management System)
- Headless CMS
- Version Control
- CI/CD (Continuous Integration / Continuous Deployment)
- JavaScript Framework
- TypeScript
Not sure how this applies to you?
A senior engineer walks your site, your search presence and the way enquiries reach you, then writes down the three things worth fixing first. You keep the document either way.