951 reputation
21322
bio website techore.com
location Atlanta, GA
age 33
visits member for 3 years, 3 months
seen yesterday

PHP web developer for sharecare, maker of medical Q&A sites.


Feb
17
awarded  Nice Question
Jan
13
awarded  Notable Question
Jan
3
awarded  Yearling
Oct
24
awarded  Popular Question
Sep
29
awarded  Famous Question
Sep
17
awarded  Notable Question
Aug
29
accepted What is proper database design for a drupal table with an order field?
Jun
1
awarded  Popular Question
May
31
comment What is proper database design for a drupal table with an order field?
Unfortunately if you were to delete an ingredient after the fact then there is still the problem of having incorrect ordering, but I believe that is the best way to go
May
30
comment What is proper database design for a drupal table with an order field?
The reason my coworker was saying we can't have two ingredients with the same order is that having duplicate order values is bad design
May
30
comment What is proper database design for a drupal table with an order field?
We can't use just nid & vid for a primary key, those will be the same for any ingredients in the same recipe
May
29
asked What is proper database design for a drupal table with an order field?
Apr
19
awarded  Notable Question
Feb
18
awarded  Favorite Question
Feb
15
awarded  Popular Question
Jan
3
awarded  Yearling
Dec
28
awarded  Notable Question
Nov
29
comment Can I use a foreign key index as a shortcut to getting a row count in an INNODB table?
@ypercube would the EXPLAIN command be more accurate than a SHOW TABLE STATUS command? I've seen the row count fluctuate wildly in phpMyAdmin
Nov
29
comment Can I use a foreign key index as a shortcut to getting a row count in an INNODB table?
This is an INNODB table, so the table does not keep updated row counts like MyISAM tables
Nov
29
asked Can I use a foreign key index as a shortcut to getting a row count in an INNODB table?