#TenantID
Design a Distributed Cache (System Design Interview)
Practice System Design question - https://codemia.io/system-design/design-an-API-rate-limiter?via=javarevisited Recommended System Design Interview Resources 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&sourceId=javarevisited&tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr #systemdesign #systemdesigninterview #softwareengineering #softwarearchitecture
www.youtube.com
November 3, 2026 at 3:19 AM
hussainhabeebi/nextai: Milestone 2: Chatwoot + ERPNext webhooks, inbound routing, conversation state (a30c54f)
November 2, 2026 at 7:00 PM
Why Rate Limiter is So Important in System Design?
Practice this question here on Codemia - https://codemia.io/system-design/design-an-API-rate-limiter?via=javarevisited More System Design Interview Resources 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&sourceId=javarevisited&tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr learn more about rater limiter interview questions: https://javarevisited.substack.com/p/what-is-rate-limiter-how-does-it https://javarevisited.substack.com/p/how-to-design-a-rate-limiter-a-complete #systemdesign #systemdesigninterview #softwareengineering #softwarearchitecture
www.youtube.com
October 31, 2026 at 5:52 PM
The Only 2 Courses You Need to Master System Design (Not ByteByteGo)
19 Best places to learn System Design 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&sourceId=javarevisited&tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr 13 System Design Interview Questions [Solved] 1. Youtube Design - https://bit.ly/3bbNnAN 2. URL Shortner - https://bit.ly/3dZoQ2G 3. Design Twitter - https://buff.ly/4fl5Fvn 4. Parking Lot Design - https://bit.ly/3eMUosX 5. Design a LMS - https://bit.ly/3SfwJQe 6. Instagram Design - https://bit.ly/3BqamCL 7. TinyURL Design - https://bit.ly/3S98WSc 8. WhatsApp design - https://bit.ly/3SbA9Eu 9. Design TiketMaster - https://buff.ly/3M5ncup 10. Design an Efficient Parking Lot System - https://buff.ly/3WssNPR 11. Design Spotify - https://javarevisited.substack.com/p/system-design-problem-design-spotify 11. more - https://bit.ly/3QtyuZl 13. Deisgn X - https://javarevisited.substack.com/p/design-twitter-x-system-design-interview 14 Design URL Shortner - https://javarevisited.substack.com/p/system-design-interview-question 🌐 Checkout Our Other Social Channels: Substack - 📝 https://javarevisited.substack.com/ Twitter - 🐦 https://x.com/javarevisited Facebook - 📘 https://www.facebook.com/javarevisited Reddit - 👤 https://www.reddit.com/r/javarevisited/
www.youtube.com
October 31, 2026 at 2:19 AM
Rate Limiter - System Design Interview 🤣😂
19 Best places to learn System Design 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&sourceId=javarevisited&tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr If you want to become good at system design, learn these concepts: 1. API Gateway vs Load Balancer? https://buff.ly/3S2bjsr 2. Reverse Proxy vs Forward Proxy? https://buff.ly/3PEGDME 3. Horizontal scaling vs vertical scaling? https://buff.ly/49NvS26 4. Microservices vs Monolithic architecture? https://buff.ly/4aC7mS4 5. Caching Strategies - https://buff.ly/413WZD9 6. What is Rate Limiter? How does it work? https://buff.ly/3Lq9jqd 7. How does Single Sign On (SSO) works? https://buff.ly/3S61wBG 8. How does Apache Kafka works? why it so fast? https://buff.ly/3LnlAf6 9. Kafka, ActiveMQ, vs RabbitMQ? https://buff.ly/3LjYSo9 10. JWT, OAuth, and SAML? https://buff.ly/3Lpzey4 11. Database Scaling - https://javarevisited.substack.com/p/system-design-basics-database-scaling 12. Database Replication vs Sharding - https://javarevisited.substack.com/p/system-design-basics-database-replication 13. JWT vs Session based authentication - https://javarevisited.substack.com/p/difference-between-jwts-json-web 14. Consistent Hashing - 15. Message Queues - https://javarevisited.substack.com/p/system-design-basics-master-message 16. REST vs gRPC - https://medium.com/javarevisited/difference-between-rest-graphql-and-grpc-10ac365462b8 17. Leader election (Raft, Paxos) 18. Circuit breakers 19. Failover & Disaster Recovery 20. Heartbeats & health checks 21. CQRS - https://javarevisited.substack.com/p/how-cqrs-pattern-works-in-microservices 22. Event-driven design - https://javarevisited.substack.com/p/scaling-to-millions-the-secret-behind 23. Microservices vs Monolith - https://javarevisited.substack.com/p/monolith-vs-microservices-the-1m 24. Saga pattern - https://javarevisited.substack.com/p/how-does-saga-design-pattern-works 25. Idempotency 🌐 Checkout Our Other Social Channels: Substack - 📝 https://javarevisited.substack.com/ Twitter - 🐦 https://x.com/javarevisited Facebook - 📘 https://www.facebook.com/javarevisited Reddit - 👤 https://www.reddit.com/r/javarevisited/
www.youtube.com
October 29, 2026 at 2:40 PM
Design a Distributed Cache (System Design Interview)
Practice System Design question - https://codemia.io/system-design/design-an-API-rate-limiter?via=javarevisited Recommended System Design Interview Resources 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&sourceId=javarevisited&tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr #systemdesign #systemdesigninterview #softwareengineering #softwarearchitecture
www.youtube.com
October 28, 2026 at 2:40 PM
Why Rate Limiter is So Important in System Design?
Practice this question here on Codemia - https://codemia.io/system-design/design-an-API-rate-limiter?via=javarevisited More System Design Interview Resources 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&sourceId=javarevisited&tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr learn more about rater limiter interview questions: https://javarevisited.substack.com/p/what-is-rate-limiter-how-does-it https://javarevisited.substack.com/p/how-to-design-a-rate-limiter-a-complete #systemdesign #systemdesigninterview #softwareengineering #softwarearchitecture
www.youtube.com
October 23, 2026 at 2:19 AM
How to Create Beautiful Software Architecture Diagrams with ChatGPT, Mermaid & Draw.io
19 Best places to learn System Design and Software Architecture 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&sourceId=javarevisited&tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr 🌐 Checkout Our Other Social Channels: Substack - 📝 https://javarevisited.substack.com/ Twitter - 🐦 https://x.com/javarevisited Facebook - 📘 https://www.facebook.com/javarevisited Reddit - 👤 https://www.reddit.com/r/javarevisited/ 0:00 Introduction to diagramming 0:41 Setting up draw.io 1:53 Creating sequence diagrams 3:14 Generating class diagrams 4:21 Customizing diagram styles 5:07 SQL code and database mapping
www.youtube.com
October 22, 2026 at 2:40 PM
I realized my API layer was blindly forwarding query params, so a typo turned pageSize into tenantId and broke contracts.list. Using Zod to parse and coerce params caught the mismatch early. Validate inputs, don't trust the client. #webdev
October 20, 2026 at 8:36 PM
一覧はテナントで絞れていても、書き込みで受け取ったIDが他テナントの行を指していないか。自分のアプリでの確かめ方と、都度確認・tenantId必須・複合外部キーの3方式の比較です。

https://www.playpark.co.jp/blog/multi-tenant-cross-tenant-reference-three-defenses?utm_source=bluesky&utm_medium=social&utm_campaign=multi-tenant-cross-tenant-reference-three-defenses

#マルチテナント
一覧は絞れていても他テナントのIDで書き込める:確かめ方とテナント分離の3方式の比較 | ブログ | playpark
マルチテナントのアプリで、一覧はテナントで絞れているのに、書き込みで受け取ったIDが他テナントの行を指していないか確かめたい人向け。自分のアプリでの確かめ方と、3つの守り方の比較、AIエージェントへの指示をまとめた。
www.playpark.co.jp
October 21, 2026 at 10:31 PM
Aprendí que validar los nombres de los parámetros antes de enviarlos evita errores sutiles. En contracts.list (PR #24) cambié page/pageSize por propertyId/tenantId y añadí una capa de type‑guard; ahora la API responde sin 400 inesperados.
October 20, 2026 at 8:36 PM
Lesson learned: never assume page and pageSize map to propertyId/tenantId. I added explicit type guards in apps/web/src/lib/api.ts and now contracts.list fails fast with a clear error. Validate external contracts early. #TypeScript
October 12, 2026 at 11:41 PM
Me di cuenta de que no puedo asumir que los parámetros lleguen con el nombre correcto. En el endpoint contracts.list, page y pageSize venían como propertyId/tenantId, así que añadí un mapper que los normaliza antes de procesar. Evita bugs silenciosos.
October 12, 2026 at 11:41 PM
The Only 2 Courses You Need to Master System Design (Not ByteByteGo)
19 Best places to learn System Design 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&sourceId=javarevisited&tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr 13 System Design Interview Questions [Solved] 1. Youtube Design - https://bit.ly/3bbNnAN 2. URL Shortner - https://bit.ly/3dZoQ2G 3. Design Twitter - https://buff.ly/4fl5Fvn 4. Parking Lot Design - https://bit.ly/3eMUosX 5. Design a LMS - https://bit.ly/3SfwJQe 6. Instagram Design - https://bit.ly/3BqamCL 7. TinyURL Design - https://bit.ly/3S98WSc 8. WhatsApp design - https://bit.ly/3SbA9Eu 9. Design TiketMaster - https://buff.ly/3M5ncup 10. Design an Efficient Parking Lot System - https://buff.ly/3WssNPR 11. Design Spotify - https://javarevisited.substack.com/p/system-design-problem-design-spotify 11. more - https://bit.ly/3QtyuZl 13. Deisgn X - https://javarevisited.substack.com/p/design-twitter-x-system-design-interview 14 Design URL Shortner - https://javarevisited.substack.com/p/system-design-interview-question 🌐 Checkout Our Other Social Channels: Substack - 📝 https://javarevisited.substack.com/ Twitter - 🐦 https://x.com/javarevisited Facebook - 📘 https://www.facebook.com/javarevisited Reddit - 👤 https://www.reddit.com/r/javarevisited/
www.youtube.com
October 11, 2026 at 10:13 PM
Rate Limiter - System Design Interview 🤣😂
19 Best places to learn System Design 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&sourceId=javarevisited&tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr If you want to become good at system design, learn these concepts: 1. API Gateway vs Load Balancer? https://buff.ly/3S2bjsr 2. Reverse Proxy vs Forward Proxy? https://buff.ly/3PEGDME 3. Horizontal scaling vs vertical scaling? https://buff.ly/49NvS26 4. Microservices vs Monolithic architecture? https://buff.ly/4aC7mS4 5. Caching Strategies - https://buff.ly/413WZD9 6. What is Rate Limiter? How does it work? https://buff.ly/3Lq9jqd 7. How does Single Sign On (SSO) works? https://buff.ly/3S61wBG 8. How does Apache Kafka works? why it so fast? https://buff.ly/3LnlAf6 9. Kafka, ActiveMQ, vs RabbitMQ? https://buff.ly/3LjYSo9 10. JWT, OAuth, and SAML? https://buff.ly/3Lpzey4 11. Database Scaling - https://javarevisited.substack.com/p/system-design-basics-database-scaling 12. Database Replication vs Sharding - https://javarevisited.substack.com/p/system-design-basics-database-replication 13. JWT vs Session based authentication - https://javarevisited.substack.com/p/difference-between-jwts-json-web 14. Consistent Hashing - 15. Message Queues - https://javarevisited.substack.com/p/system-design-basics-master-message 16. REST vs gRPC - https://medium.com/javarevisited/difference-between-rest-graphql-and-grpc-10ac365462b8 17. Leader election (Raft, Paxos) 18. Circuit breakers 19. Failover & Disaster Recovery 20. Heartbeats & health checks 21. CQRS - https://javarevisited.substack.com/p/how-cqrs-pattern-works-in-microservices 22. Event-driven design - https://javarevisited.substack.com/p/scaling-to-millions-the-secret-behind 23. Microservices vs Monolith - https://javarevisited.substack.com/p/monolith-vs-microservices-the-1m 24. Saga pattern - https://javarevisited.substack.com/p/how-does-saga-design-pattern-works 25. Idempotency 🌐 Checkout Our Other Social Channels: Substack - 📝 https://javarevisited.substack.com/ Twitter - 🐦 https://x.com/javarevisited Facebook - 📘 https://www.facebook.com/javarevisited Reddit - 👤 https://www.reddit.com/r/javarevisited/
www.youtube.com
October 6, 2026 at 5:52 PM
Multi-tenant reporting in ASP.NET Core: row-level security your users can't bypass
_By Razi Syed. Sample code for this article: github.com/dotnetreport/dotnetreport-multitenant-rls_ If you run a multi-tenant SaaS product on .NET, you have already solved tenant isolation for the parts of the app you wrote. Every query your code issues carries a `WHERE TenantId = @tenant`, or a global query filter in EF Core does it for you, and you sleep fine. Then a customer asks for reporting. Not a fixed set of reports — _self-service_ reporting, where their analysts pick tables and columns, group and filter however they like, and build dashboards without a ticket to your team. And now you have a problem, because the thing that made isolation easy — _you_ write the query — is gone. The user writes the query. If isolation is something your code adds at the call site, there is no call site anymore. This article walks through the pattern I use to make row-level security a property of the reporting engine rather than of any particular query, so that it applies to every report a user builds, from context the user cannot change. The examples use Dotnet Report, an embedded report builder for .NET that I work on (disclosure up front), but the shape of the solution — a single server-side context method plus engine-applied filters — is what matters, and it transfers to any reporting layer that gives you the same hooks. ## Why "just add the WHERE clause" stops working Three things go wrong once users author their own queries: 1. **There is no fixed query to modify.** A user can join `Orders` to `Customers` to `Regions` in an order you never anticipated. A filter that only knows about `Orders` misses rows that leak through the join. 2. **Client-side filtering is not security.** Anything applied in the browser — hidden columns, default filters, "don't show tenant X" — is one DevTools session away from being removed. 3. **Scheduled and exported reports run with nobody logged in.** If isolation depends on the current HTTP request, a nightly emailed PDF has no request and therefore no isolation. So the requirements are: the filter must be applied **server-side** , on **every** table that carries a tenant column, for **every** query path (interactive, export, scheduled), from **trusted context** the user cannot forge. ## One method, every request Dotnet Report routes every call from the report builder through a single server-side method, `GetSettings()`, on the API controller the NuGet package installs. Whatever that method returns is sent to the reporting engine with the request. The three properties that matter for multi-tenancy are: * `ClientId` — the tenant. Scopes _reports, folders and dashboards_ so tenants don't see each other's saved work. * `UserId` and `CurrentUserRole` — the user and their roles, for ownership, sharing and role-based access. * `DataFilters` — row-level security. A filter the engine appends to every generated SQL statement. That last one is the key. `DataFilters` is an anonymous object whose property names are column names and whose values are the allowed values: settings.DataFilters = new { TenantId = "42" }; The engine turns that into, in effect, ... AND [Table].[TenantId] IN (42) for **every table in the query that has a`TenantId` column** — which is exactly what solves problem #1 above. Join `Orders` to `Customers` to `Regions`; if all three carry `TenantId`, all three get filtered. If you need to be explicit about a table, use the `Table__Column` form (double underscore), and you can combine several filters: settings.DataFilters = new { Orders__TenantId = "42", Customers__TenantId = "42", RegionId = "3,7" // comma-separated -> IN (3,7) }; ## Drive it from claims, never from input The values above are hard-coded, which is fine for a demo and unacceptable for production. The whole point is that the tenant comes from context the user cannot change — and in ASP.NET Core that means **claims on the authenticated principal** , issued by _your_ sign-in code after _you_ verified who they are. Here is the middle of `GetSettings()` after the change. (The token/config lines at the top of the installed method stay as they are; the full method is in the sample repo.) var user = User as ClaimsPrincipal; // The tenant this user belongs to. Issued at login by YOUR code. var tenantId = user?.FindFirst("tenant_id")?.Value ?? string.Empty; // Scopes saved reports, folders and dashboards to the tenant. settings.ClientId = tenantId; // Scopes ownership and sharing to the user. settings.UserId = user?.FindFirst(ClaimTypes.NameIdentifier)?.Value ?? string.Empty; settings.UserName = user?.Identity?.Name ?? string.Empty; // Roles drive role-based access to reports and folders. settings.CurrentUserRole = user?.Claims .Where(c => c.Type == ClaimTypes.Role) .Select(c => c.Value) .ToList() ?? new List<string>(); // Row-level security: appended to EVERY generated query, server-side. settings.DataFilters = new { TenantId = tenantId }; And the sign-in side, which is the only place the tenant is ever decided. This is a plain cookie-auth example; with ASP.NET Core Identity or OpenID Connect the mechanism is the same — you add the claim when you build the principal: var claims = new List<Claim> { new(ClaimTypes.NameIdentifier, userId), new(ClaimTypes.Name, userName), new("tenant_id", tenantId), // looked up from YOUR user store, not from the request }; claims.AddRange(roles.Select(r => new Claim(ClaimTypes.Role, r))); var identity = new ClaimsIdentity(claims, CookieAuthenticationDefaults.AuthenticationScheme); await http.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, new ClaimsPrincipal(identity)); Notice what the user _cannot_ do now. They can build any report they like, join any tables, add any filters — and every query still ends with a tenant clause they never see and cannot remove, because it is added on the server from a claim that only your login code can issue. ## What about exports and scheduled reports? This is where the "single method" design pays off a second time. Exports go through the same context. Scheduled reports are more interesting: when a user schedules a report to be emailed nightly, the schedule **saves the user's`DataFilters` alongside it**, and the background job renders the report with those saved filters — so a PDF that lands in an inbox at 6 a.m. is filtered exactly as it would have been in the browser, with nobody logged in. Isolation doesn't depend on an HTTP request existing. ## Cases you'll hit in practice **A user who spans tenants.** Support staff or a parent-company admin may legitimately need several tenants. Issue a claim listing them and pass the comma-separated value — `"1,2,3"` becomes `IN (1,2,3)`. Isolation is still enforced; it's just enforced to a set. **Restrictions beyond tenant.** A regional manager should see only their regions _within_ their tenant. Add a second filter from a second claim: `new { TenantId = tenantId, RegionId = regionIds }`. Filters compose. **Tables without a tenant column.** Lookup/reference tables (countries, currencies) don't need filtering, and a filter keyed on a column they don't have simply doesn't apply to them. The rule is: any table that _does_ carry tenant data must have the tenant column, or it can leak. That's a schema discipline you need regardless of reporting tool. **Admin capabilities.** Who can enter the builder's admin mode or the schema setup page is also claim-driven (`AllowAdminMode`, `AllowSetupPageAccess`), so you gate those the same way you gate everything else. ## Testing it Do the boring test and do it every release: two users in two tenants, each builds the widest report they can — every table, every join — and each confirms zero rows from the other tenant and zero visibility of the other's saved reports. Then schedule one of those reports, receive the email, and check the PDF. If all three pass, your isolation is a property of the engine, not of your vigilance. ## Takeaways * Self-service reporting removes the call site where you used to add `WHERE TenantId = …`. Isolation has to move into the engine. * Put tenant, user and roles into a **single server-side context method** , sourced from **claims** , and have the engine append the filter to **every** query — including joins, exports and scheduled runs. * Never hard-code tenant values; never trust anything from the client for this. The complete `GetSettings()` and a `Program.cs` that issues the claims are in the sample repo: **dotnetreport/dotnetreport-multitenant-rls**. If you're starting from zero, my earlier post, Add self-service ad hoc reporting to an ASP.NET Core app, and the quickstart repo get the report builder running first. _Razi Syed builds Dotnet Report, an embedded self-service reporting platform for .NET whose report-builder front-end is source-available on GitHub. He writes about adding reporting and analytics to SaaS products without rebuilding them from scratch._
dev.to
September 30, 2026 at 11:52 AM
How to Create Beautiful Software Architecture Diagrams with ChatGPT, Mermaid & Draw.io
19 Best places to learn System Design and Software Architecture 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&amp;sourceId=javarevisited&amp;tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr 🌐 Checkout Our Other Social Channels: Substack - 📝 https://javarevisited.substack.com/ Twitter - 🐦 https://x.com/javarevisited Facebook - 📘 https://www.facebook.com/javarevisited Reddit - 👤 https://www.reddit.com/r/javarevisited/
www.youtube.com
September 27, 2026 at 2:19 AM
The Only 2 Courses You Need to Master System Design (Not ByteByteGo)
19 Best places to learn System Design 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&amp;sourceId=javarevisited&amp;tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr 13 System Design Interview Questions [Solved] 1. Youtube Design - https://bit.ly/3bbNnAN 2. URL Shortner - https://bit.ly/3dZoQ2G 3. Design Twitter - https://buff.ly/4fl5Fvn 4. Parking Lot Design - https://bit.ly/3eMUosX 5. Design a LMS - https://bit.ly/3SfwJQe 6. Instagram Design - https://bit.ly/3BqamCL 7. TinyURL Design - https://bit.ly/3S98WSc 8. WhatsApp design - https://bit.ly/3SbA9Eu 9. Design TiketMaster - https://buff.ly/3M5ncup 10. Design an Efficient Parking Lot System - https://buff.ly/3WssNPR 11. Design Spotify - https://javarevisited.substack.com/p/system-design-problem-design-spotify 11. more - https://bit.ly/3QtyuZl 13. Deisgn X - https://javarevisited.substack.com/p/design-twitter-x-system-design-interview 14 Design URL Shortner - https://javarevisited.substack.com/p/system-design-interview-question 🌐 Checkout Our Other Social Channels: Substack - 📝 https://javarevisited.substack.com/ Twitter - 🐦 https://x.com/javarevisited Facebook - 📘 https://www.facebook.com/javarevisited Reddit - 👤 https://www.reddit.com/r/javarevisited/
www.youtube.com
September 25, 2026 at 2:40 PM
His mother-in-law moved in and handed him a ‘Best Son-in-Law’ mug with one instruction: earn it.

Then their hands touched.

Read the prologue: https://yumeku.com/comics/best-son-in-law/prologue/?linkId=lp_282176&sourceId=social&tenantId=toonia&affS5=bluesky&affS4=bsl_prologue_ymk0003
September 20, 2026 at 2:12 PM
She took a dragon bounty. Instead, she found a suspiciously charming bard in a cave—and his curse has terrible timing.

Read the prologue: https://yumeku.com/comics/slay-me-huntress/prologue/?linkId=lp_787797&sourceId=social&tenantId=toonia&affS5=bluesky&affS4=smh_prologue_ymk0001
September 19, 2026 at 1:27 PM
I discovered that multi‑tenant isolation must be enforced at the repository layer, not just in controllers. Adding a tenantId filter to DB queries stopped three cross‑org bugs and saved hours of debugging.
September 16, 2026 at 8:06 PM
Aprendí que validar el aislamiento en cada endpoint con pruebas de cobertura es esencial en arquitectura multi‑tenant. Añadí asserts de tenantId en los tests y la cobertura subió de 0.86% a >90%, evitando fugas de datos. #multitenancy
September 13, 2026 at 7:26 PM
Finalmente resolví el bug de aislamiento en broker-portal.controller.ts. El controlador devolvía datos de todos los tenants porque faltaba filtrar por tenantId. Con tres cambios en la lógica y pruebas unitarias, la ruta ahora respeta el multi‑tenancy.
September 13, 2026 at 7:26 PM
Rate Limiter - System Design Interview 🤣😂
19 Best places to learn System Design 1. ByteByteGo - https://bit.ly/3P3eqMN 2. Codemia - https://buff.ly/4dl3eHJ 3. DesignGuru - https://bit.ly/3pMiO8g 4. BugFree.ai - https://www.bugfree.ai/?via=javarevisited 5. Exponent - https://bit.ly/3cNF0vw 6. System Design School - https://systemdesignschool.io/?linkId=lp_110319&amp;sourceId=javarevisited&amp;tenantId=system-design-school 7. Educative - https://bit.ly/3Mnh6UR 8. Udemy - https://trk.udemy.com/c/3294490/3262185/39854?u=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fsystem-design-masterclass%2F%3FcouponCode%3DKEEPLEARNING 9. InterviewKickStart - https://upwardandonwardinc.sjv.io/RG2Aka 10. DDIA https://amzn.to/3nXKaas 11. System Design Interview - An insider's guide - https://amzn.to/3nU2Mbp 12. ZTM - https://bit.ly/3YpWu4q 13. AlgoMaster - https://buff.ly/4cmZOTB 14. System Design One - https://buff.ly/4ctkXvs 15. InterviewReddy - https://buff.ly/3VXt5in 16. free system design courses - https://bit.ly/3nqVdfl 17. Github - https://bit.ly/3bSaBfC 18. AlgoMonster - http://shrsl.com/483tt 19. Coursera - https://bit.ly/3BxMXzr If you want to become good at system design, learn these concepts: 1. API Gateway vs Load Balancer? https://buff.ly/3S2bjsr 2. Reverse Proxy vs Forward Proxy? https://buff.ly/3PEGDME 3. Horizontal scaling vs vertical scaling? https://buff.ly/49NvS26 4. Microservices vs Monolithic architecture? https://buff.ly/4aC7mS4 5. Caching Strategies - https://buff.ly/413WZD9 6. What is Rate Limiter? How does it work? https://buff.ly/3Lq9jqd 7. How does Single Sign On (SSO) works? https://buff.ly/3S61wBG 8. How does Apache Kafka works? why it so fast? https://buff.ly/3LnlAf6 9. Kafka, ActiveMQ, vs RabbitMQ? https://buff.ly/3LjYSo9 10. JWT, OAuth, and SAML? https://buff.ly/3Lpzey4 11. Database Scaling - https://javarevisited.substack.com/p/system-design-basics-database-scaling 12. Database Replication vs Sharding - https://javarevisited.substack.com/p/system-design-basics-database-replication 13. JWT vs Session based authentication - https://javarevisited.substack.com/p/difference-between-jwts-json-web 14. Consistent Hashing - 15. Message Queues - https://javarevisited.substack.com/p/system-design-basics-master-message 16. REST vs gRPC - https://medium.com/javarevisited/difference-between-rest-graphql-and-grpc-10ac365462b8 17. Leader election (Raft, Paxos) 18. Circuit breakers 19. Failover &amp; Disaster Recovery 20. Heartbeats &amp; health checks 21. CQRS - https://javarevisited.substack.com/p/how-cqrs-pattern-works-in-microservices 22. Event-driven design - https://javarevisited.substack.com/p/scaling-to-millions-the-secret-behind 23. Microservices vs Monolith - https://javarevisited.substack.com/p/monolith-vs-microservices-the-1m 24. Saga pattern - https://javarevisited.substack.com/p/how-does-saga-design-pattern-works 25. Idempotency 🌐 Checkout Our Other Social Channels: Substack - 📝 https://javarevisited.substack.com/ Twitter - 🐦 https://x.com/javarevisited Facebook - 📘 https://www.facebook.com/javarevisited Reddit - 👤 https://www.reddit.com/r/javarevisited/
www.youtube.com
September 13, 2026 at 10:13 PM
My appsettings.json:

"AzureAd": {
"Instance": "https://login.microsoftonline.com/",
"Domain": "<blah>.onmicrosoft.com",
"TenantId": "<guid>",
"ClientId": "<revoked>",
"CallbackPath": "/signin-oidc",
"ClientSecret": "<revoked>",
"ServicePrincipalId": "<revoked>",
"ClientCertificates": []
}
November 19, 2025 at 8:51 PM