-
Recent Posts
Archives
- July 2016
- April 2015
- January 2015
- October 2014
- September 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- January 2014
- August 2013
- March 2013
- February 2013
- January 2013
- December 2012
- June 2012
- April 2012
- March 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
Categories
Blogroll
Meta
Author Archives: Jennifer Phillips Campbell
Importing a Shapefile into PostgreSQL
I tried to import a shapefile to a PostgreSQL database using SPIT in QGIS, but kept getting an error because the gid column already existed in the .dbf. So I used the command line instead: shp2pgsql Downloads/Archive/data_dev.shp > data.sql then … Continue reading
Posted in PostgreSQL
1 Comment
Taking the top 5 of grouped ranked data in PostgreSQL
Working from a list of my ancestors’ occupations I wanted to list the top 5 occupations in each occupational category per decade, so that given year category description total … 1851 Agriculture Ag Lab 4 1851 Agriculture Farm Bailiff 1 … Continue reading
Posted in PostgreSQL, SQL
Leave a comment
Handling Transactions with SubSonic 3
I was pulling data from a web service and splitting the information across multiple tables in my database, so I wanted to rollback the entire operation if one of the saves failed. SubSonic 3 can handle transactions and I did … Continue reading
Posted in Uncategorized
Leave a comment
Creating a Rails 3 Project with PostgreSQL and TextMate on a Mac OS X Machine
I was advised to use RVM to manage Ruby on the Mac. Sign up as an Apple developer Download and install XCode Follow the instructions for installing RVM. Install RVM by executing $ bash < <( curl http://rvm.beginrescueend.com/releases/rvm-install-head ) in … Continue reading
Posted in PostgreSQL, Ruby on Rails
Leave a comment
Creating a Rails 3 Project with RubyMine and PostgreSQL on a Windows 7 Machine
Ruby gems and Windows don’t always get on – only try doing Rails projects on a Windows 7 machine if you’re feeling brave. Downloads: RubyMine RubyInstaller for Windows (contains RubyGems, so you don’t need to download the gems separately) In … Continue reading
Posted in Ruby on Rails
1 Comment
CSS3 Effects for IE using PIE
Short and sweet, this post. PIE.htc makes it easy to persuade IE to render some CSS3 effects – including border-radius and box-shadow.
Posted in Web Design
Leave a comment
Adventures in BDD for an ASP.NET MVC 2 and jQuery Project
I’ve played with Cucumber testing for a Ruby on Rails project, and I wanted to be able to a) automate and b) document some complex scenario testing for one of my ASP.NET MVC apps. I downloaded SpecFlow 1.5 and NUnit … Continue reading
Posted in Testing
Leave a comment
Useful Tools for Working With Web Site Colours
ColorZilla – plugin for Firefox, I find the eyedropper very useful Color Converter – displays the colour as well as providing the code in different formats colorbrewer2.org – great for colour schemes for charts as well as maps, includes colorblind-safe … Continue reading
Posted in Web Design
Leave a comment
Checking if FullText Service is installed on SQL Server 2008
SELECT FullTextServiceProperty(‘IsFullTextInstalled’) This will return 1 if the service is installed.
Posted in SQL Server
Leave a comment
Concatenating column from many side of one-to-many into single record using STUFF
SELECT OneTable.col1, OneTable.col2, STUFF ( ( SELECT ‘ ‘ + mt.col1 FROM ManyTable mt WHERE mt.foreignkeycol = OneTable.primarykeycol FOR xml path(”) ), 1, 1, ” ) AS concatenatedcol FROM OneTable Note: remember the ” in the inner SELECT statement, otherwise … Continue reading
Posted in SQL
Leave a comment
Jenny's Jottings 