Back to Blog
Sequel pro mac create table5/26/2023 ![]() At every step in the database process, Sequel PRO was there to make the often tedious process of interacting with the MySQL prompts much simpler, quicker, and most importantly- error-free. Relationships could also be changed readily, as well as the types of values that would be accepted as inputs. I could also use Sequel PRO to add or delete data, which became helpful when we realized that the produce table was missing a vital column. Being able to see these values being input in nearly real-time gave us immediate feedback on whether or not our API tests were firing correctly. Sequel PRO made it really simple to view the values in each table, which was incredibly valuable when we started working with the tables in our database that held user created data. Sequel PRO continued to be incredibly useful, even after the schemas were initialized. A few more imported tables later, and our whole database was built! csv files, and after a couple of formatting questions, my entire produce table was imported. Regardless, you simply need to export your spreadsheet as a. I should mention that I had moved the spreadsheet over to Google Sheets at some point so that I could share it live with my dev team- the functionality is practically the same, although some of the options might be slightly different. Benefits of Sequel PROĮxporting my Excel database was as easy as cake. Installing new software without issue was an emotional experience for me.) and I quickly was able to link up to my AWS deployed database with ease (Seriously, I didn't get one single error. Installation was painless (oh thank god! I had been working on a WSL machine until recently and every installation was a NIGHTMARE. Sequel PRO is a graphical interface for managing relational databases. Sequel PRO was recommended specifically for the task I required of it, but it also provided a lot more functionality that continued to benefit us right up to the moment of deployment. ![]() Introducing Sequel PROĪfter our information had been collected in Excel, I lucked upon Sequel PRO after some diligent googling. I decided that I was pretty proficient with the spreadsheeting software (On top of the degree, I'd had numerous professional positions where I was in charge of inventories and payrolls, and so Excel was a welcome GUI for me after months of terminals and debuggers), and so I was going to input all of this data into an Excel spreadsheet, and then hopefully find a way to import the file from Excel into our database. in Business Administration, which had really only taught me one thing- all things can be done in Excel. I had previously spent an incredible amount of time and energy getting a B.S. The whole thing reeked of torture and toil, and that's not for me, not Ol' Geoff, no sir! Inputting Data in Excel Tables must be commanded to be built, and data must be inserted with commands like corkscrews. To input data, there are special secret commands, yelled at in all-caps into the abyss of the terminal command line, most of which are mercilessly thrown back in our faces by the cruel and insatiable Lord of Darkness The Syntax Error. ![]() So MySQL it is!Ī problem with MySQL, and any other SQL databases, is that they are incredibly rigid for good reason, but this makes them an absolute chore for inputting data into. We felt that there was significant relational connections among the seasons, regions, produce, recipes, and users in order to require a relational database. It took me around 4 days to get all of the information entered correctly.įor our database, we had chosen to go with MySQL over a document based database. The spreadsheet ended up being 20 columns wide, and close to 700 rows long. When we did our first round of deadline estimations, I was confident that the spreadsheet could be completed in a manner of hours. What wasn't clear was just how much data a lot of data is. Needless to say, this was going to be a lot of data. Which means I had to catalogue not ONLY every fruit/vegetable I could think of, as well as some information on each fruit/vegetable, I also had to make sure that every fruit/vegetable had it's entire seasonality represented across 5 different subregions of the continental United States. The only problem was that when it came to picking our assignments, I volunteered to be in charge of the static databases that would hold most of our App's contents. Simple enough, right? Nice and clean and elegant. Once you have registered for the app, it parses out your data and returns a gallery of produce that are all seasonally available in your area, along with suggested recipes for that produce, and local farmers markets nearby where you could do your shopping. HeirBloom exists to celebrate the Locavore/Slow Food movements. After deliberation, we decided on an app called HeirBloom. We were to build an app from scratch (our first), from blank repository to fully deployed MVP++. Recently, I was assigned a 2 week sprint as part of a dev team.
0 Comments
Read More
Leave a Reply. |