Repository navigation
v2.0.1
This is the start of MySQL integration.
IMPORTANT
- To use this version the pre-reqs is installing MySQL Server & Workbench 8.32+.
- During installation choose the first option of authentication not the legacy option.
- Create a table for products.
- Provide a environment variable in your code editof for the password (It's also good practice!).
- The SQL database is local. Meaning it pulls from your local machine.
Features
- Reading products from the SQL database.
- Adding products to the SQL database.
- Reading specific product from the SQL database.
- This features raw SQL injection code.
Developer Notes
- The next version will use the ORM, Sequelize but I wanted to preserve a way of just beginning SQL in the code since the next version the product created in workbench will be deleted.
- This is more for preservation at this point in time and a starting point should we need to revert or refactor or play around with just SQL code injections, then this version is the one you want.