Re: [gentoo-user] unclear (to me) errors from portage

2014-08-12 Thread Alan McKinnon
On 12/08/2014 07:43, J. Roeleveld wrote:
 Plus, I refuse under any circumstances to run Gentoo on production
  unless it's backed by a huge build farm or I have a large cluster that
  are all identical and have very special needs.
 I use Gentoo exclusively on the servers and desktops at home. I find it 
 easier 
 and more logical to maintain.
 I do have a VM dedicated to building binary packages though.
 


I just got really tired of eternally being The Only One In The Place Who
Knows Gentoo(tm) and who doesn't blindly emerge -uND world on a remote
box then walk away

At least with apt and yum juniors can be trained fairly quickly to do
reliable world updates safely. This keeps the boss off my neck. That
makes me happy.

On my personal servers and laptops, it will take on the order of atomic
warfare to make me give up my beloved Gentoo there :-)

-- 
Alan McKinnon
alan.mckin...@gmail.com




Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread Alan McKinnon
On 12/08/2014 07:36, J. Roeleveld wrote:
 On Monday, August 11, 2014 10:45:07 PM Mick wrote:
 On Monday 11 Aug 2014 20:01:16 Volker Armin Hemmann wrote:
 isn't it great? back in the days when kmail stored emails in files,
 everything worked great and even folders with 100k mails were not a
 problem.

 But, no, they had to break that.

 I lost ca 500k emails thanks to akonadi-crap and errors like that. I
 really loved kmail and thunderbird is garbage compared - but akonadi
 took away that choice.

 Thank you, kdepim-devs for making the dumbest decision ever! *thumbsup*

 I share your feelings although I haven't lost messages in my current attempt
 to road test kmail2.  I am dreading the moment when kmail1 will stop
 working due to bitrot and I'll have to make a choice.   :-(
 
 With a modern machine and the latest versions, it's not too bad and responds 
 quicker then kmail-1 did. With the old version, I often had kmail become 
 unresponsive when synchronizing the email.
 
 I didn't loose any emails, but that is more likely related to the emails 
 being 
 stored on an imap server, rather then being lucky.
 
 I really don't see the point of forcing mysql as a backend. Sqlite would have 
 been a better choice.


Way back when in the dark days of KDE-4.4 or thereabouts, the KDE devs
did do extensive tests with mysql vs sqlite and found sqlite lacking in
horsepower. Remember that it must store the metadata for all your mails
and some of us have lots of mail. IIRC there was also serious contention
issues with multiple threads.

sqlite is an amazing little product, but it does have it's limits. It
performs really well as an embedded datastore to replace flat file
storage with an SQL interface, and my gut-feel evaluation is that it
runs out of steam at similar orders of magnitude of data.

Amarok incidentally has almost exactly the same issues and the same
solution was adopted


-- 
Alan McKinnon
alan.mckin...@gmail.com




Re: [gentoo-user] Re: akonadi ... don't you just love it?

2014-08-12 Thread Neil Bothwick
On Mon, 11 Aug 2014 20:38:57 -0400, Rich Freeman wrote:

  It appears the recent mysql update broke quite a few things, my MythTV
  fronted started sulking while the backend just sucked up all the CPU
  cycles. Something else broke too, but I can't remember more than two
  things these days. @preserved-rebuild showed nothing but
  revdep-rebuild cleaned things up. It appears that revdep-rebuild is
  not ready for retirement yet, although this is the first time in ages
  that I've needed it.  
 
 I had a similar experience on two Gentoo boxes, including MythTV.  I
 don't think it was myth itself but rather something in-between.

Yes, I think it was dev-qt/qtsql that broke MythTV. I notice that
dev-python/mysql-python was rebuilt at the same time, so that must have
been missed too, whereas dev-perl/DBD-mysql was re-emerged right after
mysql.


-- 
Neil Bothwick

Top Oxymorons Number 2: Exact estimate


signature.asc
Description: PGP signature


Re: [gentoo-user] Re: akonadi ... don't you just love it?

2014-08-12 Thread Walter Dnes
On Mon, Aug 11, 2014 at 08:00:33PM -0500, Dale wrote
 Neil Bothwick wrote:
  It appears the recent mysql update broke quite a few things, my MythTV
  fronted started sulking while the backend just sucked up all the CPU
  cycles. Something else broke too, but I can't remember more than two
  things these days. @preserved-rebuild showed nothing but
  revdep-rebuild cleaned things up. It appears that revdep-rebuild is
  not ready for retirement yet, although this is the first time in ages
  that I've needed it. 
 
 Jeez Neil.  If you can remember two things at the same time, you may
 have me beat.   scratches head   Now where did that mouse go?
 
 Dale

  They say that memory is the second thing to go.  I forget what the
first is.

