Click here to Skip to main content
Click here to Skip to main content

Job Hunting Data Recorder

, 28 Jun 2010 CPOL
Rate this:
Please Sign up or sign in to vote.
This project produces a tool that can record various data gathered on employers and store it in an SQLite database

Introduction

With so many of us pounding the pavement these days, this tool will help you keep track of companies with which you are hoping to find employment, the contacts you've made so far with them, and various other attributes germane to you finding work there. This includes people's names, e-mail addresses, phone numbers, web sites, and logs recording your experiences with them so far.

Background

I wrote this program during the previous recession (remember the dotcom bubble?). At the time, I used a Microsoft Access database -- not the best idea I've had. Now I've replaced it with an SQLite database.

Using the Program

The project source code does not contain the source for SQLite 3, so the first thing you'll need to do is get that, currently found on their download page. The so-called "sqlite-amagamation" zip file should be sufficient. Having those, in EmploiRecorder/sqlite, put:

  • sqlite3.c
  • sqlite3.h
  • sqlite3ext.h

Once built, all you need to do is place the executable in a directory, where you won't mind it creating files. It should only create two files: one for the database, and another for other persistent data. Beyond that, the use of the program should be intuitive.

EmploiRecorder screenshot

Points of Interest

The moral of the story was don't use Microsoft Access for anything but compatibility. Well, maybe it has a better table browser, but SQLite is wonderfully free, stable, and feature rich. If you need the multi-user access that Access affords, then you can go to MySQL. For some reason, Microsoft has deprecated the DAO libraries, for which EmploiRecorder was originally written. That broke my code. I don't expect these kinds of shenanigans from SQLite or MySQL.

History

  • 2010/06/28 Original version 1.1

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

AngusEm
Software Developer (Senior)
Canada Canada
Angus March is a computer engineer in Ottawa.

Comments and Discussions

 
GeneralMy vote of 1 PinmemberMarco Bertschi26-Nov-12 6:34 
GeneralMy vote of 2 Pinmemberpita20091-Jul-10 21:31 
GeneralMy vote of 1 PinmvpMark Nischalke30-Jun-10 17:33 
GeneralExplanation required PinmvpMd. Marufuzzaman29-Jun-10 5:26 
GeneralBetter as a blog post... Pinmemberdigital man28-Jun-10 22:09 
GeneralNo an article... PinmvpDave Kreskowiak28-Jun-10 11:31 
You've got no discussion of how the app was designed, the concepts behind it, how the code works... This is just a download link and a "How to use". You've not teaching anyone anything and that's the whole point behind writing an article.

A guide to posting questions on CodeProject[^]



Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
     2006, 2007, 2008
But no longer in 2009...




General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.141216.1 | Last Updated 28 Jun 2010
Article Copyright 2010 by AngusEm
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid