Re: Started to work with SQLite3 in Python3

2015-09-20 Thread Cecil Westerhof
On Sunday 20 Sep 2015 17:49 CEST, Cecil Westerhof wrote: > I started a little project in Python3 with SQLite3: > https://github.com/CecilWesterhof/CarApplication > > I do not mind to get some feedback on it. > > I was wondering about two things: > - Would it be better to split the code into severa

Re: Started to work with SQLite3 in Python3

2015-09-20 Thread Cecil Westerhof
On Sunday 20 Sep 2015 17:49 CEST, Cecil Westerhof wrote: > I started a little project in Python3 with SQLite3: > https://github.com/CecilWesterhof/CarApplication > > I do not mind to get some feedback on it. I think I found a bug. In init I should put a: conn.commit() after: fill_tables()

Re: Started to work with SQLite3 in Python3

2015-09-20 Thread Cecil Westerhof
On Sunday 20 Sep 2015 18:44 CEST, Chris Angelico wrote: > On Mon, Sep 21, 2015 at 1:49 AM, Cecil Westerhof wrote: >> - I understood that with for fuel in fuel_cursor: a fetchall will >> be executed. At the moment I do not see this as a problem, but if >> the table would become very big it could.

Re: Started to work with SQLite3 in Python3

2015-09-20 Thread Chris Angelico
On Mon, Sep 21, 2015 at 1:49 AM, Cecil Westerhof wrote: > - I understood that with > for fuel in fuel_cursor: > a fetchall will be executed. > At the moment I do not see this as a problem, but if the table would > become very big it could. Would it be better to rewrite it with a > fetc