使用 AI 辅助准备-baidu 1point3acres
现在比较幸福的一点AI 确实能帮不少忙。
楼主主要用 ChatGPT、Claude 和 Grok。最后的感觉是:
ChatGPT:回答速度快,结构清晰,适合快速学习和验证思路;
Grok:回答质量非常高,尤其在细节部分;
Claude:反而有点尴尬,用得越来越少。
我每天会让 AI 出几道新题,然后在看答案之前自己思考一下。
Prompts,
This is done before, please come up a new system design question and answer it in flow of:
1. functional requirements. Χ
2. non-functional requirements
3. core entities
4. simple API endpoints
5. high level ASCII diagram (critical workflow explain). From 1point 3acres bbs
6. deep dive of non-functional requirements
知识点
✅ 1. 数据库与存储系统
. 1point3acres.com
数据模型与性能优化
. 1point 3acres
- Query Optimization / Denormalization / Partition / Sharding
- N+1 Query
- primary index vs secondary index vs global index
并发与一致性
- How to prevent race Condition
- How to prevent transaction overwrite (locking / lock-free approaches)
- ACID / row lock / distributed lock
数据库类型对比
- MySQL vs NoSQL vs TimeSeries DB
.--
分布式一致性机制
- Consistent Hashing
.1point3acres
存储系统概念
. Waral dи,
- OLAP vs OLTP
- ElasticSearch
- ELK
✅ 2. 后端架构与性能
性能优化
- Speed up on Read Path ..
- Speed up on Write Path
缓存策略
- Caching Strategies
- Cache Warm-Up
-baidu 1point3acres
热点与广播
. 1point3acres
- Sharing: Push vs Pull
- Fanout vs Hotspot(名人效应)
. 1point3acres
高可用设计
- Usage Too High issues (connection count, CPU, memory, disk, storage, cache)
- CP vs AP
Pagination
- Pagination(Cursor vs Offset)
✅ 3. 系统交互与 API 通信. From 1point 3acres bbs
API 设计
- RESTful API vs GraphQL API vs gRPC
- API Gateway
与第三方通信
- Talk to 3rd Party API(Backoff, Retry, Timeout, Circuit Breaker, Random Select, Local Fallback)
. 1point3acres
✅ 4. 消息队列与异步处理
消息中间件
. 1point 3 acres
- Kafka vs AWS SQS vs Redis + Celery