Projects

To create my FISC study tool, I originally had everything on my local machine and this required installing SQL Servers and services. I used a .csv from Plant Atlas 2020 and removed various columns that I didn't need or use in the database. However, when I transitioned from my local machine to a hosting service, Vercel, this posed a number of problems with compliling and building which resulted in needing to rollback some of my changes made and start from scratch. Fortunately I had been using github and was able to push these changes.Fast forward to now, and I'm not just getting ready to set up my database and storage with Vercel. However, they didn't have a good SQL or MySQL solution and after carefully looking through their options, I came across Neon. Neon is a serverless postgreSQL service, which is not something I had experience with. I had to install pgAdmin to connect to the Neon databse and use a copy command \copy customer FROM '/path/to/CSVFILE.csv' DELIMITER ',' CSV HEADER and copy over 3496 entries.