[gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Hi,

KDE 4 was having "issues" with sqlite not working correctly.  After 
reading about and people telling me that mySql works better, I installed 
mySql.  Its big and all but at least it works.  Anyway, I changed the 
USE flags and have -sqlite in my USE flag line.  I want to get rid of 
sqlite on here.  I see no need for me to have two of these installed at 
the same time.  Here is what depends on sqlite:

root@smoker / # equery depends sqlite
[ Searching for packages depending on sqlite... ]
app-pda/libopensync-0.22 (>=dev-db/sqlite-3)
app-portage/eix-0.17.0 (sqlite? >=dev-db/sqlite-3)
dev-lang/python-2.6.2-r1 (!build & sqlite? >=dev-db/sqlite-3)
dev-lang/python-3.1.1-r1 (!build & sqlite? >=dev-db/sqlite-3)
dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
                        (sqlite3? dev-db/sqlite:3)
dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
dev-libs/nspr-4.8 (>=dev-db/sqlite-3.5)
dev-libs/nss-3.12.3-r1 (>=dev-db/sqlite-3.5)
dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
dev-util/subversion-1.6.5 (>=dev-db/sqlite-3.4[threadsafe])
kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
media-libs/libsndfile-1.0.20 (sqlite? >=dev-db/sqlite-3.2)
net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
net-libs/webkit-gtk-1.1.10 (>=dev-db/sqlite-3)
net-libs/xulrunner-1.9.1.4 (sqlite? >=dev-db/sqlite-3.6.16)
www-client/mozilla-firefox-3.5.4 (sqlite? >=dev-db/sqlite-3.6.10)
x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
root@smoker / #

Those appear to be in the ebuild and MySql is not a option for 
replacement.  Is there a way?  I have already emerged these with the 
-sqlite and +mysql USE flag.  I notice something about sqlite3 in one of 
the ebuilds.  What is that?

Ideas?

Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Alan McKinnon]

On Tuesday 17 November 2009 23:53:01 Dale wrote:
> Hi,
> 
> KDE 4 was having "issues" with sqlite not working correctly.  After
> reading about and people telling me that mySql works better, I installed
> mySql.  Its big and all but at least it works.  Anyway, I changed the
> USE flags and have -sqlite in my USE flag line.  I want to get rid of
> sqlite on here.  I see no need for me to have two of these installed at
> the same time.  Here is what depends on sqlite:
> 
> root@smoker / # equery depends sqlite
> [ Searching for packages depending on sqlite... ]
> app-pda/libopensync-0.22 (>=dev-db/sqlite-3)
> app-portage/eix-0.17.0 (sqlite? >=dev-db/sqlite-3)
> dev-lang/python-2.6.2-r1 (!build & sqlite? >=dev-db/sqlite-3)
> dev-lang/python-3.1.1-r1 (!build & sqlite? >=dev-db/sqlite-3)
> dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
>                         (sqlite3? dev-db/sqlite:3)
> dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
> dev-libs/nspr-4.8 (>=dev-db/sqlite-3.5)
> dev-libs/nss-3.12.3-r1 (>=dev-db/sqlite-3.5)
> dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
> dev-util/subversion-1.6.5 (>=dev-db/sqlite-3.4[threadsafe])
> kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
> kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
> media-libs/libsndfile-1.0.20 (sqlite? >=dev-db/sqlite-3.2)
> net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
> net-libs/webkit-gtk-1.1.10 (>=dev-db/sqlite-3)
> net-libs/xulrunner-1.9.1.4 (sqlite? >=dev-db/sqlite-3.6.16)
> www-client/mozilla-firefox-3.5.4 (sqlite? >=dev-db/sqlite-3.6.10)
> x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
> root@smoker / #
> 
> Those appear to be in the ebuild and MySql is not a option for
> replacement.  Is there a way?  I have already emerged these with the
> -sqlite and +mysql USE flag.  I notice something about sqlite3 in one of
> the ebuilds.  What is that?

Look at it:

# equery size sqlite
 * dev-db/sqlite-2.8.16-r4
         Total files : 48
         Total size  : 2.50 MiB
 * dev-db/sqlite-3.6.20-r1
         Total files : 518
         Total size  : 7.49 MiB

10M. Why are you worried? Pretend it's not there.

sqlite is SLOTted 0 and 3 (usual reasons for SLOTs)

