• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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 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.
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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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