Development #php#mysql 1 min

PHP 5 will no longer ship with native MySQL support

Translation of the original in Catalan. Read it in: CatalàCastellano

Well as the headline says, php5 unlike the previous ones has changed the native support (libraries and such) of MySQL for SQLite.

Because MySQL from version 3.28 onwards has changed the licence to GPL. So that if you want to make an application in which MySQL is used and in the same deliver MySQL you have to deliver your source code too (before it had an LGPL licence). If you still want to use the application with MySQL but don't want to have a GPL licence what you have to do is pay the MySQL licence ( about 1200 ) to MySQL AB.

That's why PHP5 will now support SQLite, which isn't even a database server, it's a library where the whole database is stored in a single file that can take up a maximum of 2Teres.

When it comes to selects it's quite a bit faster than MySQL and POSGRESS but on the other hand when doing inserts it's up to 28 times slower than MySQL, apart from being quite restricted when doing ALTER's (basically it can't).

3 comments

Comments from the old blog, as they were written. Comments are closed.

  1. albertmaaa

    Homaaaa quin mal rollo !!! Pro suposo que sera facil de fer funcionar amb MySql
    no????

  2. —

    [1] Si, de fet no vol dir que PHP5 deixi de conectar-se amb MySQL, sinó
    que ja no serà una conexió nativa, que te la hauràs de
    currar tu a mà, i si ets "legal" (en el sentit més
    jurídic) estas obligat a cedir el teu codi font o comprar la llicencia
    de MySQL per a no cedir el codi.

  3. —

    [2]



    Doncs jo no trobo que sigui una mala idea, així doncs, recolzo aquesta
    iniciativa. Ja que d'algo ha de viure la gent 8)