There is no package called sqlite3, there are bindings in other languages with 
that string in the name. sqlite-3 in ebuilds is not a package, it's a version 
atom, like

>=dev-db/sqlite-3

Some stuff uses sqlite for storage. If it works, leave it alone. Just because 
some parts of KDE <koff><koff> amarok <koff><koff> have issues with it doesn;t 
mean all of KDE has issues with it


-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[James Ausmus]

[-- Attachment #1: Type: text/plain, Size: 3023 bytes --]

On Tue, Nov 17, 2009 at 1:53 PM, Dale <rdalek1967@gmail.com> wrote:

> Hi,
>
> KDE 4 was having "issues" with sqlite not working correctly.  After reading
> about and people telling me that mySql works better, I installed mySql.  Its
> big and all but at least it works.  Anyway, I changed the USE flags and have
> -sqlite in my USE flag line.  I want to get rid of sqlite on here.  I see no
> need for me to have two of these installed at the same time.  Here is what
> depends on sqlite:
>
> root@smoker / # equery depends sqlite
> [ Searching for packages depending on sqlite... ]
> app-pda/libopensync-0.22 (>=dev-db/sqlite-3)
> app-portage/eix-0.17.0 (sqlite? >=dev-db/sqlite-3)
> dev-lang/python-2.6.2-r1 (!build & sqlite? >=dev-db/sqlite-3)
> dev-lang/python-3.1.1-r1 (!build & sqlite? >=dev-db/sqlite-3)
> dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
>                       (sqlite3? dev-db/sqlite:3)
> dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
> dev-libs/nspr-4.8 (>=dev-db/sqlite-3.5)
> dev-libs/nss-3.12.3-r1 (>=dev-db/sqlite-3.5)
> dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
> dev-util/subversion-1.6.5 (>=dev-db/sqlite-3.4[threadsafe])
> kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
> kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
> media-libs/libsndfile-1.0.20 (sqlite? >=dev-db/sqlite-3.2)
> net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
> net-libs/webkit-gtk-1.1.10 (>=dev-db/sqlite-3)
> net-libs/xulrunner-1.9.1.4 (sqlite? >=dev-db/sqlite-3.6.16)
> www-client/mozilla-firefox-3.5.4 (sqlite? >=dev-db/sqlite-3.6.10)
> x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
> root@smoker / #
>
> Those appear to be in the ebuild and MySql is not a option for replacement.
>  Is there a way?  I have already emerged these with the -sqlite and +mysql
> USE flag.  I notice something about sqlite3 in one of the ebuilds.  What is
> that?
>
> Ideas?
>
>
Unfortunately, MySQL is not a drop-in replacement for sqlite - the
programming APIs and DB capabilities are sufficiently different to not be
able to "just replace one with the other" - the developer has to add in
extra code/abstraction in order to be able to support one or the other or
both.

As far as sqlite vs. sqlite3, the more recent major version of sqlite
(sqlite-3.*) broke backwards compatibility with <=sqlite-2.*, and has, once
again, a different programming API and different DB capabilities - some
packages might still only be able to use <sqlite-3, some might be able to
use either (hence the sqlite vs. sqlite3 USE flags), and some might only be
able to use >=sqlite-3.*. If you look at the package list above, you'll see
that pretty much all of them require some version of sqlite-3, and the only
one that can optionally do either has the USE flag split out into sqlite
(for the <sqlite-3 version) and sqlite-3 - I would guess w/o looking at the
ebuild that sqlite-3 takes precedence if both are set, as it's a better and
more robust DB system than the older sqlite.

HTH-

-James



> Dale
>
> :-)  :-)
>

