LOL, thanks for the feedback. I see what you are saying. I need to say what version I've tried it against. I have not tried it against any of the MariaDB variants, so more than likely it won't work with those.

Show HN: SQL Simulator – Create Subsetted Databases in Docker or K8s

Hi, 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/

In enterprise environments this is pretty common. I've worked at places with over 100 developers and 30 testers. So you have a situation with hundreds if not thousands of databases and then multiple schemas in each database. So imagine trying to manually validate if your script will work on all those databases and against all those schemas. How difficult of a task that is.

Oh I see. Got it.

Don't worry I have a thick skin. It's better for people to tell me what they don't like or if there is a better way to do something than to say they like the product when they really don't. The really nifty thing with my program is you can see what the data would look like. I can't tell if your script does that.