Welcome Guest, Not a member yet? Register   Sign In
What DB and Why?
#2

(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 [font=sans-serif]MariaDB box. That said my "top 3" would be[/font]
[font=sans-serif]1. MySQL or MariaDB which ever you prefer (because I know it so well)[/font]
[font=sans-serif]2. MongoDB (NoSQL has some pretty cool benefits)[/font]
[font=sans-serif]3. postgresql (development seems to be moving faster than MySQL theses days - New NoSQL stuff look awesome!)[/font]


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.
Reply


Messages In This Thread
What DB and Why? - by haneez - 11-20-2014, 03:29 AM
RE: What DB and Why? - by dmyers - 11-20-2014, 08:17 AM
RE: What DB and Why? - by Rufnex - 11-20-2014, 09:32 AM
RE: What DB and Why? - by alroker - 11-27-2014, 01:37 AM
RE: What DB and Why? - by no1youknowz - 11-30-2014, 07:42 AM
RE: What DB and Why? - by popcorner - 12-04-2014, 07:55 AM
RE: What DB and Why? - by no1 - 12-08-2014, 06:06 AM
RE: What DB and Why? - by Chroma - 12-09-2014, 10:56 AM
RE: What DB and Why? - by SunDi3yansyah - 01-19-2015, 06:10 AM
RE: What DB and Why? - by Hobbes - 01-20-2015, 07:00 AM
RE: What DB and Why? - by sv3tli0 - 01-20-2015, 07:52 AM
RE: What DB and Why? - by kilishan - 01-20-2015, 08:50 PM
RE: What DB and Why? - by Oscar165 - 03-14-2015, 03:21 PM
RE: What DB and Why? - by spjonez - 03-15-2015, 07:29 AM



Theme © iAndrew 2016 - Forum software by © MyBB