[HN Gopher] Show HN: SQL Simulator - Create Subsetted Databases ...
___________________________________________________________________
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/
Author : westonOG
Score : 30 points
Date : 2024-12-02 11:35 UTC (6 days ago)
(HTM) web link (www.tribalknowledge.tech)
(TXT) w3m dump (www.tribalknowledge.tech)
| mdaniel wrote:
| 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...
| westonOG wrote:
| 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.
| TripleChecker wrote:
| 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 :)
___________________________________________________________________
(page generated 2024-12-08 23:01 UTC)