Why am I using XFS?

I must admit I´m really conservative person in many ways. I´m using XFS almost from my linux beginnings, from 2001, when this file system was released for masses 🙂

Continue reading

Posted in Linux | Leave a comment

DB2 data sampling

Sometimes it would be very helpful to have a chance gather sample values. What if rownum limitation affects quality of records? What if the main table logic is residental in the middle of huge table? Welcome to data sampling world 🙂

Continue reading

Posted in Databases, DB2 | Leave a comment

OpenSUSE 13.2, aria2 downloader

Universal (HTTP/HTTPS, FTP, BitTorrent and Metalink) downloader, allowing mixed source protocols in CLI – impossible? Welcome to Aria2 world 🙂 Very short intro, skipping whole documentation and showing friendly software usage.

Continue reading

Posted in Applications, Linux | Leave a comment

OpenSUSE 13.2, PostgreSQL installation (by zypper)

I love linux distributions alpha-releases. They are commonly more stable than any Windows family operating system + provides interesting new features sometimes. OpenSUSE 13.2 Milestone 0 was released 19.3.2014, providing btrfs as default file system, few minor changes and rolling- software repositories. I just wanted to try quick install and quick connection check with PostgreSQL

Continue reading

Posted in Databases, PostgreSQL | Leave a comment

Solaris 11.1 (x86-64) installation in VirtualBox

As mentioned before, I hate dogmas. Very brief information leads to distorted judgments frequently. And it would be really pitty to say 1) Solaris needs SPARC for running and 2) Everything including install is really hard. Well, 2x no 🙂

Continue reading

Posted in Solaris | Leave a comment

PC-BSD 10.0.1 – review

With some unchanging facts – 1) I´m lazy, 2) I want many things working out-of-box on operating sytem levels – the world of BSD is a little bit closed to me 🙂 GhostBSD meets my requirements for many years and I can surely not forget about PC-BSD. Of course in any adventure with BSD you should know development trees of UNIX systems.

Continue reading

Posted in Distributions, Linux | Leave a comment

RHEL 6.5 x64 with CentOS 6.5 repositories

Although it looks weird, there can be reasons why OS should be looking as RedHat and using on background CentOS software updates. Let´s simulate this *tricky* environment 🙂

Continue reading

Posted in Linux | Leave a comment

Basic calculations in Bash

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.

Continue reading

Posted in Linux | Leave a comment

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

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

Continue reading

Posted in Databases, PostgreSQL | Leave a comment

DB2 – column encryption

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.

Continue reading

Posted in Databases, DB2 | Leave a comment

How Firebird 3.0 alpha 2 stores data

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 famous in Czech republic (*facepalm*).

Continue reading

Posted in Databases, Firebird | Leave a comment

Firebird 3.0 alpha 2 installation (Debian 7.3 x64)

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.

Continue reading

Posted in Databases, Firebird | Leave a comment

How PostgreSQL stores data

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 about security on physical layer 😉

Continue reading

Posted in Databases, PostgreSQL | Leave a comment

PostgreSQL 9.3.2 installation (Debian 7.2 x64)

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

Continue reading

Posted in Databases, PostgreSQL | Leave a comment

How MySQL (MariaDB,TokuDB) stores data

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.

Continue reading

Posted in Databases, MySQL | Leave a comment