-- 
Walter Dnes waltd...@waltdnes.org
I don't run desktop environments; I run useful applications



Re: [gentoo-user] Re: akonadi ... don't you just love it?

2014-08-12 Thread Peter Humphrey
On Tuesday 12 August 2014 08:31:34 Neil Bothwick wrote:
 On Mon, 11 Aug 2014 20:38:57 -0400, Rich Freeman wrote:
   It appears the recent mysql update broke quite a few things, my MythTV
   fronted started sulking while the backend just sucked up all the CPU
   cycles. Something else broke too, but I can't remember more than two
   things these days. @preserved-rebuild showed nothing but
   revdep-rebuild cleaned things up. It appears that revdep-rebuild is
   not ready for retirement yet, although this is the first time in ages
   that I've needed it.

It's so long since I last needed it that I didn't even think of it this time.

  I had a similar experience on two Gentoo boxes, including MythTV.  I
  don't think it was myth itself but rather something in-between.
 
 Yes, I think it was dev-qt/qtsql that broke MythTV. I notice that
 dev-python/mysql-python was rebuilt at the same time, so that must have
 been missed too, whereas dev-perl/DBD-mysql was re-emerged right after
 mysql.

It broke kmail here. @preserved-rebuild rebuilt dev-perl/DBD-mysql but didn't 
catch qtsql.

Thank you all for reminding me of revdep-rebuild.

-- 
Regards
Peter




Re: [gentoo-user] Re: akonadi ... don't you just love it?

2014-08-12 Thread Alan McKinnon
On 12/08/2014 09:57, Walter Dnes wrote:
 On Mon, Aug 11, 2014 at 08:00:33PM -0500, Dale wrote
 Neil Bothwick wrote:
 It appears the recent mysql update broke quite a few things, my MythTV
 fronted started sulking while the backend just sucked up all the CPU
 cycles. Something else broke too, but I can't remember more than two
 things these days. @preserved-rebuild showed nothing but
 revdep-rebuild cleaned things up. It appears that revdep-rebuild is
 not ready for retirement yet, although this is the first time in ages
 that I've needed it. 

 Jeez Neil.  If you can remember two things at the same time, you may
 have me beat.   scratches head   Now where did that mouse go?

 Dale
 
   They say that memory is the second thing to go.  I forget what the
 first is.
 


mojo?

-- 
Alan McKinnon
alan.mckin...@gmail.com




Re: [gentoo-user] unclear (to me) errors from portage

2014-08-12 Thread J. Roeleveld
On Tuesday, August 12, 2014 08:37:52 AM Alan McKinnon wrote:
 On 12/08/2014 07:43, J. Roeleveld wrote:
  Plus, I refuse under any circumstances to run Gentoo on production
  
   unless it's backed by a huge build farm or I have a large cluster that
   are all identical and have very special needs.
  
  I use Gentoo exclusively on the servers and desktops at home. I find it
  easier and more logical to maintain.
  I do have a VM dedicated to building binary packages though.
 
 I just got really tired of eternally being The Only One In The Place Who
 Knows Gentoo(tm) and who doesn't blindly emerge -uND world on a remote
 box then walk away

People who do that should be taken outside behind the chemical shed and 
shot...

 At least with apt and yum juniors can be trained fairly quickly to do
 reliable world updates safely. This keeps the boss off my neck. That
 makes me happy.

I've seen installations start acting really weird because sysadmins decided to 
update a redhat box the official way (yum).
Those usually ended up with backups being restored.

It doesn't matter which distribution you use, you still need to test updates 
on a seperate environment first to ensure all the software running on the 
environment will still work post-upgrade.

 On my personal servers and laptops, it will take on the order of atomic
 warfare to make me give up my beloved Gentoo there :-)

Hehe, same here.

--
Joost



[gentoo-user] Gentoo mirror list - where?

2014-08-12 Thread Helmut Jarausch

Hi,

if an ebuild file has, e.g.,
mirror://github/...

where do I find the list of mirrors Gentoo is using for that?

Many thanks for a hint,
Helmut



Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread Mick
On Sunday 10 Aug 2014 10:34:44 J. Roeleveld wrote:
 On Saturday, August 09, 2014 09:00:48 PM Mick wrote:
  First some general observations that relate to kmail2:
  
  I thought of giving the latest kmail-4.12.5 a spin.  So installed it on a
  machine and set up a couple of IMAP4 servers to get messages from.  An
  account with a messages in the low hundreds works fine.  An account with
  messages in the 100k plus range works like a dog.  While kmail fetches
  headers and then akonadi sets off to organise threads and whatever else
  it wants to do the application becomes pretty much unresponsive and the
  CPU climbs up to 98%. Half an hour later I can get back to it.  :-@
  
  Anyway, this is not the current problem.  I updated mysql to 5.5.39, then
  I kmail would not start with akonadi failing with mysql log containing
 
  errors. So I ran:
 snipped
 
 Why do you run unstable mysql with stable kmail?

