Installing PostGIS with built-in Postgresql in Mac OS X Lion Server 10.7.3

We recently upgraded our Snow Leopard Mac OS X server to OS X Lion Server, 10.7.3 and were pleased to find that it comes with a version of PostgreSQL (9.0.5) built-in. We're all for having good stuff built-in so we now just had the task of adding PostGIS to it and we'd be set. However this isn't quite as simple as it could be, but luckily isn't too hard and doesn't require any tinkering with Apple or PG 'makefiles' or other scripts, just the judicious use of a few compiler parameters.

Missing (red) frameworks in iPhone XCode projects after upgrade

We just upgraded XCode to the latest release (3.1.4 as at time of writing) and noticed that after doing so a number of our iPhone projects now had their Frameworks all set to missing (i.e coloured in red).

Use grep to match on the beginning of a line

Just a simple one but a syntax that I can never remember when I need to so a quick post may help jog mine, and your, memory.  This grep syntax is for matching lines from a text file that begin with a particular word or expression :

$ grep -w '^Word' input_file.txt > output_file.txt
This will search input_file.txt for lines that begin with 'Word' and then redirect the output…

Removing £ signs from a file using sed

If you've ever tried to use 'sed' to remove the UK pound sign (£) from a file you may have struggled. We were bashing our head against the wall until we tried this little trick :

Building an OCCI project using XCode 3.1

With the release of the Instant Client for Mac OS X you can now build OCCI based applications targetting modern Macs using Leopard on Intel. However, there is very little help available for building these apps using XCode, and if you hit the same problem we did (see below) then perhaps this post may be helpful.

Things we like about the Mac

As you may have gleaned from other posts we do a lot of development using Macs, specifically MacBooks and iMacs. We might develop products that run on Linux, Windows or Solaris but that doesn't stop us using our Macs to actually do the work!

Mac OS X TextEdit doesn’t display NULLs!

We just had a real hair-puller of a problem so thought we'd blog about it here just in case someone else sees something similar. We had been sent a text file (.sql) of SQL Server 'CREATE TABLE' statements that we were manually converting to Oracle syntax just using TextEdit (OK, I know there are better editors but it was a small job and TextEdit was fine).

Converting tab delimited data to CSV data

Here's a little trick we discovered for converting tab delimited text to comma separated (CSV). You'll need access to a Unix, Linux or Mac OS X machine as it relies on the 'tr' command line not present on Windows.

Editting ApEx theme images using Mac OS X and WebDAV on XE

Recently we had to make a couple of minor tweaks to a couple of ApEx theme images stored in an XE installation. At first we scratched heads a little but then found a helpful post on the ApEx forum which made it much easier. All we needed to do was work out how to do this using Mac OS X Leopard. Luckily, it's also very easy!


  • oracle (8)
  • Mac OS (6)
  • Oracle (6)
  • SQL (5)
  • apex (4)
  • mac os (3)
  • iPhone (3)
  • script (2)
  • GIS (2)
  • map (2)