652 reputation
31028
bio website sites.google.com/site/…
location Urbana, IL
age
visits member for 3 years, 7 months
seen Nov 6 at 4:49

To support my research on ecosystem functioning, my collaborators and I are developing PEcAn, a model-data synthesis framework (www.pecanproject.org) and BETYdb, its underlying database (www.betydb.org).

Source Code:


Oct
10
awarded  Autobiographer
Sep
23
awarded  Popular Question
Sep
8
awarded  Notable Question
Jul
21
awarded  Yearling
Jul
2
awarded  Curious
Jun
23
awarded  Nice Question
Jun
16
awarded  Popular Question
Apr
30
accepted Alternatives to NULL for missing data
Apr
29
comment Alternatives to NULL for missing data
@ypercube Generally, following Joe Celko's advice to default to using non-null constraints. Specifically, I would like to use nonnull constraints to avoid many known issues with nulls, e.g. in computation and logical queries, and also to be able to distinguish data that is missing from data that does not exist.
Apr
29
asked Alternatives to NULL for missing data
Apr
22
awarded  Nice Question
Mar
26
awarded  Popular Question
Feb
26
awarded  Famous Question
Feb
24
awarded  Announcer
Feb
10
awarded  Nice Question
Jan
20
awarded  Notable Question
Dec
17
comment How can I ensure a valid MySQL -> Postgres migration?
@ErwinBrandstetter I am not concerned with fixing queries because we already have a set of unit and integration tests for our key functionality. But it is hard to make these comprehensive if I don't know what to look for.
Dec
17
comment How can I ensure a valid MySQL -> Postgres migration?
@JackDouglas do you have any suggestions for narrowing the scope?
Dec
17
awarded  Promoter
Dec
14
awarded  Famous Question