Adventures in Computer Programming – bakert@gmail.com
Just completed a fairly painless transition from SQL Server to MySQL. I used the very useful MSSQL2MySQL. No Triggers, Views or any other complicated stuff. In rewriting the SQL itself the only problems I had were with built in functions and the TOP command.
SQL Server to MySQL equivalent functions:
ISNULL => IFNULL (same syntax)
GETDATE => NOW (not CURDATE as that doesn't include the time)
SELECT TOP x => LIMIT x (at the end of the statement not after SELECT)
DATEADD => DATE_ADD
I have updated my actual-web-on-a-mobile program so that it copes with BBC Sport and various other sites better instead of giving an error.
The end result is that you have a text and links-only version of the web that will work on (some) mobile phones.
The program works by stripping all html except links and rewriting all links to point back at this server so those pages can be stripped once the links are clicked too.
You can search google and get the text of actual websites on your mobile without crashing your mobile’s browser or running out of memory here:
You can enter a URL for stripping down to text and links only here:
http://bluebones.net/miniweb/?cmd=url
While you can use this service through your regular browser the reason this exists is for use with mobiles that understand HTML like the Nokia 7250i. You might be able to think of another use for these low bandwidth pages, please let me know if you do.
I’ve put up a snapshot of the source code but if you want the latest please contact me.
Damn, just spent 30 minutes fixing a problem I first had in ASP over three years ago. The FileSystemObject just stops working and no error is reported. Just hangs forever. Then you need to do an iisreset or similar.
The problem is that Norton Anti-Virus’ “Script Blocking” doesn’t allow any use of the FileSystemObject. Even when it is set to “ask me what to do” when it encounters “scripting” it still just hangs. The simple fix is just to disable script blocking. Now I need to remember this for the next time.
I’ve created an alternative tube map with movie writers, editors, producers, actors and directors instead of the usual tube lines and stations, rather like Simon Patterson’s ‘The Great Bear’ only (I think) better .
When trying to understand minimax with alpha-beta pruning I found loads of Computer Science-type material on the web. But very little in the way of practical examples.
Hopefully my java Tic-Tac-Toe game with perfect AI that uses this technique will be useful to someone looking for a practical example.
If you have any questions, please put them in the comments here and I’ll do my best to answer them.
I’ve made my fixture generating code available via a web page for those who don’t want to delve into programming in order to generate a fixture list.
Fixtures Generator (now in PHP as I didn’t want to have to install Tomcat again). Source code.
A minimalist’s guide to Ruby:
"strings", 'strings', :lisplikesymbol
Constant
variable
object.method()
Class::staticmethod()
$global
@instance_var
@@static_var
{ block }
do
alternative_block
end
{ |block, args| at_beginning_of_block }
(1..3)
('a'..'z')
(0...5) # three dots = excludes last
['array', 'jfdlka']
{'hash' => 'dictionary', 'jfsdkal' => 'jfd9'}
/^regexp$/
nil
false
==
=== # if in range
if else end
"concat" << "enate"
check_for_nil.nil?
My new(ish) site, thediaryofanobody.com is still not appearing in Google. Perhaps due to the purported Google Sandbox Effect that penalizes new domains.
To get around this I am also going to link to it off bluebones.net (as that where it truly “is”, anyway. The Diary of a Nobody.
Update 2007-03-21: If all you want to do is generate a fixtures list you can use my Fixtures Generator
I’ve been trying to find out how to generate fixture lists for some time (it is harder than it sounds!) and I finally worked it out thanks to this page about a fixture generating algorithm. My Java implementation of the algorithm is below.
/*
* This code owes an enormous debt to
* http://www.barrychessclub.org.uk/berger2001.htm
*/
import java.util.Arrays;
public class Fixtures2 {
public static void main(String[] args) {
// Find out how many teams we want fixtures for.
int teams = 0;
try {
teams = Integer.parseInt(args[0]);
} catch (NumberFormatException e) {
System.err.println("Please state number of teams as first arg.");
System.exit(0);
}
// If odd number of teams add a "ghost".
boolean ghost = false;
if (teams % 2 == 1) {
teams++;
ghost = true;
}
// Generate the fixtures using the cyclic algorithm.
int totalRounds = teams - 1;
int matchesPerRound = teams / 2;
String[][] rounds = new String[totalRounds][matchesPerRound];
for (int round = 0; round < totalRounds; round++) {
for (int match = 0; match < matchesPerRound; match++) {
int home = (round + match) % (teams - 1);
int away = (teams - 1 - match + round) % (teams - 1);
// Last team stays in the same place while the others
// rotate around it.
if (match == 0) {
away = teams - 1;
}
// Add one so teams are number 1 to teams not 0 to teams - 1
// upon display.
rounds[round][match] = (home + 1) + " v " + (away + 1);
}
}
// Interleave so that home and away games are fairly evenly dispersed.
String[][] interleaved = new String[totalRounds][matchesPerRound];
int evn = 0;
int odd = (teams / 2);
for (int i = 0; i < rounds.length; i++) {
if (i % 2 == 0) {
interleaved[i] = rounds[evn++];
} else {
interleaved[i] = rounds[odd++];
}
}
rounds = interleaved;
// Last team can't be away for every game so flip them
// to home on odd rounds.
for (int round = 0; round < rounds.length; round++) {
if (round % 2 == 1) {
rounds[round][0] = flip(rounds[round][0]);
}
}
// Display the fixtures
for (int i = 0; i < rounds.length; i++) {
System.out.println("Round " + (i + 1));
System.out.println(Arrays.asList(rounds[i]));
System.out.println();
}
System.out.println();
if (ghost) {
System.out.println("Matches against team " + teams + " are byes.");
}
System.out.println("Use mirror image of these rounds for "
+ "return fixtures.");
}
private static String flip(String match) {
String[] components = match.split(" v ");
return components[1] + " v " + components[0];
}
}
Update 2005-06-05: Now allows “complementary teams”, that is – teams that never play at home at the same time as each other. For example, try 10 teams — for each pair from 1 & 6, 2 & 7, 3 & 8, 4 & 9, and 5 & 10, both are never both at home. It was meant to be in the original program but a bug in my code was fouling things up.
Update 2007-03-21: You might also want to see the source code to my PHP fixtures generator
My perfect IDE/text editor has the following features:
To me that doesn’t look an unachievable list but my prime candidates all fall short:
Ultraedit doesn’t have the IDE-defining capability of understanding what the text files it is working on mean, therefore it cannot do Intellisense.
JEdit is too slow and Intellisense support is patchy and from a third party.
Visual Studio is just about there but only supports .NET languages.
IntelliJ IDEA is great, if very large/slow. But it only does Java.
My only hopes are Emacs (which doesn’t feel like a Windows application when running on Windows) and Eclipse (which at least aspires to supporting many languages though it is slow and uninituitive). I will investigate both of these further.
Basically I want Ultraedit (or any other really good text editor) with Intellisense. Or failing that Visual Studio/IntelliJ IDEA with support for all languages. Any suggestions?