Inspiration
Time to time everyone is experiencing problems with database table relations especially when the area you are working on is quite new for you. In any case our system has a lot of tables and involves DB pretty strong. I would like to have a tool which helps me to make our life at least a bit easier while we are working with DB.
What it does
The application analyzes the codebase and extracts table relations Users manually add relations WebSQL builds a diagram based on user’s requirements Build SQL for selected tables
Accomplishments that I'm proud of
I've managed to build pretty useful and stable application in short period of time
What I learned
D3.js library which provides a possibility to build incredible things
What's next for Wayfair WebSQL
A lot of plans, but the most important things are:
- support all databases (currently it's only csn_product).
- analyze PHP code
- feature to share diagram
- show a reference to codesearch where relation was found
- vote for relations to recognize incorrect
PS: Since it's internal tool you need to authorize to access it. Please ask me via smytsyk@wayfair.com, slack or by phone to get access credentials.
Log in or sign up for Devpost to join the conversation.