searching all skype messages on Linux

if you ever need to search skype messages:

sqliteman

the query is "SELECT author, datetime(timestamp, 'unixepoch'), body_xml FROM messages ORDER BY timestamp desc;"

the sqlite file is ~/.Skype/your_user_name/main.db

Might need to stop skype before looking at the file.

inject subroutines at runtime

Creating subroutines on the fly using Symbolic references

how to install DLangIDE on Debian Wheezy

how to install DLangIDE on Debian Wheezy:

 - get the source from here:  https://github.com/buggins/dlangide or

git clone https://github.com/buggins/dlangide.git
cd dlangide
dub run

This will fail with

"
Derelict: cannot load freetype shared library: Failed to load symbol FT_Gzip_Uncompress from shared library libfreetype.so.6
"

or

"
2015-02-23 16:16:06.462 E No font files found!!!
2015-02-23 16:16:06.463 E Currently, only hardcoded font paths implemented.
2015-02-23 16:16:06.463 E Probably you can modify sdlapp.d to add some fonts for your system.
"

or

"
Failed to load symbol SDL_HasAVX from shared library libSDL2.so
"




or

"
SDL_CreateWindow failed - cannot create OpenGL window: No OpenGL support in video driver
"

No worries, will fix them next.

 - set the LD_LIBRARY_PATH to include /usr/local/lib if it does not include it already

export LD_LIBRARY_PATH=/usr/local/lib/:$LD_LIBRARY_PATH

 - install freetype from sources (configure, make, sudo make install) from here http://sourceforge.net/projects/freetype/files/freetype2/2.5.5/

 - install libxext-dev (required by SDL)

apt-get install libxext-dev

 - install libsdl2-dev from wheezy-backports: don't need it since we'll install from sources, but lots of other dependencies will be installed

apt-get -t wheezy-backports install libsdl2-dev

 - install SDL2 from sources (configure, make, sudo make install) from here https://www.libsdl.org/download-2.0.php

 - install ttf-dejavu ttf-dejavu-core ttf-dejavu-extra

apt-get install ttf-dejavu ttf-dejavu-core ttf-dejavu-extra

 - update dependencies

dub upgrade --force-remove

 - edit a file in DLangUI:

find the source for DLangUI in ~/.dub/packages/ and edit the file src/dlangui/platforms/sdl/sdlapp.d :

find the line "ft.registerFonts("/usr/share/fonts/dejavu/");" and add after it this line:

ft.registerFonts("/usr/share/fonts/truetype/ttf-dejavu/");


return to the folder with the sources for DLangIDE and run

dub build --force

and then

dub run

or

./bin/dlangide

and you should get the main window to open

Did not get further today, will update this post if I get into more snags.





To get autocompletion install dcd from http://d-apt.sourceforge.net/ .

format json with Gedit and Perl

How to prettify/format/indent json with Gedit and Perl:

install JSON::XS
go to Plugins and enable "External tool"

go to Tools -> Manage External Tools -> add new (the button in the bottom on the left if no icons are shown)
add a name, for example "Format JSON with Perl"
replace the contents of the text area on the right with

#!/usr/bin/env perl 

use strict;
use JSON::XS;
local $/ = undef;
my $content = <STDIN>;

my $j = JSON::XS->new->utf8->pretty(1);
my $output = $j->encode($j->decode($content));

print $output;

open your file, then Tools -> External Tools -> "Format JSON with Perl"


you can also set a shortcut in the Manage External Tools window

good answer to an internet rant : "Perl already won"

Perl Already Won

readable text by an experienced Perl developer

my perlbrew build options

mostly copied from Debian, as shown by

perl -V


here they are:

perlbrew install -j 5 -Dusethreads -Duselargefiles -Dcccdlflags=-fPIC -Duse64bitint -Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm -Doptimize=-O2 -Duseshrplib perl-5.20.1


"-j 5" thanks to http://www.dagolden.com/index.php/1384/parallel-make-for-perlbrew/

fglrx (AMD proprietary driver) on Debian Wheezy on Athlon 5350 with AM1H-ITX

The open source radeon driver works fine, but if for some reason you want to install the proprietary driver the Wheezy default will not recognize the integrated graphics AMD Radeon HD 8400. Fortunately the version in wheezy-backports does.

Add this line to /etc/apt/sources.list:

deb http://ftp.debian.org/debian wheezy-backports main contrib non-free


then

apt-get update

apt-get install -t wheezy-backports fglrx-driver fglrx-control

aticonfig --initial

reboot

Yes, the reboot is required, the open source radeon driver needs to be blacklisted and the package fglrx-driver apparently does that for you.