What I mean by "manually"

We have to specify which DB server, which database and which table for every query. For pages that deal exclusively with one database we can set up the single connection and re-use it.

I know you don't like OO,, but that's how we write our PHP. Since we're using OO programming to interface with an RDBMS, there is an "impedance mismatch". If we had an object/relational database, we could define the objects in the DB and query things much more naturally. So instead of

$db = new objDB( "db_server_1" );\n$sql = "SELECT \n  tbl_user.*,\n  tbl_office.addr1 AS office_addr1,\n  tbl_office.addr2 AS office_addr2,\n  tbl_office.city AS office_city,\n  tbl_office.state AS office_state,\n  tbl_office.zip AS office_zip,\n  tbl_office.phone AS office_phone,\n  tbl_office.fax AS office_fax\nFROM\n  db_user.tbl_user,\n  db_office.tbl_office\nWHERE\n  tbl_user.office_id = tbl_office.id\n  AND tbl_user.id = '$user_id'";\n$db->query( $sql )

we could use

$db = new objDB();\n$db->query( "GET user '$id'")

That's what I mean by "manually".

Since we're using OO programming to interface with an RDBMS, there is an "impedance mismatch". If we had an object/relational database, we could define the objects in the DB and query things much more naturally.

Since you *don't* have an ORDB nor an OODB, perhaps it would make sense to stop trying. IOW, give up on OO so that you are not constantly battling paradigm translation/adaption issues. I suppose your response is that OO is so useful that the translation costs are still worth it. Is OO really that much more useful in your mind that you are willing to spend such translation/adapting costs to have OO? I won't fuss if you say, "yes", I just want to confirm if this is your reasoning for pursuing it despite an admitted translation tax.

Post #61,586 by drewk 11/7/02 9:43:12 AM Reply	What I mean by "manually" We have to specify which DB server, which database and which table for every query. For pages that deal exclusively with one database we can set up the single connection and re-use it. I know you don't like OO,, but that's how we write our PHP. Since we're using OO programming to interface with an RDBMS, there is an "impedance mismatch". If we had an object/relational database, we could define the objects in the DB and query things much more naturally. So instead of $db = new objDB( "db_server_1" );\n$sql = "SELECT \n tbl_user.*,\n tbl_office.addr1 AS office_addr1,\n tbl_office.addr2 AS office_addr2,\n tbl_office.city AS office_city,\n tbl_office.state AS office_state,\n tbl_office.zip AS office_zip,\n tbl_office.phone AS office_phone,\n tbl_office.fax AS office_fax\nFROM\n db_user.tbl_user,\n db_office.tbl_office\nWHERE\n tbl_user.office_id = tbl_office.id\n AND tbl_user.id = '$user_id'";\n$db->query( $sql ) we could use $db = new objDB();\n$db->query( "GET user '$id'") That's what I mean by "manually". === Microsoft offers them the one thing most business people will pay any price for - the ability to say "we had no choice - everyone's doing it that way." -- [link\|http://z.iwethey.org/forums/render/content/show?contentid=38978\|Andrew Grygus]
Post #61,661 by tablizer 11/7/02 1:15:33 PM Reply	inter-paradigm translation costs Since we're using OO programming to interface with an RDBMS, there is an "impedance mismatch". If we had an object/relational database, we could define the objects in the DB and query things much more naturally. Since you don't have an ORDB nor an OODB, perhaps it would make sense to stop trying. IOW, give up on OO so that you are not constantly battling paradigm translation/adaption issues. I suppose your response is that OO is so useful that the translation costs are still worth it. Is OO really that much more useful in your mind that you are willing to spend such translation/adapting costs to have OO? I won't fuss if you say, "yes", I just want to confirm if this is your reasoning for pursuing it despite an admitted translation tax. ________________ oop.ismad.com
Post #61,664 by drewk 11/7/02 1:23:38 PM Reply	Yes === Microsoft offers them the one thing most business people will pay any price for - the ability to say "we had no choice - everyone's doing it that way." -- [link\|http://z.iwethey.org/forums/render/content/show?contentid=38978\|Andrew Grygus]

Welcome to IWETHEY!