Database

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.

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.