473,320 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

python 2.5 & sqlite3

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
12 7864
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
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
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
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
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
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
> 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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Harold Shore | last post by:
From the release notes I read that "If you're compiling the Python source yourself, note that the source tree doesn't include the SQLite code, only the wrapper module. You'll need to have the...
16
by: bobrik | last post by:
Hello, I am using the Python DB API for access to MySQL. But it is not platform-independent - I need a module not included in Python by default - python-mysql, and it uses a compiled binary...
4
by: Simon | last post by:
I installed the source code on unix for python 2.5.1. The install went mainly okay, except for some failures regarding: _ssl, _hashlib, _curses, _curses_panel. No errors regarding sqlite3....
0
by: Kurt B. Kaiser | last post by:
Patch / Bug Summary ___________________ Patches : 385 open (+21) / 3790 closed (+21) / 4175 total (+42) Bugs : 1029 open (+43) / 6744 closed (+43) / 7773 total (+86) RFE : 262 open...
3
by: milan_sanremo | last post by:
I have sqlite installed, but when I try to import sqlite3 I receive: Python 2.5.1 (r251:54863, Nov 3 2007, 02:54:36) on sunos5 Type "help", "copyright", "credits" or "license" for more...
0
by: Guilherme Polo | last post by:
On Tue, Jul 1, 2008 at 9:51 PM, Joe Goldthwaite <joe@goldthwaites.comwrote: You need sqlite itself (www.sqlite.org) and bindings, pysqlite 2 (http://oss.itsystementwicklung.de/trac/pysqlite/) or...
0
by: Joe Goldthwaite | last post by:
Thanks Guilherme. That helped. I guess I was thinking that pysqlite would automatically come with some version of sqlite. The fact that it doesn't is what was causing me to get the strange...
20
by: timotoole | last post by:
Hi all, On a (sun) webserver that I use, there is python 2.5.1 installed. I'd like to use sqlite3 with this, however sqlite3 is not installed on the webserver. If I were able to compile sqlite...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.