Category Archives: Databases
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
Laziness. Need for one-click solution (Windows). Need for one-command solution (*nix). OK! 🙂
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.
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
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.
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
Binary way, ignoring repositories, is very favourite and can be reproduced in any other linux distribution…
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.
„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.
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.
Second visit in enterprise level database software area 🙂 What about simple varchar saving in datafile in an IBM flagship? Let´s see!
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….
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
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!
„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…