Show HN: SQL Simulator – Create Subsetted Databases in Docker or K8s
westonOG Monday, December 02, 2024Hi, I'm Weston Goodwin. I originally posted about my project on HN back in June 2023 (https://news.ycombinator.com/item?id=36187556) and wanted to share some of the updates I’ve made since then. As a referesher SQL Simulator is a tool that simulates SQL script execution by creating a subsetted database. Below is a list of changes I've made:
1.)It now supports both Docker and Kubernetes. 2.)The database container automatically self-destructs after 15 minutes of inactivity to improve security. 3.)A Data Governor limits the amount of sensitive data that can be retrieved in a day. 4.)The K8s version can be used as a database proxy. Simply remove direct access to the database and force users to go through the K8s cluster/Data governor to view any data.
The tool is available without requiring signup or credit card. I’d appreciate any feedback or suggestions. Thanks for this post reading.
Docker Documentation: https://ssdocker.tribalknowledge.tech/
K8s Documentation: https://sql-simulator.tribalknowledge.tech/