Page 1 of 1

Short questions about the v4 compared to v5

Posted: Wed Apr 02, 2008 6:43 pm
by 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

Re: Short questions about the v4 compared to v5

Posted: Wed Apr 02, 2008 11:44 pm
by 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.

Re: Short questions about the v4 compared to v5

Posted: Thu Apr 03, 2008 12:31 am
by 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

Re: Short questions about the v4 compared to v5

Posted: Thu Apr 03, 2008 4:36 pm
by 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.

Re: Short questions about the v4 compared to v5

Posted: Sun Sep 14, 2008 4:09 pm
by wbartels
wbartels wrote: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.