Short questions about the v4 compared to v5

Locked
ma2xfr
User
Posts: 8
Joined: Wed Apr 02, 2008 12:45 am

Short questions about the v4 compared to v5

Post by ma2xfr » Wed Apr 02, 2008 6:43 pm

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

User avatar
wbartels
netjukebox developer
Posts: 797
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Re: Short questions about the v4 compared to v5

Post by wbartels » Wed Apr 02, 2008 11:44 pm

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
User
Posts: 8
Joined: Wed Apr 02, 2008 12:45 am

Re: Short questions about the v4 compared to v5

Post by ma2xfr » Thu Apr 03, 2008 12:31 am

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

User avatar
wbartels
netjukebox developer
Posts: 797
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Re: Short questions about the v4 compared to v5

Post by wbartels » Thu Apr 03, 2008 4:36 pm

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.

User avatar
wbartels
netjukebox developer
Posts: 797
Joined: Thu Nov 04, 2004 3:12 pm
Location: Netherlands
Contact:

Re: Short questions about the v4 compared to v5

Post by wbartels » Sun Sep 14, 2008 4:09 pm

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.

Locked