Postgres is only an apt-get away!
# apt-get install postgresql postgresql-client
To integrate with PHP PDO:
# apt-get install php5-pgsql
Installing PostgreSQL on Debian
Reply
Daily Archives: 2014-05-27 [Tuesday]
PHP urlencode
Used PHP’s urlencode today…
psql fatal role does not exist
I was setting up a postgres server and I got the message “psql fatal role ‘user’ does not exist”. Found a solution over here, basically:
CREATE USER jj5 SUPERUSER; CREATE DATABASE dbname WITH OWNER jj5;
Sorting Arrays in PHP
Everything you ever wanted to know about sorting arrays in PHP.
PHP instance of Closure vs is_callable or function_exists
The problem is that is_callable and function_exists check a string to see if it’s a function. But I wanted to check to see if it was an anonymous function and not a string. Turns out you can do this by checking for an instance of Closure:
if ( $fn instanceof Closure ) { $fn( ... ); }