379 reputation
17
bio website daviestrachan.co.uk
location Paisley uk
age 71
visits member for 2 years, 2 months
seen Nov 9 at 22:05

Have been programming for more years than I can remember (40 ++). Fortran,Basic,Clipper,C,C++,PHP,Javascript.

I also have experience of databases dB3,Access,Paradox,MySQL and stand alone applications using Clipper.

I am now retired and keeping up my programming skills developing Google Maps using jQuery,PHP and MySQL


Oct
21
awarded  Yearling
Oct
1
comment Unit-testing databases: test all possible permutations of read and write to table?
Why are you trying to test (reinvent) the wheel? I suggest you read a good book on databases. Pay special attention to Transactions.
Apr
9
comment How do you store “fuzzy dates” into a database?
@Konerak Semantically yes. But as the majority of dates are accurate only the special cases need to be identified and using NULL here as default.
Apr
9
awarded  Nice Answer
Apr
8
awarded  Editor
Apr
8
revised How do you store “fuzzy dates” into a database?
additional information
Apr
8
awarded  Critic
Apr
8
comment How do you store “fuzzy dates” into a database?
OP wants some way to denote that this date is only accurate to the month.
Apr
8
answered How do you store “fuzzy dates” into a database?
Feb
26
awarded  Caucus
Oct
21
awarded  Teacher
Oct
21
comment Best approach for saving highlighted areas on geographical map
Glad to be of help.
Oct
21
answered Best approach for saving highlighted areas on geographical map
Oct
21
awarded  Autobiographer
Oct
21
awarded  Supporter