I mentioned not too long ago that I was working on getting portage details crammed into postgresql, and here is the end result.
GPNL is meant to be a QA tool for treecleaners to use, making it easier to find packages and ebuilds that … well, need some lovin.
Though it’s primarily intended for quality assurance, I’ve written the frontend to be hopefully pretty generic so anyone can browse the portage tree and just see some interesting statistics all around. There’s still a lot more to be done on the website, but I think it’s to a point right now where it’s at least ready for some public consumption.
One thing I’m excited about is setting up the advanced search page, where you’ll be able to run all kinds of funky queries. I’m going to be adding some more QA checks as well, once I get some time. Getting this much done though was quite a lot of work though, and I’m probably going to take a break and focus more on other things for a while. However, if anyone has some reasonable feature requests, I’m all ears.
Oh, also the source code for the database schema and the import scripts is available online. I’ll setup SVN access and some documentation on the db layout sometime soon, not to mention how to get it working (short howto: emerge php, pkgcore, postgresql and portage-utils).
Also, a huge shout out to marienz and ferringb who put together pkgcore and my little python scripts that made importing the data incredibly simple. Thanks, guys.
Sometimes reading / studying my scriptures can get boring (a sure sign of apostasy, I’m sure … I’m doomed!), but it occurred to me the other day that while we are instructed to read our scriptures on a daily basis, nobody ever said anything about reading them in any certain order.
So, while I was tweaking the db layout of the lds_scriptures tables, I added a new table: chapters. Then I setup a view to pull out a random chapter and its verses. This works much better than me randomly flipping something open in my book, because if I do that then I usually land somewhere near the middle. This time, anything goes, baby! Anyway, I wrote a quick php script to pull them out, and put it on my server, so here you go — a random Book of Mormon chapter each time you refresh the page.
For some reason, *every* time I run it, I get a really long chapter that comes up. I think the Lord is trying to tell me something. Doh!
So I pinged SuperLag the other day on IRC about the wordpress ebuilds, and somehow I came out of that conversation as being the new maintainer. Buh. I’m still not sure how that happened.
I’m excited, though. He didn’t mind ditching it and I didn’t mind picking it up. I like wordpress a lot, and I’m going to add wordpress multi-user to the tree as soon as I get a chance. Also, I’ve been meaning to do an audit of the PHP code myself to check for security vulns, so I guess I should get on that.
Something else I’ve been thinking of doing is maybe putting some popular themes in there as well, and maybe modules too. I use Spam Karma 2 to kill any nasty comment spam, and while it’s a cinch to install (just unzip the file and drop it in the plugins directory), I’m all about the laziness that portage caters to.
If anyone’s got any other ideas for wordpress stuff, just drop me a line and lemme know about it, and I’ll see what I can do.
I’ve been holding off announcing this for a while, since I wanted it to be “done” before doing anything, but since I’m never really going to be finished, I’ll just display what I do have.
I setup a new website to act as the dumping grounds for all my development stuff across the board, including gentoo stuff, php code, lds oss stuff, etc. Pretty much everything I’m working on across the board that is intended for public release.
The new website is http://spaceparanoids.org/ and it’s running on my Dell Intel Pentium 4 desktop. I got this thing on craigslist for $45, and I couldn’t pass up that deal.
Anyway, if you really poke around there, you’ll find two big projects that I’m working on right now which I haven’t announced yet since they aren’t finished either. Please don’t crush my poor little server under the load.
Something I find interesting lately, is that with the Playstation 3 coming out, I haven’t seen hardly any positive press about how this thing freely lets you run other operating systems on it. Geeks will get all up in arms about DRM and lockdowns (which is a good thing), but nobody seems to really give say too much when someone actually does open up a platform. I must be reading the wrong blogs, or something.
Well, I think it’s cool. They even have a page about how to get started hacking your playstation. I’m not much of a gamer, and certainly not a console one, but just the fact that you can freely screw around with it makes me think about getting one someday.
Just another quick Gentoo public service announcement. Hans released a new version of ivtv, v0.8.1, and this comes with a lot of cool updates. It’s already been bumped in portage as well, so for those of you using Hauppage PVR cards, give it a whirl. Note that you’ll have to install it with a 2.6.18 kernel because of the new MPEG2 API.
I’ve been crazy busy lately, but I installed mine and managed to record and watch about 15 seconds of TV just fine with MPlayer’s new PVR functionality, so it seems like it’s okay. I’ve been rebuilding my server all weekend, and hopefully I’ll get around to finishing up with mythtv and testing it out again. With luck, my squelchy audio issues will go away too.
I have not worked on my LDS Scriptures project in a very long time.Â In fact, annual realeases are becoming an embarrassing reality.Â However, I’ve been itching to update the project for a while now, since I’ve been learning quite a lot more about databases since my last release.
I had an interesting idea for doing some custom RSS feeds of pulling down scriptures (which I’ll get into at a later time), but I quickly realized the current db schema wasn’t quite up to par.Â I started poking around the postgres one, and it was much easier than I imagined to fix it up quite a bit.Â I dropped all the tables and recreated them, this time with primary and foreign keys, and I got rid of some columns that were completely unnecessary.Â I renamed some too, along with the other general cleanup.
I tarballed the snapshot once I was finished.Â This isn’t what I’m going to release as the final 3.0 version, since I still need to add things like views and more indexes, but this is the direction I’m going to be heading.Â You can download the snapshot tarball here.Â Feedback is welcome, as always.