[-- Attachment #2: Type: text/html, Size: 3847 bytes --]

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Alan McKinnon wrote:
> On Tuesday 17 November 2009 23:53:01 Dale wrote:
>   
>> Hi,
>>
>> KDE 4 was having "issues" with sqlite not working correctly.  After
>> reading about and people telling me that mySql works better, I installed
>> mySql.  Its big and all but at least it works.  Anyway, I changed the
>> USE flags and have -sqlite in my USE flag line.  I want to get rid of
>> sqlite on here.  I see no need for me to have two of these installed at
>> the same time.  Here is what depends on sqlite:
>>
>> root@smoker / # equery depends sqlite
>> [ Searching for packages depending on sqlite... ]
>> app-pda/libopensync-0.22 (>=dev-db/sqlite-3)
>> app-portage/eix-0.17.0 (sqlite? >=dev-db/sqlite-3)
>> dev-lang/python-2.6.2-r1 (!build & sqlite? >=dev-db/sqlite-3)
>> dev-lang/python-3.1.1-r1 (!build & sqlite? >=dev-db/sqlite-3)
>> dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
>>                         (sqlite3? dev-db/sqlite:3)
>> dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
>> dev-libs/nspr-4.8 (>=dev-db/sqlite-3.5)
>> dev-libs/nss-3.12.3-r1 (>=dev-db/sqlite-3.5)
>> dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
>> dev-util/subversion-1.6.5 (>=dev-db/sqlite-3.4[threadsafe])
>> kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
>> kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
>> media-libs/libsndfile-1.0.20 (sqlite? >=dev-db/sqlite-3.2)
>> net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
>> net-libs/webkit-gtk-1.1.10 (>=dev-db/sqlite-3)
>> net-libs/xulrunner-1.9.1.4 (sqlite? >=dev-db/sqlite-3.6.16)
>> www-client/mozilla-firefox-3.5.4 (sqlite? >=dev-db/sqlite-3.6.10)
>> x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
>> root@smoker / #
>>
>> Those appear to be in the ebuild and MySql is not a option for
>> replacement.  Is there a way?  I have already emerged these with the
>> -sqlite and +mysql USE flag.  I notice something about sqlite3 in one of
>> the ebuilds.  What is that?
>>     
>
> Look at it:
>
> # equery size sqlite
>  * dev-db/sqlite-2.8.16-r4
>          Total files : 48
>          Total size  : 2.50 MiB
>  * dev-db/sqlite-3.6.20-r1
>          Total files : 518
>          Total size  : 7.49 MiB
>
> 10M. Why are you worried? Pretend it's not there.
>
> sqlite is SLOTted 0 and 3 (usual reasons for SLOTs)
>
> There is no package called sqlite3, there are bindings in other languages with 
> that string in the name. sqlite-3 in ebuilds is not a package, it's a version 
> atom, like
>
>   
>> =dev-db/sqlite-3
>>     
>
> Some stuff uses sqlite for storage. If it works, leave it alone. Just because 
> some parts of KDE <koff><koff> amarok <koff><koff> have issues with it doesn;t 
> mean all of KDE has issues with it
>
>
>   

So basically I have to have it anyway?  It's just one more thing to 
update is why I want to gt rid of it.

I also noticed the sqlite3 USE flag.  Changing that next.

Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Alan McKinnon]

On Wednesday 18 November 2009 00:22:08 Dale wrote:
> > Some stuff uses sqlite for storage. If it works, leave it alone. Just
> > because  some parts of KDE <koff><koff> amarok <koff><koff> have issues
> > with it doesn;t mean all of KDE has issues with it
> >
> >
> >   
> 
> So basically I have to have it anyway?  It's just one more thing to 
> update is why I want to gt rid of it.
 
You have better things to worry about, trust me :-)

Like, why do you have to have redland and lucene around when a) redland sucks 
b) lucene sucks much less despite being java?

Or XML parsers... why do you invariably have libxml and expat at the same 
time?

For that matter, I'll bet you have 3 SLOTTED versions of db in addition to 
gdbm (all in addition to sqlite of course)

Lets not even start with the scripting languages ... I often hear newbies 
complain about having bash, python, perl and ruby all at the same time. Can't 
the devs just stick to one language?

See where I'm going with this? At <10M for two versions of sqlite, it's not 
worth worrying about and you don't have to pay any attention to updating it - 
portage and --depclean will sort you out just fine

-- 
alan dot mckinnon at gmail dot com

equery depends vs. emerge -pv --depclean <atom> (was: Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.)

[Daniel Pielmeier]

