Monthly Archives: Únor 2014

Basic calculations in Bash

Posted on 26.2.2014 by admin

Discussion about limits in Excel (15 decimal digits maximum) with my friend caused inspiration for writing few words about basic number magic within Bash command line.

Posted in Linux | Leave a comment

PostgreSQL 9.3 install-by-one-command (Debian 7.4 x64)

Posted on 17.2.2014 by admin

Laziness. Need for one-click solution (Windows). Need for one-command solution (*nix). OK! 🙂

Posted in Databases, PostgreSQL | Leave a comment

DB2 – column encryption

Posted on 11.2.2014 by admin

Column encryption is one of the oldest encryption method in this product, I think deprecated should be the right position in encryption level in these days. Anyway – it can be really handy to use it for storing sensitive data.

Posted in Databases, DB2 | Leave a comment

How Firebird 3.0 alpha 2 stores data

Posted on 10.2.2014 by admin

5th part (Oracle, DB2, MySQL, PostgreSQL) of my series „How xxx stores data“ with an idea of insider (system administrator) who wants to be rich (selling valid credit card numbers). Firebird is excellent RDBM – nevermind it is not so … Continue reading →

Posted in Databases, Firebird | Leave a comment

Firebird 3.0 alpha 2 installation (Debian 7.3 x64)

Posted on 7.2.2014 by admin

I like Firebird software very much, for many years. Development is not as fast as I would like – anyway it is still exceptional RDBM software. Now I´m focused on 3.0 alpha2 version in a linux environment.

Posted in Databases, Firebird | Leave a comment

How PostgreSQL stores data

Posted on 5.2.2014 by admin

4th part (Oracle, DB2, MySQL) of my series „How xxx stores data“ with an idea of insider (system administrator) who wants to be rich (selling valid credit card numbers) 🙂 PostgreSQL is excellent product. Let´s see if they are thinking … Continue reading →

Posted in Databases, PostgreSQL | Leave a comment

PostgreSQL 9.3.2 installation (Debian 7.2 x64)

Posted on 5.2.2014 by admin

Binary way, ignoring repositories, is very favourite and can be reproduced in any other linux distribution…

Posted in Databases, PostgreSQL | Leave a comment

How MySQL (MariaDB,TokuDB) stores data

Posted on 5.2.2014 by admin

3rd part of my investigation how databases stores data in data file / container on disk. Oracle Databse and DB2 proved that plain text for saving tables is common. Let´s see opinion from most spreaded community database.

Posted in Databases, MySQL | Leave a comment

TokuDB installation (Debian 7.2 x64)

Posted on 5.2.2014 by admin

„Pure“ MySQL is dead. Thanks to Oracle approach, thanks to very few inventions in last years (=versions). Among MariaDB there are few other players trying to attract customer. TokuDB is from my opinion the best choice for mature storage engine.

Posted in Databases, MySQL | Leave a comment

DB2 10.5 communication (server<-->client), Debian 7.2 x64

Posted on 4.2.2014 by admin

We have „almost“ fresh DB2 install in our Debian environment, running in VirtualBox. Well, now we want to have this db2 instance as server and client (host) would be connecting into server from some GUI. Few steps are necessary.

Posted in Databases, DB2 | Leave a comment