Liferea slowing down? here is the fix

I found that Liferea (my rss reader) was starting to get really slow. Hitting space bar to go to the next article was getting somewhat painful levels of delay.

The Fix

Liferea uses sqlite to store it's information. Over time, when you delete from sqlite, the db gets pretty unoptimized (lots of tombstones). This can be fixed with the following command (make sure Liferea is NOT running before doing this):

sqlite3 ~/.liferea_1.4/liferea.db vacuum

(adjust the directory if running a different version of liferea.) It both made my liferea.db 1/2 as big, and now everything is snappy again.

Speaking at Linux World on OpenSim

If you are in the San Francisco area in early August, I'll be giving a presentation on OpenSim at the Linux World Conference. Our local linux users group got a preview of that talk this past week. For the talk I started up an OpenSim instance on my laptop and let everyone with wireless and a capable video card connect to it, with much hilarity ensuing. It worked so well, that I'm definitely going to include that portion in my talk at Linux World.

If you are going to be around there, let me know. I'd also love to meet up with OpenSim folks in the SF area during my trip out.

Why is there no "No drop permissions" bit in SecondLife?

I've been thinking a lot about the way the implementation of SecondLife has created a very specific culture in that environment. One of the issues SecondLife is currently having in expanding scope, is that culture makes some things easy, some things hard, and other things impossible. The technology is never impossible, but meeting the needs of the residents of can be. I'm going to start posting some of these "what if" bits on the technology here under the opensim and secondlife tags, please feel free to jump in and discuss.

The Permissions System

The SecondLife permissions system is a curious thing:

  • No modify
  • No copy
  • No transfer

The model provides the ability to let people create modifiable, but un resellable goods, or prevents a good from propagating. What it doesn't really do though is encourage Creative Commons content. Most creators that create "full perms" objects, find that someone takes a copy removes some of the permissions, then sells it elsewhere.

There has been a lot of arguments that a CC model for content creation can't work on grid scale, but I don't think it's been given a fair shake. If you really wanted to try this experiment, you'd need another bit (at least one more) which was:

  • No drop permissions

Doing so would let you put content into the environment that has the Modify / Copy / Transfer bits enabled, and no down stream person could turn them off. "I gave away this thing, and want it to be part of the commons. Anyone can have it, but also has to keep it in the commons." To support this kind of model building content on the main grid, Linden could even remove the upload cost for NDP content, making it a richer world for all.

The recent trend to do public works projects in SecondLife, paid for by the Lindens, means there is definitely some need for a commons space. Perhaps expanding the permissions model to keep free content free would do some of this on it's own.

OpenOffice Lessons for the Day

Things that I spent too much time figuring out again today with OpenOffice

  • Tools -> AutoCorrect .... - to turn off all those replacement tables which make your Unix commands in a presentation all go funny
  • OpenOffice "automatic colors" are anything but, as they don't realize you have a black background, and choose horrible defaults
  • To fix this do the following:
    • Options -> OpenOffice.org -> Appearance
    • Modify link color to something like yellow
    • Modify document background to black (so you can see when you edit)
    • Save as some other profile, as this will affect all documents, including text ones

Now my life with open office is a bit better. 🙂