MySQL or MySQLi

[el_jentel1]

Just curious, are you using MySQL or MySQLi? (provide reason, if any)

 

[Royal King]

Mysql .

 

[SuicidalMedia]

I'm using MySQL, but my friend told me that MySQLi is faster than MySQL.

 

[Danny1986]

MySQL here too.

 

[mmuyskens]

Why isn't MSSQL an option :D

+1 for MySQL

 

[litewarez]

MySQLi is good tbf, personally i dont use it because i tend to built my database abstraction layers myself around MySQL but for simple applications i would go with mysqli

but for larger applications where you have query caching etc i think overall it much easier to go with the stranded version

Why improve something that dont need improving!

 

[Bread]

MYSQLi came with my xampp package :P

 

[Storm]

i use mysql ^^

 

[djeuro]

mssql 2000 and 2005 respect... been using those for gave servers for yearssss

 

[Angeix]

Mysql is great,

But MysqlI is a improved much faster framework.

 

[deFiant]

I use MYSQL too.

 

[ScopeHosts.Sales]

hi,

MySQLi is still new and vulnerable . Its better to say on the mySQL . Till the mySQLi gets improved with security point of view.

 

[JmZ]

MySQL Lib is old, it shouldn't be chosen over MySQLi in any circumstances really.

MySQL Lib = old & lacks new functionality
MySQLi = new & restricted to MySQL
PDO = new & works on almost any DB

So you should generally use PDO over anything for portability.

Though half of you probably don't even know PDO exists.

I never use the mysql or mysqli libraries in my code now, it'd be an illogical decision to do so when you can have complete portability with PDO. You can code your script to use PDO so if you ever switch DB, you only change the connection, not the queries.

 

[taxidiver]

MySQL. Thanks for the details.

 

[Golden Falcon]

I use whatever default the software itself recommends, this way your sure to have the best experience

 

[duality99]

i use mysql but mysqli is faster.