* [gentoo-dev] meaning of sqlite/sqlite3 use flag
@ 2007-09-14 17:18 Hanno Böck
2007-09-14 22:46 ` Petteri Räty
` (2 more replies)
0 siblings, 3 replies; 13+ messages in thread
From: Hanno Böck @ 2007-09-14 17:18 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 799 bytes --]
Hi,
I noticed that the sqlite/sqlite3-useflags have no consistent meaning in the
tree.
E.g.
- apr-util uses sqlite for sqlite-2.x support and sqlite3 for sqlite-3.x
support
- eix uses sqlite for sqlite-3.x support
Just the first examples I found, you can find countless for both of them in
the tree.
We should imho decide if
a) sqlite means sqlite-2.x and sqlite3 means sqlite-3.x.
b) sqlite means enable sqlite-support always and sqlite+sqlite3 means if both
are available use sqlite-3.x instead of 2.x.
I don't care which one (or a completely different one), but I think it should
be made clear. At least I think the current behaviour in the tree doesn't
really make sense.
--
Hanno Böck Blog: http://www.hboeck.de/
GPG: 3DBD3B20 Jabber: hanno@hboeck.de
[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 189 bytes --]
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 17:18 [gentoo-dev] meaning of sqlite/sqlite3 use flag Hanno Böck
@ 2007-09-14 22:46 ` Petteri Räty
2007-09-14 22:51 ` Jan Kundrát
2007-09-14 23:23 ` Jan Kundrát
2007-09-14 23:52 ` Mike Frysinger
2007-09-15 7:11 ` Samuli Suominen
2 siblings, 2 replies; 13+ messages in thread
From: Petteri Räty @ 2007-09-14 22:46 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 856 bytes --]
Hanno Böck kirjoitti:
> Hi,
>
> I noticed that the sqlite/sqlite3-useflags have no consistent meaning in the
> tree.
>
> E.g.
> - apr-util uses sqlite for sqlite-2.x support and sqlite3 for sqlite-3.x
> support
> - eix uses sqlite for sqlite-3.x support
> Just the first examples I found, you can find countless for both of them in
> the tree.
>
> We should imho decide if
> a) sqlite means sqlite-2.x and sqlite3 means sqlite-3.x.
> b) sqlite means enable sqlite-support always and sqlite+sqlite3 means if both
> are available use sqlite-3.x instead of 2.x.
>
> I don't care which one (or a completely different one), but I think it should
> be made clear. At least I think the current behaviour in the tree doesn't
> really make sense.
>
>
We should remove 2.x from tree and use just sqlite.
Regards,
Petteri
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 252 bytes --]
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 22:46 ` Petteri Räty
@ 2007-09-14 22:51 ` Jan Kundrát
2007-09-14 23:05 ` Petteri Räty
2007-09-14 23:23 ` Jan Kundrát
1 sibling, 1 reply; 13+ messages in thread
From: Jan Kundrát @ 2007-09-14 22:51 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 174 bytes --]
Petteri Räty wrote:
> We should remove 2.x from tree and use just sqlite.
Qt3 supports only sqlite2.
Cheers,
-jkt
--
cd /local/pub && more beer > /dev/mouth
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 252 bytes --]
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 22:51 ` Jan Kundrát
@ 2007-09-14 23:05 ` Petteri Räty
2007-09-14 23:12 ` Caleb Tennis
2007-09-14 23:20 ` Jan Kundrát
0 siblings, 2 replies; 13+ messages in thread
From: Petteri Räty @ 2007-09-14 23:05 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 238 bytes --]
Jan Kundrát kirjoitti:
> Petteri Räty wrote:
>> We should remove 2.x from tree and use just sqlite.
>
> Qt3 supports only sqlite2.
>
> Cheers,
> -jkt
>
Does anything need the sqlite2 support in QT?
Regards,
Petteri
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 252 bytes --]
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 23:05 ` Petteri Räty
@ 2007-09-14 23:12 ` Caleb Tennis
2007-09-18 15:08 ` Doug Goldstein
2007-09-14 23:20 ` Jan Kundrát
1 sibling, 1 reply; 13+ messages in thread
From: Caleb Tennis @ 2007-09-14 23:12 UTC (permalink / raw
To: gentoo-dev
> Does anything need the sqlite2 support in QT?
Not explicitly. Qt can also build against an internal version of sqlite2, so it
shouldn't be too big of a problem to remove this particular dep (but that doesn't
get rid of the flag issue, I suppose).
Caleb
--
gentoo-dev@gentoo.org mailing list
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 23:05 ` Petteri Räty
2007-09-14 23:12 ` Caleb Tennis
@ 2007-09-14 23:20 ` Jan Kundrát
1 sibling, 0 replies; 13+ messages in thread
From: Jan Kundrát @ 2007-09-14 23:20 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 258 bytes --]
Petteri Räty wrote:
> Does anything need the sqlite2 support in QT?
Anything that uses Qt for database access (and chooses sqlite as the
backend). media-gfx/kphotoalbum is an example.
Cheers,
-jkt
--
cd /local/pub && more beer > /dev/mouth
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 252 bytes --]
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 22:46 ` Petteri Räty
2007-09-14 22:51 ` Jan Kundrát
@ 2007-09-14 23:23 ` Jan Kundrát
1 sibling, 0 replies; 13+ messages in thread
From: Jan Kundrát @ 2007-09-14 23:23 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 289 bytes --]
Petteri Räty wrote:
> We should remove 2.x from tree and use just sqlite.
Oh, and another reason is compatibility -- sqlite2 and sqlite3 use
different on-disk format. sqlite3 can't read sqlite2 data and vice versa.
Cheers,
-jkt
--
cd /local/pub && more beer > /dev/mouth
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 252 bytes --]
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 17:18 [gentoo-dev] meaning of sqlite/sqlite3 use flag Hanno Böck
2007-09-14 22:46 ` Petteri Räty
@ 2007-09-14 23:52 ` Mike Frysinger
2007-09-18 15:25 ` Doug Goldstein
2007-09-24 19:25 ` Alin Năstac
2007-09-15 7:11 ` Samuli Suominen
2 siblings, 2 replies; 13+ messages in thread
From: Mike Frysinger @ 2007-09-14 23:52 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 961 bytes --]
On Friday 14 September 2007, Hanno Böck wrote:
> I noticed that the sqlite/sqlite3-useflags have no consistent meaning in
> the tree.
>
> E.g.
> - apr-util uses sqlite for sqlite-2.x support and sqlite3 for sqlite-3.x
> support
> - eix uses sqlite for sqlite-3.x support
> Just the first examples I found, you can find countless for both of them in
> the tree.
>
> We should imho decide if
> a) sqlite means sqlite-2.x and sqlite3 means sqlite-3.x.
> b) sqlite means enable sqlite-support always and sqlite+sqlite3 means if
> both are available use sqlite-3.x instead of 2.x.
>
> I don't care which one (or a completely different one), but I think it
> should be made clear. At least I think the current behaviour in the tree
> doesn't really make sense.
how about 'sqlite' means you want sqlite irregardless of version ... then
sqlite-2 either gets punted from apr-util or it gets a local USE
flag 'sqlite-old' for older cruft
-mike
[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 827 bytes --]
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 17:18 [gentoo-dev] meaning of sqlite/sqlite3 use flag Hanno Böck
2007-09-14 22:46 ` Petteri Räty
2007-09-14 23:52 ` Mike Frysinger
@ 2007-09-15 7:11 ` Samuli Suominen
2 siblings, 0 replies; 13+ messages in thread
From: Samuli Suominen @ 2007-09-15 7:11 UTC (permalink / raw
To: gentoo-dev
On Fri, 14 Sep 2007 19:18:29 +0200
Hanno Böck <hanno@gentoo.org> wrote:
> Hi,
>
> I noticed that the sqlite/sqlite3-useflags have no consistent meaning
> in the tree.
Python uses USE="sqlite" to install basically pysqlite3..
--
gentoo-dev@gentoo.org mailing list
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 23:12 ` Caleb Tennis
@ 2007-09-18 15:08 ` Doug Goldstein
0 siblings, 0 replies; 13+ messages in thread
From: Doug Goldstein @ 2007-09-18 15:08 UTC (permalink / raw
To: gentoo-dev
Caleb Tennis wrote:
>> Does anything need the sqlite2 support in QT?
>>
>
> Not explicitly. Qt can also build against an internal version of sqlite2, so it
> shouldn't be too big of a problem to remove this particular dep (but that doesn't
> get rid of the flag issue, I suppose).
>
> Caleb
>
>
So let's use the internal sqlite2 library and just use the sqlite USE
flag. Since it won't really affect depends that way. It'll basically be
sqlite support...
--
gentoo-dev@gentoo.org mailing list
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 23:52 ` Mike Frysinger
@ 2007-09-18 15:25 ` Doug Goldstein
2007-09-24 19:25 ` Alin Năstac
1 sibling, 0 replies; 13+ messages in thread
From: Doug Goldstein @ 2007-09-18 15:25 UTC (permalink / raw
To: gentoo-dev
Mike Frysinger wrote:
> On Friday 14 September 2007, Hanno Böck wrote:
>
>> I noticed that the sqlite/sqlite3-useflags have no consistent meaning in
>> the tree.
>>
>> E.g.
>> - apr-util uses sqlite for sqlite-2.x support and sqlite3 for sqlite-3.x
>> support
>> - eix uses sqlite for sqlite-3.x support
>> Just the first examples I found, you can find countless for both of them in
>> the tree.
>>
>> We should imho decide if
>> a) sqlite means sqlite-2.x and sqlite3 means sqlite-3.x.
>> b) sqlite means enable sqlite-support always and sqlite+sqlite3 means if
>> both are available use sqlite-3.x instead of 2.x.
>>
>> I don't care which one (or a completely different one), but I think it
>> should be made clear. At least I think the current behaviour in the tree
>> doesn't really make sense.
>>
>
> how about 'sqlite' means you want sqlite irregardless of version ... then
> sqlite-2 either gets punted from apr-util or it gets a local USE
> flag 'sqlite-old' for older cruft
> -mike
>
I agree with this. I'd take this a step further, using old cruft isn't a
choice anymore. If an app supports sqlite2 and sqlite3, we'll have a
USE=sqlite that'll enable sqlite3... sqlite2 just isn't an option
anymore. The conversion process is very simple...
Step 1) mv mydatabase.db mydatabase.db-old
Step 2) sqlite mydatabase.db-old .dump | sqlite3 mydatabase.db
Step 3) Profit!
I'm willing to start making this change asap in the tree. Since sqlite2
and sqlite3 are SLOTED, people won't lose their sqlite2 binary and will
be able to make the conversion. I'll even add an ewarn for people to
make sure to update their databases to sqlite3.
Also, qt already uses it's own internal sqlite2 library and doesn't use
the system library so that won't be a problem.
--
gentoo-dev@gentoo.org mailing list
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-14 23:52 ` Mike Frysinger
2007-09-18 15:25 ` Doug Goldstein
@ 2007-09-24 19:25 ` Alin Năstac
2007-09-25 10:04 ` Petteri Räty
1 sibling, 1 reply; 13+ messages in thread
From: Alin Năstac @ 2007-09-24 19:25 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 750 bytes --]
Mike Frysinger wrote:
> how about 'sqlite' means you want sqlite irregardless of version ... then
> sqlite-2 either gets punted from apr-util or it gets a local USE
> flag 'sqlite-old' for older cruft
>
Wouldn't be better to determine what version of sqlite should be used
based on the version of sqlite currently installed on the system?
Something like:
sqlite_atom=$(best_version dev-db/sqlite)
sqlite_major_version=${sqlite_atom#*/*-} #reduce it to $PV-$PR
sqlite_major_version=${sqlite_major_version%%.*} # major version
... ebuild stuff...
econf \
$(use_enable sqlite sqlite${sqlite_major_version})
Better yet, why not make an sqlite.eclass that would contain at least
get_sqlite_major_version()?
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 252 bytes --]
^ permalink raw reply [flat|nested] 13+ messages in thread
* Re: [gentoo-dev] meaning of sqlite/sqlite3 use flag
2007-09-24 19:25 ` Alin Năstac
@ 2007-09-25 10:04 ` Petteri Räty
0 siblings, 0 replies; 13+ messages in thread
From: Petteri Räty @ 2007-09-25 10:04 UTC (permalink / raw
To: gentoo-dev
[-- Attachment #1: Type: text/plain, Size: 934 bytes --]
Alin Năstac kirjoitti:
> Mike Frysinger wrote:
>> how about 'sqlite' means you want sqlite irregardless of version ... then
>> sqlite-2 either gets punted from apr-util or it gets a local USE
>> flag 'sqlite-old' for older cruft
>>
> Wouldn't be better to determine what version of sqlite should be used
> based on the version of sqlite currently installed on the system?
> Something like:
> sqlite_atom=$(best_version dev-db/sqlite)
> sqlite_major_version=${sqlite_atom#*/*-} #reduce it to $PV-$PR
> sqlite_major_version=${sqlite_major_version%%.*} # major version
>
> ... ebuild stuff...
> econf \
> $(use_enable sqlite sqlite${sqlite_major_version})
>
> Better yet, why not make an sqlite.eclass that would contain at least
> get_sqlite_major_version()?
>
No. The produced binaries can't depend on the build system like this.
Breaks binary packages etc.
Regards,
Petteri
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 252 bytes --]
^ permalink raw reply [flat|nested] 13+ messages in thread
end of thread, other threads:[~2007-09-25 10:16 UTC | newest]
Thread overview: 13+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2007-09-14 17:18 [gentoo-dev] meaning of sqlite/sqlite3 use flag Hanno Böck
2007-09-14 22:46 ` Petteri Räty
2007-09-14 22:51 ` Jan Kundrát
2007-09-14 23:05 ` Petteri Räty
2007-09-14 23:12 ` Caleb Tennis
2007-09-18 15:08 ` Doug Goldstein
2007-09-14 23:20 ` Jan Kundrát
2007-09-14 23:23 ` Jan Kundrát
2007-09-14 23:52 ` Mike Frysinger
2007-09-18 15:25 ` Doug Goldstein
2007-09-24 19:25 ` Alin Năstac
2007-09-25 10:04 ` Petteri Räty
2007-09-15 7:11 ` Samuli Suominen
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox