Re: couple more questions about sqlite

2006-08-25 Thread Preston Hagar
It looks like most of your questions have been answered, but I might also suggest the APress book on SQLite: http://www.amazon.com/gp/product/1590596730/sr=8-2/qid=1142277203/ref=pd_bbs_2/002-3764084-7189633?%5Fencoding=UTF8***MAJOR DISCLAIMER: I was the technical reviewer on this book.***The book

Re: couple more questions about sqlite

2006-08-19 Thread John Salerno
Joel Rosdahl wrote: > John Salerno <[EMAIL PROTECTED]> writes: > >> What is really confusing is that I did a search for 'sqlite' in my >> Ubuntu repositories and it came up with entries like this: >> >> python2.4-pysqlite1.1 python interface to SQLite 3 >> python2.4-pysqlite2 python interfac

Re: couple more questions about sqlite

2006-08-19 Thread Joel Rosdahl
John Salerno <[EMAIL PROTECTED]> writes: > What is really confusing is that I did a search for 'sqlite' in my > Ubuntu repositories and it came up with entries like this: > > python2.4-pysqlite1.1 python interface to SQLite 3 > python2.4-pysqlite2 python interface to SQLite 3 > python2.4-pys

Re: couple more questions about sqlite

2006-08-19 Thread John Machin
Dennis Lee Bieber wrote: > > The only reason, then, to download the stand-alone SQLite package > (not the python package) would be to obtain the command line query/admin > tool. Pre-compiles binaries of the tool are available for Linux and Windows. http://www.sqlite.org/download.html

Re: couple more questions about sqlite

2006-08-19 Thread John Machin
Robert Kern wrote: > John Machin wrote: > > John Salerno wrote: > >> John Machin wrote: > >> > >>> Your confusion is quite understandable. I started looking at sqlite > >>> when the announcement that it would be included in Python 2.5 came out. > >>> Puzzlement reigned. I ended up with the followi

Re: couple more questions about sqlite

2006-08-18 Thread John Salerno
Dennis Lee Bieber wrote: > SQLite, in whatever incarnation, is a "file server" database. There > is no separate database server running -- each application is linked > directly to the code that opens and processes the database file(s). > > If SQLite is supplied with the impending Pyth

Re: couple more questions about sqlite

2006-08-18 Thread Robert Kern
John Machin wrote: > John Salerno wrote: >> John Machin wrote: >> >>> Your confusion is quite understandable. I started looking at sqlite >>> when the announcement that it would be included in Python 2.5 came out. >>> Puzzlement reigned. I ended up with the following up the front of my >>> experime

Re: couple more questions about sqlite

2006-08-18 Thread John Machin
John Salerno wrote: > John Machin wrote: > > > Your confusion is quite understandable. I started looking at sqlite > > when the announcement that it would be included in Python 2.5 came out. > > Puzzlement reigned. I ended up with the following up the front of my > > experimental module: > > So do

Re: couple more questions about sqlite

2006-08-18 Thread John Salerno
John Machin wrote: > Your confusion is quite understandable. I started looking at sqlite > when the announcement that it would be included in Python 2.5 came out. > Puzzlement reigned. I ended up with the following up the front of my > experimental module: So does this mean that when 2.5 is relea

Re: couple more questions about sqlite

2006-08-18 Thread Paul McGuire
"John Machin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I would strongly recommend for a learner of SQL and the Python DBAPI: > (1) start with sqlite; it's great, and there's minimal admin involved > (2) download the command-line utility from the sqlite website -- you'll > need

Re: couple more questions about sqlite

2006-08-18 Thread John Machin
John Salerno wrote: > [EMAIL PROTECTED] wrote: > >> 2. What's the difference between sqlite and pysqlite? Do you need both, > >> just one, or is one an older version of the same thing? > > > > To access your database from python you need both (or some alternative > > to pysqlite) > > I can understa

Re: couple more questions about sqlite

2006-08-18 Thread John Salerno
[EMAIL PROTECTED] wrote: >> 2. What's the difference between sqlite and pysqlite? Do you need both, >> just one, or is one an older version of the same thing? > > To access your database from python you need both (or some alternative > to pysqlite) I can understand this in terms of MySQL being on

Re: couple more questions about sqlite

2006-08-18 Thread andychambers2002
> 2. What's the difference between sqlite and pysqlite? Do you need both, > just one, or is one an older version of the same thing? To access your database from python you need both (or some alternative to pysqlite) > 3. What's the difference between the command line program called sqlite3 > and