Files
system-design-101/data/guides/how-to-choose-the-right-database.md
Kamran Ahmed ee4b7305a2 Adds ByteByteGo guides and links (#106)
This PR adds all the guides from [Visual
Guides](https://bytebytego.com/guides/) section on bytebytego to the
repository with proper links.

- [x] Markdown files for guides and categories are placed inside
`data/guides` and `data/categories`
- [x] Guide links in readme are auto-generated using
`scripts/readme.ts`. Everytime you run the script `npm run
update-readme`, it reads the categories and guides from the above
mentioned folders, generate production links for guides and categories
and populate the table of content in the readme. This ensures that any
future guides and categories will automatically get added to the readme.
- [x] Sorting inside the readme matches the actual category and guides
sorting on production
2025-03-31 22:16:44 -07:00

962 B

title, description, image, createdAt, draft, categories, tags
title description image createdAt draft categories tags
How to Choose the Right Database A guide to selecting the optimal database for your specific needs. https://assets.bytebytego.com/diagrams/0227-how-to-choose-the-right-database.png 2024-02-28 false
database-and-storage
database selection
data storage

How to Choose the Right Database

  • OLTP: For transactional systems requiring strong consistency

  • OLAP: Optimized for complex queries and data analysis

  • Full-Text Search: Fast, flexible text search capabilities

  • Document Stores: JSON-like document storage and querying

  • Key-Value Stores: High-speed, simple data models

  • Graph Databases: Managing highly connected data

  • Embeddings: Efficient storage and retrieval of vector representations

  • Geospatial: Specialized for location-based data and queries