Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 82511 - dev-python/pysqlite needs version bump / slot: 1.0 (sqlite 2.x) -> 1.1 (sqlite 3.x)
Summary: dev-python/pysqlite needs version bump / slot: 1.0 (sqlite 2.x) -> 1.1 (sqlit...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High enhancement
Assignee: Python Gentoo Team
URL: http://sourceforge.net/projects/pysql...
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-02-18 17:05 UTC by Stefan Briesenick (RETIRED)
Modified: 2006-08-22 15:30 UTC (History)
6 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Briesenick (RETIRED) gentoo-dev 2005-02-18 17:05:42 UTC
pysqlite 1.0 is for sqlite 2.x
pysqlite 1.1 is for sqlite 3.x

so we need a slot for it. 

Reproducible: Always
Steps to Reproduce:
Comment 1 Rob Cakebread (RETIRED) gentoo-dev 2005-02-22 11:58:38 UTC
Quick note here to the python herd:
sqlite3 and sqlite2 databases are completely incompatible, yet they've kept the module name 'pysqlite' for both versions. I think we should hold off adding pysqlite-1.1 and see if they change the module name to pysqlite2 when the final release comes out so we can slot them and not have to change every existing app using pysqlite1 to avoid incompatible databases in existing apps.
Comment 2 Stefan Briesenick (RETIRED) gentoo-dev 2005-02-22 13:26:48 UTC
pysqlite3-x.y.z would make much more sense. If you name it pysqlite2, then everybody would think it's for sqlite2, instead of sqlite3.

Nonetheless, sqlite2 should be faded out ASAP by all projects IMHO. But this lays not in our hands.
Comment 3 Rob Cakebread (RETIRED) gentoo-dev 2005-02-22 15:16:24 UTC
The author originally wanted to leave the module named "pysqlite" for all versions and force people to convert their databases, but it looks they changed their minds and newer versions will be named appropriately, which is good news for us:

http://sourceforge.net/mailarchive/forum.php?thread_id=6021987&forum_id=9559

So, slotting will be good, but not till the next version comes out with the new name change.

Comment 4 Anders Rune Jensen (RETIRED) gentoo-dev 2005-04-24 03:47:09 UTC
Stefan: sqlite3 has had a _lot_ of data corruption bugs so I don't think people should abandon sqlite2 just yet.

Anyway on to the subject. I think pysqlite 1.1 should be added to portage for people who wants/have to work with sqlite3. pysqlite2 is still alpha.
Comment 5 Wojciech "radious" Wojtyniak 2005-04-29 13:31:05 UTC
It's good think to create a new slot for pysqlite1.1. e.g. I had to write ebuild for it and thought that developer forgot about his work. Have both versions and compare them is necessary.
Comment 6 Julien Allanos (RETIRED) gentoo-dev 2005-06-22 07:47:56 UTC
Can pysqlite-1.1 be bumped please? sqlite-3.2.1 is marked stable, but there is
no stable python bindings for it. pysqlite-2* can't be marked stable, as it has
a new API and is still considered as alpha. That's what we need pysqlite-1.1 for
the moment, to make the switch to sqlite-3 possible. As an exemple, pysqlite-2*
is incompatible with Trac (see
http://projects.edgewall.com/trac/wiki/TracInstall), so Trac users are required
to use sqlite-2.8 and can't switch their databases to sqlite-3. Maybe
pysqlite-2* ebuilds should even be hard masked?
Comment 7 Julien Allanos (RETIRED) gentoo-dev 2005-09-07 07:07:01 UTC
Actually, I'm interested in seeing pysqlite-2.x stable before starting trac-0.9
ebuilds releases (which will support sqlite-3/pysqlite-2). Apparently
pysqlite-1.1 has some API problems.
Comment 8 Alastair Tse (RETIRED) gentoo-dev 2005-11-05 07:16:41 UTC
so what is the status of this? i know that we have slotted versions of pysqlite-2.x.x to correspond to 
sqlite-3.2.x. i suppose we need to go through all the packages taht depends on pysqlite and make sure 
they either have the deps set as <dev-python/pysqlite-2 or >=dev-python/pysqlite-2
Comment 9 Julien Allanos (RETIRED) gentoo-dev 2005-11-06 08:09:10 UTC
Current slots are OK for me. It would be great if pysqlite-2 would be marked  
as stable some day.  
  
Correcting ebuilds of packages that depend on pysqlite would be nice.  
Actually, the dependency should be either <dev-python/pysqlite-1.1 or       
>=dev-python/pysqlite-2. The following ebuilds should be corrected:      
     
dev-python/sqlobject (have <dev-python/pysqlite-2.0)     
media-sound/bossogg (have dev-python/pysqlite)     
net-irc/supybot (some have >=dev-python/pysqlite-0.4.3    
 
Comment 10 Alastair Tse (RETIRED) gentoo-dev 2006-08-22 03:07:40 UTC
Christian, net-print/pykota is the last remaining package that needs to have the pysqlite dependency specified for either pysqlite-2 or <pysqlite-2. Can you please check that?
Comment 11 Christian Andreetta (RETIRED) gentoo-dev 2006-08-22 13:05:14 UTC
I'm afraid I'll have to pass the pykota test to Patrick: I lack my dev box at now :-(
Comment 12 Patrick McLean gentoo-dev 2006-08-22 14:29:04 UTC
Ok, updated pykota to dep on =dev-python/pysqlite-2*
Comment 13 Alastair Tse (RETIRED) gentoo-dev 2006-08-22 15:30:44 UTC
thanks for the quick response. i believe this solves the pysqlite slotting issues  now. closing this bug.