2,586 reputation
722
bio website vancouverdata.blogspot.com
location Vancouver, Canada
age
visits member for 3 years, 8 months
seen 6 hours ago

MBA Finance
BA Econ
Data Mining
C#, Javascript, VB, SQL


2d
comment How to restrict access to current user record and its rights in postgres
9.4 gives you updateable security barrier views and WITH CHECK OPTION too.
Nov
21
awarded  database-design
Nov
20
revised Marking duplicate records
added 7 characters in body
Nov
20
revised Marking duplicate records
added 286 characters in body
Nov
20
asked Marking duplicate records
Nov
20
comment How to restrict access to current user record and its rights in postgres
Can you wait for version 9.4? Do you need your own users/roles or can you use PG's built-in users/roles?
Nov
17
answered which type of database to choose for OLAP applications?
Nov
15
comment When using underscores, should they be reserved to junction tables?
Depends on your database. You should use snake_case for all identifiers in PostgreSQL. Which means that if you want to be cross-database compatible, you should use snake_case for all identifiers in all databases
Nov
11
comment Database Security - Prevent column writing?
postgresql supports column level security. see the GRANT statement in the docs
Nov
5
revised Dealing with co-dependent not null columns
added 38 characters in body
Nov
5
comment Dealing with co-dependent not null columns
@Kenneth_fisher, foreign keys are part of the data model. Check constraints are great if you got em and if single table. Triggers necessary for multi table biz rules. My main point was that data model should be generalized and biz rules should not compromise a good data model.
Nov
5
answered Dealing with co-dependent not null columns
Nov
2
comment Good way to restructure a table
Don't forget: doctors can be patients.
Oct
29
revised Trying to map postal codes to their respective cities, but running into some issues
deleted 1 character in body
Oct
27
revised Trying to map postal codes to their respective cities, but running into some issues
added 232 characters in body
Oct
26
answered Trying to map postal codes to their respective cities, but running into some issues
Oct
22
answered One field with multiple values?
Oct
21
revised What are Measures and Dimensions in Cubes
added 62 characters in body
Oct
21
revised What are Measures and Dimensions in Cubes
added 62 characters in body
Oct
20
revised Fuzzy Matching with Postgresql 9.3
added 196 characters in body