512 reputation
319
bio website connjur.uchc.edu
location Connecticut, USA
age 27
visits member for 2 years, 8 months
seen Jul 14 at 16:19

I work in a scientific computing group on the CONNJUR project, providing open-source software for NMR (Nuclear Magnetic Resonance) spectroscopy.

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

May
14
comment
Is it just questions that need strict moderation, or is it important that answers are strictly moderated, too? Should answers that are real answers but don't really answer the question be moderated, and if so, how? (btw, thanks for answering my earlier questions)
May
14
comment
SE are trialling an alternative way of asking the candidates questions: please see this meta question ………………………………………………………………………………………………………………………………… In your opinion, what are the major strengths and weaknesses of how DBA.SE is currently moderated?
May
14
comment
SE are trialling an alternative way of asking the candidates questions: please see this meta question ………………………………………………………………………………………………………………………………… There are varying opinions on what is wrong with StackOverflow. Can you be more specific on what problems you see with it, and what you would do to deal with them or prevent them from happening on DBA.SE?
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
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
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.
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?
Mar
27
comment what does SHOW /*!50000 GLOBAL */ STATUS do ?
I'd recommend splitting the second part into a completely separate question.
Mar
26
comment Why does MySQL choose this execution plan?
@ypercube what is the problem?
Mar
22
comment How do I get the execution plan for a view?
+1 for showing that the execution plan is the same both ways!
Mar
22
comment How do I get the execution plan for a view?
@Jannes good point, I didn't consider that aspect. Is it safe to assume that the execution plan from select * from <view_name> will match?
Mar
9
comment Linking identifiers across tables in MySQL (Foreign Keys)
@DTest -- good point, updated post to reflect that.