Re: The best way to populate sqlite3 database

2009-12-12 Thread Zeynel
On Dec 12, 3:04 pm, Shawn Milochik wrote: > > http://pastebin.com/f651cf8de Hi, Thanks for the script, I want to use it but I have some questions. These are from the previous thread: http://groups.google.com/group/django-users/msg/091f964c6c8e40c7 but I have others as

Re: The best way to populate sqlite3 database

2009-12-12 Thread Shawn Milochik
The fastest way for large files is to use sqlite3's .import command to directly import a file. However, this will bypass any validation done by your models. You could end up with "bad" data, in that it doesn't conform to the rules of your models. Or, you can just write an external script to

The best way to populate sqlite3 database

2009-12-12 Thread Zeynel
Hi, I first put the data in csv format than convert it to json and then create a fixture... which seems a long process. This http://stackoverflow.com/questions/1884694/how-to-populate-sqlite3-in-django/1885417#1885417 answer suggests to "Just load the database directly," but without giving much