Welcome to my blog!

I am a Software Information Technologist but my interests are not limited to Information Technology. I tried out many things in this area so it is my official profile but I am always ready to learn new things. This is my personal website, which may include many things but it will cover mainly Information Technology, education and any kind of hobby projects. Originally, I created this website to learn Drupal but it will be used for personal purposes in practice as well.

How I built my first solar-powered workstation

Submitted by admin on Thu, 07/28/2022 - 17:41
This article is about how I built my first solar-powered workstation to survive a potential energy-crisis. Price for energy is rising in Europe, electricity is getting more expensive but I'll still have to do my job somehow so, for me, the solution is becoming independent fromĀ public utility network as quickly as possible. Not because it's cheaper, it's not cheaper at all in short term; I consume what I produce with my own utilities and I have to maintain them on my own and maintenance costs extra money. It simply makes me feel more secure that I can continue working even when power is completely out of public network.

How to access Firebird database on localhost without knowing the appropriate user name and password

Submitted by admin on Sat, 11/16/2019 - 17:31
Assume you are a system administrator and you have forgotten your username or password so you have no longer access to your database. You don't have any other access to your database, you cannot reset the SYSDBA user's password because other people or applications are using it and you don't have access to them either but you really need access to certain records quickly. How annoying is that? Luckily, there is a solution for this problem but we also have to assume that we can shut down the database server for a short time.

Linux Bash: creating employee codes from basic personal details

Submitted by admin on Sat, 11/16/2019 - 17:25
Few years ago I wrote a simple bash script to generate employee codes for future project management systems. Now, that the time has come to create a system that must be able to generate employee codes automatically, I realized that it is more elegant to generate employee codes directly with PL/SQL functions so the script has become completely useless. I was going to delete it permanently from my filesystem, but then checked the code and decided to post it here because it is a simple but perfect example of how fast problems can be solved using Linux bash only. Experts can skip this post because probably it will show nothing new for them.

How to install PostgreSQL with Apache 2 and phpPgAdmin on Windows 7

Submitted by admin on Sat, 11/16/2019 - 17:19
Most PostgreSQL database and web developers, who want to make sure their program is completely cross-platform, might have encouthered the problem: PostgreSQL simply does not want to work on Windows 7. Well, it works but installing it properly is not thatĀ matter of course what we first thought to be but it is also not that hard to make it work. In this post, we will cover how PostgreSQL with web components can be installed on a Windows 7 Professional system.

How to create encrypted Windows 7 - Ubuntu dualboot system with DiskCryptor

Submitted by admin on Sat, 11/16/2019 - 16:21
This post will cover how you can create a relatively safe, Windows 7 - Ubuntu dualboot system where Windows partition is encrypted with the free and opensource DiskCryptor program. Since Microsoft does not provide BitLocker on Windows 7 Professional our choice is this 3rd party software.