PHP is the VB of Linux

[Pham Nuwen]

Re: PHP is the VB of Linux

127.0.0.1 wrote:
[color=blue]
> Pham Nuwen wrote:
>
>[color=green][color=darkred]
>>>Not to mention the incredibly horrible vacuum cleaning in PG which
>>>makes Postgress a complete horror in large scale databases anyway.[/color]
>>
>>What is so horrible about it? I don't have any troubles with it, and
>>I have tables with 1.5 Million rows.[/color]
>
> Does the content of those tables change frequently, and do you have any
> tall skinny tables ?[/color]

Much to my dismay. It changes frequently and is skinnier than all get
out. (4 columns) There is a dba (and I use the term loosely here) out
there who should be shot over this table amongst others.

--
/---+----+----+----+----+----+----++----+----+----+----+----+----+---\
I pham.nuwen3d6@l ibertydice.org II No nation was ever ruined by I
I http://www.libertydice.org II trade, even seemingly the most I
I remove "3d6" to e-mail II disadvantageous . - Ben Franklin I
\---+----+----+----+----+----+----++----+----+----+----+----+----+---/

[Pham Nuwen]

Re: PHP is the VB of Linux

Gerhard Fiedler wrote:
[color=blue]
> On Sun, 12 Oct 2003 15:03:05 GMT, Pham Nuwen wrote:
>[color=green]
>>Not really, and anything it loses in speed, trust me it more than makes
>>up in functionality, and reliability.[/color]
>
>
> When I did some research regarding the choice between MySQL and
> Postgre, the major downside for Postgre was that some claimed
> experineces of crashes and data loss, something that seems not to
> happen with MySQL. For me, that was a major turn down (after all,
> before features comes data in a data base). Do you have any comments
> on that?[/color]

I've never had any problems with it. For what it's worth, I store
medical data in postgresql, and I wouldn't do that if I had any concerns
about it's reliability.

--
/---+----+----+----+----+----+----++----+----+----+----+----+----+---\
I pham.nuwen3d6@l ibertydice.org II No nation was ever ruined by I
I http://www.libertydice.org II trade, even seemingly the most I
I remove "3d6" to e-mail II disadvantageous . - Ben Franklin I
\---+----+----+----+----+----+----++----+----+----+----+----+----+---/

[Google Mike]

Re: PHP is the VB of Linux

Gerhard Fiedler <me@privacy.net > wrote in message news:<5hglovsdv c2oevl25hk0msek f2f6vhasas@4ax. com>...[color=blue]
> On 13 Oct 2003 06:58:11 -0700, Google Mike wrote:[color=green]
> >About the only thing that was a bummer for me was the odd
> >case-sensitivies with MySQL when accessing via PHP.[/color]
>
> Can you expand a bit on that? I haven't seen anything like this (and
> would like to know before I start chasing something else in case it
> happens to me :)[/color]

Gerhard, you'll probably experience it. I did. I was having very odd
problems at first when working with PHP and MySQL. I was getting
replies that told me that my query worked, but that I could not
extract values from the associative array that was returned. The
reason in this case was because the SQL SELECT statements I was using
had lowercase field names, rather than specifying something like
asterisk (*). Then, when I tried to access the result as in
$myrow['FIRSTNAME'], it would fail unless I switched it to
$myrow['firstname']. I also found that, for some reason, I have to
have a FROM clause in my SQL statement that specifies my table names
exactly as they are specified in the database. So, I had to use
'Logins' and 'LOGINS' or 'logins' would not work in the FROM clause
without error. I don't know why this is, but I gave in and just gave
PHP's MySQL connector, and/or MySQL, whatever it wanted by switching
the case around until my code worked.

[Zurab Davitiani]

Re: PHP is the VB of Linux

Google Mike wrote on Monday 13 October 2003 21:09:
[color=blue]
> Gerhard, you'll probably experience it. I did. I was having very odd
> problems at first when working with PHP and MySQL. I was getting
> replies that told me that my query worked, but that I could not
> extract values from the associative array that was returned. The
> reason in this case was because the SQL SELECT statements I was using
> had lowercase field names, rather than specifying something like
> asterisk (*). Then, when I tried to access the result as in
> $myrow['FIRSTNAME'], it would fail unless I switched it to
> $myrow['firstname']. I also found that, for some reason, I have to
> have a FROM clause in my SQL statement that specifies my table names
> exactly as they are specified in the database. So, I had to use
> 'Logins' and 'LOGINS' or 'logins' would not work in the FROM clause
> without error. I don't know why this is, but I gave in and just gave
> PHP's MySQL connector, and/or MySQL, whatever it wanted by switching
> the case around until my code worked.[/color]

http://www.mysql.com/doc/en/Name_case_sensitivity.html

--
Business Web Solutions
ActiveLink, LLC

https://www.active-link.com/intranet/

[Tim Tyler]

Re: PHP is the VB of Linux

Google Mike <googlemike@hot pop.com> wrote or quoted:
[color=blue]
> So, newbies, if you are looking for the "VB" in Linux, look no further
> than PHP. It has matured.[/color]

Likening PHP to VB may be appropriate - but it is *NOT* a compliment!
--
__________
|im |yler http://timtyler.org/ tim@tt1lock.org Remove lock to reply.

[Google Mike]

Re: PHP is the VB of Linux

Tim Tyler <tim@tt1lock.or g> wrote:[color=blue]
> Likening PHP to VB may be appropriate - but it is *NOT* a compliment![/color]

My point is that I can used to get a lot done really fast in VB, and
now that I don't want to be on Windows for my development anymore, PHP
is something where I can knock out web business app projects really
fast. I believe I can knock them out much faster than JSP, Python,
Perl, etc.

[Gerhard Fiedler]

Re: PHP is the VB of Linux

On 13 Oct 2003 21:09:03 -0700, Google Mike wrote:[color=blue]
>Gerhard, you'll probably experience it. ...[/color]

Oh... :) As Zurab commented, MySQL is case-sensitive on Linux for
example. When doing development on Windows and deploying on Linux,
that can be an issue, as you might notice a typo only on the server.

I'm used to programming in case-sensitive environments and tend to
maintain the case even in case-insensitive ones, but typos of course
may happen. Thanks for following up.

[Gerhard Fiedler]

Re: PHP is the VB of Linux

On Mon, 13 Oct 2003 16:13:05 GMT, Pham Nuwen wrote:[color=blue][color=green]
>> When I did some research regarding the choice between MySQL and
>> Postgre, the major downside for Postgre was that some claimed
>> experineces of crashes and data loss, something that seems not to
>> happen with MySQL. ...[/color]
>
>I've never had any problems with it. For what it's worth, I store
>medical data in postgresql, and I wouldn't do that if I had any concerns
>about it's reliability.[/color]

Thanks for following up. Collecting experiences... Postgre is
definitely more attractive from a programmer's point of view :)

[Google Mike]

Re: PHP is the VB of Linux

Zurab Davitiani <agt@mindless.c om> wrote[color=blue]
>
> http://www.mysql.com/doc/en/Name_case_sensitivity.html[/color]

Gosh, Zurab. Thanks. That explains why that occurred.

[MrNod]

Re: PHP is the VB of Linux

googlemike@hotp op.com (Google Mike) wrote in message news:<25d8d6a8. 0310140703.6f53 fae2@posting.go ogle.com>...[color=blue]
>
> My point is that I can used to get a lot done really fast in VB, and
> now that I don't want to be on Windows for my development anymore, PHP
> is something where I can knock out web business app projects really
> fast. I believe I can knock them out much faster than JSP, Python,
> Perl, etc.[/color]

Thanks for your post googlemike - very interesting thread. I'm at a
point where I'm about to start a new project and the choice is either
VC.NOT or PHP. Professionally I use Java & JSP, but this new project
is non work related and I want to avoid Java like the plague because
of the hassles you explained earlier.

I'll seriously look at using PHP & Postgres now :)