Django change the database backend.

Dec. 22, 2016, 8:37 a.m. odo , python , django , sqlite , mysql

In theory if you use django, changing your RDBS from say sqlite to mysql is a breeze. All you need is generate a dump of your existing data with ./manage.py dumpdata, change settings.py and do ./manage.py migrate on the new server. Then you can import the previously exported data through ./manage.py ...

using SQL Server

Dec. 17, 2016, 1:03 a.m. heidisql , sql-server , winetricks , wine , DBeaver

sqlcmd sucks, so I thought to try out VS Code to connect to the sql server. Unfortunately I had to upgrade my Linux Mint Version due partly to inistallation conflicts with sqlcmd on it. But what do I get when I try to run the sql-server extension on VS Code? Failed to load sql tools service Thi ...

Mint Upgrade

Dec. 15, 2016, 1:33 p.m. mint , vim , gvim , python

I hate updating my OS, but this time I had no choice but to go ahead with it because so many package conflicts are appearing speciallly when using Oracle and SQL Server clients on Mint 17.3 (Ubuntu 14.04). In the old days upgrading mint was particularly diffcult becaus it doesn't have the 'd ...

SQL Server on Linux

Dec. 13, 2016, 3:48 p.m. sql-server , microsoft , docker

Right, it's been more than 15 years since I last opened a connection to a M$ SQL Server. I thought I would have another crack at it since Mircrosoft has embracced open source in general and linux in particular. I setup sql server on my linux machine using the official docker image provided by mi ...

Asp.Net in 24 hours.

Dec. 7, 2016, 1:10 a.m. csharp , asp.net , django

Now it's time for the die hard Django fan to learn ASP.Net. Once upon a long ago, around the time that Asp.Net was born I worked with a guy who had practially every single M$ certificate they had on offer at the time. We were constantly arguing about which is better PHP or ASP. Those days PHP wa ...

C# in 24 hours

Dec. 6, 2016, 12:33 a.m. csharp , dotnet , vs code

What the hell am i doing with c#? What the hell is microsoft doing on github? When Visual Studio Code was announced for linux, I was more than sceptical. I soffed and folks who tried it out. But now here I am having a crack at it myself. Right now I am on holiday at my sister's place in the hill ...

Predictability of tournament results based on ratings.

July 28, 2016, 6:51 a.m. KOTH , Scrabble , Pairing

This is a part of a series of articles on the King Of The Hill Pairing System and it's use at Scrabble tournaments. King Of The Hill or KOTH for short is a strict 1 plays 2, 3 plays 4 , 5 plays 6 pairing system commonly used at the last few rounds of a Scrabble tournament. It allows repeats. In ...

When should top players meet in a tournament?

July 13, 2016, 6:28 a.m. scrabble , chess , swiss , dutch

In any sport, if the top players play against each other during the early stages of the tournament some of them will be knocked out or be out of contention for any of the prizes. Almost all chess tournaments involving a large number of players are carried out using the swiss pairing system. If we ta ...

Average points scored in a game of Scrabble.

July 11, 2016, 5:21 a.m. Scrabble , KOTH , Pairing

What is a good score in a game of Scrabble? Nigel Richards averages 462.54 in international tournaments. He has gone past 400 points 84.41% of the time. Craig Beavers averages 438.59 and has gone past 400 points 73.34% of the time. Mind you these are international tournaments where they wo ...

Buchholz score as a measure of fairness of the draw.

July 5, 2016, 5:17 a.m. chess , scrabble , buchholz , KOTH

Average Ratings of Opponents, the Buchholz and Sonneborn-Berger System are some of the methods recommended by FIDE for breaking ties in Chess tournaments. In a Scrabble tournament, a tie is virtually unheard of. However Buchholz and Average Ratings of Opponents provide an excellent method of evaluat ...

Fairness of KOTH pairing.

July 4, 2016, 7:15 a.m. KOTH , Pairing , Scrabble

This is part 3, in a series of posts on KOTH pairings. The analysis is carried out using the results of the Age Group Scrabble Championship 2015.. The tables on this post can be recreated by web scraping the contents of the above link. The fairness of the draw can be calculated based on three differ ...

Analysis of Pairing Systems : Definition of Terms.

June 30, 2016, 4:44 a.m. KOTH , Scrabble , Pairing

This the continuation of a series of articles that analyses the King of The Hill pairing system. Before we get to the analysis proper, we need to get some definitions out of the way. KOTH The King Of The Hill Pairing system, which is a strict 1 plays 2, 3 plays 4 .. (2n-1) plays 2n pairing system. S ...

King Of The Hill Pairing System - An Analysis.

June 28, 2016, 5:41 a.m. scrabble , pairing , KOTH

The King Of The Hill pairing system is one where the “Top ranked plays second, third plays fourth, etc. Usually used for the last round(s) of the tournament” (NSA 2008, p53) “KOTH pairings are often used in the final round(s) of a tournament to ensure that contenders face each othe ...

A dilapidated Scrabble Power House

June 26, 2016, 1:40 p.m. scrabble

What does the 2003 UK Scrabble Champion and the 2005 Australian Scrabble Champion have in common? They are both of Sri Lankan origin.  For good measure Naveen Fernando won the Australian title again in 2010.  Before that he had won the Gulf Championship. Ancient history ...

Sending Google Cloud Notifications with python and XMPP

May 2, 2016, 1:31 p.m. python , android , xmpp , xmpppy , gcm , ccs

Trouble with running Google's sample script for python CCS? You need to update to you xmppp libraries as follows ...

Updrading Postgresql 9.3 to 9.5 with Postgis.

April 29, 2016, 6:21 a.m. postgis , postgresql , pg_dump

encodings for database "postgres" do not match:  old "UTF8", new "SQL_ASCII"   can be overcome by using /usr/pgsql-9.5/bin/initdb -E 'UTF-8' 9.5 as mentioned in the manual. When you run pg_upgrade, you must provide the following information: &nbsp ...

Modified round robin pairing.

Feb. 2, 2016, 6:34 a.m. scrabble , chess , round robin , pairing , python

Do you want to organize a tournament where the pairing system is round robin but some players need to play against other players at a specific time? This gist is what you are looking for.   On friday evening, I got a call from the tournament director of the Scrabble league, asking if I could write a bit of code .. ...

Wifi with Qualcomm Atheros Device [168c:0042] (rev 30) on Linux Mint

Jan. 8, 2016, 6:45 a.m. wifi , ath10k , mint

Having trouble with an Atheros wifi device on linux? Here's how to fix it. ...