| CodeIgniter 4 Proposed Roadmap |
(09-16-2016, 03:13 PM)timw4mail Wrote: What are you thinking for the Database Layer? The code is available to look at  Honestly, it will remain similar to how it has been with both PDO and non-PDO drivers. We currently have MySQLi and PostgreSQL drivers implemented. Others will be looked at to see current status, if it's possible to get it actually tested in Travis, etc. PDO has some great benefits, and many frameworks go that route but here's a couple things to consider. Not all PDO versions of the drivers have all of the same features as their non-PDO versions, so you could be missing out if you really need to get down to brass tacks with your database if you're using the PDO version. Granted, it won't crop up much, but discrepencies do exist. Furthermore, what does PDO do? Primarily two things: it provides a consistent way to connect to the various databases. That's it's primary reason for being. A lot of people bring up prepared statements as the reason to use. A number of the non-PDO drivers also support that feature so that's kind of a wash. Either way, the driver that CodeIgniter has always taken care of both of those points with all of the different drivers that it supports. It doesn't do prepared statements exactly, but has always escaped the data to keep it safe. Yes, I know prepared statements are still a bit more secure since the variables are sent in a completely different format than the query itself. Another good thing to be aware of is that use of prepared statements for every call doubles the strain on your database, potentially causing your app's performance to suffer, which is the exact opposite of what prepared statements were intended to do for you. But, that mini-rant aside, we will continue to provide PDO support across a variety of databases for those that prefer to use it. We also now support true prepared statements for those times when you feel the need for speed. |
| Welcome Guest, Not a member yet? Register Sign In |