mysql-5.5.39 is stable now.

-- 
Regards,
Mick


signature.asc
Description: This is a digitally signed message part.


Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread Mick
On Tuesday 12 Aug 2014 07:42:46 Alan McKinnon wrote:
 On 12/08/2014 07:36, J. Roeleveld wrote:
  On Monday, August 11, 2014 10:45:07 PM Mick wrote:
  On Monday 11 Aug 2014 20:01:16 Volker Armin Hemmann wrote:
  isn't it great? back in the days when kmail stored emails in files,
  everything worked great and even folders with 100k mails were not a
  problem.
  
  But, no, they had to break that.
  
  I lost ca 500k emails thanks to akonadi-crap and errors like that. I
  really loved kmail and thunderbird is garbage compared - but akonadi
  took away that choice.
  
  Thank you, kdepim-devs for making the dumbest decision ever! *thumbsup*
  
  I share your feelings although I haven't lost messages in my current
  attempt to road test kmail2.  I am dreading the moment when kmail1 will
  stop working due to bitrot and I'll have to make a choice.   :-(
  
  With a modern machine and the latest versions, it's not too bad and
  responds quicker then kmail-1 did. With the old version, I often had
  kmail become unresponsive when synchronizing the email.
  
  I didn't loose any emails, but that is more likely related to the emails
  being stored on an imap server, rather then being lucky.
  
  I really don't see the point of forcing mysql as a backend. Sqlite would
  have been a better choice.
 
 Way back when in the dark days of KDE-4.4 or thereabouts, the KDE devs
 did do extensive tests with mysql vs sqlite and found sqlite lacking in
 horsepower. Remember that it must store the metadata for all your mails
 and some of us have lots of mail. IIRC there was also serious contention
 issues with multiple threads.
 
 sqlite is an amazing little product, but it does have it's limits. It
 performs really well as an embedded datastore to replace flat file
 storage with an SQL interface, and my gut-feel evaluation is that it
 runs out of steam at similar orders of magnitude of data.
 
 Amarok incidentally has almost exactly the same issues and the same
 solution was adopted

Only to add that it's more than just mail.  It is the meta/data of the whole 
caboodle of the PIM suite of applications.

I recall the devs explicitly stating early enough in the KDE4 development that 
sqlite is not man enough for the job and advising everyone to move over to 
mysql.

Someone was looking at postgresql as an alternative to mysql, but I'm not sure 
that this would bring any benefit.

-- 
Regards,
Mick


signature.asc
Description: This is a digitally signed message part.


Re: [gentoo-user] Gentoo mirror list - where?

2014-08-12 Thread Neil Bothwick
On Tue, 12 Aug 2014 10:42:34 +0200, Helmut Jarausch wrote:

 if an ebuild file has, e.g.,
 mirror://github/...
 
 where do I find the list of mirrors Gentoo is using for that?

From memory (see other thread) emerge -fp cat/pkg.


-- 
Neil Bothwick

Deja Moo: The feeling that you heard this bull somewhere before.


signature.asc
Description: PGP signature


Re: [gentoo-user] Gentoo mirror list - where?

2014-08-12 Thread Helmut Jarausch

On 08/12/2014 12:21:09 PM, Neil Bothwick wrote:

On Tue, 12 Aug 2014 10:42:34 +0200, Helmut Jarausch wrote:

 if an ebuild file has, e.g.,
 mirror://github/...

 where do I find the list of mirrors Gentoo is using for that?

From memory (see other thread) emerge -fp cat/pkg.



Yes, thanks a lot,
Helmut




[gentoo-user] Re: Emerge of sys-devel/llvm-3.3-r3 fails....

2014-08-12 Thread Jouni Kosonen
Volker Armin Hemmann wrote:

 Am 10.08.2014 um 08:33 schrieb Christopher Kurtis Koeber:
 *emerge --info =sys-devel/llvm-3.3-r3::gentoo*:

 Pastebin: http://pastebin.com/qF92DXSY

 
 I am not a fan of that.
 

gcc-4.7.3, Intel-R-_Atom-TM


 *End Section of Build Log*:

 Pastebin: http://pastebin.com/HEkMicgw

 
 or that.
 

/var/tmp/portage/sys-devel/llvm-3.3-r3/work/llvm-3.3.src/tools/llvm-
readobj/Error.cpp:49:1: internal compiler error: Segmentation fault


 Any assistance will be greatly appreciated.

 
 did you search bugs.gentoo.org? Lots of llvm stuff there 

