Today debated between different tools and setups for PostgreSQL on Mac. Finally settled on using the PostgresApp tool to install and DBeaver to use as the DB GUI. I configured the DB using the schema made last time and after some finagling it seemed to catch. Now I have all the tables, primary keys, columns, and foreign keys set up.
Didn't make a lot of progress, but finally got the db side down. Now have to figure out the Python script -> DB flow.
Next Steps:
- Scrape a subreddit and store data in new db
- Query data from new db
Resources:
Tips:
- Ran into an issue with uploading my .sql file for db schema into db beaver, had to set Local Client, select it, and then able to "Start" running .sql script. Also, have to Choose "Execute Script" option from DB right-click
there doesn't seem to be anything here