I mention MySQL because I remembered during the post that it was providing the data I was looking at.
PostgreSQL an object-relational DBMS which supports almost all SQL constructs, including subselects, transactions, and user-defined types and functions. MySQL now supports transactions with the Berkely and Inno DB table structures, but you still can't use subselects functions, and user-defined types.
Python is a very clean OOP language with an XML fetish. And I say that in an ultimate compliment kind of way. PHP is a scripting language, although it certainly has support for OOP and XML (through expat or Sablotron).
Why the discrepancy in popularity?
I think the reason that MySQL is used in more instances than PostgresSQL is because of its ease of use. Most sites use a DB for login and registration. PostgreSQL is not necessay for these transactions. However, if you have a more db-intensive site, you will miss subselects and stored procedures (in the same way you would miss your thumbs!).
The same is true of PHP. You can go from HTML to JavaScript to PHP very, very quickly. And then, as you mature as a programmer, PHP will still take care of you. If you move from an OOP environment, however, Python would probably be your first choice.
Is Microsoft secretly funding PHP and MySQL? Without any proof one way or the other, I'm going to say 'no'. I might even go so far as to say you had a legitimate, if oft-repeated, point that you diluted with unsubstantiated, unlikely, irrelevant conspiracy-theorist nonsense.
So lets leave on a combative note, shall we? SAP DB is the most hardcore commercial DB and Ruby is the most elegant open-source OOP language!
Re:MySQL
Posted by: DCallaghan on July 07, 2002 05:16 AMPostgreSQL an object-relational DBMS which supports almost all SQL constructs, including subselects, transactions, and user-defined types and functions. MySQL now supports transactions with the Berkely and Inno DB table structures, but you still can't use subselects functions, and user-defined types.
Python is a very clean OOP language with an XML fetish. And I say that in an ultimate compliment kind of way. PHP is a scripting language, although it certainly has support for OOP and XML (through expat or Sablotron).
Why the discrepancy in popularity?
I think the reason that MySQL is used in more instances than PostgresSQL is because of its ease of use. Most sites use a DB for login and registration. PostgreSQL is not necessay for these transactions. However, if you have a more db-intensive site, you will miss subselects and stored procedures (in the same way you would miss your thumbs!).
The same is true of PHP. You can go from HTML to JavaScript to PHP very, very quickly. And then, as you mature as a programmer, PHP will still take care of you. If you move from an OOP environment, however, Python would probably be your first choice.
Is Microsoft secretly funding PHP and MySQL? Without any proof one way or the other, I'm going to say 'no'. I might even go so far as to say you had a legitimate, if oft-repeated, point that you diluted with unsubstantiated, unlikely, irrelevant conspiracy-theorist nonsense.
So lets leave on a combative note, shall we? SAP DB is the most hardcore commercial DB and Ruby is the most elegant open-source OOP language!
#