https://bugs.gentoo.org/show_bug.cgi?id=500032#c9 
looks like a good fit.






Re: [gentoo-user] Emerge of sys-devel/llvm-3.3-r3 fails....

2014-08-12 Thread J. Roeleveld
On Sunday, August 10, 2014 02:33:40 AM Christopher Kurtis Koeber wrote:
 Hello,
 
 I am attempting to emerge xorg-server and sys-devel/llvm-3.3-r3 is pulled in
 as a dependency.
 
 So, when I emerge llvm it fails.
 
 Here is some relevant output:
 
 emerge --info =sys-devel/llvm-3.3-r3::gentoo:
 
 Pastebin: http://pastebin.com/qF92DXSY
 
 End Section of Build Log:
 
 Pastebin: http://pastebin.com/HEkMicgw
 
 Any assistance will be greatly appreciated.

Please do not use pastebin or similar services.
This list is archived and posted issues with their solutions only make sense 
as long as all the information remains available.

Pastebin and similar services do not have the necessary retention period.

Additionally, many people on this list will not even be responding.

--
Joost



Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread Alan McKinnon
On 12/08/2014 11:10, Mick wrote:
 I recall the devs explicitly stating early enough in the KDE4 development 
 that 
 sqlite is not man enough for the job and advising everyone to move over to 
 mysql.
 
 Someone was looking at postgresql as an alternative to mysql, but I'm not 
 sure 
 that this would bring any benefit.


pg is a fine database, but for this use will always be a 2nd class
citizen. Most users will already have mysql installed, or will be
willing to install it.

The number of folks with pg and without mysql will probably be small

-- 
Alan McKinnon
alan.mckin...@gmail.com




Re: [gentoo-user] Re: Emerge of sys-devel/llvm-3.3-r3 fails....

2014-08-12 Thread Volker Armin Hemmann
Am 12.08.2014 um 12:52 schrieb Jouni Kosonen:
 Volker Armin Hemmann wrote:

 Am 10.08.2014 um 08:33 schrieb Christopher Kurtis Koeber:
 *emerge --info =sys-devel/llvm-3.3-r3::gentoo*:

 Pastebin: http://pastebin.com/qF92DXSY

 I am not a fan of that.

 gcc-4.7.3, Intel-R-_Atom-TM

 *End Section of Build Log*:

 Pastebin: http://pastebin.com/HEkMicgw

 or that.

 /var/tmp/portage/sys-devel/llvm-3.3-r3/work/llvm-3.3.src/tools/llvm-
 readobj/Error.cpp:49:1: internal compiler error: Segmentation fault

 Any assistance will be greatly appreciated.

 did you search bugs.gentoo.org? Lots of llvm stuff there 
 https://bugs.gentoo.org/show_bug.cgi?id=500032#c9 
 looks like a good fit.





could be - I had build failures caused by the -ftracer cflag - which
shows nicely the fragility of the whole mess.



Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread J. Roeleveld
On 12 August 2014 14:06:07 CEST, Alan McKinnon alan.mckin...@gmail.com wrote:
On 12/08/2014 11:10, Mick wrote:
 I recall the devs explicitly stating early enough in the KDE4
development that 
 sqlite is not man enough for the job and advising everyone to move
over to 
 mysql.
 
 Someone was looking at postgresql as an alternative to mysql, but I'm
not sure 
 that this would bring any benefit.


pg is a fine database, but for this use will always be a 2nd class
citizen. Most users will already have mysql installed, or will be
willing to install it.

The number of folks with pg and without mysql will probably be small

Not necessarily.
People who care about databases actually supporting SQL properly and performing 
properly will prefer PostgreSQL.

I don't like to be forced to run a MySQL instance as well. It's often the 
laziness of developers that causes the difficulty of supporting a different 
database when they started with MySQL.
If you start with a different one, like PostgrSQL, supporting different 
database engines is very simple.

--
Joost
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.



Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread Alan McKinnon
On 12/08/2014 15:28, J. Roeleveld wrote:
 On 12 August 2014 14:06:07 CEST, Alan McKinnon alan.mckin...@gmail.com 
 wrote:
 On 12/08/2014 11:10, Mick wrote:
 I recall the devs explicitly stating early enough in the KDE4
 development that 
 sqlite is not man enough for the job and advising everyone to move
 over to 
 mysql.

 Someone was looking at postgresql as an alternative to mysql, but I'm
 not sure 
 that this would bring any benefit.


 pg is a fine database, but for this use will always be a 2nd class
 citizen. Most users will already have mysql installed, or will be
 willing to install it.

 The number of folks with pg and without mysql will probably be small
 
 Not necessarily.
 People who care about databases actually supporting SQL properly and 
 performing properly will prefer PostgreSQL.
 
 I don't like to be forced to run a MySQL instance as well. It's often the 
 laziness of developers that causes the difficulty of supporting a different 
 database when they started with MySQL.
 If you start with a different one, like PostgrSQL, supporting different 
 database engines is very simple.


