692 reputation
712
bio website joshduff.com
location Nebraska
age
visits member for 4 years, 3 months
seen 19 hours ago

I'm a happy coder!

I like

  • The internet
  • Writing code for the internet
  • Writing applications for users

...and I especially like relational databases.


Dec
9
comment What is the best way to format complex SQL queries in Node?
It's impossible to name a definitive "best" library, but you should probably check out Knex
Nov
25
comment How to prevent race conditions in a web application?
FYI, the form of locking you mention in your question is known as "optimistic concurrency control"
Nov
24
comment How to really master MySQL?
@jaybny right-click on the url bar and go to "edit search engines"
Sep
24
awarded  Autobiographer
Sep
1
awarded  Nice Answer
Jul
28
comment Implementing distributed Semaphore for AWS workload
Use Amazon's Simple Queue Service!
May
29
awarded  Announcer
May
19
comment Should I implement a function or a method?
See John Carmack's Functional Programming in C++
Apr
28
comment When do you use subquery in SQL?
I believe "inline view" is also commonly referred to as a "derived table".
Apr
25
comment Is database version control practical?
If you make this question about versioning sql schemas, you may be able to turn it into an answerable question.
Apr
5
comment What is the benefit of offloading email to a transactional mail service?
+1 Sending email to people is not hard. Maintaining the reputation of your email server to other servers can be difficult.
Feb
19
revised How do purely functional programming languages deal with fast changing data?
Expanding abbreviation, fixing small spelling mistake
Feb
19
suggested approved edit on How do purely functional programming languages deal with fast changing data?
Nov
26
revised Which of these old criticisms of common lisp still apply today?
Clarified the title, made some minor spelling/grammar fixes
Nov
26
suggested approved edit on Which of these old criticisms of common lisp still apply today?
Nov
24
comment Naming convention for higher order functions?
The implication being that Hungarian notation is to be avoided at all costs? I'd recommend reading Making Wrong Code Look Wrong
Oct
3
comment Optional semicolons
It's not a bad idea, it's just confusing to people who try to use JavaScript without bothering to learn about its automatic semicolon insertion. Perhaps instead of saying "this is a very bad idea" you could more accurately say "making semicolons optional introduces pitfalls for programmers who don't go out and learn all the details".
Sep
8
awarded  Yearling
May
28
comment What does 'enumerable' mean?
In the context of JavaScript, see "Enumerability and ownership of properties" on MDN
May
27
comment Saving user profiles in SQL database
@RossPatterson ...what? No! 8-|