Today I’ll be connecting to a Postgres database for the first time. I’m used to mySQL but I hear they’re basically the same when it comes down to functionality. I’ve already started working on an AJAX based property search with some sample data, so I just have to take my code off of dev.urbiance and hook it into our server.
I’m also a virgin to remote databases, it looks like the connection is working – but I haven’t queried or echoed anything yet. So far I’ve got a Javascript price slider, city selector and zip code input which send an XMLHttp request to a php page, query the property table and send the response text back into a div. Going for a completely object-oriented code structure here, wish me luck. I’ll be updating my progress and snippets along the way here on my blog.
Happy remote coding, Antonio
