2013-08-24

Real-time console based monitoring of PostgreSQL databases (pg_view)

›
In many cases, it is important to be able to keep your hand on the pulse of your database in real-time. For example when you are running a ...
12 comments:
2012-01-22

Schema based versioning and deployment for PostgreSQL

›
I am one of the supporters of keeping as much business logic in the database itself. This reduces the access layer of the application to mo...
5 comments:
2011-10-30

How to remove SIM Card PIN from your GSM/UMTS modem on Ubuntu (Linux)

›
If your GSM modem SIM Card is configured with a PIN a NetworkManager is constantly trying to ask for that PIN on every wake up... and this ...
7 comments:
2011-04-06

Index sizes depending on the type of the field being indexed

›
The sizes of indexes (and tables of cause) are influencing the look up speed directly (the smaller are the corresponding file system files, ...
3 comments:
2011-02-17

pgAdmin III macros: get table fields

›
When writing SQL statements of Stored Procedure code in pgAdmin, it is quite often quite handy to know the names and restrictions on the fi...
2 comments:

Type of NULL is important

›
The following SQL query shows how different can be the result of concatenating arrays with NULL values: select '{e1,e2}'::text[] |...
2 comments:
2010-11-24

Reflecting generic type parameters in Java

›
If you one is introspecting an object class in Java, it was always a problem to be able to find out, what is the actual type of the generic ...
5 comments: