Re: [Tutor] How is database creation normally handled?

2017-09-13 Thread Alan Gauld via Tutor
On 10/09/17 18:41, Mats Wichmann wrote: > restore" and a local copy of the (mysql) db will be built. So that's > what I just agreed with: the setup process happens outside the code app ... > maybe it's not that unusual - any time you need to start with a > reproducible known state of the DB, that

Re: [Tutor] How is database creation normally handled?

2017-09-10 Thread Chris Warrick
On 10 September 2017 at 02:29, boB Stepp wrote: > While reading about SQL, SQLite and the Python module sqlite3, it > appears that I could (1) have a program check for the existence of the > program's database, and if not found, create it, make the tables, > etc.; or, (2) create the database separ

Re: [Tutor] How is database creation normally handled?

2017-09-10 Thread Mats Wichmann
On 09/10/2017 02:08 AM, Alan Gauld via Tutor wrote: > On 10/09/17 01:29, boB Stepp wrote: >> While reading about SQL, SQLite and the Python module sqlite3, it >> appears that I could (1) have a program check for the existence of the >> program's database, and if not found, create it, make the table

Re: [Tutor] How is database creation normally handled?

2017-09-10 Thread Peter Otten
boB Stepp wrote: > While reading about SQL, SQLite and the Python module sqlite3, it > appears that I could (1) have a program check for the existence of the > program's database, and if not found, create it, make the tables, > etc.; or, I'm only a casual user of sqlite, and therefore I prefer t

Re: [Tutor] How is database creation normally handled?

2017-09-10 Thread Alan Gauld via Tutor
On 10/09/17 01:29, boB Stepp wrote: > While reading about SQL, SQLite and the Python module sqlite3, it > appears that I could (1) have a program check for the existence of the > program's database, and if not found, create it, make the tables, > etc.; or, (2) create the database separately and inc

Re: [Tutor] How is database creation normally handled?

2017-09-09 Thread leam hall
On Sat, Sep 9, 2017 at 8:29 PM, boB Stepp wrote: > While reading about SQL, SQLite and the Python module sqlite3, it > appears that I could (1) have a program check for the existence of the > program's database, and if not found, create it, make the tables, > etc.; or, (2) create the database sep

[Tutor] How is database creation normally handled?

2017-09-09 Thread boB Stepp
While reading about SQL, SQLite and the Python module sqlite3, it appears that I could (1) have a program check for the existence of the program's database, and if not found, create it, make the tables, etc.; or, (2) create the database separately and include it with the program. What are the pros