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]

Re: python 2.5 & sqlite3

BartlebyScriven er wrote:

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]

Re: python 2.5 &amp; sqlite3

Fredrik Lundh wrote:

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]

Re: python 2.5 &amp; sqlite3

BartlebyScriven er wrote:

Fredrik Lundh wrote:
>

>wasting time on broken distributions?

>
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/show...ckage_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]

Re: python 2.5 &amp; sqlite3

At Wednesday 11/10/2006 18:45, BartlebyScriven er wrote:

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?

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]

Re: python 2.5 &amp; sqlite3

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

>
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\DLL s\_sqlite3.pyd

and

c:\Python25\DLL s\sqlite3.dll

to the corresponding location in the other installation.

</F>

[John Machin]

Re: python 2.5 &amp; sqlite3

Fredrik Lundh wrote:

BartlebyScriven er wrote:

Fredrik Lundh wrote:

wasting time on broken distributions?

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/show...ckage_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>

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_brand2.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]

Re: python 2.5 &amp; sqlite3

> Looks like it could be from reading some

> build-Python-from-source instructions for Unix platforms ...

Yes, Sorry. I read the doc too hastily.

>If you're compiling the Python source yourself,
> note that the source tree doesn't include the SQLite code,
>only the wrapper module.

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]

Re: python 2.5 &amp; sqlite3

John Machin wrote:

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]

Re: python 2.5 &amp; sqlite3

Fredrik Lundh wrote:

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]

Re: python 2.5 &amp; sqlite3

John Salerno wrote:

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]

Re: python 2.5 &amp; sqlite3

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

--
Trent Mick
trentm@activest ate.com

[Steve Holden]

Re: python 2.5 &amp; sqlite3

Trent Mick wrote:

>>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

>

>>ActivePytho n 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.
>

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

regards
Steve
--
Steve Holden +44 150 684 7255 +1 800 494 3119
Holden Web LLC/Ltd http://www.holdenweb.com
Skype: holdenweb http://holdenweb.blogspot.com
Recent Ramblings http://del.icio.us/steve.holden