Re: [Tutor] Is it possible to archive subsets of data from an SQLite db and restore it later?

2015-08-18 Thread Alan Gauld
On 18/08/15 10:02, Ben Finney wrote: Alan Gauld alan.ga...@btinternet.com writes: A flag column that can be used to include/exclude students from reports. So better than a boolean in the database, would be a timestamp (or just a date) indicating *when* the status changes. Either an

Re: [Tutor] Is it possible to archive subsets of data from an SQLite db and restore it later?

2015-08-18 Thread Ben Finney
Alan Gauld alan.ga...@btinternet.com writes: A flag column that can be used to include/exclude students from reports. Boolean flags very commonly indicate something that can be different at different times. When the name is of the form “currently_foo”, that's almost certainly something that is

Re: [Tutor] Is it possible to archive subsets of data from an SQLite db and restore it later?

2015-08-18 Thread Alan Gauld
On 18/08/15 04:51, Zachary Ware wrote: On Mon, Aug 17, 2015 at 10:44 PM, boB Stepp robertvst...@gmail.com wrote: My wife had an interesting request tonight: Would it be possible to have two dbs, one that is the current working db, and the other an archival db for students who have left the

[Tutor] Is it possible to archive subsets of data from an SQLite db and restore it later?

2015-08-17 Thread boB Stepp
My wife had an interesting request tonight: Would it be possible to have two dbs, one that is the current working db, and the other an archival db for students who have left the school? If yes, then the archival db would need to be able to serve two functions: 1) If the teacher gets a request

Re: [Tutor] Is it possible to archive subsets of data from an SQLite db and restore it later?

2015-08-17 Thread Ben Finney
boB Stepp robertvst...@gmail.com writes: My wife had an interesting request tonight: Would it be possible to have two dbs, one that is the current working db, and the other an archival db for students who have left the school? (Note that this isn't anything to do with Python per se, and would

Re: [Tutor] Is it possible to archive subsets of data from an SQLite db and restore it later?

2015-08-17 Thread Zachary Ware
On Mon, Aug 17, 2015 at 10:44 PM, boB Stepp robertvst...@gmail.com wrote: My wife had an interesting request tonight: Would it be possible to have two dbs, one that is the current working db, and the other an archival db for students who have left the school? If yes, then the archival db