Category Archives: Databases

OpenSUSE 13.2, PostgreSQL installation (by zypper)

Posted on 20.3.2014 by admin

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- … Continue reading →

Posted in Databases, PostgreSQL | 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

How DB2 stores data

Posted on 28.1.2014 by admin

Second visit in enterprise level database software area 🙂 What about simple varchar saving in datafile in an IBM flagship? Let´s see!

Posted in Databases, DB2 | Leave a comment

DB2 10.5 install (Debian 7.2 x64) in text mode

Posted on 28.1.2014 by admin

There are 2 options for installing DB2 on linux machine – with GUI setup (Java forever) or in text mode. According praxis, text mode is usable in 100% cases so….

Posted in Databases, DB2 | Leave a comment

How Oracle stores data

Posted on 27.1.2014 by admin

This small article is a reaction for those convincing me that authentication+authorization policy inside database provides you ultimate data protection 🙂 You don´t want to pay for Oracle Advanced Security, you´re not compressing data and you feel that your data … Continue reading →

Posted in Databases, Oracle | Leave a comment

Percona server in Manjaro linux

Posted on 27.1.2014 by admin

Percona  server, „less-known“ MySQL drop-in replacement for enterprises stands for high quality software. Percona is offering a lot and I really do recommend to test it!

Posted in Databases, MySQL | Leave a comment

Grafove databaze

Posted on 26.1.2014 by admin

„Standard“ klasickych SQL databazi narazi na bariery kazdy den – tim, jak velikost a pestrost dat rostou exponencialne, vznikaji pozadavky na ulozeni specifickych dat. Grafove databaze jsou pro me fascinujici uz par let…

Posted in Databases | Leave a comment