[-- Attachment #1: Type: text/plain, Size: 1698 bytes --]

Dale schrieb am 17.11.2009 22:53:
>
> root@smoker / # equery depends sqlite
> [ Searching for packages depending on sqlite... ]
> app-pda/libopensync-0.22 (>=dev-db/sqlite-3)

If you have this package installed and want to keep it you are forced to
keep sqlite as it is a hard dependency. Meaning this package needs
sqlite and there is no alternative.

> app-portage/eix-0.17.0 (sqlite? >=dev-db/sqlite-3)

Here sqlite is optional via use flag. So you can get rid of the
dependency it by disabling the use flag.

> Those appear to be in the ebuild and MySql is not a option for
> replacement.  Is there a way?  I have already emerged these with the
> -sqlite and +mysql USE flag.  I notice something about sqlite3 in one of
> the ebuilds.  What is that?

The main reason why I respond to this post is that there are still a lot
of people which are using "equery depends", although it is known to
print false positive by not taking use flags into account. You have to
scan through the output and check if the use flag is activated which
pulls in the package you want to check. Like for eix in the above
example. Eix only depends on sqlite if the sqlite use flag is activated.
"Equery depends" lists it in any case (activated or not) as it doesn't
take the use flags into account.

A more convenient way to find out the correct reverse dependencies with
portage is "emerge -pv --depclean <atom>"[1]. Running only "emerge -pv
--depclean" checks the complete world and system set, but if you pass a
package to it only the reverse dependencies of the package in question
are examined.

[1] http://www.gentoo.org/proj/en/portage/doc/faq.xml

-- 
Daniel Pielmeier


[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 261 bytes --]

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Alan McKinnon wrote:
> On Wednesday 18 November 2009 00:22:08 Dale wrote:
>   
>>> Some stuff uses sqlite for storage. If it works, leave it alone. Just
>>> because  some parts of KDE <koff><koff> amarok <koff><koff> have issues
>>> with it doesn;t mean all of KDE has issues with it
>>>
>>>
>>>   
>>>       
>> So basically I have to have it anyway?  It's just one more thing to 
>> update is why I want to gt rid of it.
>>     
>  
> You have better things to worry about, trust me :-)
>
> Like, why do you have to have redland and lucene around when a) redland sucks 
> b) lucene sucks much less despite being java?
>
> Or XML parsers... why do you invariably have libxml and expat at the same 
> time?
>
> For that matter, I'll bet you have 3 SLOTTED versions of db in addition to 
> gdbm (all in addition to sqlite of course)
>
> Lets not even start with the scripting languages ... I often hear newbies 
> complain about having bash, python, perl and ruby all at the same time. Can't 
> the devs just stick to one language?
>
> See where I'm going with this? At <10M for two versions of sqlite, it's not 
> worth worrying about and you don't have to pay any attention to updating it - 
> portage and --depclean will sort you out just fine
>
>   

Well that stirred up my curiosity.  Here is my USE line:

root@smoker / # emerge --info | grep USE
USE="3dnow X aac acl acpi alsa amd automount berkdb bzip2 cairo cddb cdr 
chroot cli consolekit cracklib cups curl dbus dri dvd dvdr dvdread 
emboss encode esd evo exif fam fdftk flac fortran gdbm gif gimp gkrellm 
gphoto2 gpm gstreamer gtk hal hbci htmlhandbook iconv ipv6 java 
javascript jbig jpeg jpeg2k justify kde ldap libnotify libwww logrotate 
loop-aes mad mikmod mmx mng modules mp3 mp4 mpeg mplayer mudflap mysql 
ncurses nptl nptlonly nsplugin offensive ofx ogg opengl openmp pam 
parport pcre pdf perl png ppds pppd python qt3 qt3support qt4 quicktime 
readline realmedia reflection sdl seamonkey session spell spl sse ssl 
startup-notification svg sysfs syslog tcl tcpd thunar tiff tk truetype 
unicode usb vorbis webkit win32codecs wma wmf wmp x264 x86 xml xorg xv 
xvid yahoo zeroconf zlib" ALSA_CARDS="emu10k1" ALSA_PCM_PLUGINS="adpcm 
alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug 
ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route 
share shm softvol" CAMERAS="canon ptp2" ELIBC="glibc" 
INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LINGUAS="en_US en" 
SANE_BACKENDS="hp" USERLAND="GNU" VIDEO_CARDS="nvidia nv"
root@smoker / #

Should I be turning some of those off as they are not needed?  This is 
my oldest install so I bet some are not even needed or can be done away 
with.  I most likely had a good reason for turning them on way back when 
but may not have a good reason now. 

Dale

:-)  :-) 

[gentoo-user] Re: equery depends vs. emerge -pv --depclean <atom>

