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

couple more questions about sqlite

2006-08-18 Thread John Salerno
I've been looking around and reading, and I have a few more questions about SQLite in particular, as it relates to Python. 1. What is the current module to use for sqlite? sqlite3? or is that not out until Python 2.5? 2. What's the difference between sqlite and pysqlite? Do you need both, just