1,708 reputation
618
bio website vancouverdata.blogspot.com
location Vancouver, Canada
age
visits member for 3 years, 1 month
seen 4 hours ago

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


Apr
10
answered postgresql bigserial or sequence using jpa
Apr
8
comment How to implement business logic permissions in PostgreSQL (or SQL in general)?
@JohnCand I don't really see how it's easier to manage permissions elsewhere, but please point us to your solution once you've found it! :)
Apr
7
revised How to implement business logic permissions in PostgreSQL (or SQL in general)?
added 11 characters in body
Apr
7
revised How to implement business logic permissions in PostgreSQL (or SQL in general)?
added 68 characters in body
Apr
7
revised How to implement business logic permissions in PostgreSQL (or SQL in general)?
deleted 140 characters in body
Apr
7
revised How to implement business logic permissions in PostgreSQL (or SQL in general)?
added 68 characters in body
Apr
7
revised How to implement business logic permissions in PostgreSQL (or SQL in general)?
added 165 characters in body
Apr
7
comment How to implement business logic permissions in PostgreSQL (or SQL in general)?
@a_horse_with_no_name yes I did. He could write his own RLS/ACL system, or he could use a database's built-in security to do what he is asking for.
Apr
7
answered How to implement business logic permissions in PostgreSQL (or SQL in general)?
Apr
6
comment Organizing a couple tables in postgresql
Cool, the first ever question on database design for Q&A sites!
Apr
3
comment Database Normalization: A Case Of The NULLs
Either use Sixth Normal Form, which is a pain in the ass, or live with nulls, like everyone else.
Mar
30
answered Efficiently storing irregular/repeating intervals (think calendar/events)
Mar
19
comment How dangerous is it to have a user's password in plaintext in a cgi script?
Operating System environment variables, not apache ones.
Mar
19
comment How dangerous is it to have a user's password in plaintext in a cgi script?
It's probably not super dangerous in this limited case, but using envvars is a globally good solution, so it's probably worth getting used to so that you use it automatically in other situations.
Mar
19
revised How dangerous is it to have a user's password in plaintext in a cgi script?
edited body
Mar
19
answered How dangerous is it to have a user's password in plaintext in a cgi script?
Mar
19
revised Ready-to-Use Database models example
added 690 characters in body
Mar
19
comment Help understanding database design logic for a secondhand bookstore project in MySQL
It's a waste of time to re-invent the wheel when quality data model patterns exist for this exact problem.
Mar
18
answered Help understanding database design logic for a secondhand bookstore project in MySQL
Mar
12
answered Dynamically change schema to accommodate custom fields!