Wed, 2 Aug 2006

12:04 AM - SQL is a pain in the ass

I'm trying to get this sql query to work where each rss post is unique by user id.  Another words if i post 10 entries i don't want them to be my rss feed of "new" entries.. only my latest and everyone else's.

Here's the problem.. the query i'm working on so far is 17 seconds to run! 

SELECT * from entry WHERE id IN (SELECT MAX(id) as id FROM entry WHERE security=2 GROUP BY uid) ORDER BY date DESC;

This doesn't do much even.  I still have to join this on several other rows etc.  I could start generating the document statically if needed, but still way too slow. 

Anyone got ideas?

(4 comments | )

10:18 AM - Just Journal bug?

I've been trying to figure out why dates are off by one month in the RSS feed.  I've seen it occasionally on other parts of jj as well.  I noticed i'm incrementing the month by one since its zero based.  Odd enough journal entries use some of this code too.. so it should be universal.  I'm adding some debug logging to jj to detect this.  It may help. 

()

Tue, 1 Aug 2006

1:42 PM - T-mobile

I just talked with T-mobile.  They are cancelling my account.  I have to say they have great customer serivce. 

(1 comment | )

Mon, 31 Jul 2006

11:57 AM - (no subject)

Debugging this new code is very difficult.  I just enabled debugging statements again.  It slows the site down a bit, but I don't have much choice.  Nothing is hitting weblogs afaik. 

(1 comment | )

11:45 AM - (no subject)

Sometimes I wonder about my  java code.  This is pretty bad.  What happened to my coding? 

()

9:25 AM - Hmm.. new jj feature live?

I might have pinging working... it pings weblogs that you have a new entry... lets see what happens.

()

7:51 AM - Who made your laptop?

http://tuxmobil.org/laptop_oem.html

Find out using that website. Lenovo doesn't make laptops. Apple only designs laptops. You can use a linux utility to determine the make.

location: Home

()

Sun, 30 Jul 2006

4:28 PM - etpower mod

I just added the etpower addon to my etpro server.  Finally, I have some administration power back. :)

()

Fri, 28 Jul 2006

6:29 PM - Stupid parents, big asshole

Yet again children are hurt by idiot parents. DONT LET YOUR KIDS ONLINE BY THEMSELVES DAMN IT.

http://www.cnn.com/2006/WORLD/americas/07/28/canada.porn.ap/index.html

This asshole tricked 9-15 year old girls into revealing themselves on a webcam. Not only is he an asshole, but all the parents who put a WEBCAM in the hands of a 9-15 year old girl! Could you be any more retarded parents? I think the lot should go to jail and the children placed with RESPONSIBLE adults. Fucking assholes.

location: Home

()

5:29 PM - 802.11 Wireless Security

I've been reading up on wireless security. I wondered if its possible for our neighbor to crack our wireless network. The short answer is yes.

I've always known wireless is suseptible to attack. I didn't realize how bad it really is. First, WEP security is useless. There are countless brute force programs that can find the key in minutes to a few hours. Mac address filtering is also practically useless. An attacker can determine MAC addresses used very easily. Next, WPA isn't much better. The first version was also crackable using tools. Most keys are very weak. Some new routers supporting WPA2 can allow you to use a key per MAC address. Those are considered the most secure at this point. I am using WPA2 personal on my wireless network. While its the most secure I can do right now, its not full proof. I found tools which I can't run that would allow me to attack. I need to buy a usb wireless device to use the windows or bsd (yes specificially) tools. Most tools currently run on linux though. I may start changing my key and perhaps write a program to generate one more often.

location: Home
mood: Sad Sad

()

12:30 AM - Jewel on Ellis Island?

From Genealogy.com web site:

Swiss National Day Celebration at Ellis Island Saturday - Featuring
Jeweltion-at-ellis-island-saturday-featuring-jewel-5391>
7/27/2006 The Swiss are having a holiday on Ellis Island this weekend. I
rather wish I'd heard about this earlier. I would like to have attended. I
too, have Swiss roots



New York (PRWEB via PR Web Direct) July 27, 2006 International pop star
Jewel will put her Swiss roots on display with a
performance at the Swiss National Day celebration on Ellis
Island,
Saturday, July 29, 2006, from 12:15 to 1:00 honoring Switzerland's 715th
birthday. The event, presented by www.swissroots.org will also feature the
newly designed exhibition, "Small Number - Big Impact," a lively
presentation of Swiss immigration history to the U.S. that will run at Ellis
Island until October 31, 2006 and is organized by "The Association for a
Swiss Migration Museum." Swiss Minister of Culture, Federal Councilor Pascal
Couchepin, will officially open the exhibition, and will deliver the Swiss
National
Daykeynote
address. Furthermore, Swiss
National
Daywill
showcase a wide range of Swiss entertainers, exhibits, and culinary
delicacies.



