2
votes
1answer
64 views

python adding unique items to a huge table

I have a very large list of items (10M+) that must be put in a table with three columns (Item_ID,Item_name,Item_count) The items in the table must be unique. We are adding the items one by one. When ...
0
votes
1answer
111 views

Generate SQL Insert statements for SQLite with Django

I want to generate a complete SQL file with Django that can be downloaded and executed to create a SQLite DB. The problem is escaping the strings to insert them into the file to download. This is ...
0
votes
1answer
1k views

SQLite, MySQLdb to open .db file conceptual Python process

I have a db file that I would like to open, process the data within and re-save as another db file to be inserted into a MySQLdb database. I have read that the only way to open a db file is with ...