• 3 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CodeIgniter 4 Proposed Roadmap

#54
(09-16-2016, 04:13 PM)timw4mail Wrote: What are you thinking for the Database Layer?

Right now it's kind of a mess, with a lot of outdated drivers.

It seems like the best course of action would be to use PDO as the starting point, and add back drivers around that.

At the very least, you're going to have to remove the original mysql driver, as the mysql_ family of functions is finally gone from PHP 7.

The code is available to look at Smile

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.
Support Development  • Practical CodeIgniter 3  • Vulcan - CLI Tools for CI4


Messages In This Thread
CodeIgniter 4 Proposed Roadmap - by kilishan - 08-05-2015, 09:33 AM
RE: CodeIgniter 4 Proposed Roadmap - by skunkbad - 08-05-2015, 10:50 PM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 08-05-2015, 11:43 PM
RE: CodeIgniter 4 Proposed Roadmap - by marksman - 06-13-2016, 11:24 AM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 08-07-2015, 09:13 PM
RE: CodeIgniter 4 Proposed Roadmap - by sv3tli0 - 08-08-2015, 08:01 AM
RE: CodeIgniter 4 Proposed Roadmap - by akharraz - 08-12-2015, 11:15 AM
RE: CodeIgniter 4 Proposed Roadmap - by peterdenk - 08-13-2015, 04:41 AM
RE: CodeIgniter 4 Proposed Roadmap - by sv3tli0 - 08-16-2015, 12:11 AM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 08-16-2015, 08:30 PM
RE: CodeIgniter 4 Proposed Roadmap - by sv3tli0 - 08-16-2015, 10:59 PM
RE: CodeIgniter 4 Proposed Roadmap - by peterdenk - 08-17-2015, 12:49 PM
RE: CodeIgniter 4 Proposed Roadmap - by CroNiX - 08-17-2015, 05:51 PM
RE: CodeIgniter 4 Proposed Roadmap - by apsweb - 08-18-2015, 07:18 PM
RE: CodeIgniter 4 Proposed Roadmap - by peterdenk - 08-19-2015, 04:49 AM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 08-19-2015, 08:49 PM
RE: CodeIgniter 4 Proposed Roadmap - by sepehr - 08-29-2015, 03:44 AM
RE: CodeIgniter 4 Proposed Roadmap - by Vimal - 09-01-2015, 06:35 AM
RE: CodeIgniter 4 Proposed Roadmap - by pravmahe - 09-18-2015, 03:09 AM
RE: CodeIgniter 4 Proposed Roadmap - by musheertm - 09-17-2015, 01:31 PM
RE: CodeIgniter 4 Proposed Roadmap - by Muzikant - 09-18-2015, 06:36 AM
RE: CodeIgniter 4 Proposed Roadmap - by ahmed - 10-06-2015, 12:50 PM
RE: CodeIgniter 4 Proposed Roadmap - by condor - 10-12-2015, 12:41 PM
RE: CodeIgniter 4 Proposed Roadmap - by mlantz - 10-26-2015, 12:41 PM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 10-26-2015, 01:43 PM
RE: CodeIgniter 4 Proposed Roadmap - by sv3tli0 - 11-30-2015, 02:02 AM
RE: CodeIgniter 4 Proposed Roadmap - by kenjis - 11-30-2015, 02:01 PM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 11-30-2015, 09:29 AM
RE: CodeIgniter 4 Proposed Roadmap - by sv3tli0 - 11-30-2015, 11:31 PM
RE: CodeIgniter 4 Proposed Roadmap - by kenjis - 12-02-2015, 12:32 AM
RE: CodeIgniter 4 Proposed Roadmap - by sv3tli0 - 12-02-2015, 01:29 AM
RE: CodeIgniter 4 Proposed Roadmap - by kenjis - 12-02-2015, 02:37 AM
RE: CodeIgniter 4 Proposed Roadmap - by condor - 02-01-2016, 01:51 AM
RE: CodeIgniter 4 Proposed Roadmap - by sv3tli0 - 02-01-2016, 02:24 AM
RE: CodeIgniter 4 Proposed Roadmap - by codenoon - 02-01-2016, 10:50 AM
RE: CodeIgniter 4 Proposed Roadmap - by sv3tli0 - 02-15-2016, 03:43 AM
RE: CodeIgniter 4 Proposed Roadmap - by Mladen - 04-12-2016, 11:38 AM
RE: CodeIgniter 4 Proposed Roadmap - by freebox - 09-03-2016, 05:54 PM
RE: CodeIgniter 4 Proposed Roadmap - by timw4mail - 09-16-2016, 04:13 PM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 09-16-2016, 09:13 PM
RE: CodeIgniter 4 Proposed Roadmap - by pstef - 09-17-2016, 01:39 PM
RE: CodeIgniter 4 Proposed Roadmap - by pstef - 09-17-2016, 03:36 PM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 09-17-2016, 08:28 PM
RE: CodeIgniter 4 Proposed Roadmap - by pstef - 09-21-2016, 11:03 PM
RE: CodeIgniter 4 Proposed Roadmap - by JayPatel - 03-17-2017, 12:25 AM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 02-26-2017, 11:51 PM
RE: CodeIgniter 4 Proposed Roadmap - by ross03 - 03-13-2017, 12:56 AM
RE: CodeIgniter 4 Proposed Roadmap - by sv3tli0 - 03-13-2017, 02:57 AM
RE: CodeIgniter 4 Proposed Roadmap - by kilishan - 03-17-2017, 07:40 AM
RE: CodeIgniter 4 Proposed Roadmap - by bose - 04-21-2017, 11:34 PM
RE: CodeIgniter 4 Proposed Roadmap - by AppJetty - 06-02-2017, 06:07 AM
RE: CodeIgniter 4 Proposed Roadmap - by ardavan - 07-09-2017, 03:53 AM
RE: CodeIgniter 4 Proposed Roadmap - by yuricua - 10-30-2017, 09:42 AM
RE: CodeIgniter 4 Proposed Roadmap - by ciadmin - 10-30-2017, 09:58 AM
RE: CodeIgniter 4 Proposed Roadmap - by ciadmin - 03-23-2018, 05:33 PM
RE: CodeIgniter 4 Proposed Roadmap - by madadi - 04-13-2018, 09:37 PM
RE: CodeIgniter 4 Proposed Roadmap - by goeko77 - 08-20-2018, 01:15 PM
RE: CodeIgniter 4 Proposed Roadmap - by ciadmin - 08-20-2018, 03:44 PM
RE: CodeIgniter 4 Proposed Roadmap - by ciadmin - 09-15-2018, 02:14 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
2 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.