Proud of her Swiss heritage, Jewel decided, much like Pittsburgh Steelers'
Ben Roethlisberger, to join "Swiss
Roots,"
a program that seeks to inspire Americans to connect with Switzerland, and
she will become a "Swiss Roots" spokesperson. She says: "I was raised aware
of my Swiss roots, singing traditional songs and eating traditional food. I
even have a Swiss passport." As a Swiss-born American, Jewel's father, Atz
Kilcher, with whom she will perform at Swiss National Day, helped
familiarize his daughter with her family's Swiss heritage.



Jewel became aware of Swiss Roots through the makers of "Small Number - Big
Impact
,"
and is one of the celebrities featured in the exhibition at Ellis
Island.
Others include Marc Forster
(Oscar-winning film maker), Adolf
Rickenbacker (inventor of the
electric guitar), Albert
Gallatinl>(finance
minister under President Thomas
Jefferson ), Elisabeth
K|bler-Ross
(psychiatrist
and death researcher), Louis
Chevrolet (racing driver and
car maker), Robert Frank
(photographer), Andreas
Dietsch (early socialist), Othmar
H. Amman (bridge
builder) and General Johann August
Sutter(adventurer). The
exhibition also includes the "Swiss Forum," a lounge in
which visitors have access to Internet stations enabling Swiss-ancestry
genealogical searches. In addition, a comprehensive exhibition catalogue
will be on sale at the Ellis Island Museum's book shop.



*About "Swiss Roots"*
"Swiss Roots" brings the United States and Switzerland closer together
through activities that foster dialogue and understanding, through online
exchanges and live events. The program's centerpiece, www.swissroots.org, is
a state-of-the-art website that serves as a tool for more than one million
Americans of Swiss descent to discover their ancestral roots, and as a
gateway for those curious about Switzerland to discover and communicate with
the Swiss people. The "Swiss Roots" website was launched officially on March
29 at the Embassy of
Switzerlandin
Washington,
D.C., and will be active well into the future.



Featuring various events throughout the United States, "Swiss Roots"
showcases the best in Swiss innovation, culture, history, education, and
business. The project is managed by the Consulate General of Switzerland in
New York and the official Swiss representations in the U.S., in cooperation
with numerous local Swiss associations. "Swiss Roots" is coordinated
by Presence
Switzerland (the Swiss Government's
country branding agency) and supported by Switzerland
Tourism(the
official Swiss tourist board) and Pro
Helvetia (the Swiss Arts
Council). The program is additionally sponsored by private sector companies
such as Swiss Helvetia Fund , Swiss International Air
Lines and Swiss
Post
.



About Jewel
An accomplished and world-renowned singer, songwriter, poet, and painter,
Jewel has continued to explore fresh musical avenues, branching out from her
folk roots to incorporate rock, pop, country, blues, jazz, and classical
influences into her work. Jewel's personal odyssey, partly chronicled on her
landmark 12-times platinum debut, "Pieces of You," comes to full flower on
"Goodbye Alice in Wonderland," her most recent album which was released in
May. Marking her first album in three years and sixth all told the
collection is her most autobiographical work in more than a decade, tracing
her path from the extreme solitude of Alaska to the extreme joys and
pitfalls of fame. "Goodbye Alice in Wonderland" follows 2003's "0304," which
debuted at #2 on the Billboard 200 album chart, simultaneously becoming both
the highest-debuting and highest-charting album of her career to date, while
also marking her fourth album to hit the top ten on the national charts. To
date, Jewel has sold over 25 million albums worldwide, enjoying career
longevity rare among her generation of artists.

location: Home

()

10:34 AM - I bought a NeXTstation!

For those of you who are clueless, view http://en.wikipedia.org/wiki/NeXTstation

location: Home

()

9:05 AM - Websites as graphs

Someone wrote a java applet to graph tags in HTML code on websites!

http://www.aharef.info/2006/05/websites_as_graphs.htm


location: Home

()

Thu, 27 Jul 2006

2:20 PM - The Hoff wasn't drunk?

http://www.cnn.com/2006/SHOWBIZ/TV/07/27/people.hasselhoff.flight.ap/index.html

I think the media is over-reacting a bit to these stories. On the other hand, I found it interesting he was injured shaving. One could almost think he was trying to axe himself but chickened out or failed. It really depends on the situation of course. Its much more likely he was on some drugs as he says than alcohol. In fact, he's been depressed. What if they put him on an MAOI and then he took pain killers or something? That would make him appear very fucked in the head.

location: Home

()