on PDO

PDO::bindParam with GeomFromText

So I heard you're using PDO, so you should use bindParam to replace your parameters in your requests DQL. Now, suppose you use functions in your requests, such as GeomFromText : $query = " SELECT * FROM points p WHERE p.point = GeomFromText('POINT(:lat :lng)')"; $statement = $db->prepare($query)…

on nginx | hhvm | supervisor

HHVM and multiple sites

When using HHVM when you come from the PHP world (I'm talking about the binaries, not the language), you can easily get lost when trying to serve multiple sites on one server. That's why using a single instance of HHVM on one server to serve many sites can be a…

Tame your forwardAgent directive on Mac OS X

if it doesn't work ... despite having he correct line in your ~/.ssh/config : Host foobar.pizza ForwardAgent yes ... and that your global configuration does not override your local configuration (check /etc/ssh_config) : Host * SendEnv LANG LC_* # ForwardAgent no Well, on OS X, You just need to (Mac OS X…

on nginx

Redirect www.* with Nginx

To redirect a www domain to the « root » domain with Nginx, one always prefers not to make any use of the if syntax (because it's evil), and rather use two different server directives for each rule : server { server_name www.domain.com; return 301 $scheme://domain.com$request_uri; } server…

on obj c | xcode

Tips & tricks for Obj-C

These are taken for an old blog of mine about Objective-C ... Adding a trackingRect to a NSView object This might be of interest (I spent a good hour trying to make it work); In the following code, I set a trackingRect to my entire NSView object, so I can track…