It's All About the Database

by Dave Keeshin

---

April 2025

---

ARCHIVE

2018-05-08 Database Design Guidelines 2018-07-08 Sheep Backup 2020-03-13 The Data Vault 2020 2020-06-10 Async Data Vault Pipeline 2020-12-10 Popular APIs Summer 2021 Container Gardening 2021-05-27 Open To Open Source? 2021-06-21 OLTP 2.0 2023-09-15 Hello Dave, I'm ChatGPT 2023-11-07 An Image Managment Proof of Concept 2023-12-18 Lost in the Clouds? 2024-06-03 A Better Data Source Discovery Concept- Introduction 2024-07-02 Designing a Database to Support a Chatbot Interview App - Part 1 2024-09-03 Designing a Database to Support a Chatbot Interview App - Part 2 2024-09-19 Designing a Database to Support a Chatbot Interview App – Part 3: Modeling Data 2024-10-02 Designing a Database to Support a Chatbot Interview App – Part 4: Staging the Data Discovery Model 2024-10-16 Designing a Chatbot Interview App Database – Part 5: Mapping LLM-Generated Data to Real-World Data 2024-10-25 Designing a Chatbot Interview App Database – Part 6: Formatting Interview Questions and Answers 2024-11-07 Designing a Chatbot Interview App Database – Part 7: Storing Answers 2024-11-13 Designing a Chatbot Interview App Database – Part 8: Handling Location and Job Role Data with APIs 2024-12-04 Designing a Data Source Discovery App - Part 9: Managing Organizational Data 2024-12-22 Designing a Data Source Discovery App - Part 10: Retrieval-Augmented-Generation (RAG) in kDS-DSD 2025-02-10 Designing a Data Source Discovery App - Part 11: New Year, New Architecture 2025-02-27 Designing a Data Source Discovery App - Part 12: Summarizing Interview Data 2025-03-05 Designing a Data Source Discovery App - Part 13: Summarizing Interview Data Continued... 2025-03-17 Designing a Data Source Discovery App - Part 14: Generating Smart Test Data with LLMs 2025-03-24 Designing a Data Source Discovery App - Part 15: A Primarily Data Insert Only Approach 2025-04-07 Designing a Data Source Discovery App - Part 16: Testing SQL Efficiency 2025-04-14 Designing a Data Source Discovery App - Part 17: Migrating LLM Prompts To Jinja2 2025-04-21 Designing a Data Source Discovery App - Part 18: Deploying the kds_discovery_2025 Database 2025-05-06 Designing a Data Source Discovery App - Part 19: Generating a Role Based Hierarchy 2025-05-13 Designing a Data Source Discovery App - Part 20: Securing Access with Token-Based Authentication

2025-05-25 Designing a Data Source Discovery App - Part 21: Securing The kds_discovery_2025 Database