[Dale]

Daniel Pielmeier wrote:
> Dale schrieb am 17.11.2009 22:53:
>   
>> root@smoker / # equery depends sqlite
>> [ Searching for packages depending on sqlite... ]
>> app-pda/libopensync-0.22 (>=dev-db/sqlite-3)
>>     
>
> If you have this package installed and want to keep it you are forced to
> keep sqlite as it is a hard dependency. Meaning this package needs
> sqlite and there is no alternative.
>
>   
>> app-portage/eix-0.17.0 (sqlite? >=dev-db/sqlite-3)
>>     
>
> Here sqlite is optional via use flag. So you can get rid of the
> dependency it by disabling the use flag.
>
>   
>> Those appear to be in the ebuild and MySql is not a option for
>> replacement.  Is there a way?  I have already emerged these with the
>> -sqlite and +mysql USE flag.  I notice something about sqlite3 in one of
>> the ebuilds.  What is that?
>>     
>
> The main reason why I respond to this post is that there are still a lot
> of people which are using "equery depends", although it is known to
> print false positive by not taking use flags into account. You have to
> scan through the output and check if the use flag is activated which
> pulls in the package you want to check. Like for eix in the above
> example. Eix only depends on sqlite if the sqlite use flag is activated.
> "Equery depends" lists it in any case (activated or not) as it doesn't
> take the use flags into account.
>
> A more convenient way to find out the correct reverse dependencies with
> portage is "emerge -pv --depclean <atom>"[1]. Running only "emerge -pv
> --depclean" checks the complete world and system set, but if you pass a
> package to it only the reverse dependencies of the package in question
> are examined.
>
> [1] http://www.gentoo.org/proj/en/portage/doc/faq.xml
>
>   

I do know, because I have read about it, that equery is not 100% 
accurate.  It is a starting point tho.  Is it that equery needs a bit of 
rewriting or is it just that hard to do when taking USE flags into account?

Since one of those has a hard dependency on sqlite, it would have to 
stay anyway.  May as well leave it for the rest too.  Here is the output 
of --depclean for sqlite:

root@smoker / # emerge -pv --depclean sqlite

Calculating dependencies... done!
  dev-db/sqlite-3.6.19 pulled in by:
    dev-util/subversion-1.6.5

 >>> No packages selected for removal by depclean
Packages installed:   1199
Packages in world:    109
Packages in system:   50
Required packages:    202
Number to remove:     0
root@smoker / #     

Going by that, I would *think* subversion is all that needs sqlite.  
Would that be correct?  Trying to have a learning moment here.  ;-)

It appears that subversion is needed by this:

root@smoker / # emerge -pv --depclean subversion

Calculating dependencies... done!
  dev-util/subversion-1.6.5 pulled in by:
    app-admin/eselect-python-99999999

 >>> No packages selected for removal by depclean
Packages installed:   1199
Packages in world:    109
Packages in system:   50
Required packages:    202
Number to remove:     0
root@smoker / #

That lead to this:

root@smoker / # emerge -pv --depclean eselect-python

Calculating dependencies... done!
  app-admin/eselect-python-99999999 pulled in by:
    app-admin/gam-server-0.1.10
    dev-java/java-config-2.1.9-r1
    dev-lang/python-2.6.2-r1
    dev-lang/python-3.1.1-r1
    dev-libs/libgamin-0.1.10-r2
    dev-libs/libxml2-2.7.3-r2
    dev-libs/libxslt-1.1.24-r1
    dev-util/subversion-1.6.5
    sys-apps/file-5.03
    sys-apps/portage-2.2_rc50

 >>> No packages selected for removal by depclean
Packages installed:   1199
Packages in world:    109
Packages in system:   50
Required packages:    202
Number to remove:     0
root@smoker / # 

So in the end, it appears that a few things "depend" on sqlite. 

Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

