Firebird instead of MySQL ?

[Lothar Scholz]

Because PHP5 does not include the mysql extension any more is there
a chance that we will see more Providers offering webspace with
Firebird or Postgres Databases ?

What is your opinion ? I must say that i like it to see mysql replaced
by a real database (stored procedures etc.)

[RG]

Re: Firebird instead of MySQL ?


"Lothar Scholz" <llothar@web.de > wrote in message
news:6ee58e07.0 307010041.7a49b 776@posting.goo gle.com...[color=blue]
> Because PHP5 does not include the mysql extension any more is there
> a chance that we will see more Providers offering webspace with
> Firebird or Postgres Databases ?
>
> What is your opinion ? I must say that i like it to see mysql replaced
> by a real database (stored procedures etc.)[/color]


Personal opinion is I would be sorry to see it go.
I've been using it for a few years and am comfortable with it.
I think most will say the same, but then again, this is usenet :)
RG

[Andy Hassall]

Re: Firebird instead of MySQL ?

On 1 Jul 2003 01:41:14 -0700, llothar@web.de (Lothar Scholz) wrote:
[color=blue]
>Because PHP5 does not include the mysql extension any more[/color]

That just means they don't have a _bundled_ MySQL CLIENT library_

Last I saw of the PHP5 bits of the manual, there were significant improvements
in the MySQL extension (the imysql_* functions) and the original mysql_* set of
functions still in the mysql extension; but you have to link against a proper
MySQL client, i.e. at least have the real MySQL client libraries installed
instead of having it come with its own version of the client libraries.

PHP MySQL extension != MySQL client libraries.

Hardly a great inconvenience; probably boils down to just having to specify
--with-mysql=DIR when compiling.

(Unless there's been some other news - writing this offline at the moment so
can't check...)
[color=blue]
>is there
>a chance that we will see more Providers offering webspace with
>Firebird or Postgres Databases ?[/color]

Doubt it'll change that much; particularly given the slow uptake of new 4.x
versions, many providers are way behind - how long will it take to take up
PHP5?
[color=blue]
>What is your opinion ? I must say that i like it to see mysql replaced
>by a real database (stored procedures etc.)[/color]

MySQL has its niche, but it's amazing how much is missing from it compared to
a 'real' database.

--
Andy Hassall (andy@andyh.co. uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[kaptain kernel]

Re: Firebird instead of MySQL ?

>[color=blue]
> Admittedly if I was working in a large team on a large distributed
> application then mySQL would probably have to go in the bin. As per
> usual it's all horses-for-courses.[/color]

so, i guess that Yahoo Finance is just a bunch of homepages so, and isn't a
"large distributed application"... ;-)

http://www.mysql.com/press/user_stories/yahoo_finance.html

[Andy Hassall]

Re: Firebird instead of MySQL ?

On 2 Jul 2003 06:29:42 -0700, llothar@web.de (Lothar Scholz) wrote:
[color=blue]
>But the problem comes with the windows version that a lot of developer
>use before staging to a UNIX system. If you can't bundle the fu**ed
>MySQL Client libraries[/color]

But this is the same point again, isn't it? Why bundle the MySQL client
libraries anyway?

The _MySQL PHP extension_ will be bundled (I haven't seen anything saying it
won't be, yet?), and dynamically linked against the no-longer-included MySQL
client library DLLs.

So you install MySQL for Windows; giving you the MySQL client libraries, add
that to the PATH, and it all links at runtime...

Just means you have to install one more thing; and if you're running it on
Windows and want MySQL access you may well have MySQL installed anyway...
[color=blue]
>because the swedisch became greedy now, this
>will be not possible anymore. So what's now. MySQL was never free -
>because they were going much to far with there linkage definition in
>there license (connecting via a socket and using a protocol is the
>same as linking to a GPL library).[/color]

MySQL hasn't been completely free for a very long time; only for certain
circumstances.

--
Andy Hassall (andy@andyh.co. uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[Matthias Esken]

Re: Firebird instead of MySQL ?

Andy Hassall <andy@andyh.co. uk> schrieb:
[color=blue]
> PHP MySQL extension != MySQL client libraries.[/color]

Oh fine. I got the idea.

Thanks for pointing me the right direction.

Matthias

[Grunff]

Re: Firebird instead of MySQL ?

Harry Slaughter wrote:
[color=blue]
> i don't ever understand where people get this idea that mysql doesn't
> scale. only valid reason for switching to something like Oracle (at
> least that i've ever seen) is to please investors. yes, mysql doesn't
> offer some of the features of bloatware dbs. in theory this is a
> limitation; in practice, it's normally moot.[/color]

While I love mysql dearly and use it for 80% of all my
development, there are some things which make me switch to other
dbs for some projects.

The main missing functionality is stored procedures, and more
importantly nested queries.

--
Grunff

[lawrence]

Re: Firebird instead of MySQL ?

Andy Hassall <andy@andyh.co. uk> wrote in message[color=blue][color=green]
> >is there
> >a chance that we will see more Providers offering webspace with
> >Firebird or Postgres Databases ?[/color]
>
> Doubt it'll change that much; particularly given the slow uptake of new 4.x
> versions, many providers are way behind - how long will it take to take up
> PHP5?[/color]

Agreed. I find any code I write needs to check for old vars like
$HTTP_POST_VARS as well as new ones like $_POST. I'm often surprised
how many hosting companies still use pre 4.1 PHP.

However, SQLlite is being bundled into PHP 5. Isn't this a clear
indication that the PHP dev team expects SQLlite to eventually replace
MySQL as the database that beginners expect to use with PHP?

Any way, I'd be damn happy to see PostGreSQL replace MySQL as the most
ubiqitous database in the PHP world. MySQL DOES NOT scale, as Tim
Perdue pointed out a long time ago on PHPBuilder, and PostGreSQL has
grown surprisingly fast.

[lawrence]

Re: Firebird instead of MySQL ?

ng4rrjanbiah@re diffmail.com (R. Rajesh Jeba Anbiah) wrote in message[color=blue]
> Agreed that SQLite will dominate in the near future. My
> experience with MySQL is: MySQL is not good for big sites--I have
> coded one PPC site in which MySQL started bugging "too many
> connections". BTW, I couldn't accept the domination of PostGreSQL as
> it's slow compared to MySQL.[/color]

But, again, on large sites PostGreSQL is faster. It handles more
simultaneous connections than MySQL. Again, Tim Perdue's articles on
PHPBuilder were informative on this matter.