I don't think you read what I said.

I didn't say postgresql shouldn't be supported, I said it would always
end up being a second class citizen as the number of people who'd be
happy with mysql will vastly outnumber the number of people who highly
desire postgresql. So, logically, a postgresql driver in this case will
probably just bitrot away. Whihc nicely explains the likely reason why
that driver is not there.

People like yourself who care about databases are very much in the
minority of users, even on Linux. Most users across the boards just
don't give a shit. Them's the breaks.



-- 
Alan McKinnon
alan.mckin...@gmail.com




Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread J. Roeleveld
On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote:
 On 12/08/2014 15:28, J. Roeleveld wrote:
  On 12 August 2014 14:06:07 CEST, Alan McKinnon alan.mckin...@gmail.com 
wrote:
  On 12/08/2014 11:10, Mick wrote:
  I recall the devs explicitly stating early enough in the KDE4
  
  development that
  
  sqlite is not man enough for the job and advising everyone to move
  
  over to
  
  mysql.
  
  Someone was looking at postgresql as an alternative to mysql, but I'm
  
  not sure
  
  that this would bring any benefit.
  
  pg is a fine database, but for this use will always be a 2nd class
  citizen. Most users will already have mysql installed, or will be
  willing to install it.
  
  The number of folks with pg and without mysql will probably be small
  
  Not necessarily.
  People who care about databases actually supporting SQL properly and
  performing properly will prefer PostgreSQL.
  
  I don't like to be forced to run a MySQL instance as well. It's often the
  laziness of developers that causes the difficulty of supporting a
  different database when they started with MySQL. If you start with a
  different one, like PostgrSQL, supporting different database engines is
  very simple.

 I don't think you read what I said.

Sorry, didn't read the below in what you put.

 I didn't say postgresql shouldn't be supported, I said it would always
 end up being a second class citizen as the number of people who'd be
 happy with mysql will vastly outnumber the number of people who highly
 desire postgresql. So, logically, a postgresql driver in this case will
 probably just bitrot away. Whihc nicely explains the likely reason why
 that driver is not there.

It wouldn't bitrot away as there would be people willing to keep it working, 
provided it wouldn't require a MySQL - SQL translator to be kept up-to-date.

 People like yourself who care about databases are very much in the
 minority of users, even on Linux. Most users across the boards just
 don't give a shit. Them's the breaks.

Users never care about what they install. I just wish the majority of 
developers would actually be willing to follow some simple guidelines to make 
it actually possible to others to write and maintain the drivers to connect to 
different databases.

Several attempts have been made by people to add support for different 
databases to various projects. I've tried to do it myself on occasion, but 
even when patches are accepted by upstream, they get broken by upstream at a 
future release again because of the bad design that is often employed by lazy 
developers.

--
Joost



Re: [gentoo-user] Re: akonadi ... don't you just love it?

2014-08-12 Thread Daniel Frey
On 08/12/2014 12:31 AM, Neil Bothwick wrote:
 
 Yes, I think it was dev-qt/qtsql that broke MythTV. I notice that
 dev-python/mysql-python was rebuilt at the same time, so that must have
 been missed too, whereas dev-perl/DBD-mysql was re-emerged right after
 mysql.
 
 

It most definitely was, I just updated my backend and 3 remote frontends
and had this issue. Portage missed this completely, it was
revdep-rebuild that found this breakage and repaired it. From what I
remember there was a python sql package that wound up being broken too.

Dan



Re: [gentoo-user] Re: akonadi ... don't you just love it?

2014-08-12 Thread Rich Freeman
On Tue, Aug 12, 2014 at 10:38 AM, Daniel Frey djqf...@gmail.com wrote:
 On 08/12/2014 12:31 AM, Neil Bothwick wrote:

 Yes, I think it was dev-qt/qtsql that broke MythTV. I notice that
 dev-python/mysql-python was rebuilt at the same time, so that must have
 been missed too, whereas dev-perl/DBD-mysql was re-emerged right after
 mysql.



 It most definitely was, I just updated my backend and 3 remote frontends
 and had this issue. Portage missed this completely, it was
 revdep-rebuild that found this breakage and repaired it. From what I
 remember there was a python sql package that wound up being broken too.

Yup.  My frontends broke after updating the backend.  Clearly there is
some kind of incompatibility between client/server cross-version.
This isn't just a linking issue.  I suspect qtsql was the issue - I
just didn't recall that when I made my last post.

Rich



[gentoo-user] Portage metadata cache backend: sqlite or not?

2014-08-12 Thread Marc Joliet
Hi list

