Login

dmyers · 11-20-2014, 08:17 AM

(11-20-2014, 03:29 AM)haneez Wrote: Hello everyone!

PHP/MySQL love is kinda over, most of the developers are moving away from MySQL to MariaDB after the whole Oracle drama and some have moved to NoSQL .

Looking back at your personal experience. If you are to suggest 3 database options for CI what would that be?

From what I understand MariaDB "is" MySQL (http://en.wikipedia.org/wiki/MariaDB) so I believe you can still use the same mysql drivers and just point them at your MariaDB box. That said my "top 3" would be
1. MySQL or MariaDB which ever you prefer (because I know it so well)
2. MongoDB (NoSQL has some pretty cool benefits)
3. postgresql (development seems to be moving faster than MySQL theses days - New NoSQL stuff look awesome!)

I setup a "CRUD" php interface file which I then implement as a "base" model nosql_crud & sql_crud (using built in SQL CI db support of course). Then I just extend it with my models model_people extends nosql_crud or model_buildings extends sql_crud.
That way switching between the 2 backends is fairly easy since they both implement the same crud methods. It's only the model specific query's that get a little tricky.

https://github.com/ProjectOrangeBox / https://github.com/dmyers2004