Trent Richardson

The web is a global resource for anything, anywhere, any timezone. But often times we are careless in consideration for people in other areas of the world. The different timezones offset people’s schedules from one area to the next. When handling user profiles (or anything for that matter) where date and time is involved we [...]

I thought of another handy scenario for using regular expressions in Postgres. This time not within the conditions, but in the returned results. Lets say for instance you have a column with URL, (maybe blog comments or something) and you would like to get a list of all the domain names, not the full paths [...]

I was playing with cake and postgresql when I decided I needed to do a search. Sure a classic ‘%’ search would have been sufficient, but we all know I love using regular expressions in sql. Well come to find out it doesn’t seem that CakePHP likes PostgreSQL’s syntax when using its native conditions, so [...]

A few posts ago I explained how you can connect Ubuntu to SQL Server for PHP. All worked well until you tried to execute stored procedures. (It worked fine if you wrote the query, but not so much with mssql_execute() function). It would result in an error like this: Warning: mssql_execute() [function.mssql-execute]: stored procedure execution [...]

I don’t prefer using an ODBC datasource, but sometimes it is the easiest way to gain access to a database. Often times when using frameworks(php, not sure about others) an odbc option is available, however who knows if it will deliver sql compatible with the database we’re trying to gain access to. I’ll base this [...]