Python 2.5 and sqlite

[timotoole]

Hi all,

On a (sun) webserver that I use, there is python 2.5.1 installed. I'd
like to use sqlite3 with this, however sqlite3 is not installed on the
webserver. If I were able to compile sqlite using a sun machine (I
normally use linux machines) and place this in my lunix home account
would I be able to use python and sqlite?

Any thoughts? I know its a bit of a stretch ...

[david.lyon]

Quoting "ti*******@gmai l.com" <ti*******@gmai l.com>:

Hi all,

On a (sun) webserver that I use, there is python 2.5.1 installed. I'd
like to use sqlite3 with this, however sqlite3 is not installed on the
webserver. If I were able to compile sqlite using a sun machine (I
normally use linux machines) and place this in my lunix home account
would I be able to use python and sqlite?

Any thoughts? I know its a bit of a stretch ...

Can you ask them if sqlite3 is installed? and if not... to install it?

You could include in your discussions "well sqlite3 is part of python"
"if it isn't, you haven't installed python properly"

Worth a try...

[Thorsten Kampe]

* ti*******@gmail .com (Mon, 10 Nov 2008 15:33:22 -0800 (PST))

On a (sun) webserver that I use, there is python 2.5.1 installed. I'd
like to use sqlite3 with this, however sqlite3 is not installed on the
webserver.

Python comes with SQLite support. It's not necessary to have SQLite
installed for that.

If I were able to compile sqlite using a sun machine (I normally use
linux machines) and place this in my lunix home account would I be
able to use python and sqlite?

Just go ahead and import sqlite3

Thorsten

[Thorsten Kampe]

* (Mon, 10 Nov 2008 18:48:28 -0500)

Quoting "ti*******@gmai l.com" <ti*******@gmai l.com>:

On a (sun) webserver that I use, there is python 2.5.1 installed. I'd
like to use sqlite3 with this, however sqlite3 is not installed on the
webserver. If I were able to compile sqlite using a sun machine (I
normally use linux machines) and place this in my lunix home account
would I be able to use python and sqlite?

Any thoughts? I know its a bit of a stretch ...

Can you ask them if sqlite3 is installed? and if not... to install it?

Why would he have to install SQLite?!

You could include in your discussions "well sqlite3 is part of python"
"if it isn't, you haven't installed python properly"

Sqlite3 is an optional part of Python. It has no dependencies on SQLite.

Thorsten

[Thorsten Kampe]

* Thorsten Kampe (Tue, 11 Nov 2008 10:45:28 +0100)

* (Mon, 10 Nov 2008 18:48:28 -0500)

Can you ask them if sqlite3 is installed? and if not... to install it?

Why would he have to install SQLite?!

You could include in your discussions "well sqlite3 is part of python"
"if it isn't, you haven't installed python properly"

Sqlite3 is an optional part of Python. It has no dependencies on SQLite.

It seems it's not that simple. On a Gentoo host the SQLite package
provided the necessary library. On a openSUSE host it was libsqlite.
From my understanding SQLite (the headers) is only needed for building
python with SQLite support (or pysqlite) from scratch.

Thorsten

[=?UTF-8?B?Ik1hcnRpbiB2LiBMw7Z3aXMi?=]

Sqlite3 is an optional part of Python. It has no dependencies on SQLite.

That's not true. To build the _sqlite3 module, you need the SQLite3
sources or binaries, in addition to the Python sources.

Regards,
Martin

[Thorsten Kampe]

* "Martin v. Löwis" (Tue, 11 Nov 2008 20:54:37 +0100)

Sqlite3 is an optional part of Python. It has no dependencies on
SQLite.

That's not true. To build the _sqlite3 module, you need the SQLite3
sources or binaries, in addition to the Python sources.

That's not what I meant: the question is, do you need SQLite /after/
you've built from source or if you install the Python binary.

Thorsten

[Guilherme Polo]

On Tue, Nov 11, 2008 at 6:04 PM, Thorsten Kampe
<th******@thors tenkampe.dewrot e:

* "Martin v. Löwis" (Tue, 11 Nov 2008 20:54:37 +0100)

Sqlite3 is an optional part of Python. It has no dependencies on
SQLite.

That's not true. To build the _sqlite3 module, you need the SQLite3
sources or binaries, in addition to the Python sources.

That's not what I meant: the question is, do you need SQLite /after/
you've built from source or if you install the Python binary.

Is that some form of tricky question ? The binary package either comes
with the sqlite lib, or in the case of linux distributions, the
package requires the installation of sqlite lib. If you try removing
the sqlite lib package (in Linux), the package manager will tell you
that python depends on it.

Thorsten
--
http://mail.python.org/mailman/listinfo/python-list

--
-- Guilherme H. Polo Goncalves

[=?UTF-8?B?Ik1hcnRpbiB2LiBMw7Z3aXMi?=]

That's not what I meant: the question is, do you need SQLite /after/

you've built from source or if you install the Python binary.

Depends on how you built SQLite on your system. If it was a static
library, you won't need it - if it is a shared library, you certainly
need the shared library at run-time.

Regards,
Martin

[Thorsten Kampe]

* "Martin v. Löwis" (Tue, 11 Nov 2008 21:40:44 +0100)

That's not what I meant: the question is, do you need SQLite /after/
you've built from source or if you install the Python binary.

Depends on how you built SQLite on your system. If it was a static
library, you won't need it - if it is a shared library, you certainly
need the shared library at run-time.

Aah, thanks. Makes sense a lot. There were quite a few people here in
the last few days who asked how to build or use Python (or pysqlite)
when SQLite is not installed (and they can't because it's not their
system). I always said that it's not necessary to have SQLite installed
for /running/ Python. Seems that I was "65%" right.

Thorsten