Articles tagged with #database




6 Things I Learned Moving to PostgreSQL

Let me say before I begin that my move to Postgres has been nothing but great. Syntax wise Postgres is very similar SQL to that you are already familiar with. Feature wise you would probably compare it with an enterprise level database. To add to the good news you probably …



Postgres Gets JSON Type in 9.2

Pretty exciting news that Postgres will be getting a JSON type in 9.2. I have to admit I rarely stray from the standard numeric, string, and timestamps, but this could be very useful. I could see this being used similiar to how some setups serialize php sessions for database …



Return Multiple Result Sets with PHP and PostgreSQL Functions

A while back I discussed how to use the new sqlsrv extension for php to retrieve multiple result sets at a time from stored proceedures. This was indeed helpful when you need to retrieve related data and avoid multiple calls to stored proceedures. The down side is this was using …



Incorporating Regex into ORM's and Database Abstractions

Almost on a daily basis I come across using regular expressions rather convenient. I first toyed with regular expressions in my Compiler Design classes during my undergrad studies, and little did I know they can be used for everyday things like submitting forms. I've even toyed with them to create …