James Ausmus wrote:
>
>
> On Tue, Nov 17, 2009 at 1:53 PM, Dale <rdalek1967@gmail.com 
> <mailto:rdalek1967@gmail.com>> wrote:
>
>     Hi,
>
>     KDE 4 was having "issues" with sqlite not working correctly.
>      After reading about and people telling me that mySql works
>     better, I installed mySql.  Its big and all but at least it works.
>      Anyway, I changed the USE flags and have -sqlite in my USE flag
>     line.  I want to get rid of sqlite on here.  I see no need for me
>     to have two of these installed at the same time.  Here is what
>     depends on sqlite:
>
>     root@smoker / # equery depends sqlite
>     [ Searching for packages depending on sqlite... ]
>     app-pda/libopensync-0.22 (>=dev-db/sqlite-3)
>     app-portage/eix-0.17.0 (sqlite? >=dev-db/sqlite-3)
>     dev-lang/python-2.6.2-r1 (!build & sqlite? >=dev-db/sqlite-3)
>     dev-lang/python-3.1.1-r1 (!build & sqlite? >=dev-db/sqlite-3)
>     dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0)
>                           (sqlite3? dev-db/sqlite:3)
>     dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite)
>     dev-libs/nspr-4.8 (>=dev-db/sqlite-3.5)
>     dev-libs/nss-3.12.3-r1 (>=dev-db/sqlite-3.5)
>     dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*)
>     dev-util/subversion-1.6.5 (>=dev-db/sqlite-3.4[threadsafe])
>     kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3)
>     kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3)
>     media-libs/libsndfile-1.0.20 (sqlite? >=dev-db/sqlite-3.2)
>     net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*)
>     net-libs/webkit-gtk-1.1.10 (>=dev-db/sqlite-3)
>     net-libs/xulrunner-1.9.1.4 (sqlite? >=dev-db/sqlite-3.6.16)
>     www-client/mozilla-firefox-3.5.4 (sqlite? >=dev-db/sqlite-3.6.10)
>     x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3)
>     root@smoker / #
>
>     Those appear to be in the ebuild and MySql is not a option for
>     replacement.  Is there a way?  I have already emerged these with
>     the -sqlite and +mysql USE flag.  I notice something about sqlite3
>     in one of the ebuilds.  What is that?
>
>     Ideas?
>
>
> Unfortunately, MySQL is not a drop-in replacement for sqlite - the 
> programming APIs and DB capabilities are sufficiently different to not 
> be able to "just replace one with the other" - the developer has to 
> add in extra code/abstraction in order to be able to support one or 
> the other or both.
>
> As far as sqlite vs. sqlite3, the more recent major version of sqlite 
> (sqlite-3.*) broke backwards compatibility with <=sqlite-2.*, and has, 
> once again, a different programming API and different DB capabilities 
> - some packages might still only be able to use <sqlite-3, some might 
> be able to use either (hence the sqlite vs. sqlite3 USE flags), and 
> some might only be able to use >=sqlite-3.*. If you look at the 
> package list above, you'll see that pretty much all of them require 
> some version of sqlite-3, and the only one that can optionally do 
> either has the USE flag split out into sqlite (for the <sqlite-3 
> version) and sqlite-3 - I would guess w/o looking at the ebuild that 
> sqlite-3 takes precedence if both are set, as it's a better and more 
> robust DB system than the older sqlite.
>
> HTH-
>
> -James

So they do the same thing but in different ways.  Hmmm.  Oh well.

Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Albert Hopkins]

On Tue, 2009-11-17 at 17:41 -0600, Dale wrote:
> Should I be turning some of those off as they are not needed?  This
> is 
> my oldest install so I bet some are not even needed or can be done
> away 
> with.  I most likely had a good reason for turning them on way back
> when 
> but may not have a good reason now. 
> 
> Dale 

I think you go down the wrong path when you ask someone else what USE
flags *you* need.  We don't know you and your requirements/preferences
enough to know what is needed for you.  It's like going up to a random
person and asking them if you should have your kitchen repainted and if
so what color.  That rarely happens but for kitchens but confusingly
enough it's frequent for USE flags.

Also, "emerge --info |grep USE" isn't very USEful (IMO) because it only
shows what USE flags you have turned on, not the ones you have turned
off.

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Albert Hopkins wrote:
> On Tue, 2009-11-17 at 17:41 -0600, Dale wrote:
>   
>> Should I be turning some of those off as they are not needed?  This
>> is 
>> my oldest install so I bet some are not even needed or can be done
>> away 
>> with.  I most likely had a good reason for turning them on way back
>> when 
>> but may not have a good reason now. 
>>
>> Dale 
>>     
>
> I think you go down the wrong path when you ask someone else what USE
> flags *you* need.  We don't know you and your requirements/preferences
> enough to know what is needed for you.  It's like going up to a random
> person and asking them if you should have your kitchen repainted and if
> so what color.  That rarely happens but for kitchens but confusingly
> enough it's frequent for USE flags.
>
> Also, "emerge --info |grep USE" isn't very USEful (IMO) because it only
> shows what USE flags you have turned on, not the ones you have turned
> off.
>
>   

