A Bit of SQL For Jobberbase Open Source Job Board

Bookmark and Share
| 5 Comments
JobberBase is an open source job board application written in php / mysql.

It's pretty powerful and is open source, so I've decided to use it for one of my many sideline projects that I promised myself to get off the ground this year.

Unfortunately there wasn't any SQL for the counties of Ireland, so I did up a simple one last night.

You can grab it here

Thanks to Paul from BlackDog for recommending the script!

  • Currently 2.3/5
  • 1
  • 2
  • 3
  • 4
  • 5
Rating: 2.3 /5( 6 votes cast)

latest funny tshirts

5 Comments

Two questions that got me curious:

1. Why did you include Belfast as a county, resulting in 33 counties in total?

2. Why did you include the first entry for Ireland with the id of -1.

James

1 - simply because it's the only major urban centre that isn't the same name as the actual county itself. Cork is in Cork, Dublin is in Dublin etc :)

2 - You'll notice on the install at technicaljobs.ie that Ireland is showing slightly indented - that's why / how

Michele

I like it - nice and simple...

Pity the recruitment market is in a bit of a hoop these days though :-(

Nice. Could be a lot of work for you though? Considering the spam that actually gets published as jobs on job sites and the usual penis enlargement spam.

Gary

That's a fair point, but as it's written in PHP it wouldn't be that hard to use some simple GEO IP code to deny certain IP ranges access to the job submission page ie. as it's aimed at Ireland then blocking everywhere else from that one page shouldn't cause any negative impact.

Michele

OpenID accepted here Learn more about OpenID
Powered by Movable Type 4.34-en
Get a personal domain - get a .me!
TwitterCounter for @mneylon

About this Entry

This page contains a single entry by Michele Neylon published on January 7, 2009 8:07 PM.

Irish Green Party Are Spamming Idiots was the previous entry in this blog.

IE Domains For 10 Euro!!! is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Recent Activity

Today