Date: Sat, 11 Jan 2003 02:25:47 -0800 From: Terry Lambert <tlambert2@mindspring.com> To: Doug Barton <DougB@FreeBSD.org> Cc: freebsd-chat@freebsd.org Subject: Re: Need advice on PHP and MySQL books Message-ID: <3E1FF12B.5390D978@mindspring.com> References: <20030110234309.R12065@2-234-22-23.pyvrag.nggov.pbz>
next in thread | previous in thread | raw e-mail | index | archive | help
Doug Barton wrote: > I know this can become a religious topic, but I'd like to pick up some > books on PHP and SQL, so I thought I'd ask here for advice. I'm currently > considering the following O'Reilly titles: > > Managing & Using MySQL, 2nd Edition > Programming PHP Almost every PHP book deals with MySQL. Find one with examples ou like, and it will cover most of what you care about. If you were asking about, say, building a WebMail client, I'd say there are no good PHP books for that, since there are none that deal adequately with the rendering of MIME-encapsulated data, in to any reasonable level. But database clients, particularly MySQL, are pretty much what you find in great abundance in every single PHP book. I liked: Core PHP Programming and: PHP Essentials well enough to buy both of them. > My ultimate goal is to produce a web-based DNS Management tool with an SQL > back end. You are probably not going to be happy with this, unless you take the data in the MySQL database, and post-process it, to get the DNS configuration files. Specifically, MySQL is a relational database, and DNS is actually a hierarchical database; the mapping works much better from LDAP to DNS (for example), than from MySQL to DNS. Basically, there's an "impedance mismatch". If you intend to derive the configuration files from MySQL data, though, it's rather trivial. Specifically, I've been involved with using Java, Perl, and other CGI code to both modify and generate "reports" that contain DNS configuration data for use by a DNS server, from MySQL stored data, and pretty much anything will work. The only real issue, I'd say, is that now that the MySQL license has changed, you need to worry about L/GPL applied to language bindings for the code, since both Perl and Java are interpreted, and if you mean to use L/GPL'ed language bindings, they are a lot less severable from interpreted languages than they are from other languages. If this is for internal use, you can ignore the GPL, since it only really applies if you distribute the code. -- Terry To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-chat" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3E1FF12B.5390D978>