For the longest time I've had portage configured to use the sqlite metadata
cache backend as per an old HOWTO [0], however, I thought that it would be a
good idea to revisit that decision.

Now apparently, this was supposed to speed up portage, although even that
depends.  For instance, [0] says that the metadata_overlay backend is faster on
fast storage; since all of portage is on an SSD, that ought to be the case for
me. However, [0] is pretty outdated, so I don't really know, and don't have any
comparison.

In addition to that, I don't explicitly make use of the sqlite metadata cache,
that is, I don't (consciously) use any software that accesses those DBs, except
for eix (except for overlays, where one would need to run emerge --regen
first, which is *sllw*), which can make use of them if
CACHE_METHOD is set appropriately; this speeds up eix-update considerably.

Does anybody here have experience with this, or a recommendation?  I tried
switching to the default cache method temporarily to see how things perform,
and emerge @world -uDNva slowed down by about 30 seconds, so preliminary
results point to sticking with sqlite (although it could at least partly be a
btrfs performance regression in Linux 3.15, since there have been several 
reports of
those, and several fixes slated for 3.16). Anyway, I'm also unsure of unintended
consequences, or other settings I might have to change, too.

Also, does anybody have any performance data and/or experience on using btrfs
with compression in this context?

[0] http://www.gentoo-wiki.info/TIP_speed_up_portage_with_sqlite

Greetings,
-- 
Marc Joliet
--
People who think they know everything really annoy those of us who know we
don't - Bjarne Stroustrup


signature.asc
Description: PGP signature


Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread Volker Armin Hemmann
Am 12.08.2014 um 16:10 schrieb J. Roeleveld:
 On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote:
 On 12/08/2014 15:28, J. Roeleveld wrote:
 On 12 August 2014 14:06:07 CEST, Alan McKinnon alan.mckin...@gmail.com 
 wrote:
 On 12/08/2014 11:10, Mick wrote:
 I recall the devs explicitly stating early enough in the KDE4
 development that

 sqlite is not man enough for the job and advising everyone to move
 over to

 mysql.

 Someone was looking at postgresql as an alternative to mysql, but I'm
 not sure

 that this would bring any benefit.
 pg is a fine database, but for this use will always be a 2nd class
 citizen. Most users will already have mysql installed, or will be
 willing to install it.

 The number of folks with pg and without mysql will probably be small
 Not necessarily.
 People who care about databases actually supporting SQL properly and
 performing properly will prefer PostgreSQL.

 I don't like to be forced to run a MySQL instance as well. It's often the
 laziness of developers that causes the difficulty of supporting a
 different database when they started with MySQL. If you start with a
 different one, like PostgrSQL, supporting different database engines is
 very simple.
 I don't think you read what I said.
 Sorry, didn't read the below in what you put.

 I didn't say postgresql shouldn't be supported, I said it would always
 end up being a second class citizen as the number of people who'd be
 happy with mysql will vastly outnumber the number of people who highly
 desire postgresql. So, logically, a postgresql driver in this case will
 probably just bitrot away. Whihc nicely explains the likely reason why
 that driver is not there.
 It wouldn't bitrot away as there would be people willing to keep it working, 
 provided it wouldn't require a MySQL - SQL translator to be kept up-to-date.

 People like yourself who care about databases are very much in the
 minority of users, even on Linux. Most users across the boards just
 don't give a shit. Them's the breaks.
 Users never care about what they install. I just wish the majority of 
 developers would actually be willing to follow some simple guidelines to make 
 it actually possible to others to write and maintain the drivers to connect 
 to 
 different databases.

 Several attempts have been made by people to add support for different 
 databases to various projects. I've tried to do it myself on occasion, but 
 even when patches are accepted by upstream, they get broken by upstream at a 
 future release again because of the bad design that is often employed by lazy 
 developers.

 --
 Joost


wasn't qtsql once supposed to that?



Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread J. Roeleveld
On 12 August 2014 20:21:03 CEST, Volker Armin Hemmann 
volkerar...@googlemail.com wrote:
Am 12.08.2014 um 16:10 schrieb J. Roeleveld:
 On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote:
 On 12/08/2014 15:28, J. Roeleveld wrote:
 On 12 August 2014 14:06:07 CEST, Alan McKinnon
alan.mckin...@gmail.com 
 wrote:
 On 12/08/2014 11:10, Mick wrote:
 I recall the devs explicitly stating early enough in the KDE4
 development that

 sqlite is not man enough for the job and advising everyone to
move
 over to

 mysql.

 Someone was looking at postgresql as an alternative to mysql, but
I'm
 not sure

 that this would bring any benefit.
 pg is a fine database, but for this use will always be a 2nd class
 citizen. Most users will already have mysql installed, or will be
 willing to install it.

 The number of folks with pg and without mysql will probably be
