NoSQL is a topic and there are admirable technologies floating around. MySQL is an old fellow yet you can have reliable master-master replication. We have been using it in our production environment without hassle for a long time. It does not require much maintenance. Here is a short guideline to follow if you ever need to re-sync a master node to another. This is a bit like a series of notes for myself.

Permalink | Leave a comment  »

I recently started developing internationalization features for Trio. It feels good to be rely on symfony again. Otherwise it is hard to image to establish i18n capabilities to project after a year of development. It is ridiculously easy to implement. I spend half a day to get everything up and running and I am planning to finish by tomorrow to extract strings from files.

Just assing shortcut keys then enjoy :)

Permalink | Leave a comment  »

For my latest piece of project I have been highly engaged with jqGrid which is an Ajax-enabled JavaScript control that provides solutions for representing and manipulating tabular data on the web. Since the grid is a client-side solution loading data dynamically through Ajax callbacks I was able to integrate it with symfony and Propel. Well, to be honest it cost me a night without sleep. Actually there is a great implementation for PHP which makes it so much easier to integrate with PHP. I tried it. I spend a whole day trying to make it work out. There were some problems in the beginning but I got great support from the Trirand jqSuite forums (where you can actually get quick help from developers of jqGrid) However, in the end I felt like stuck within the PHP implementation. I had to quit it and create my own implementation for several reasons. It was not open source and there was lack of documentation and features. jqGrid javascript library is really mature, feature rich, but I cannot say the same for PHP implementation classes. Moreover it is $299 or $449 since you need to buy a license. If you buy the expensive license you get the full source code but still it was going to hard integrate it with symfony & propel since it is using raw SQL. Last but not least, I can tell you that I went over every single answer posted to this stackoverflow question. I am not going into details but, jqGrid is superior. Some lack features, some lack documentation, some lackmatureness, some lack active development or community. (DataTables was the one I attracted most)

Right now, I would like to share a piece of code which may give an insight about how to deal with this problem.

if($this->request->getParameter('_search', 'dummy') == 'true') {
  $s = $this->request->getParameter('filters');
  if($s) {
    $jsona = json_decode($s,true);
    if(is_array($jsona)) {
      $gopr = $jsona['groupOp'];
      $this->filter->opr = $gopr;
      $rules = $jsona['rules'];
      foreach($rules as $key => $val) {
        $field = $val['field'];
        $op = $val['op'];
        $v = $val['data'];
        if($v && $op) {
          switch ($op) {
            case 'eq':
              $comp = Criteria::EQUAL;
              break;
            case 'ne':
              $comp = Criteria::NOT_EQUAL;
              break;
            case 'lt':
              $comp = Criteria::LESS_THAN;
              break;
            case 'le':
              $comp = Criteria::LESS_EQUAL;
              break;
            case 'gt':
              $comp = Criteria::GREATER_THAN;
              break;
            case 'ge':
              $comp = Criteria::GREATER_EQUAL;
              break;
            case 'bw':
              $comp = Criteria::LIKE;
              $v = "$v%";
              break;
            case 'bn':
              $comp = Criteria::NOT_LIKE;
              $v = "$v%";
              break;
            case 'ew':
              $comp = Criteria::LIKE;
              $v = "%$v";
              break;
            case 'en':
              $comp = Criteria::NOT_LIKE;
              $v = "%$v";
              break;
            case 'cn':
              $comp = Criteria::LIKE;
              $v = "%$v%";
              break;
            case 'nc':
              $comp = Criteria::NOT_LIKE;
              $v = "%$v%";
              break;
            case 'in':
              $comp = Criteria::IN;
              $v = "($v)";
              break;
            case 'ni':
              $comp = Criteria::NOT_IN;
              $v = "($v)";
              break;
          }
          if($gopr=='AND')
            $andOr = 'And';
          elseif($gopr=='OR')
            $andOr = 'Or';
          if(!isset($search_criteria)) {
            $search_criteria = $this->default_criteria->getNewCriterion($field, $v, $comp);
          }else {
             call_user_func(array($search_criteria, "add$andOr"), $this->default_criteria->getNewCriterion($field, $v, $comp));
          }
        }
      }
      $this->default_criteria->addAnd($search_criteria);
    }
  }
}

Permalink | Leave a comment  »