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

[david.lyon at preisshare.net]

Hi Kurda,

I have been through this problem. Somebody needs to write a FAQ.

Took me a few days to pinpoint the problem.

Don't know which platform but I assume Linux...

Python depends upon Sqlite... which is weird... but it is what I discovered...

When Python is being built.. it checks for sqlite3.h.. in it's  
'configure' script. If it is not there it doesn't provide any support  
for it.

Other databases go 'ontop' of the language... so once you install your  
compiler/interpretor, you install your database. That is my experience.

Anyway, it is the other way around with sqlite. Install sqlite.. then  
build python... then it will all work.....

The trick is having sqlite installed before the 'make configure' step  
in the install process.

If you have sophisticated packaging system in your linux... then use that...

Regards

David

Quoting Kurda Yon <kurdayon at yahoo.com>:

> On Nov 4, 8:59 pm, "saju.pil... at gmail.com" <saju.pil... at gmail.com>
> wrote:
>> On Nov 5, 6:47 am, Kurda Yon <kurda... at yahoo.com> wrote:
>>
>> > 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.
>>
>> You can try downloading sqlite3 from the web and installing it in a
>> local dir. Update pysqlite setup.cfg to add these local dir names and
>> then try building it.
>>
>> -srp
>>
>
> I see the problem. The pysqlite is a package which allows a
> communication between the python and sqlite. I try to install the
> "pysqlite" but I do not have the "sqlite" on my computer. So, I have
> the problem. I tried to find out how to install the sqlite3 but it
> seems there are no simple and clear explanations of how to do it. So,
> I think I will give up and search for an easier way. Tank you for your
> help.
>
>> > 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.
>
> --
> http://mail.python.org/mailman/listinfo/python-list
>