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

:-)  :-)