Oracle SQL Fast Retrieval of CLOBS

If a table contains CLOBS, depending on the method you use to connect, usually the CLOB-columns just return a handle that will trigger another connection/query to the database in order to retrieve the value. This makes it really slow. An easy way to speed it up is to retrieve everything which is small enough as string value. A string value however is limited to 4'000 characters. Thus you need to issue two queries:


Import local subversion repository to git

If you want to import a local subversion repository (maybe a dump) to git you can do this quite easily:

First you need to map the Subversion commit authors to Git commiters. For you just create a textfile author-mapping.txt:


And then you run the following commands:


Mangled Names on Synology Diskstation

From time to time I noticed strange filenames on the Synology Diskstation. Names like BGELMF~0. They always had a tilde. Those strange names are called mangled names. Samba has a feature to provide them to bad clients. Unfortunately this can also lead to "renaming" those files.

It is better to prevent this behavior altogether. To do this you need to connect over SSH to your diskstation and then you need to login as root.

Issue the following commands:

cd /usr/syno/etc
vi smb.conf

Now insert the following line in the section global:


Interesting Swiss Maps

They always hide interesting stuff on map.geo.admin.ch. You need to search "somewhere" for additional layers. One nice layer is the Zeitreihen layer because it allows anyone to see the maps from the 80s and 90s. Those maps (1:25'000) have a lot more detail than the ones used today. Today lots of small routes for example inside of forests are not visible anymore.

Check it here: Swiss Map from 1844 till 2012


Backup all MySQL Databases of a User

The following script can be used to backup all MySQL-Databases of a user each in it's own compressed. sql file inside a folder with todays date:


Get a large corpus of text data

I needed to get a large corpus of text data in order to test some full-text-search functionality. Also the text data should not be in one big file but in many small files instead. This lead me to Project Gutenberg and to Wikipedia.

Here is how you can get lot's of data (we exclude the zip from gutenberg because they contain just the other files that are downloaded anyway):


Remove a windows service using the command line

sc [ServerName] delete [ServiceName]


InnoDB Engine not available in MySQL

I had an empty standard installation of MySQL but somehow I could not create a database using the InnoDB engine. The engine was just not activated (you can check that with the



Revisioncontrol with Git

The most fundamental difference between Git and other revision control systems like SVN or CVS is the way how you work with it. With Git you will usually clone a repository. This creates a directory on your desktop where all the data about all revisions is stored. This means that you are not depending on a server somewhere. You can easily just use git locally.



Subscribe to RSS - Misc