I recently added a cgi-bin programme to my website (see van-maanen.com/cgi-bin/test.py). It allows me to add functionality to the website that cannot be achieved with standard html. Most web servers […]

I worked with Salesforce in recent period. A nice feature of this application is the possibility to send requests via the http protocol. Doing so, one may add data to […]

Salesforce is a CRM application that is build upon a set of data. These data may refer to customers, but is is possible to create your own data structures. These […]

It is possible to trap errors in the loading process. This is handy when we work on a migration project. We simply load a table and trap all possible errors. […]

Oracle has a use that may act as an example user with a series of tables. This example can be used to get acquainted with oracle SQL or data modelling […]

Encrypting in Python can be very easy. Below, a snippet is provided that allows to encrypt data. The code can be found here : However, as the code is simple, […]

I am quite impressed with Azure SQL Server. The DBMS is easy to understand as will be shown below. The problem is how to add data from a local file […]

Below, I provide a snippet to read data from an Azure SQL Server database. Subsequently, it is written to another table in the same database. The trick here is to […]

Below, you find a nice example of an hierarchical query in Oracle. The idea is that you see the top-down hierarchy with some indications on the level that is shown. […]

What is the size of an Oracle table? A very rough approximation is to multiply the number of rows with the average row length in bytes. Fortunately, Oracle directly provide […]