Object oriented DB access

So I'm doing a very low scale project - just a simple blog/template for a guy. PHP5/MySQL5 on Apache.

I had programmed mostly the entire thing without abstracting the database, since I figured this project would be pretty specific to my clients needs, now however... I'm really liking how this turned out and would like to use the backend for my own personal site.

The problem is my personal site is on Postgre.

So my question is... do I dick around with PEAR::DB (does that project even exist anymore?) - or, do I just go through searching query by query and changing them by hand?

So lets get this straight.

You have a site on Postgre. You made a new site on MySQL.

First, lets be clear. Both of the RDMSes are shit.

You want to transition from Postgre to MySQL.

While both are shit, it is very clear that Postgre is superior shit to MySQL.

Additionally you want OOP access to the DB, and you want this with PHP.

PHP is not object oriented. It may be able to do some things in an object oriented way, but that does not make it object oriented.

So what you are asking is stupid and misguided. Stop fucking around with this toy shit and step up to the real world of web applications.

You are at the shit tier. You could go mid-shit tier and go with fucking Java and Orcle for fucks sake. Or you could join us up in the God tier and go with .Net and MsSQL sever.

Or if you insist on being a loonix fag you can still .Net on Mono and at a minimum use Postgre for a DB. Then you can run a real IDE like Visual Studio (even on loonix too for free) and stop fucking around with pumped up text editors like Eclipse and that shit. You will also get all the OOP access to your database, even MySQL shit (but don't run that).

>>17

You really are a fucking idiot. You are one of those fags who thinks they know everything, when in fact you know very little.

The Mono project is .Net on Unix, mainly developed by Novel with support from MS. You didn't even fucking know that. The latest release runs pretty fucking good too.

It is also fucking true that MS SQL > Oracle > Postregre > MySQL.

I am sure your database experience is running a couple related tables and running dynamic SQL queries concatenated from PHP stings. Ohhhh, look at you go girl. You are a fag and doing it wrong.

MS SQL is better than Oracle because it has better features and comes with better tools. It really is that fucking simple.

PHP does try to OOP, but it doesn't fully. Just like you try not to be a fag, but you are anyway.

And yes, Eclipse is shit compared to Visual Studio. Take, for instance, debugging a PHP app vs debugging an ASP.Net app.

Visual Studio:
1. Write app
2. Hit F5

Eclipse:
1. Write app.
2. manually edit your fucking php.ini text file like its 1994.
3. go to the Navigator window and right-click on your PHP project, debugArticle. Select Properties, then click PHP Project Settings. Click Configure Workspace Settings and change localhost appropriately or add the port your Web server is listening on (http://localhost:8080, for example). Click Apply
4. click Run > Debug
5. Select PHP DBG Script on the left-side panel and click New. 6. go to the File tab, and type in your current project, debugArticle, and the file you want to debug
7. go to the Environment tab, then to the Interpreter subtab. Browse for your php.exe file in your PHP install directory
8. click on the Remote Debug subtab, select Remote Debug
9. Set the Remote Source path equal to the absolute path (not the Web path) to the PHP script you're going to test

Eclipse just can't debug shit, you have to fuck around with it for a while to enable that. That is to say that the integration of PHP debugging isn't there, its up to you to do it. That's what makes it a fucking gay ass text editor. Visual Studio is a real IDE, it actually has mechanisms integrated and readily available to do development tasks like debug. Its a fucking INTEGRAATED DEVELOPMENT ENVIRONMENT. If the Development task of debugging is poorly Integrated, then the Environment fucking sucks.

Idiot faggot.