mass migration from mysql?

[Mike Henley]

considering the recent changes to the mysql licensing terms, which
meant the php5 team had to adopt sqlite instead into the php5 and drop
mysql stuff from the standard language distro (as i understand
things)... will there be a mass migration now to something like
postgresql?

[John Smith]

Re: mass migration from mysql?

Mike Henley wrote:[color=blue]
> considering the recent changes to the mysql licensing terms, which
> meant the php5 team had to adopt sqlite instead into the php5 and drop
> mysql stuff from the standard language distro (as i understand
> things)... will there be a mass migration now to something like
> postgresql?[/color]

Short Answer: No, because that is not what has happened.

This rumour/FUD is spreading around the net like wildfire, here's the truth.

- PHP is NOT DROPING MYSQL SUPPORT.
Traditionally PHP came with bundled MySQL drivers in-built, meaning that
even though your box may have the MySQL client librarys for connection,
PHP would just use its own. This is unnecessary bloat, ans subsequently
PHP will no longer ship with its own MySQL drivers/librarys whatever,
but use the ones installed on the system that came with MySQL.


- SQLite is another PHP 'extra'
SQLite is not a client library used to connect to a big database server.
SQLite is the server. The SQLite library reads and writes directly to
and from the database files on disk, which in this case will be through PHP.

Personally I think this is a GREAT idea, especially for a lots of sites
that require just very simple databases, without the need of using a DBMS.

Grant.

[Martin Lucas-Smith]

Re: mass migration from mysql?


[color=blue]
> considering the recent changes to the mysql licensing terms, which meant
> the php5 team had to adopt sqlite instead into the php5 and drop mysql
> stuff from the standard language distro (as i understand things)... will
> there be a mass migration now to something like postgresql?[/color]

I'm also/more interested to know how the migration from mysql to mysqli is
going to be handled. This seems like register_global s and PHP4.1 all over
again.

Perhaps it is time for PHP to get an officially encouraged native
DB-independent driver interface, other than the likes of PEAR-DB/ADOdb, so
that people take DB-independent coding as the norm.


Martin

[Heikki Tuuri]

Re: mass migration from mysql?

Hi!

"Martin Lucas-Smith" <mvl22@cam.ac.u k> kirjoitti viestissä
news:Pine.SOL.4 .44.03082412403 40.14908-100000@yellow.c si.cam.ac.uk...[color=blue]
>
>[color=green]
> > considering the recent changes to the mysql licensing terms, which meant
> > the php5 team had to adopt sqlite instead into the php5 and drop mysql
> > stuff from the standard language distro (as i understand things)... will
> > there be a mass migration now to something like postgresql?[/color][/color]

I have heard that PHP would get a special free license of MySQL.

....[color=blue]
> Martin[/color]

Best regards,

Heikki Tuuri
Innobase Oy

http://www.innodb.com

Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a non-free hot backup tool for MySQL

[matty]

Re: mass migration from mysql?

Heikki Tuuri wrote:
[color=blue]
> Hi!
>
> "Martin Lucas-Smith" <mvl22@cam.ac.u k> kirjoitti viestissä
> news:Pine.SOL.4 .44.03082412403 40.14908-100000@yellow.c si.cam.ac.uk...[color=green]
>>
>>[color=darkred]
>> > considering the recent changes to the mysql licensing terms, which
>> > meant the php5 team had to adopt sqlite instead into the php5 and drop
>> > mysql stuff from the standard language distro (as i understand
>> > things)... will there be a mass migration now to something like
>> > postgresql?[/color][/color]
>
> I have heard that PHP would get a special free license of MySQL.
>[/color]

They're just dropping bundled MySQL support - so you have to
buikd it against the Mysql libs - mysql support is staying in

[matty]

Re: mass migration from mysql?

Louis-Philippe Huberdeau wrote:
[color=blue]
> There is no real problem, from the moment you install MySQL, the
> libraries are installed, all you need to do is specify where they are
> when you compile, it's not really a problem.
>[/color]

Thanks Louis, I'd never have realised that I said that already unless you'd
told me.
[color=blue]
> matty wrote:[color=green]
>>
>>
>> They're just dropping bundled MySQL support - so you have to
>> buikd it against the Mysql libs - mysql support is staying in[/color][/color]