Author Archives: admin

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

Masivni nahrada MySQL MariaDB v linuxovych distribucich

Posted on 14.1.2014 by admin

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

Muj problem s distribucemi z Francie

Posted on 9.1.2014 by admin

Od poteseneho mruceni k silenemu revu – takto polarizovane se stavim k francouzskym linuxovym pocinum 🙂

Posted in Distributions, Linux | Leave a comment

Alpine pro pouziti s gmail uctem

Posted on 8.1.2014 by admin

V roce 1999 jsem poprve pouzival emailovy klient. Pine – klasika klasik, neochvejny a statecny gladiator…. Alpine (od stejneho vyvojoveho tymu z Washingtonske univerzity) puvodni Pine preprogramovali, opet v C a opet je to nadhera 🙂

Posted in Applications | Leave a comment

Node.js & Yeoman installation on PC-BSD

Posted on 4.1.2014 by admin

My very good friend of mine – let´s call him Tomas Marny – wrote very nice article about Node.js + Yeoman on PC-BSD. I´m very happy to have a chance to publish it:

Posted in BSD | Leave a comment

Antialiasing fontu – Fedora 20 MATE

Posted on 22.12.2013 by admin

„Why does Fedora still have terrible font rendering in 2013?“  – nenajdu lepsi uvodni zvolani.

Posted in Linux | Leave a comment

Oracle Linux 6.5

Posted on 17.12.2013 by admin

V zaplave distribuci je jeden druh, ktery si zaslouzi zvysenou pozornost – „klony“ (nebijte me) RedHat Enterprise Linuxu, ktere jsou zrcadlem a ocaskem teto distribuce (=cislovani stejne, datum vydani radove par dni/tydnu zpozdeni oproti RHEL). Z pomerne skromneho davu je … Continue reading →

Posted in Distributions, Linux | Leave a comment

GUI klienti pro databaze

Posted on 16.12.2013 by admin

SQLPlus, stejne jako DB2 CLI maji sva kouzla, ta obvykle prestavaji fungovat, pokud jsme nuceni textove prostredi pouzivat stale, pripadne neco jineho brzdi efektivitu a moznost par kliky udelat praci za mnoho, mnoho radku.

Posted in Databases | Leave a comment