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.
Featured project: Nemesis Information System (NIS) is a business management system and webshop engine with lots of useful features in the e-commerce area. The target audience of this system is mainly small companies, who need a fast and easy solution for building a website and/or a simple business management system for basic tasks, but it may also be useful for home users, who need a smart application for managing business of their household.
I was curious about how ChatGPT can generate code so I tried it out on PL/pgSQL for PostgreSQL. Here's what we got after a few iterations.
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.
This article will cover how you can replicate Nemesis Information System's web application between 2 or more Windows hosts keeping all of your data in the database and your entire configuration applied on the web application.
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.
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.
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.
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.