Show HN: SQL Simulator – Create Subsetted Databases in Docker or K8s
36 points
24 days ago
| 1 comment
| tribalknowledge.tech
| HN
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/

mdaniel
23 days ago
[-]
Might I suggest including version ranges with the supported DB list[1] since my experience is that "mysql" isn't just one thing across major versions, and that goes double for its sibling MariaDB which may work or may not, so knowing that you've tried it, and across which versions, would be super helpful

I'd also advocate linking to https://sql-simulator.tribalknowledge.tech/getting-started/l... from the FAQ because someone would need to be aware of that before investing the energy in setting up a PoC (or scheduling a call only for them to learn it from the expenditure of both of your times, arguably worse from your perspective due to opportunity cost)

Watch out for the mention of K8s pod in the docker docs: https://ssdocker.tribalknowledge.tech/getting-started/techni...

p.s. I'm aware that complaining about websites is off topic, but that fly-out menu is so enraging I'm willing to risk the flag because as best I can tell it offers zero value but non-zero rage

1: https://www.tribalknowledge.tech/faq.html#:~:text=What%20Dat...

reply
westonOG
23 days ago
[-]
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.
reply
TripleChecker
23 days ago
[-]
While you're making any websites fixes, a few broken links you can also fix: https://triplechecker.com/s/696381/tribalknowledge.tech and perhaps update the copyright year :)
reply