How to build the pysqlite? Where to find the "sqlite3.h" ?

[Kurda Yon]

Hi,

I try to "build" and "install" pysqlite? After I type "python setup.py
build" I get a lot of error messages? The first error is "src/
connection.h:33 :21: error: sqlite3.h: No such file or directory". So,
I assume that the absence of the "sqlite3.h" is the origin of the
problem.

I found on the web, that this file should be either in "/usr/local/
include" or in "/usr/local/lib". I check this directories and I really
do not have the "sqlite3.h" there.

Thinks becomes even more complicated since I have no permissions to
write to the 2 above mentioned directories? So, do I have any chance
to install the pysqlite? If yes, what should I do?

Should I find the file on the web and put in in some of my directories
and then to change the path in the "setup.cfg" ?

Thank you for any help.

[Thorsten Kampe]

* Shawn Milochik (Wed, 5 Nov 2008 12:28:46 -0500)

Thanks, but either I'm missing something or you're missing
something. I can't do any of what you describe on the machine I
want to use sqlite on.

I have downloaded the binary sqlite3 file from sqlite's Web site,
and

The linux binary will not work. You need the headers and the
libraries. Grab the src tar ball and build and install locally.

That is not correct. The binary *does* work, as I said last time.

For the third time, it is not possible for me to build from source on
that box.

Sure you can. There are never permission problems for compiling - only
for installing.

And in any case, you keep talking about sqlite3, but I'm talking about
pysqlite2.

You (and Kurda) keep on talking the wrong stuff. First: you don't need
pysqlite2. SQLite support is included in the latest Python as module
sqlite3.

If for whatever reason you need the latest SQLite module for Python
(2.5.0), you can simply grab an rpm or build it from source and install
it to your home directory. To build pysqlite you need the SQLite
headers. If you can't install those to default path then simply grab the
headers, put them somewhere into your home directory and tell the
pysqlite build process where to find them.

Thorsten

[Shawn Milochik]

On Wed, Nov 5, 2008 at 1:55 PM, Thorsten Kampe
<th******@thors tenkampe.dewrot e:

* Shawn Milochik (Wed, 5 Nov 2008 12:28:46 -0500)

>Thanks, but either I'm missing something or you're missing
something. I can't do any of what you describe on the machine I
want to use sqlite on.

I have downloaded the binary sqlite3 file from sqlite's Web site,
and

The linux binary will not work. You need the headers and the
libraries. Grab the src tar ball and build and install locally.

That is not correct. The binary *does* work, as I said last time.

For the third time, it is not possible for me to build from source on
that box.

Sure you can. There are never permission problems for compiling - only
for installing.

>And in any case, you keep talking about sqlite3, but I'm talking about
pysqlite2.

You (and Kurda) keep on talking the wrong stuff. First: you don't need
pysqlite2. SQLite support is included in the latest Python as module
sqlite3.

If for whatever reason you need the latest SQLite module for Python
(2.5.0), you can simply grab an rpm or build it from source and install
it to your home directory. To build pysqlite you need the SQLite
headers. If you can't install those to default path then simply grab the
headers, put them somewhere into your home directory and tell the
pysqlite build process where to find them.

Thorsten

Okay, sorry if I haven't been specific enough. I don't know about the
original poster, but on the box I'm using, I don't have the latest
Python, the "make" command breaks because the system doesn't have the
proper libraries, and there is no sqlite3 module. I am not authorized
to fix any of that, and our support team isn't interested in helping
me because it's a Perl shop, not Python.

I'm not demanding that anyone solve my problem. I'm just asking if
there are files I can download and without compiling or building them
in any way, put them somewhere, point Python to that path, and be able
to use sqlite from Python. If the answer is no, it's no. I'm not
repeating myself because I enjoy it. For some reason everyone who has
answered me has ignored the basic question of whether this is possible
or not, so I have felt the need to reply and say so.

Thanks,
Shawn

[Kurda Yon]

On Nov 5, 1:55*pm, Thorsten Kampe <thors...@thors tenkampe.dewrot e:

>
You (and Kurda) keep on talking the wrong stuff. First: you don't need
pysqlite2. SQLite support is included in the latest Python as module
sqlite3.

By the way, I think the above statement is very helpfull. I tried to
install the "pysqlite" to be able to communicate with the "sqlite",
and then I have realized that for that I need first to install the
"sqlite"...

But I read your statement and understood that I do not need to install
neither "pysqlite" no "sqlite". In my Python session I tried to type
"from sqlite import connect" and it does not compaline. It meand that
Python see the database!!! I hope.

By the where can I find a simle tutorial about the work with the
"sqlite" from the Python?

[Thorsten Kampe]

* Kurda Yon (Wed, 5 Nov 2008 17:52:08 -0800 (PST))

On Nov 5, 1:55Â*pm, Thorsten Kampe <thors...@thors tenkampe.dewrot e:

You (and Kurda) keep on talking the wrong stuff. First: you don't
need pysqlite2. SQLite support is included in the latest Python as
module sqlite3.

By the way, I think the above statement is very helpfull. I tried to
install the "pysqlite" to be able to communicate with the "sqlite",
and then I have realized that for that I need first to install the
"sqlite"...

But I read your statement and understood that I do not need to install
neither "pysqlite" no "sqlite". In my Python session I tried to type
"from sqlite import connect" and it does not compaline. It meand that
Python see the database!!! I hope.

I don't think so. There is no "sqlite" module in Python so the above
line should give you an error. The module is called sqlite3.

By the where can I find a simle tutorial about the work with the
"sqlite" from the Python?

Guess where: in the Python documentation and on the pysqlite web site:
http://docs.python.org/library/sqlite3.html
http://oss.itsystementwicklung.de/do...c/sqlite3.html

Thorsten

[Thorsten Kampe]

* Shawn Milochik (Wed, 5 Nov 2008 14:32:15 -0500)

On Wed, Nov 5, 2008 at 1:55 PM, Thorsten Kampe

You (and Kurda) keep on talking the wrong stuff. First: you don't
need pysqlite2. SQLite support is included in the latest Python as
module sqlite3.

If for whatever reason you need the latest SQLite module for Python
(2.5.0), you can simply grab an rpm or build it from source and
install it to your home directory. To build pysqlite you need the
SQLite headers. If you can't install those to default path then
simply grab the headers, put them somewhere into your home directory
and tell the pysqlite build process where to find them.

Okay, sorry if I haven't been specific enough. I don't know about the
original poster, but on the box I'm using, I don't have the latest
Python, the "make" command breaks because the system doesn't have the
proper libraries, and there is no sqlite3 module. I am not authorized
to fix any of that, and our support team isn't interested in helping
me because it's a Perl shop, not Python.

I'm not demanding that anyone solve my problem. I'm just asking if
there are files I can download and without compiling or building them
in any way, put them somewhere, point Python to that path, and be able
to use sqlite from Python.

I more or less answered that already: you can grab a rpm for the same
Python version as you already have, unpack it and put the sqlite3
support files somewhere into your home directory (~/bin/python/site-
packages for example). If your Python is older than 2.5 then you have to
download the pysqlite rpms for your distribution and do the same as
above. To have Python find the modules you have to set the PYTHONPATH
environment variable. See the man page.

If your distribution doesn't provide RPMs for pysqlite then you have to
build it yourself. You have to grab the SQLite headers (they are in the
SQLite RPM probably), unpack them somewhere into your home directory and
tell the pysqlite build process where to find them. I don't exactly know
how but this is probably very easy to find out.

Thorsten

[Kurda Yon]

>

But I read your statement and understood that I do not need to install
neither "pysqlite" no "sqlite". In my Python session I tried to type
"from sqlite import connect" and it does not compaline. It meand that
Python see the database!!! I hope.

I don't think so. There is no "sqlite" module in Python so the above
line should give you an error. The module is called sqlite3.

Well, but the "above line" does not give me an error. I get an error
if I replace "sqlite" by "sqlite3". But anyway, now everything works
fine.

Thnak you everybody for the help.