NYCPHP Meetup

[nycphp-talk] Database code solutions

pswebcode, nyc psaw at pswebcode.com
Wed Aug 13 12:36:03 EDT 2003


Alternatively, I found the EZSQL product I mentioned in my previous note to
be a bit "biggie-sized" for a quick job. So, I might suggest this from the
great people at Wrox.

In the book "Professional PHP 4", Chap 17, they build a q quickie class for
PHP to MySQL only. Then give you lots of sample PHP code to execute it with.
You can get the sample code for the entire book from their site Or you can
go to: http://www.pswebcode.com/downloads/ where the only the database class
and all the sample PHP files are zipped.

PSaw


 

-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of pswebcode, nyc
Sent: Wednesday, August 13, 2003 12:22 PM
To: 'NYPHP Talk'
Subject: RE: [nycphp-talk] Database code solutions


Okay. Yeah, the other response was just good  talk. 

But, here is response to your topic.

A php class that does every kind of db access (select, update, etc) (on
every db type: mysql, postgres, oracle) and has it all knocked down to a
couple of terse functions. Lots of documentation too:
http://php.justinvincent.com/

PSaw



-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of Ophir Prusak
Sent: Wednesday, August 13, 2003 12:07 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] Database code solutions



back to the subject, I'm not looking for database management / deisgn /
access type tools, I'm looking for something (classes, packages, products)
that will allow me to concentrate my php programming efforts on the business
logic, and not spend so much time creating the "plumbing" for basic database
operations such as create a new row, edit a row, read a row or delete a row.

phplens is the closest to what I want that I've found so far. Has anyone
here ever used it or heard anything about it ? (other than what's on the
phplens site and the php|arch "review" )

Thanx
Ophir

----- Original Message -----
From: "Cogswell, Eric" <eric.cogswell at innlink.com>
To: <psaw at pswebcode.com>; "NYPHP Talk" <talk at lists.nyphp.org>
Sent: Wednesday, August 13, 2003 10:42 AM
Subject: RE: [nycphp-talk] Database code solutions


I have used NaviCat also, and liked it very much.  Right now, I am using a
product from EMS that I also find very nice.  It has all the standard
features a MySQL GUI needs, is lightweight, and user friendly.  Overall, a
very nice tool.

http://ems-hitech.com/mymanager/index.phtml

-Eric


-----Original Message-----
From: pswebcode, nyc [mailto:psaw at pswebcode.com]
Sent: Wednesday, August 13, 2003 9:28 AM
To: 'NYPHP Talk'
Subject: RE: [nycphp-talk] Database code solutions


On this topic, I have recently been using a product called NaviCat found at
http://www.mysqlstudio.com/

Provides very nice graphical interface on MySQL servers, including
import/export data transfer of tables and/or whole databases from server to
server, backup and user management. Exposes SQL schema code that makes up
tables. Run queries from Query window.

30-day full-functioning demo.

PSaw


-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of Steve Manes
Sent: Wednesday, August 13, 2003 7:44 AM
To: NYPHP Talk
Subject: Re: [nycphp-talk] Database code solutions


Ophir Prusak wrote:
> I'm looking for something that will reduce my development time on
> database related code. I know there are several packages, classes, etc 
> that will help with this, but I don't have time to research all the 
> possibilities and was hoping to hear from nyphp members their 
> experiences and recommendations (or non-recommendations). I'm looking 
> for any solution, commercial or open source.

Hey Ophir,

One thing I've found that dramatically helps me deal with database issues is
a good database design tool to help me visualize what's going on.  I found
something recently that I really like, CaseStudio:

http://www.casestudio.com

After a couple of hours learning the demo Lite version, I bought it. The Pro
version has a reverse engineering feature that logs into an RDBMS and
creates a model from an existing database.  I demoed this as well and found
a couple of things I should have been doing to optimize my digest archive.
Supports MySQL 4 and PosgreSQL 7.x too.

---------------------------------------------=o&o>---------
Steve Manes          http://www.magpie.com
Brooklyn, NY


_______________________________________________
talk mailing list
talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk

_______________________________________________
talk mailing list
talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk
_______________________________________________
talk mailing list
talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk


_______________________________________________
talk mailing list
talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk

_______________________________________________
talk mailing list
talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk




More information about the talk mailing list