Migrating Existing Data From Sqlite to Other Databases

When we begin our learning journey with Django we use the default database i.e., sqlite. It is very much enough for development and learning purposes. But as we make progress with our project and/or want to switch to a high end databases like MySQL,PostgreSQL etc. we will have to transfer our existing data to the new database.

python manage.py dumpdata -o data.json --format json

Change the settings.py file and connect to another database. After that

python manage.py migrate
This would create the tables according to the models we have made in the new database.

python manage.py loaddata data.json
If run successfully. All the data will be transferred to the new database.

Day 26

Have started a solving a programming exercise question from this Github repository. I have taken a task of 5 questions per day and will be pushibg these to my Github Account. This programming exercise has 3 levels of difficulty from Beginner to Advanced. So I will have a good grasp over Python Language.

Day 22

Still stuck on the same PR. There has been a lot of confusion about what should be done and different reviewers giving different suggestions regarding the pr. So I have been listening to all of them and applying the changes as requested. I just hope that it gets merged till tomorow as I am kinda bored with this one and want to work on somehing new. So let’s see what happens tomorrow.

Day 20

Couldn’t do much of the programming today other than the usual classes of OOPS, DSA, Software Engineering and other subjects that are being taught at the college, because I was out at some place. But there I learned how to set up a biometrics sensor and the other things related to it.

Day 18

Took up another issue to work on on coala project. Have done 90% of the work it needed, now just waiting for the maintainer to reply to some questions to finalise it. Will probably submit a PR till tomorrow.

Also didn’t felt like doing anything at night so watched some videos from a a channel. I like these kinds of infographics videos.