2,485 reputation
619
bio website
location Longmeadow, MA
age 45
visits member for 3 years, 5 months
seen Nov 13 at 19:33

Just your average code monkey.

I try to keep up with technology and best practices to continually improve myself to become a better programmer.


Oct
29
answered Should I store images in my database or file system in this application?
Oct
24
answered 500 databases or 1 database with 500 tables or just 1 table with all the records?
Oct
15
comment Designing classes the right way
Some stations serve more than one line, so getLaneColor may not be appropriate, you may want to model the intersection points and assign that to your station object. For some stations intersections will be null or empty.
Sep
8
answered Providing friendly URLs for a website vs. realities of database IDs
Aug
28
awarded  Notable Question
Jul
8
comment Returning results of method on batch list?
Your asking to keep track of the successes and failures, so yes, both type of objects are returned. If one is processing a batch, certainly knowing what items succeeded and/or failed would be important.
Jul
7
answered Returning results of method on batch list?
Jun
23
awarded  Yearling
Jun
20
comment How would you know if you've written readable and easily maintainable code?
This should be the answer. Measure. Other answers are more opinion than fact, if I can understand it, it must good? First measure using complexity analysis, then human refactor to look for duplication, etc.
Mar
11
comment How do I stop designing and start architecting this project as suggested by my lead?
The architect wears no hat, but rather envisions an abstract head protection system.
Mar
5
comment SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
Your designing the system to handle the edge case. Proper datasizing is critical for indexing. There is overhead for using this type of field. dba.stackexchange.com/questions/47910/…
Mar
5
answered SQL string field lengths in a db having about 6 different types of addresses, with about 20 markets and environments
Feb
4
awarded  Nice Answer
Jan
30
comment Why should passwords be encrypted if they are being stored in a secure database?
Disgrunted DBA says... select * from user, and then sells that list for severence pay. Nothing is ever secure.
Jan
29
answered What are the valid test cases for method calls within if-else condition
Jan
23
revised How to Explain Coding is not just Copy and Paste to non Software Developers?
deleted 2 characters in body
Jan
23
answered How to Explain Coding is not just Copy and Paste to non Software Developers?
Jan
21
comment Is CSV a good alternative to XML and JSON?
Any CSV message structure can be mapped to an XML or JSON message format. Not all XML/JSON message format can be mapped to CSV. So, CSV only covers a specific data use case, tabular format, where as JSON and XML can cover more complex message structures.
Jan
10
answered Violating SQL principles
Jan
10
comment Lead developer unable to do INNER JOIN
Your design has 5 tables and 4 relations, but you could have a design with just one table with customer, phone, and address columns on one row. Every new customer new address or phone is a new record. One table, no joins. Now there would be a lot of nulls and lots of chances to insert poor quality data and potentially data repeats, but it's a workable. So, I wouldn't call it crucial in small applications, but it's definately important and leads to better (maintainable and sound) software and underlying code.