| 1 |
James Ausmus wrote: |
| 2 |
> |
| 3 |
> |
| 4 |
> On Tue, Nov 17, 2009 at 1:53 PM, Dale <rdalek1967@×××××.com |
| 5 |
> <mailto:rdalek1967@×××××.com>> wrote: |
| 6 |
> |
| 7 |
> Hi, |
| 8 |
> |
| 9 |
> KDE 4 was having "issues" with sqlite not working correctly. |
| 10 |
> After reading about and people telling me that mySql works |
| 11 |
> better, I installed mySql. Its big and all but at least it works. |
| 12 |
> Anyway, I changed the USE flags and have -sqlite in my USE flag |
| 13 |
> line. I want to get rid of sqlite on here. I see no need for me |
| 14 |
> to have two of these installed at the same time. Here is what |
| 15 |
> depends on sqlite: |
| 16 |
> |
| 17 |
> root@smoker / # equery depends sqlite |
| 18 |
> [ Searching for packages depending on sqlite... ] |
| 19 |
> app-pda/libopensync-0.22 (>=dev-db/sqlite-3) |
| 20 |
> app-portage/eix-0.17.0 (sqlite? >=dev-db/sqlite-3) |
| 21 |
> dev-lang/python-2.6.2-r1 (!build & sqlite? >=dev-db/sqlite-3) |
| 22 |
> dev-lang/python-3.1.1-r1 (!build & sqlite? >=dev-db/sqlite-3) |
| 23 |
> dev-libs/apr-util-1.3.9 (sqlite? dev-db/sqlite:0) |
| 24 |
> (sqlite3? dev-db/sqlite:3) |
| 25 |
> dev-libs/cyrus-sasl-2.1.23-r1 (sqlite? dev-db/sqlite) |
| 26 |
> dev-libs/nspr-4.8 (>=dev-db/sqlite-3.5) |
| 27 |
> dev-libs/nss-3.12.3-r1 (>=dev-db/sqlite-3.5) |
| 28 |
> dev-libs/redland-1.0.9-r1 (sqlite? =dev-db/sqlite-3*) |
| 29 |
> dev-util/subversion-1.6.5 (>=dev-db/sqlite-3.4[threadsafe]) |
| 30 |
> kde-base/kget-4.3.3 (sqlite? dev-db/sqlite:3) |
| 31 |
> kde-base/kopete-4.3.3 (statistics? dev-db/sqlite:3) |
| 32 |
> media-libs/libsndfile-1.0.20 (sqlite? >=dev-db/sqlite-3.2) |
| 33 |
> net-im/pidgin-2.6.3 (prediction? =dev-db/sqlite-3*) |
| 34 |
> net-libs/webkit-gtk-1.1.10 (>=dev-db/sqlite-3) |
| 35 |
> net-libs/xulrunner-1.9.1.4 (sqlite? >=dev-db/sqlite-3.6.16) |
| 36 |
> www-client/mozilla-firefox-3.5.4 (sqlite? >=dev-db/sqlite-3.6.10) |
| 37 |
> x11-libs/qt-sql-4.5.3 (sqlite? dev-db/sqlite:3) |
| 38 |
> root@smoker / # |
| 39 |
> |
| 40 |
> Those appear to be in the ebuild and MySql is not a option for |
| 41 |
> replacement. Is there a way? I have already emerged these with |
| 42 |
> the -sqlite and +mysql USE flag. I notice something about sqlite3 |
| 43 |
> in one of the ebuilds. What is that? |
| 44 |
> |
| 45 |
> Ideas? |
| 46 |
> |
| 47 |
> |
| 48 |
> Unfortunately, MySQL is not a drop-in replacement for sqlite - the |
| 49 |
> programming APIs and DB capabilities are sufficiently different to not |
| 50 |
> be able to "just replace one with the other" - the developer has to |
| 51 |
> add in extra code/abstraction in order to be able to support one or |
| 52 |
> the other or both. |
| 53 |
> |
| 54 |
> As far as sqlite vs. sqlite3, the more recent major version of sqlite |
| 55 |
> (sqlite-3.*) broke backwards compatibility with <=sqlite-2.*, and has, |
| 56 |
> once again, a different programming API and different DB capabilities |
| 57 |
> - some packages might still only be able to use <sqlite-3, some might |
| 58 |
> be able to use either (hence the sqlite vs. sqlite3 USE flags), and |
| 59 |
> some might only be able to use >=sqlite-3.*. If you look at the |
| 60 |
> package list above, you'll see that pretty much all of them require |
| 61 |
> some version of sqlite-3, and the only one that can optionally do |
| 62 |
> either has the USE flag split out into sqlite (for the <sqlite-3 |
| 63 |
> version) and sqlite-3 - I would guess w/o looking at the ebuild that |
| 64 |
> sqlite-3 takes precedence if both are set, as it's a better and more |
| 65 |
> robust DB system than the older sqlite. |
| 66 |
> |
| 67 |
> HTH- |
| 68 |
> |
| 69 |
> -James |
| 70 |
|
| 71 |
So they do the same thing but in different ways. Hmmm. Oh well. |
| 72 |
|
| 73 |
Dale |
| 74 |
|
| 75 |
:-) :-) |
Archives