We build information systems that connect clients to databases via a
variety of intermediates. We use Web-browsers based interfaces, but
also Java based interfaces. For web based interfaces our primary
development tools are PHP, Perl and WebObjects. For Java based
interfaces we make heavy use of WebObjects.
Ostadetheater had a set of databases in Access. A lot of the data was
overlapping. We redesigned the database in postgresql and cleaned up
the data. We configured Postgresql so that the data could be reached
via three interfaces:
- Via Access (through ODBC)
- Via a Webbrowser (with a PHP script)
- Via a LDAP interface, so that one could find via eg the Mozilla adressbook or
the Mac OS X Addressbook the adress, E-mail and telephone number of
persons and organisations.
Admin for Small Biz
Admin For Small Biz (ASB) is a JavaClient/Perl project which consists of
A lot of the repetitive tasks (making and printing invoices, VAT
totals, hours per employee etc) are done via perl scripts that run
once a month. For a lot of the overviews a web interface is build with
The database we use at the moment is Postgresql, but before that we
used Access, and then Mysql. The design and interfaces in PHP, Perl
and WebObjects have not changed significantly as caused by the change
- project management: hour administration, deliveries done for a
specific project, different project types etc.
- invoicing: done based on hours,goods and own defined items, with
reminders, overviews etc.
- customer relation management: every contact with relations can be
logged, action items can be added and monitored, contacts can be
defined on function within an organization, seniority, etc.
- centralized contacts database, approachable through LDAP,
WebBrowser and JavaClient.
Van Dale is a Dictionary company. Netsense was asked to build a search
engine for one of their dictionaries via a webbrowser. We implemented
the search engine in Perl and MySQL.
When Van Dale asked to replace the dutch dictionary by an english
dictionary, all we had to do was to define an extra table, and rewrite
the script to make use of the english table in the database.