python 2.5 & sqlite3

[BartlebyScrivener]

Sorry, I have a knack for making things more difficult than they need
to be. I'm on Windows XP and waiting for the ActiveState release of
Python 2.5. I want to experiment with sqlite and I see that Python 2.5
has the "wrapper" but sqlite itself must be downloaded separately.

I see no installation instructions on the sqlite.org site for Windows
XP. I have downloaded sqlite3.exe, sqlite3.dll, and sqlite3.def. Must I
put them in a certain location, or will any folder do as long as it is
in path?

Anybody know if the ActiveState distribution will have sqlite itself
included?

As always, thank you for the generous help.

rd

 

[Fredrik Lundh]

> Sorry, I have a knack for making things more difficult than they need
to be. I'm on Windows XP and waiting for the ActiveState release of
Python 2.5. I want to experiment with sqlite and I see that Python 2.5
has the "wrapper" but sqlite itself must be downloaded separately.

why not just grab the *official* 2.5 release from python.org instead of
wasting time on broken distributions?

</F>

 

[BartlebyScrivener]

wasting time on broken distributions?

It's not broken. I like Pythonwin better than IDLE. Either way I need
to know where to put the sqlite files, right?

rd

 

[Fredrik Lundh]

It's not broken.

of course it's broken; the official release ships with properly built
and properly tested versions of the stuff you're struggling to install.

> I like Pythonwin better than IDLE.

last time I checked, the PythonWin IDE was part of the win32all kit,
available from:

https://sourceforge.net/project/showfiles.php?group_id=78018&package_id=79063

> Either way I need to know where to put the sqlite files, right?

not if you're using a proper release, no.

</F>

 

[Gabriel Genellina]

It's not broken. I like Pythonwin better than IDLE. Either way I need
to know where to put the sqlite files, right?

You can download Pythonwin (and the whole win32all packages) from
http://sourceforge.net/projects/pywin32/



--
Gabriel Genellina
Softlab SRL





__________________________________________________
Preguntá. Respondé. Descubrí.
Todo lo que querías saber, y lo que ni imaginabas,
está en Yahoo! Respuestas (Beta).
¡Probalo ya!
http://www.yahoo.com.ar/respuestas

 

[Fredrik Lundh]

not if you're using a proper release, no.

the easiest way to unbreak your ActiveState installation is probably to
install the python.org version, and copy

c:\Python25\DLLs\_sqlite3.pyd

and

c:\Python25\DLLs\sqlite3.dll

to the corresponding location in the other installation.

</F>

 

[John Machin]

of course it's broken; the official release ships with properly built
and properly tested versions of the stuff you're struggling to install.


last time I checked, the PythonWin IDE was part of the win32all kit,
available from:

https://sourceforge.net/project/showfiles.php?group_id=78018&package_id=79063


not if you're using a proper release, no.

</F>

OK, I'll bite; I can't understand what this thread is all about.

The Activestate Python 2.5 distribution is not yet available.

(1) Why is the effbot saying that a not-yet available distribution is
broken?

(2) The OP says he has downloaded sqlite*.* from the sqlite.org website
.... without saying why he thought he needed to nor which Windows Python
he is planning to run it with:
(a) Activestate 2.5 -- not-yet-available
(b) python.org 2.5-- *includes* the sqlite3 stuff; Pythonwin is as the
effbot said in effect only a download and a double-click away ...
(c) <any_brand> 2.4 -- needs pysqlite etc

What am I missing?
Oh, possibly
"""
I see that Python 2.5 has the "wrapper" but sqlite itself must be
downloaded separately.
"""
Looks like it could be from reading some build-Python-from-source
instructions for Unix platforms ...

Bewilderedly yours.
John

 

[BartlebyScrivener]

Looks like it could be from reading some
Yes, Sorry. I read the doc too hastily.

I'm playing with sqlite now, and awaiting the yet-to-be-issued 2.5
distro from ActiveState.

My apologies. Thank you, again.

rd

 

[Fredrik Lundh]

The Activestate Python 2.5 distribution is not yet available.

(1) Why is the effbot saying that a not-yet available distribution is
broken?

because I misread the "waiting for" in the first paragraph; Python 2.5
has been out for some while, and the OP's post didn't appear to make any
sense if he wasn't using a 2.5 build, and had found that he had a
wrapper but no driver DLL. Occam's razor.

but given that he wasn't using a 2.5 install, his post makes even less
sense. I guess I need to get myself a new razor.

I still think the "get the official build (and add win32all if you're
doing native windows stuff)" advice is sound, though.

</F>

 

[John Salerno]

I still think the "get the official build (and add win32all if you're
doing native windows stuff)" advice is sound, though.

Agreed. It seems silly to use anything other than the official release.

But anyway, I think the OP was confused about having to install the
sqlite libraries manually, because I believe you have to do this on
Linux distros, but a Windows binary of Python already includes all you
need to work with sqlite3.

Now, if the ActiveState distro *doesn't* include the libraries, then I
would probably call it broken too.

 

[Fredrik Lundh]

Now, if the ActiveState distro *doesn't* include the libraries, then I
would probably call it broken too.

if it doesn't, it wouldn't be the first time they'd (by accident or on
purpose) left things out. trust me, it'd cause a lot less confusion if
ActivePython was a true superset of the python.org distribution.

</F>

 

[Trent Mick]

if it doesn't, it wouldn't be the first time they'd (by accident or on

purpose) left things out.

Other than SSL, do you have examples?

> trust me, it'd cause a lot less confusion if
ActivePython was a true superset of the python.org distribution.

For every extension except SSL support (*) it is.

(*) Still working on export-control legals for that. I was hoping to
have that ready for ActivePython 2.5. But that doesn't look like it will
happen on time. And now I've missed getting ActivePython 2.5 out soon
after Python 2.5 because I'm focussed on Komodo 4.0 for now.

For others, unfortunately ActivePython 2.5 will probably not be ready
until mid-November.

Trent

 

[Steve Holden]

Other than SSL, do you have examples?




For every extension except SSL support (*) it is.

(*) Still working on export-control legals for that. I was hoping to
have that ready for ActivePython 2.5. But that doesn't look like it will
happen on time. And now I've missed getting ActivePython 2.5 out soon
after Python 2.5 because I'm focussed on Komodo 4.0 for now.

For others, unfortunately ActivePython 2.5 will probably not be ready
until mid-November.

You guys need to hurry up and get that Komodo hire made ...

regards
Steve