small
 Not necessarily.
 People who care about databases actually supporting SQL properly
and
 performing properly will prefer PostgreSQL.

 I don't like to be forced to run a MySQL instance as well. It's
often the
 laziness of developers that causes the difficulty of supporting a
 different database when they started with MySQL. If you start with
a
 different one, like PostgrSQL, supporting different database
engines is
 very simple.
 I don't think you read what I said.
 Sorry, didn't read the below in what you put.

 I didn't say postgresql shouldn't be supported, I said it would
always
 end up being a second class citizen as the number of people who'd be
 happy with mysql will vastly outnumber the number of people who
highly
 desire postgresql. So, logically, a postgresql driver in this case
will
 probably just bitrot away. Whihc nicely explains the likely reason
why
 that driver is not there.
 It wouldn't bitrot away as there would be people willing to keep it
working, 
 provided it wouldn't require a MySQL - SQL translator to be kept
up-to-date.

 People like yourself who care about databases are very much in the
 minority of users, even on Linux. Most users across the boards just
 don't give a shit. Them's the breaks.
 Users never care about what they install. I just wish the majority of

 developers would actually be willing to follow some simple guidelines
to make 
 it actually possible to others to write and maintain the drivers to
connect to 
 different databases.

 Several attempts have been made by people to add support for
different 
 databases to various projects. I've tried to do it myself on
occasion, but 
 even when patches are accepted by upstream, they get broken by
upstream at a 
 future release again because of the bad design that is often employed
by lazy 
 developers.

 --
 Joost


wasn't qtsql once supposed to that?

If a framework like qtsql is used, swapping the database is easy.

Most developers seem to prefer to reinvent the wheel and often come up with 
something that vaguely resembles a circle and is held together with a mixture 
of glue and duck tape. 

--
Joost
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.



Re: [gentoo-user] akonadi ... don't you just love it?

2014-08-12 Thread Alan McKinnon
On 12/08/2014 21:00, J. Roeleveld wrote:
 On 12 August 2014 20:21:03 CEST, Volker Armin Hemmann 
 volkerar...@googlemail.com wrote:
 Am 12.08.2014 um 16:10 schrieb J. Roeleveld:
 On Tuesday, August 12, 2014 03:38:15 PM Alan McKinnon wrote:
 On 12/08/2014 15:28, J. Roeleveld wrote:
 On 12 August 2014 14:06:07 CEST, Alan McKinnon
 alan.mckin...@gmail.com 
 wrote:
 On 12/08/2014 11:10, Mick wrote:
 I recall the devs explicitly stating early enough in the KDE4
 development that

 sqlite is not man enough for the job and advising everyone to
 move
 over to

 mysql.

 Someone was looking at postgresql as an alternative to mysql, but
 I'm
 not sure

 that this would bring any benefit.
 pg is a fine database, but for this use will always be a 2nd class
 citizen. Most users will already have mysql installed, or will be
 willing to install it.

 The number of folks with pg and without mysql will probably be
 small
 Not necessarily.
 People who care about databases actually supporting SQL properly
 and
 performing properly will prefer PostgreSQL.

 I don't like to be forced to run a MySQL instance as well. It's
 often the
 laziness of developers that causes the difficulty of supporting a
 different database when they started with MySQL. If you start with
 a
 different one, like PostgrSQL, supporting different database
 engines is
 very simple.
 I don't think you read what I said.
 Sorry, didn't read the below in what you put.

 I didn't say postgresql shouldn't be supported, I said it would
 always
 end up being a second class citizen as the number of people who'd be
 happy with mysql will vastly outnumber the number of people who
 highly
 desire postgresql. So, logically, a postgresql driver in this case
 will
 probably just bitrot away. Whihc nicely explains the likely reason
 why
 that driver is not there.
 It wouldn't bitrot away as there would be people willing to keep it
 working, 
 provided it wouldn't require a MySQL - SQL translator to be kept
 up-to-date.

 People like yourself who care about databases are very much in the
 minority of users, even on Linux. Most users across the boards just
 don't give a shit. Them's the breaks.
 Users never care about what they install. I just wish the majority of

 developers would actually be willing to follow some simple guidelines
 to make 
 it actually possible to others to write and maintain the drivers to
 connect to 
 different databases.

 Several attempts have been made by people to add support for
 different 
 databases to various projects. I've tried to do it myself on
 occasion, but 
 even when patches are accepted by upstream, they get broken by
 upstream at a 
 future release again because of the bad design that is often employed
 by lazy 
 developers.

 --
 Joost


 wasn't qtsql once supposed to that?
 
 If a framework like qtsql is used, swapping the database is easy.
 
 Most developers seem to prefer to reinvent the wheel and often come up with 
 something that vaguely resembles a circle and is held together with a mixture 
 of glue and duck tape. 


