Category Archives: Databases

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! 🙂

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.

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 … 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.

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 … 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…

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.

Posted in Databases, MySQL | Leave a comment

TokuDB installation (Debian 7.2 x64)

„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

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

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

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

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

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

„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

Masivni nahrada MySQL MariaDB v linuxovych distribucich

Kdysi bylo MySQL pojmem. Kdysi, v dobach MySQL AB. Kdysi byl Oracle pojmem. Aktualne je Oracle pohrebistem skvelych projektu (OpenSolaris, MySQl). Zadumany uvod, v clanku se pokusim zlepsit 🙂

Posted in Databases | Leave a comment