193 reputation
3
bio website wimiro.com
location London, United Kingdom
age
visits member for 1 year, 10 months
seen Jun 19 at 10:32

software developer


Jul
30
comment Why should a column in a Relational Database have a single purpose?
Thanks Kilian. I was hoping somebody would say this! Although the problem is that the price of a pear really is a composite. If the price of an Apple changes for the first day then the price of the Pear needs to reflect this without a second update query, hence the requirement for a relationship #thingsclientswant
Mar
30
comment Best practices for sharing tiny snippets of code across projects
Ah, yes. Those too. By issues around discover-ability I mean that given a sufficient number of little packages with specific function maybe it becomes more difficult to catalogue (and find) each. For example, how does your team make known which packages contain various functions? (showing nuget search ignorance here)
Jan
8
comment Database History Table / Tracking Table
On the flip side the query to see which columns change most often will be easier using the approach you've proposed.
Jan
8
comment Database History Table / Tracking Table
So this approach might be overkill. Even worse it won't be easy then to query this table with the one being monitored together to recreate the live data at a point in time, should recreating a snapshot be of any value.
Jan
8
comment Database History Table / Tracking Table
Do you know in advance how many tables you will be tracking?