php-general Digest 16 Jul 2006 16:27:08 -0000 Issue 4243
Topics (messages 239512 through 239517):
Re: Zend Studio, phpMyAdmin, and mysql.sock
239512 by: Richard Lynch
239515 by: Tony Marston
239517 by: Kevin Waterson
Re: GD to database directly
239513 by: Richard Lynch
239514 by: Lester Caine
Re: php-head-shrink WAS: Re: [PHP] Zend Studio, phpMyAdmin, and
mysql.sock
239516 by: Jochem Maas
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
On Sat, July 15, 2006 2:05 am, Kevin Waterson wrote:
> Being that these products are commercial in nature, should not they
> be supporting thier own products, rather than relying on the good
> will of the open source/PHP folks for tech support? If we should
> support
> Zend products, why not other commercial applications also?
> Is Zend hoping for volunteer contributions for commercial enterprises?
> Should we support Zend business partners also?
Zend has provided a great deal to the PHP community -- Zend basically
pays Ze'ev and Andi (and more) to work about half their time on
improving PHP Open Source code.
Zend has NEVER expected the PHP General list to provide free support
for their products.
It is inevitable that some people will turn here if Zend Support lags
for whatever reason, for any definition you choose for "lag" -- but
you can hardly blame Zend for that.
--
Like Music?
http://l-i-e.com/artists.htm
--- End Message ---
--- Begin Message ---
""Richard Lynch"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Sat, July 15, 2006 2:05 am, Kevin Waterson wrote:
>> Being that these products are commercial in nature, should not they
>> be supporting thier own products, rather than relying on the good
>> will of the open source/PHP folks for tech support? If we should
>> support
>> Zend products, why not other commercial applications also?
>> Is Zend hoping for volunteer contributions for commercial enterprises?
>> Should we support Zend business partners also?
>
> Zend has provided a great deal to the PHP community -- Zend basically
> pays Ze'ev and Andi (and more) to work about half their time on
> improving PHP Open Source code.
>
> Zend has NEVER expected the PHP General list to provide free support
> for their products.
>
> It is inevitable that some people will turn here if Zend Support lags
> for whatever reason, for any definition you choose for "lag" -- but
> you can hardly blame Zend for that.
>
> --
> Like Music?
> http://l-i-e.com/artists.htm
I have used Zend Studio Professional for just over a year and I have only
ever had two problems which I raised with Zend support, and in both cases
their response was quick and their solution effective. Perhaps in some cases
they do not get back quickly because they are still trying to analyse the
problem, or trying to reproduce it before they can suggest a solution.
I have no complaints with either their product or their support.
--
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
--- End Message ---
--- Begin Message ---
This one time, at band camp, "Richard Lynch" <[EMAIL PROTECTED]> wrote:
> Zend has provided a great deal to the PHP community -- Zend basically
> pays Ze'ev and Andi (and more) to work about half their time on
> improving PHP Open Source code.
As an ex-Zend employee I find that they are maybe the only ones with this
arrangement. It is in the best interest of Zend to have the PHP language
pushed further and (dare I name the beast?) Web 2.0 to be able to push
thier line of products. What good is a PHP IDE without the PHP language?
I am not putting forward some anti <insert commercial application here>
scenario,
but where do folks draw the line?
Kind regards
kevin
--
"Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb contesting the vote."
--- End Message ---
--- Begin Message ---
On Fri, July 14, 2006 9:52 pm, Kevin Waterson wrote:
>
>
>> I'm more concerned about the disaster recovery of a DB from a
>> crashed
>> hard drive, which has been cluttered up with binary data, making
>> data
>> recovery.
>
> One of the greatest benifits of binary DB storage is a single point
> of back up
> mysqldump db_name > backup.sql -u username -p
> It really is as simple as that and no need to bother about referential
> integrity when rebuilding, simple
> mysql db_name < back.sql -u username -p
>
> How much easier does it get?
Assume, for the sake of argument, that your hard drive crashed.
And your backup tape was invalid.
And the weekly backup tape is also invalid.
And, for good measuere, the monthly tape is just so out-of-date, that
recovering from the crashed hard drive actually looks like an
attractive option.
Your images will make this final last stand not viable.
>> Then your field storage size has to be large enough.
>
> LONGBLOB
Not big enough.
If it *WAS* big enough, we wouldn't have the posts here asking why
their monster image didn't work in their database, and got corrupted.
>> Given the number of posts here in PHP-General alone, of people
>> getting
>> tripped up by these things, I have concluded that cramming images
>> into
>> the DB is far more trouble than it is worth.
>>
>> It *seems* like a Good Idea until you actually do it for awhile, and
>> then run into all these snags.
>
> Oddly enough, I have never run into them. Nor has terraserver which
> stores
> hundreds of thousands of images in its db, although not mysql.
You may well have the needed skill set.
Alas, the sheer number of problem posts here would indicate that that
skillset is not the norm.
I'll stop advising against images in the DB when you answer all the
posts here from the problems it causes. :-)
--
Like Music?
http://l-i-e.com/artists.htm
--- End Message ---
--- Begin Message ---
Richard Lynch wrote:
Given the number of posts here in PHP-General alone, of people getting
tripped up by these things, I have concluded that cramming images into
the DB is far more trouble than it is worth.
It *seems* like a Good Idea until you actually do it for awhile, and
then run into all these snags.
Oddly enough, I have never run into them. Nor has terraserver which stores
hundreds of thousands of images in its db, although not mysql.
You may well have the needed skill set.
Alas, the sheer number of problem posts here would indicate that that
skillset is not the norm.
I'll stop advising against images in the DB when you answer all the
posts here from the problems it causes. :-)
Given the right database, then posting raw data to it is not a problem.
I would not classify MySQL as one that one would use or that.
Personally I still use the rather crude database called Windows to store
binary data and live with the backup and crash problems that involves.
Simply because the customers have insisted, and signed to accept that
they know the problems - even after showing how much more stable Linux
is for the server!
At the end of the day, binary data is stored on the disk. Whether it is
stored in a 'proper' BLOB page set with an id in the related record or
direct on the disk with the file name in the record, it still has to be
accessed from the disk in order to use it. None of the existing
OS/Database options provide the ideal solution and it is that which
needs fixing :) - perhaps in another 100 years when Windows has been
replaced with a real operating system ;)
--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php
--- End Message ---
--- Begin Message ---
Paul Scott wrote:
> ------=neXtPaRt_1152981398
> Content-Type: text/plain
> Content-Transfer-Encoding: 7bit
>
>
> My IBM laptop and I are having relationship issues...
I suggest trading her in for a better looking model half her age,
try a Mac Book Pro
;-)
>
> --Paul
>
>
> ------=neXtPaRt_1152981398
> Content-Type: text/plain;
>
> All Email originating from UWC is covered by disclaimer
> http://www.uwc.ac.za/portal/uwc2006/content/mail_disclaimer/index.htm
>
> ------=neXtPaRt_1152981398--
>
--- End Message ---
