Skip To Main Content
Carl Manaster on Muck Rack

Carl Manaster

Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile
Back to Carl Manaster’s profile

Articles by Carl Manaster

INNER JOIN ON vs WHERE clause

|
By Uwe Keim, Melanie Shebel, Carl Manaster, Arsen Khachaturyan
| stackoverflow.com
For simplicity, assume all relevant fields are NOT NULL. You can do: SELECT table1.this, table2.that, table2.somethingelse FROM table1, table2 WHERE table1.foreignkey = table2.primarykey AND (some other conditions) Or else: SELECT table1.this, table2.that, table2.somethingelse FROM table1 INNER JOIN table2 ON table1.foreignkey = table2.primarykey WHERE (some other conditions) Do these two work on the same way in MySQL? asked Jun 19, 2009 at 16:16 INNER JOIN is ANSI syntax that you should use.
Open in Who Shared Issue with article?

Is there a need to keep tests for simple (self-contained) functions?

|
By Carl Manaster
| programmers.stackexchange.com
It's all about regression testing. Imagine the next developer looking at your method and noticing that you are using magical numbers. He was told that magical numbers are evil, so he creates two constants, one for the number two, the other one for the number three—there is nothing wrong in doing this change; it's not like he was modifying your already correct implementation. Being distracted, he inverts two constants.
Open in Who Shared Issue with article?

Is testable code better code?

|
By Kilian Foth, Eric King, Carl Manaster
| programmers.stackexchange.com
I'm attempting to get into the habit of writing unit tests regularly with my code, but I've read that first it's important to write testable code. This question touches on SOLID principles of writing testable code, but I want to know if those design principles are beneficial (or at least not harmful) without planning on writing tests at all. To clarify - I understand the importance of writing tests; this is not a question on their usefulness.
Open in Who Shared Issue with article?
Show More