In reply to “Benji’s Space: g0t.comments?“:
I’ll do you one better, I’ll trackback you. 
micolous.id.au
the result of a blogging accident
Saturday, June 25, 2005
Thursday, June 23, 2005
Presenting A.S.S.H.O.L.E. and g0t.planet?
The ASS proudly presents a
new era in Access-hating. The ASS is a society dedicated to expressing one’s mental anguish over the use and creation of databases in Microsoft Access as well as the general misuse of the software by using it for big company databases and such where an SQL server setup
would work more effectively.
In order to rally numbers better, I’m splitting the ASS into chapters (or “cracks”). The first of which is ASSHOLE. Application forms for ASSHOLE are availible from here to fill out and sumbit electronically. Mental instability will help your application, as well as mood swings, depression and a firearms license… 
In other news, btmassgen is coming to a finalised state, which is my simplified yet still powerful UI to create .torrent files. I’m using a native BitTorrent .NET library to do it, with the whole thing written in Visual Basic .NET 2005. There’s still some issues with the BitTorrent library that are stalling a final release.
I thought I’d better also mention g0t.planet?, a random assortment of blogs I’m starting to syndicate from people I know at TAFE. This was formally known as “Planet Trough”, but that name sucked, so I thought I’d better steal borrow a Benji-ism.
Tuesday, May 31, 2005
Notice to certain people with my mobile phone number.
You know who you are. Maybe you’ll read this to find out where I’ve disappeared off the face of the earth to. I really don’t feel like being talked to on the phone, it’s coming up final assignment time, and I really don’t need any demands made of me. Don’t take it personally if I hang up on you or turn off my phone. Emailing me is generally a good option.
Thanks.
Monday, May 23, 2005
Lanetarium of May 2005, ddrgen updates
Last weekend, I went to Lanetarium. It was a little quiet though still enjoyable. Did a little experimentation with BitTorrent in a LAN environment, and it will still warrent further
testing. The low turnout ment that there wasn’t enough popular files to really give the system a good test. The final hurdle to adoption is that creating
torrents is a long process. Azureus has a wizard for it, but it still takes a fair bit of effort per file that really needs to be reduced. Anyway, my future ideas:
- Automatic mass torrent creation. Have a client side application that can go and “walk” through a directory and automatically create torrents based on that. Though the program would first check with the tracker wether or not the file exists, so as to avoid duplication.
- Fix the tracker software so that it uses an SQLite backend, rather than a flatfile system.
- Allow tracking of file requests, and be able to fulfill those requests. So say if you wanted to look for the Star Wars Episode 3 Trailer, you’d file a request. Someone with the trailer would then make a torrent for it and then satisfy the request.
- Basic user tracking. Things like a file upload, request or comment on a file should be identifiable as to whom did it.
I also tested ddrgen, the version I’ve been toying around with in SVN. I’ve fixed Windows 2003 Server support
(as in, the detection of it), though I still have to have a look at Longhorn, making the whole system more portable (ie: remove the dependency on nmap and smbclient), and detecting more Quake 3-based games. Some of those changes will be coming in this week.
I have a nice Windows XP/amd64 trial to play with too now, and I should have a look at getting ddrgen working on Windows 2003 Server… because some people seem to like it as a server over Linux or
BSD boxes.
Finally, the coffee spilt on my laptop during the Lanetarium has completely killed the touchpad and the keyboard is damaged. Both will need replacement, and I’m getting quotes on this done this week. It will probably cost over 100$, so I’m not terribly happy about it. I’m not taking it to Lanetarium anymore, that’s for sure.
Monday, May 9, 2005
I hate Oracle
It is officially the most retarded thing ever. Very fussy with GROUP BY and doesn’t like LIMIT. I’ve been helping Laska with it the last two days, and it’s stressful. After spending several hours getting queries working on MySQL, we find that Oracle is retarded and doesn’t like most of them.
The main problem is that with
GROUP BY in your SELECT queries, you have to group every column except count(), min(), max(), etc. generated columns. LIMIT in Oracle is done by putting everything in a subquery and use WHERE rownum. For example:
SELECT * FROM (SELECT * FROM oracle_users ORDER BY stress DESC) WHERE rownum <= 5
This would get a list of the top 5 most stressed people in the oracle_users table.
Though it feels great when everything works just as it should. 
Update: The final SQL query came in at 2205 bytes. This is to look up a list of
players teams, then figure out how many games they won and how many they lost, and calculate the difference.