Django migrate generates SQLite3 file filled with junk

14 views
Skip to first unread message

kbman99

unread,
Sep 25, 2016, 8:17:54 AM9/25/16
to Django users
Just getting started with django and having an issue with the migrate.py script. It generates a db.SQLite3 file which is filled with a lot of garbage characters. It's in UTF-8 encoding, but looks like this.

I've deleted the file and redone the migrate a few times but it's always like this.

Any help appreciated!
Thanks

Gergely Polonkai

unread,
Sep 25, 2016, 8:27:26 AM9/25/16
to Django users

That file is an SQLite database, which is a binary format. It should look like this.

I know it is confusing, because of that bunch of SMS statements, but it's OK that way. If you want to interact with it, use the sqlite3 command, or an SQLite GUI.


--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2980ce12-c366-454b-844a-c625e7520977%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Lekan Wahab

unread,
Sep 25, 2016, 8:35:13 AM9/25/16
to django...@googlegroups.com


On 25 Sep 2016 1:17 PM, "kbman99" <kylebo...@gmail.com> wrote:

>

> Just getting started with django and having an issue with the migrate.py script. It generates a db.SQLite3 file which is filled with a lot of garbage characters. It's in UTF-8 encoding, but looks like this.
>

> I've deleted the file and redone the migrate a few times but it's always like this.
>
> Any help appreciated!
> Thanks
>

> --
> You received this message because you are subscribed to the Google Groups "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
> To post to this group, send email to django...@googlegroups.com.
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2980ce12-c366-454b-844a-c625e7520977%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

Hi kbman,
If you use PyCharm, you can easily read the sqlite3 file better with its database integration.
Click on database.
Select from sources and then okay.

Lekan.

Reply all
Reply to author
Forward
0 new messages