Archive for the ‘Database’ Category

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 [...]

As I’m sure everyone has heard Oracle has bought Sun Microsystems. As a linux user this could have a very big impact on my everyday computing. Sun produces atleast three products off the top of my head which I use every single day: MySQL, VirtualBox, and Java. There are probably others like Open Office, however [...]

This is part two of my quest to Incorporating Regex into ORM’s and Database Abstractions. My first steps to exploring the option to implement uniform regex support into my own database orm/abstraction is to compare the syntax of the more popular database systems. To do so I will build an sql query where possible to [...]