1,085 reputation
518
bio website yourcodeisshowing.wordpress.c…
location Quebec City, Canada
age 36
visits member for 3 years, 5 months
seen Mar 18 at 13:52

Developer with 8 years experience. I work with J, C, C++, C#, SQLite, MySQL, VBA, and a bunch of other odds and ends.

On Twitter: @MPProg


Nov
28
comment Keeping an enum and a table in sync
@suslik They are both pronounced the same. Synch and Sync.
Nov
28
comment Keeping an enum and a table in sync
It's not so much about new statuses (which would definitely warrant a modification of both database and program), but Id values.
Nov
28
revised Keeping an enum and a table in sync
deleted 1 characters in body; edited title
Nov
28
asked Keeping an enum and a table in sync
Nov
2
awarded  Notable Question
Oct
30
awarded  Yearling
Sep
26
awarded  Excavator
Sep
26
revised Why is prefixing column names considered bad practice?
Just like prefixing column names, prefixing questions with a tag is frowned upon
Sep
26
comment What good reasons are there to capitalise SQL keywords?
Capitalizing SQL keywords I can understand. Most table declarations and queries I see capitalize EVERYTHING, table names and columns included.
Sep
26
suggested suggested edit on Why is prefixing column names considered bad practice?
May
18
comment Should the most recent date be named 'start' or 'end'?
There's also a case to be made for reading left to right. The order goes that way in more languages than the reverse. Both human and programming languages.
May
18
comment Should the most recent date be named 'start' or 'end'?
I agree with the desire to make something adequate and clear. I'm working with an old code base where any notion of "first" and "last" are labelled "a" and "z"... "Start" and "End" sound much more natural.
May
18
comment Should the most recent date be named 'start' or 'end'?
Simply "StartDate", "EndDate", and good documentation. There is a case to be made for documentation. A well made API has appropriate documentation. Furthermore, if you want to get cocky, throw an Exception if EndDate < StartDate, and document that too.
May
18
answered Should the most recent date be named 'start' or 'end'?
Mar
25
awarded  Good Answer
Mar
21
revised What is the most effective way to add functionality to unfamiliar, structurally unsound code?
added 6 characters in body
Feb
23
comment Examples of operator overloading, which make sense
@dan04 Very very good to know!
Feb
23
answered Examples of operator overloading, which make sense
Feb
16
awarded  Nice Answer
Feb
16
comment What is the most effective way to add functionality to unfamiliar, structurally unsound code?
You're actually more dead on with several valid approaches. All I have are pointers and tips...