3 ms·
This is pretty cool -- one thing I think you may want to highlight more is the SQL analysis. In your demo video, when you run the following statement: updat
by gavinray 3y ago
This is pretty cool -- one thing I think you may want to highlight more is the SQL analysis.
In your demo video, when you run the following statement:
update payroll
set payroll_status = = 'X'
where ...
In the simulation DB schema, it picks up the FK from (payroll.employee_id <-> employee.id) and creates the employee table + inserts the related employee records for the affected payroll records in the parent statement.
That's pretty nifty.
---
On an unrelated note, I think that creating an open-source version of this on the JVM using tools like jOOQ, SchemaCrawler, and Apache Calcite could be a fun weekend project.
- westonOG 3y agoThanks for the feedback. I use Java to do the static code analysis, C# for the front end and DB connections. One of the biggest issues I've had is trying to explain what it does and how it does it. If I say too much I scare people away. So I am not sure how much information to give at once. As for coding it over a weekend, it's taken me a few years to get it to this point I doubt I could re-write it that quick :-)