Install the server:
sudo apt-get install postgresql-9.1 postgresql-contrib-9.1 pgadmin3
Execute the psql command under user postgres (sudo -u postgres)
and connect to database postgres (psql postgres):
Dan Karran dankarran
giorgiofellipe
/ install_psql_php.sh
Last active
October 10, 2021 05:58
— forked from doole/install_psql_php.sh
Install PHP PGSQL extensions on Mac OS X Yosemite (change PHP_VER with your PHP version)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| PHP_VER="5.5.14" | |
| # Check if extension exists first | |
| php -m | grep pgsql | |
| # Update brew and install requirements | |
| brew update | |
| brew install autoconf | |
| # Download PHP source and extract |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Go to Bitbucket and create a new repository (its better to have an empty repo) | |
| git clone [email protected]:abc/myforkedrepo.git | |
| cd myforkedrepo | |
| Now add Github repo as a new remote in Bitbucket called "sync" | |
| git remote add sync [email protected]:def/originalrepo.git | |
| Verify what are the remotes currently being setup for "myforkedrepo". This following command should show "fetch" and "push" for two remotes i.e. "origin" and "sync" | |
| git remote -v |
akkerman
/ Install PostGIS and GeoServer on Ubuntu 13.04.md
Last active
May 28, 2023 01:53
Install PostGIS and GeoServer on Ubuntu 13.04
searbe
/ parse_xlsx.php
Created
August 7, 2012 09:48
Parse simple XLSX in PHP with SimpleXML and ZipArchive
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * I had to parse an XLSX spreadsheet (which should damn well have been a CSV!) | |
| * but the usual tools were hitting the memory limit pretty quick. I found that | |
| * manually parsing the XML worked pretty well. Note that this, most likely, | |
| * won't work if cells contain anything more than text or a number (so formulas, | |
| * graphs, etc ..., I don't know what'd happen). | |
| */ |