Have I to delete SQLite database from the directory after migrating to PostgreSQL on Django 2.2?

Question

I am new to Django 2.2 and I found that SQLite is default database engine here. But I want to use the PostgreSQL instead of SQLite.

I have created a new project and migrate the (ex: Post) model after creating and adding the app to the settings.py and admin.py file. And after that, I decided to use the postgreSQL, and I did it too by migrating to postgreSQL. Before migrating I created a postgres database and add all the necessary details to the settings.py file's DATABASE settings according to instruction of Django. It's working fine. I haven't got any problem yet. Though I see still the sqlite database file still in the project directory. It looks bit odd though. I'm new to Django. Can you please tell me should I keep that file there or delete sqlitedb file? And is there any security issue with sqlitedb file if I keep there? I love to want a neat and clean project settings. Thanks in advance my dear friends!

You can delete the sqlite database file after you have migrated to postgreSQL. — Ahmad Javed
– Ahmad Javed, Commented Jun 21, 2019 at 5:02
Thank you Mr. Ahmed for your answer. Can you please clarify why the sqlite deletion will not cause any futuristic problem? — Coduser
– Coduser, Commented Jun 21, 2019 at 6:39
SQLite is the default database for django projects.Once you have migrated to postgreSQL database, all the changes will take place there only. — Ahmad Javed
– Ahmad Javed, Commented Jun 21, 2019 at 6:43

Cipher · Accepted Answer · 2019-06-21 11:02:35Z

0

It's totally up to you. If you want to keep then keep it. And if you want to delete that file delete it. There is no security reason or any problem will occur. Just delete it if you don't need it.

When to Use SQLite?

All applications that require portability and don’t require expansion.
In cases where applications need to read or write files to disk directly.

When to Use MySQL?

Where high-security features are required for data access.
For websites that work on MySQL despite some constraints.It's a scalable tool that is easy to manage.

edited Jun 21, 2019 at 11:02

answered Jun 21, 2019 at 5:22

Cipher

2,1304 gold badges38 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Coduser Over a year ago

Thanks a lot for your prompt reply Mr. Huzaif. After deleting the file db.sqlite3 I don't see any file named db.postgrsql (i.e db.sqlite3) on that place as a reproduction. Why?

Cipher Over a year ago

Because PostgresSQL is scalable so we have installed a databse using terminal. See the difference in above answer.

Coduser Over a year ago

Thank you very much dude. I got it now. I'm bit enthusiastic as I'm a learner. Have a great day!

Collectives™ on Stack Overflow

Have I to delete SQLite database from the directory after migrating to PostgreSQL on Django 2.2?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related