3,671 reputation
614
bio website systemajik.com
location Gatineau, Canada
age 59
visits member for 3 years, 8 months
seen yesterday
I have over 30 years experience in all phases of software development and delivery. I have administered a variety of midrange servers, and worked with systems from PCs to Mainframes.

1d
comment Normalization 3NF and BCNF
@user1062704 Remove either A or B from the relationship, into their own relationship (table). Until you do you are have 2NF.
Oct
17
comment How to clean up nested try/except/else?
@WinstonEwert In a real life example I would expect some overlap in the Errors (exceptions). However, I would also expect the handling to be the same. BazError could be a keyboard interrupt. I would expect it to be handled appropriately for all four lines of code.
Oct
17
comment How to clean up nested try/except/else?
@Kevin Wrapping each line of code in a Try Catch Else block quickly becomes unreadable. This is made more so by Python's indentation rules. Think how far this would end up indented if the code was 10 lines long. Would it be readable or maintainable. As long as the code follows the single responsibility I would stand by the example above. If not, then the code should be rewritten.
Oct
17
answered How to clean up nested try/except/else?
Sep
16
revised Is it a bad practice to keep database schema scripts (DDL) and manipulation (DML) scripts in different modules
Clarify
Sep
16
revised Is it a bad practice to keep database schema scripts (DDL) and manipulation (DML) scripts in different modules
Respond to comment.
Sep
8
answered Why does “charset” really mean “encoding” in common usage?
Aug
15
answered Is it a bad practice to keep database schema scripts (DDL) and manipulation (DML) scripts in different modules
Aug
6
comment How do you make a service stateless?
@Songo Updated.
Aug
6
revised How do you make a service stateless?
Respond to comment.
Aug
6
answered Patterns for undo in multi-user applications on relational data
Aug
6
answered How do you make a service stateless?
Jul
31
revised Should all HTTP requests including credentials be made using a POST even if it is actually just a request for data?
deleted 5 characters in body
Jul
30
answered Should all HTTP requests including credentials be made using a POST even if it is actually just a request for data?
Jul
25
comment What is the best use case for selenium?
@EduardoDennis I build my test to hit a path on a site. The site is specified when running the test. Multiple, tests can be combined into a test suite and run as a group. You can build tests based on preconditions (user is on shop screen), then run different tests to get you to the purchase screen, which then use a common complete purchase test.
Jul
25
revised Passing data between hundreds of objects in java
Add addtional information
Jul
25
comment Passing data between hundreds of objects in java
@user2864336 I've addressed your issues in an edit.
Jul
24
revised Passing data between hundreds of objects in java
Clarify
Jul
24
answered Passing data between hundreds of objects in java
Jul
22
comment Preventing ip resolvers in a skype-like program
@NoamGal I've added some pointers in my edit.