Category Archives: Databases

SQSH!

About the only reason I ever boot into Windows on the spare PC nowadays is because I need to use Enterprise Manager or Query Analyser to manage a SQL Server database. Today it was inconvenient to reboot, because I was … Continue reading

Posted in Databases | Tagged , | Leave a comment

How to install ODBC on Linux

I have been looking for a while for a tool to create Entity Relationship Diagrams (ERDs) on Linux. On Windows I used Dezign for Databases, an excellent tool which I would still be using if it was available for Linux. … Continue reading

Posted in Databases, Linux | Tagged | Leave a comment

Neat tricks with Oracle

The task: provide a neat hierarchical tree as a web interface to a project management system where any project might have a variable number of sub-projects. A tree structure in other words. So I ended up with this: ID Project … Continue reading

Posted in Databases, Javascript, PHP, Web development | Tagged , | Leave a comment

Bound to succeed

I’ve been developing websites with PHP for about 5 years now and I blush to confess that I have only just discovered I can use bind parameters with SQL, instead of painstakingly building up my SQL statements by concatenating strings, … Continue reading

Posted in Databases, PHP, Web development | Tagged | Leave a comment