Short questions about the v4 compared to v5

[ma2xfr]

Hi There,

What are the main differences between the version 4 and the version 5?

Why did you choose to use mysqli for the version 5?
For my part, it is a limitation. You impose the usage of mysqli whereas some host providers (such mine) do not support this feature. At this end it gives you an additional limitation to install your product compared to the other similar products than your.

Thank you for you advise,
ma2xfr

[wbartels]

I started netjukebox 5 because of:

• Lose compatibility with php 4 and make use of new php 5.2 features.
• Makes use of the getID3() 2.0 library with new features like flac album art support.

New features in netjukebox 5:

• Transcode cache
• Batch transcode
• User statistics
• Seakable stream
• Etc...

I think that MySQLi has the future and it has the same speed as MySQL.

[ma2xfr]

Hi,

It is just to understand your technical descisions. It is not a critique, but what are the advantages of using Mysqli compared to a direct call to Mysql?

Cheers,
ma2xfr

[wbartels]

The way I use it now doesn’t have much advantages.
Maybe prepared statements or object-orientated access to the database could later be used with same MySQLi engine.

Because MySQLi misses the mysql_result function it is easier to translate the code from MySQLi to MySQL than the other way around. As far as I know are all the query’s compatible with MySQL. So if someone really find the need (and the time) to use the older MySQL engine it can be done.

[wbartels]

The way I use it now doesn’t have much advantages.
Maybe prepared statements or object-orientated access to the database could later be used with same MySQLi engine.

Because MySQLi misses the mysql_result function it is easier to translate the code from MySQLi to MySQL than the other way around. As far as I know are all the query’s compatible with MySQL. So if someone really find the need (and the time) to use the older MySQL engine it can be done.

netjukebox 5.05 and up contains a script (tools/mysqli2mysql.php) to convert all MySQLi commands to the MySQL counterparts.