Dead Rising - I’ve been playing this off and on since 2008. This last weekend I made a huge amount of progress, but I might have to start over due to saving when I was almost out of time for a mission. Punishing difficulty, but it’s more fun that way.
Dragon Age - There’s no way I’ll finish before Mass Effect 2 comes out this month, and I like the Mass Effect story more. I suspect this one will be around for a while.
Left 4 Dead 2 - It’s intense, but difficult to get the right people for a good game at expert. Clearly I need a second TV and xbox to put in the family room.
D&D
Just finished a 3 year once a week campaign. My character destroyed the universe. Sorry about that guys.
Started a new campaign as a Binder/Bard based way too closely on Eddie Riggs from Brütal Legend. I know it’s cheep to copy, but it’s fun. Since the world he lives in looks more like the a heavy metal cover from this world his album covers will have folks in offices, staring at computers.
I use Django and Postgres at home, because I use Rails and MySQL all day at work. Working in totally different solutions to the same problem keeps you fresh.
To do this you need both mysql and postgresql running on a local computer.
You probably want this to be a local workstation that you have superuser
access to. We are going to use features in mysql and postgres that makes
the database daemon read and write to local files.
We’ll use django’s schema format deal with the difference between postgresql
and mysql. We’ll use tab separated value (TSV) data files as the
interchange format between databases. Mysql has a different idea of how to
escape newlines and carriage returns than Postgresql so we’ll use a quick and
dirty python script to clean that up.
While this should work in many different OS’s, I did this on a Ubuntu, so
the details might be a bit different.
mysqladmin -uroot create gcd
mysql -uroot gcd < pub_dec21_schema_innodb.sql
unzip pub_dec21_data.zip
mysql -uroot gcd < pub_dec21_data.sql
create django project
django-admin.py startproject grandcomicdb
cd grandcomicdb
chmod +x manage.py
./manage.py startapp gcd
# edit settings.py to add gcd to INSTALLED_APPS
# edit settings.py to set up connection to mysql
./manage.py inspectdb > gcd/models.py
# edit gcd/models.py to make the fk quoted, and add relative_name's
create mysql clean up script
cat >> fix_mysql_tsv.py << EOF
#!/usr/bin/env python
# this will not work for very big files.
import sys
ff = open(sys.argv[1], 'r').read()
ff = ff.replace('\r', '\\r')
ff = ff.replace('\\\n', '\\n')
open(sys.argv[1], 'w').write(ff)
EOF
chmod +x fix_mysql_tsv.py
create postgres database with schema derived from the mysql database
sudo -s -u postgres
createuser gcd --pwprompt --no-createrole --no-createdb
createdb gcd -O gcd
exit
# edit settings.py to set up connection to postgresql
./manage syncdb
create postgres database and load data
sudo -s -u postgres
psql
BEGIN;
COPY gcd_language FROM '/tmp/gcd_dump/gcd_language.txt';
COPY gcd_country FROM '/tmp/gcd_dump/gcd_country.txt';
COPY gcd_brand FROM '/tmp/gcd_dump/gcd_brand.txt';
COPY gcd_publisher FROM '/tmp/gcd_dump/gcd_publisher.txt';
COPY gcd_indicia_publisher FROM '/tmp/gcd_dump/gcd_indicia_publisher.txt';
COPY gcd_story_type FROM '/tmp/gcd_dump/gcd_story_type.txt';
COPY gcd_series FROM '/tmp/gcd_dump/gcd_series.txt';
COPY gcd_issue FROM '/tmp/gcd_dump/gcd_issue.txt';
COPY gcd_story FROM '/tmp/gcd_dump/gcd_story.txt';
COMMIT;
I couldn’t find the simplest example of using Ruby’s SVN bindings. Here’s something simple, get the info on some file in a local working directory.
require 'svn/client'
ctx = Svn::Client::Context.new
ctx.add_simple_provider
ctx.info('some file in your svn working dir') do |path,info|
p path
p info.last_changed_rev
end