network profile
| bio | website | james.lab6.com |
|---|---|---|
| location | United Kingdom | |
| age | 30 | |
| visits | member for | 1 year, 4 months |
| seen | May 12 at 11:00 | |
| stats | profile views | 7 |
I run a website full of photos.
|
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" |
|
Jun 10 |
comment |
How should I model an “either/or” relationship? If I understand correctly, you are recommending a Software entity, and SoftwareType entity. Are you saying Free, NonFree, and OperatingSystem are all just different instances of SoftwareType? I'm sure you're correct, but then where do you store the various attributes of the different types? |
|
Jun 10 |
comment |
How should I model an “either/or” relationship? I would like OperatingSystem to be a separate entity as it is a specialization of Software. It may have attributes that no other Software will have (such as kernel type, RTOS-or-not flag, multiuser flag, etc.). |
|
Jun 10 |
asked | How should I model an “either/or” relationship? |
|
Apr 25 |
comment |
Is a year-to-date dimension the same as a time dimension? May I ask what you mean by an appropriate unit of analysis? I think you mean something like "an appropriately grained dimension". Is that right? |
