541 reputation
321
bio website connjur.uchc.edu
location Connecticut, USA
age 27
visits member for 3 years
seen Oct 21 at 4:50

Check out some of my work on github:

  • NMRPyStar: an API for accessing archived NMR data files in the NMR-Star format used by the BMRB.

  • Miscue-js: validation of JSON files to deal with obnoxious and tricky interoperability issues such as number overflows and duplicate keys

Some technologies that I've used and like:

  • Python
  • git
  • Javascript
  • Haskell
  • Java
  • MySQL

Apr
30
comment How do I create a user-defined aggregate function?
Cool math, but I actually wanted to know how to create an aggregate function in general. product was just supposed to be one example of several.
Apr
30
revised How do you query supertypes to get subtype data?
formatting -- align outlines of tables
Apr
30
suggested suggested edit on How do you query supertypes to get subtype data?
Apr
30
revised How do I create a user-defined aggregate function?
added 401 characters in body
Apr
30
answered What is a common way to save 'debit' and 'credit' information?
Apr
30
asked How do I create a user-defined aggregate function?
Apr
26
comment MySQL: A better way to write this query?
The thing that really stands out to me is the tablescan (type = ALL in the explain output) on submission. So either you don't have a suitable index for submission.submitted, or MySQL estimates that a large enough percentage of rows will pass through the filter that it's cheaper to just do a tablescan.
Apr
24
comment MySQL Character set and Collation Issue.?
I assume you're running these queries from the terminal. It may be possible that the data and the database are fine, but your terminal isn't reading and displaying the characters properly.
Apr
24
comment Why is a secondary index chosen over a clustered index for SELECT COUNT(*) …?
MySQL does allow that -- see column_definition.
Apr
23
awarded  Commentator
Apr
23
comment Mysql:Need to upload data to database, get duplicate key error - how can dup keys be ignored
@Nir what do you mean by large -- lots of rows or lots of tables? You'll have to make one change for each table, regardless of number of rows. If you're only dumping one table, then you have to make one change.
Apr
23
comment Why is a secondary index chosen over a clustered index for SELECT COUNT(*) …?
Yes; it doesn't seem to help, though.
Apr
23
comment Why is a secondary index chosen over a clustered index for SELECT COUNT(*) …?
Perhaps this is a non-repeatable phenomenon, i.e. it will only happen with my specific hardware/configuration.
Apr
23
asked Why is a secondary index chosen over a clustered index for SELECT COUNT(*) …?
Apr
23
revised Why do my ON UPDATE/ON DELETE rules disappear?
code formatting, spelling, shortened some sentences
Apr
23
suggested suggested edit on Why do my ON UPDATE/ON DELETE rules disappear?
Apr
23
answered Mysql:Need to upload data to database, get duplicate key error - how can dup keys be ignored
Mar
28
revised memcached service stopped unexpectedly
major reformatting, also spelling & grammar
Mar
28
suggested suggested edit on memcached service stopped unexpectedly
Mar
27
comment How to initiate MySQL on Mac OS X 10.6.8?
@user6076 what doesn't work? My error messages are exactly the same as yours, until I follow my procedure. Do you not have either root password? What is the output from sudo mysqld -u root?