I blame php and others of it's ilk.

The good thing about php is that everyone and their dog can knock out
running code.
The bad thing about php is that they do.

Substitute mysql and bash if you will and tweak the content to suit - it
all works out the same.

Sensible languages (like, oh I dunno - python maybe?) have this trick
about them - you have to work hard to write awful code. You also have to
work hard to write awesome code, but if you just follow the book you
usually end up with acceptable code.

I will refrain from commenting on perl.


-- 
Alan McKinnon
alan.mckin...@gmail.com




[gentoo-user] Re: Portage metadata cache backend: sqlite or not?

2014-08-12 Thread James
Marc Joliet marcec at gmx.de writes:

 
 Hi list
 
 For the longest time I've had portage configured to use the sqlite 
 metadata cache backend as per an old HOWTO [0], however, I thought that 
 it would be a  good idea to revisit that decision.

 Does anybody here have experience with this, or a recommendation?  

I cannot directly speak to your issues. But, a while back when I 
was researching some dB tools, I discovered a add-on for browsers that 
allows you to view sqllite db:

 SQLite Manager 0.8.1 

and this interesting tool:

http://sqlitestudio.pl/

I hope this helps you diagnose your problems.


James







Re: [gentoo-user] XFCE4: How cab I disable Restart and Shut down buttons?

2014-08-12 Thread Canek Peláez Valdés
On Mon, Aug 11, 2014 at 5:05 AM, Johannes Geiss johannes.ge...@web.de wrote:
 Hello there,

 I have XFCE4 and Systemd running and I want to know if it is possible
 to disable or remove the buttons Restart and Shut down at the
 logout dialog (xfce4-session-logout).

 If so, how?

(Sorry I took so long, I was updating my system).

You want to disable only the buttons, or the functionality? For one
user, or several?

Assuming you want to disable the functionality for one user, this
disables both the functionality *AND* the buttons (they show up grayed
out):

$ cat /etc/polkit-1/rules.d/10-no-restart-shutdown.rules
polkit.addRule(function(action, subject) {
if (subject.user == myuser) {
if (action.id.match(org.freedesktop.login1.power-off) ||
action.id.match(org.freedesktop.login1.reboot)) {
return polkit.Result.NO;
}
}
});

Of course, change myuser for the user you want to disable this. You
can also use groups (subject.isInGroup(group)), or use suspend or
hibernate instead of reboot.

This works for any desktop that uses systemd (logind, technically) for
session tracking: AFAIK, this should work for at least GNOME, Xfce,
and KDE.

Regards.
-- 
Canek Peláez Valdés
Profesor de asignatura, Facultad de Ciencias
Universidad Nacional Autónoma de México



Re: [gentoo-user] Portage metadata cache backend: sqlite or not?

2014-08-12 Thread Nilesh Govindrajan
On Tue, Aug 12, 2014 at 11:40 PM, Marc Joliet mar...@gmx.de wrote:
 Hi list

 For the longest time I've had portage configured to use the sqlite metadata
 cache backend as per an old HOWTO [0], however, I thought that it would be a
 good idea to revisit that decision.

 Now apparently, this was supposed to speed up portage, although even that
 depends.  For instance, [0] says that the metadata_overlay backend is faster 
 on
 fast storage; since all of portage is on an SSD, that ought to be the case for
 me. However, [0] is pretty outdated, so I don't really know, and don't have 
 any
 comparison.

 In addition to that, I don't explicitly make use of the sqlite metadata cache,
 that is, I don't (consciously) use any software that accesses those DBs, 
 except
 for eix (except for overlays, where one would need to run emerge --regen
 first, which is *sllw*), which can make use of them if
 CACHE_METHOD is set appropriately; this speeds up eix-update considerably.

 Does anybody here have experience with this, or a recommendation?  I tried
 switching to the default cache method temporarily to see how things perform,
 and emerge @world -uDNva slowed down by about 30 seconds, so preliminary
 results point to sticking with sqlite (although it could at least partly be a
 btrfs performance regression in Linux 3.15, since there have been several 
 reports of
 those, and several fixes slated for 3.16). Anyway, I'm also unsure of 
 unintended
 consequences, or other settings I might have to change, too.

 Also, does anybody have any performance data and/or experience on using btrfs
 with compression in this context?

 [0] http://www.gentoo-wiki.info/TIP_speed_up_portage_with_sqlite

 Greetings,
 --
 Marc Joliet
 --
 People who think they know everything really annoy those of us who know we
 don't - Bjarne Stroustrup

Having tried this feature, I'd advise against it. It takes long time
to generate metadata after sync and not really that advantageous. Also
eix has it's own issues in this mode.