By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,995 Members | 1,217 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,995 IT Pros & Developers. It's quick & easy.

python 2.5 & sqlite3

P: n/a
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

Oct 11 '06 #1
Share this Question
Share on Google+
12 Replies


P: n/a
BartlebyScrivener 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>

Oct 11 '06 #2

P: n/a
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

Oct 11 '06 #3

P: n/a
BartlebyScrivener 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>

Oct 11 '06 #4

P: n/a
At Wednesday 11/10/2006 18:45, BartlebyScrivener 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

Oct 11 '06 #5

P: n/a
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\DLLs\_sqlite3.pyd

and

c:\Python25\DLLs\sqlite3.dll

to the corresponding location in the other installation.

</F>

Oct 11 '06 #6

P: n/a
Fredrik Lundh wrote:
BartlebyScrivener 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

Oct 12 '06 #7

P: n/a
> 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

Oct 12 '06 #8

P: n/a
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>

Oct 12 '06 #9

P: n/a
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. :)
Oct 12 '06 #10

P: n/a
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>

Oct 12 '06 #11

P: n/a
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
tr****@activestate.com
Oct 12 '06 #12

P: n/a
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
>>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.
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

Oct 13 '06 #13

This discussion thread is closed

Replies have been disabled for this discussion.