Skip to main content
Home
Robert Abraham's Blog

Main navigation

  • Home
  • Educational materials
  • GenPass
  • ReactImages
  • Nemesis Information System
  • About
User account menu
  • Log in
Writing (Free-Photos, www.pixabay.com)

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.
Nemesis Information System - Cover Image

Nemesis Information System

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.
By admin, 8 February, 2023
Big Data Artificial Intelligence | publicdomainpictures.net

Trying ChatGPT on PL/pgSQL

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.

Tags

  • PostgreSQL
  • PL/pgSQL
  • ChatGPT
  • OpenAI
  • coding
By admin, 28 July, 2022
Solar Panels (Vera Kratochvil, www.publicdomainpictures.net)

How I built my first solar-powered workstation

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.

Tags

  • solar-powered
  • workstation
  • notebook
  • laptop
By admin, 28 April, 2022
NIS logo

How to replicate NIS web application between Windows hosts

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.

Tags

  • NIS
  • Replication
  • Database
  • Webserver
  • Backup
  • Restore
By admin, 16 November, 2019
Database (OpenClipart-Vectors, www.pixabay.com)

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

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.

Tags

  • Database
  • Firebird
  • FlameRobin
  • gsec
  • Security
  • Windows
By admin, 16 November, 2019
Linux shell (clarkdonald413, www.pixabay.com)

Linux Bash: creating employee codes from basic personal details

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.

Tags

  • bash
  • Linux
  • script
  • shell
By admin, 16 November, 2019
Database (OpenClipart-Vectors, www.pixabay.com)

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

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.

Tags

  • Apache
  • Database
  • PHP
  • phpPgAdmin
  • PostgreSQL
  • Webserver
  • Windows
By admin, 16 November, 2019
IT security (TheDigitalWay, www.pixabay.com)

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

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.

Tags

  • DiskCryptor
  • Dualboot
  • Encryption
  • Linux
  • Security
  • TrueCrypt
  • Windows

Recent content

  • Trying ChatGPT on PL/pgSQL
    Wed, 02/08/2023 - 19:28
  • How to create encrypted Windows 7 - Ubuntu dualboot system with DiskCryptor
    Tue, 09/06/2022 - 18:19
  • How to install PostgreSQL with Apache 2 and phpPgAdmin on Windows 7
    Tue, 09/06/2022 - 18:17
  • Linux Bash: creating employee codes from basic personal details
    Tue, 09/06/2022 - 18:15

Monthly archive

  • February 2023 (1)
  • July 2022 (1)
  • April 2022 (1)
  • November 2019 (4)

Footer

  • Privacy Policy
  • Cookie Policy
  • About
Powered by Drupal