B-Open / jobbuzz

Brunei job search database and alert notification
https://jobbuzz.org
MIT License
1 stars 1 forks source link

DB Seeder #53

Open syahnur197 opened 2 years ago

syahnur197 commented 2 years ago

It's not an enjoyable development experience to keep on scraping the websites especially when you have unreliable internet connection. Suggestion is to have another cmd programme that seeds data to the DB. We can use export an SQL file from existing data and create a new cmd programme that imports the SQL file.

dsychin commented 2 years ago

@syahnur197 The MySQL docker image has a special directory at /docker-entrypoint-initdb.d where it will execute any scripts and sql in there. So we can keep an sql dump and mount it to that directory in docker-compose.