Despite all the implications of using LIKE in MySQL, sometimes it’s quite useful for a proof-of-concept to be able to use it.
Even though this is a rather trivial example, I hope it will be of help to whoever is wondering how to use a LIKE in a where using a Zend_Db_Select::where() or Zend_Db_Select::orWhere() and did not manage to find decent documentation about it.
Ever considered developing a RESTful API? Ever wondered what is FRAPI and how it works? Well apart from reading the frameworks’s website, there was no real way to assess FRAPI as a RESTful API Framework — Not until recently.
In order to ease adoption and make it more accessible for people to evaluate FRAPI, we’ve put an Amazon AMI together. This AMI comes pre-installed with Linux Lucid Lynx (Ubuntu 10.04 LTS), NGINX as the webserver, Memcached — (And no, port 11211 isn’t opened to the public), PHP5-FPM, APC and obviously FRAPI.
If you’d like to give this public AMI a spin, just go to Amazon’s instance management section, click on “Launch Instance, go to community AMIs, and search for : “ami-0adf2f63″ . Once you found it, click on “Select” (And make sure to select Port HTTP (80) when asked about which ports to open).
One of the highlights for me at yesterday’s Dublin Web Summit was Ruby developer Stuart Chaney’s awesome talk on migrating existing web apps to the cloud. Check out his github for the datacore project which covers some of the methods he went through.
Last week Helgi and I had the humongous chance and honour to fly to the “windy city” to PHP Tek 2010. For a change however, the purpose of this trip was not to give a talk at #tekx but to announce the open source release of a little something we’ve been cooking up for a while.
After flying from Dublin (me) and London (Helgi) finally reached Chicago and met up with the PHP Tek crowd. After discussing details with Marco Tabini, we organized a little event to announce our long awaited RESTful API Framework FRAPI.
Lately I’ve noticed that more and more service seem to include API testing in their list of services. For instance this week at Chirp, Twitter announced their development console available on dev.twitter.com which gives you the ability to test the API without really having to write any code just yet.
This feature is also well known for people using Hurl which is a website that you can use to make HTTP requests and test your API responses. Also on OSX there’s the HTTP Client Tool which does more or less the same as the ones above.
Another company that announced this feature this week was Apigee:
Use the API Console to review an API’s structure, experiment with the endpoint, and review the request and response messages. We’re launching with support for Twitter APIs and are adding more soon
Apigee is basically an analytics tool for your API. It allows you to track requests, users, errors, etc. So for them, implementing the API tester is something that makes sense as they provide statistics for you API, if you notice an error, you should be able to just test the API call and see if you can reproduce from within Apigee.
As the web grows, we developers have to write applications that are not location centric but rather develop applications that can be viewed by anyone around the world. Any developer that had to write such software probably has used GeoIP and has encountered issues when the time came to test their application. The only real way to test your application, without setting up servers around the world, is to assume that your code works and that the GeoIP database is working correctly.
As some of you may know from the tweets I’ve been posting for nearly 3 weeks now, I was invited to attend the very first edition of the JumpInCamp organized by Microsoft in April 2010.
The goal of this camp was to get the European PHP community leaders together and learn about the new products and new ideas Microsoft are working on. For those of you who read about the Microsoft web developer summit that took place in Redmond in December 2009 you might think it was the same thing however you would be utterly wrong.
While the camp in Redmond was very informative and we are learnt a great deal of new features coming up with Microsoft, it was vastly different than the JumpinCamp in Zurich where the focus of the camp was to get the developers to interact with the actual Microsoft developers instead of only learning about new features. The point of the JumpinCamp was to get your hands dirty in code so we all got a few hours of lectures, then sat down and worked on either implementing those solutions into our respective Open Source projects or even discussed and raised concerns we might have regarding some of their products.
I thought it might be nice to share some of the projects I’ve started working on while I was over there and what I had interests in:
At echolibre we’ve been trying to organize our sales and customer relationship in a more efficient way as the company customer base is getting larger and larger. That’s natural process for any growing company. In order to help us organize how we do everything related to customers (Sales, Leads, Relationships, etc) we are giving Capsule CRM a good run.
Therefore, we realized that we needed to integrate Capsule with some online services we have and so we built a PHP wrapper for their API to give developers the ability to place requests and use the web service as they wish using PHP
Services_Capsule is now being proposed to PEAR however you can already get the code from http://github.com/davidcoallier/Services_Capsule and start using it. The lack of end-user documentation may be the greatest lack in the package right now so I figured it might be good to post a few usage examples in a post.
As many of you know, Helgi Thormar and I have been exchanging with Microsoft for a while now trying to give what we can in order to help them improve their open source approaches and ideas.
Last summer we were invited to Seattle for the Microsoft Web Developer Summit (Which was a blast thanks to Microsoft) and as soon as we came back to Europe, I got a call from Yuri from Microsoft who wanted to organize some kind of workshop/camp/developer summit for European developers and Microsoft altogether. Read on…
Well, I’ve been working on my project for the week and here’s the update that you were promised! (And stick with the post, there’s a live demo!) I haven’t gotten as far as I had hoped but I have learnt a lot whilst here. See the previous post for more on that and what I had planned.
We like to blog about things we're passionate about. We love PHP, MySQL, CouchDB, Linux, Apache - web development standards. We also like writing about building web apps and working with web technology.
You can email us on firstname.lastname@example.org