2,845 reputation
825
bio website vancouverdata.blogspot.com
location Vancouver, Canada
age
visits member for 4 years
seen 13 hours ago

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


2d
awarded  Nice Answer
2d
revised Ready-to-Use Database models example
added 68 characters in body
2d
revised postgresql bigserial or sequence using jpa
added 63 characters in body
Mar
19
comment What limits the number of connections?
Thanks Erwin. So which system resources are limiting? Sounds like #cores and spindles. Is a particular OS better than others?
Mar
19
asked What limits the number of connections?
Mar
14
comment Inheritance of unknown type at creation time
Only use Inheritance for IS AND ALWAYS WILL BE relationship. Use Composition (hasMany) for PLAYS THE ROLE OF relationships
Mar
11
answered Java Spring application Database triggers auditing - how to provide the right user that made the change
Mar
5
awarded  Yearling
Mar
5
comment Random unguessable primary key which preserves correct order
Why don't you look into Row Security instead?
Feb
20
answered How match a numeric column with a varchar parameter?
Feb
18
answered Good encryption performance
Feb
18
comment How do I alter my role to be a superuser?
You can't become a superuser if you're not a superuser. Google "postgresql reset password"
Feb
14
awarded  Popular Question
Feb
11
comment Is it bad idea to create foreign keys on the tables in a different schemas in the same database for big applications?
Is it wrong to use a function from namespace A that calls a function from namespace B? Essentially the same question.
Feb
3
answered Multiple instances of same foreign key in a single table
Feb
3
comment Multiple instances of same foreign key in a single table
How about a diagram? Table A references Table B via 4 columns?
Jan
27
comment Normalizing: when to apply 2NF and 3NF
Why don't you tell us the problem and give us your solution...
Jan
27
answered PostgreSQL: Foreign key on string column
Jan
16
comment Feasible to have thousands of users in Postgres?
@David PGAdmin was okay, just slow. psql should be fine. Might be able to tweak PGAdmin to speed things up.
Jan
15
revised Feasible to have thousands of users in Postgres?
added 19 characters in body