I was thinking that someone may see some USE flags that are no longer 
needed in most cases.  Some may not even be still in use as far as 
portage is concerned.  In other words, portage doesn't even recognize 
them as a option.  Basically, I do some picture stuff, surf with 
Seamonkey, Firefox and sometimes Konqueror, sometimes get on chat with 
Kopete, play Solitaire, watch a video on youtube sometimes.  Oh, I print 
stuff with my HP printer and download pics from my Canon camera. 

I never noticed that emerge --info doesn't show the USE flags I 
removed.  That is sort of weird.  I was thinking that it showed the USE 
flags with not only the profile but what I have set in make.conf which 
would include the ones turned on and turned off.   Neat info.

Dale

:-)  :-) 

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Alan McKinnon]

On Wednesday 18 November 2009 07:49:40 Dale wrote:
> Albert Hopkins wrote:
> > On Tue, 2009-11-17 at 17:41 -0600, Dale wrote:
> >> Should I be turning some of those off as they are not needed?  This
> >> is
> >> my oldest install so I bet some are not even needed or can be done
> >> away
> >> with.  I most likely had a good reason for turning them on way back
> >> when
> >> but may not have a good reason now.
> >>
> >> Dale
> >
> > I think you go down the wrong path when you ask someone else what USE
> > flags *you* need.  We don't know you and your requirements/preferences
> > enough to know what is needed for you.  It's like going up to a random
> > person and asking them if you should have your kitchen repainted and if
> > so what color.  That rarely happens but for kitchens but confusingly
> > enough it's frequent for USE flags.
> >
> > Also, "emerge --info |grep USE" isn't very USEful (IMO) because it only
> > shows what USE flags you have turned on, not the ones you have turned
> > off.
> 
> I was thinking that someone may see some USE flags that are no longer
> needed in most cases.  Some may not even be still in use as far as
> portage is concerned.  In other words, portage doesn't even recognize
> them as a option.  Basically, I do some picture stuff, surf with
> Seamonkey, Firefox and sometimes Konqueror, sometimes get on chat with
> Kopete, play Solitaire, watch a video on youtube sometimes.  Oh, I print
> stuff with my HP printer and download pics from my Canon camera.
> 
> I never noticed that emerge --info doesn't show the USE flags I
> removed.  That is sort of weird.  I was thinking that it showed the USE
> flags with not only the profile but what I have set in make.conf which
> would include the ones turned on and turned off.   Neat info.

eix comes with some useful utilities like eix-test-obsolete which scans all 
your portage files and tells you which settings are redundant, duplicated and 
so on.

It takes a while to parse all of it, but a useful exercise nonetheless


-- 
alan dot mckinnon at gmail dot com

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 446 bytes --]

On Wed, 18 Nov 2009 09:09:35 +0200, Alan McKinnon wrote:

> eix comes with some useful utilities like eix-test-obsolete which scans
> all your portage files and tells you which settings are redundant,
> duplicated and so on.

And flagedit warns if you have set any obsolete flags in make.conf.


-- 
Neil Bothwick

To most people solutions mean finding the answers. But to chemists
solutions are things that are still all mixed up.

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 198 bytes --]

Re: [gentoo-user] MySql versus sqlite. Don't want sqlite anymore.

[Dale]

Neil Bothwick wrote:
> On Wed, 18 Nov 2009 09:09:35 +0200, Alan McKinnon wrote:
>
>   
>> eix comes with some useful utilities like eix-test-obsolete which scans
>> all your portage files and tells you which settings are redundant,
>> duplicated and so on.
>>     
>
> And flagedit warns if you have set any obsolete flags in make.conf.
>
>
>   

I have used that eix one before.  It was a while back tho.  It does seem 
to output a LOT and takes a while to sort through it all.  Don't worry, 
I won't post all that on here.  I bet it is a lot of stuff. 

About to emerge flagedit now.  See what it does.

Thanks.

Dale

:-)  :-)