Re: How to use SQLite (sqlite3) more efficiently

2014-06-09 Thread Philip Shaw
On 2014-06-06, Mark Lawrence wrote: > On 06/06/2014 22:58, Dave Angel wrote: >> Chris Angelico Wrote in message: >>> On Sat, Jun 7, 2014 at 4:15 AM, R Johnson >>> wrote: > The subject line isn't as important as a header, carried invisibly > through, that says that you were replying to an

Re: How to use SQLite (sqlite3) more efficiently

2014-06-06 Thread Mark Lawrence
On 06/06/2014 22:58, Dave Angel wrote: Chris Angelico Wrote in message: On Sat, Jun 7, 2014 at 4:15 AM, R Johnson wrote: The subject line isn't as important as a header, carried invisibly through, that says that you were replying to an existing post. :) Sorry for my ignorance, but I've neve

Re: How to use SQLite (sqlite3) more efficiently

2014-06-06 Thread Dave Angel
Chris Angelico Wrote in message: > On Sat, Jun 7, 2014 at 4:15 AM, R Johnson > wrote: >>> The subject line isn't as important as a header, carried invisibly >>> through, that says that you were replying to an existing post. :) >> >> Sorry for my ignorance, but I've never edited email headers befo

Re: How to use SQLite (sqlite3) more efficiently

2014-06-06 Thread Chris Angelico
On Sat, Jun 7, 2014 at 4:15 AM, R Johnson wrote: >> The subject line isn't as important as a header, carried invisibly >> through, that says that you were replying to an existing post. :) > > Sorry for my ignorance, but I've never edited email headers before and > didn't find any relevant help on

How to use SQLite (sqlite3) more efficiently

2014-06-06 Thread R Johnson
> The subject line isn't as important as a header, carried invisibly > through, that says that you were replying to an existing post. :) Sorry for my ignorance, but I've never edited email headers before and didn't find any relevant help on Google. Could you please give some more details about

Re: How to use SQLite (sqlite3) more efficiently

2014-06-06 Thread Steve Hayes
On Thu, 5 Jun 2014 17:17:19 -0500 (CDT), Dave Angel wrote: >R Johnson Wrote in message: > >> >> I've attached some new sample code in which I've attempted to correct >> various things that you mentioned. > >Attachments don't work well for many people using this list. I > for one can't even s

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Chris Angelico
On Fri, Jun 6, 2014 at 8:57 AM, R Johnson wrote: > Sorry about that. As you can probably tell, I'm relatively new to using > mailing lists. I'm not exactly sure why that occurred like it did. I'll try > adding "Re:" in front of the subject when I send this e-mail, and see if it > works right this

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread R Johnson
Sorry for the attachment issue. I'm used to the wxPython-users Google group, where posters are instructed to attach code to their post instead of including it in the body of the message. I placed the latest version of my sample code below, since I made a few minor changes to it after posting it

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Chris Angelico
On Fri, Jun 6, 2014 at 6:12 AM, R Johnson wrote: > I forgot to mention that the scripts Peter pointed to used REPLACE instead > of INSERT OR REPLACE. The SQLite documentation says that REPLACE is an alias > for INSERT OR REPLACE provided for compatibility with other SQL database > engines. Is ther

How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread R Johnson
I forgot to mention that the scripts Peter pointed to used REPLACE instead of INSERT OR REPLACE. The SQLite documentation says that REPLACE is an alias for INSERT OR REPLACE provided for compatibility with other SQL database engines. Is there a preference for one or the other? I had changed my

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Chris Angelico
On Fri, Jun 6, 2014 at 3:42 AM, R Johnson wrote: > Thank you all for your replies and suggestions. > > To Chris's "two small points": > I saw that using the mailing list was recommended to several other people > who posted here using Google Groups, so I thought it might be recommended to > me as w

How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread R Johnson
Thank you all for your replies and suggestions. To Chris's "two small points": I saw that using the mailing list was recommended to several other people who posted here using Google Groups, so I thought it might be recommended to me as well sometime :). I'll try to use it from now on. My code w

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Peter Otten
ps16thypresenceisfullnessof...@gmail.com wrote: > I'm completely new to SQL, and recently started using SQLite in one of my > Python programs. I've gotten what I wanted to work, but I'm not sure if > I'm doing it in the best/most efficient way. I have attached some sample > code and would apprecia

Re: How to use SQLite (sqlite3) more efficiently

2014-06-05 Thread Chris Angelico
On Thu, Jun 5, 2014 at 1:35 PM, Demian Brecht wrote: >> > On Thu, Jun 5, 2014 at 6:27 AM, ps16thypresence wrote: >> >> > > I'm completely new to SQL, and recently started using SQLite in >> > > one of my Python programs. > > Unrelated to Python but as you're new to SQL I figured I'd ask: Do you ha

Re: How to use SQLite (sqlite3) more efficiently

2014-06-04 Thread Demian Brecht
> > On Thu, Jun 5, 2014 at 6:27 AM, ps16thypresence wrote: > > > > I'm completely new to SQL, and recently started using SQLite in > > > one of my Python programs. Unrelated to Python but as you're new to SQL I figured I'd ask: Do you have an index on the name field? If you don't, you'll incur a f

Re: How to use SQLite (sqlite3) more efficiently

2014-06-04 Thread Rustom Mody
On Thursday, June 5, 2014 2:53:21 AM UTC+5:30, Chris Angelico wrote: > On Thu, Jun 5, 2014 at 6:27 AM, ps16thypresence wrote: > > I'm completely new to SQL, and recently started using SQLite in > > one of my Python programs. : : > Happy to help out! But before I look into the code itself, two sma

Re: How to use SQLite (sqlite3) more efficiently

2014-06-04 Thread Chris Angelico
On Thu, Jun 5, 2014 at 6:27 AM, wrote: > I'm completely new to SQL, and recently started using SQLite in one of my > Python programs. I've gotten what I wanted to work, but I'm not sure if I'm > doing it in the best/most efficient way. I have attached some sample code and > would appreciate any

How to use SQLite (sqlite3) more efficiently

2014-06-04 Thread ps16thypresenceisfullnessofjoy
I'm completely new to SQL, and recently started using SQLite in one of my Python programs. I've gotten what I wanted to work, but I'm not sure if I'm doing it in the best/most efficient way. I have attached some sample code and would appreciate any (polite) comments about how the SQL (or Python)