273 reputation
16
bio website james.lab6.com
location United Kingdom
age 31
visits member for 2 years, 6 months
seen Jun 17 at 21:44

I run a website full of photos.


Jul
2
awarded  Curious
Mar
11
asked What is the correct name for “relational role”?
Jul
5
comment Obvious inefficiencies in this Netezza query?
Are you speaking with specific knowledge of the way Netezza handles distribution? Because all my tables are distributed on random and similar queries with similar volumes do not perform so poorly.
Jul
5
asked Obvious inefficiencies in this Netezza query?
May
12
accepted How to view the full, flattened query underlying a Postgresql view?
May
11
comment How to view the full, flattened query underlying a Postgresql view?
I mean I want to see SQL, not the query plan.
May
11
accepted How should permissions for anonymous users be modelled?
May
11
asked How to view the full, flattened query underlying a Postgresql view?
May
6
asked How should permissions for anonymous users be modelled?
Jan
14
accepted Is there any reason that metadata should not be a part of my database schema?
Jan
13
awarded  Yearling
Jan
13
asked Is there any reason that metadata should not be a part of my database schema?
Sep
11
asked Data type for a fuzzy date?
Jul
2
comment What is the primary key on a temporal table?
Fair points both.
Jul
2
comment What is the primary key on a temporal table?
Thanks for your answer. 1. That would make the query simpler and probably faster but I'm just trying to fully normalize the model at the moment. 2. I'm aware of bitemporal methods; my example is the simplest case. 3. Could you elaborate on the problem of row ordering that you refer to in the triply-paranoid case?
Jul
2
asked What is the primary key on a temporal table?
Jun
17
awarded  Supporter
Jun
17
awarded  Scholar
Jun
17
accepted How should I model an “either/or” relationship?
Jun
10
revised How should I model an “either/or” relationship?
missing word "something"