943 reputation
716
bio website
location Orem, UT
age
visits member for 3 years, 6 months
seen May 13 at 22:08

Adobe Certified Expert - CQ Component Developer


Jan
11
comment How do you document your databases?
I'm curious to see what "database documentation" even looks like, aside from the obvious schema diagram. I have trouble envisioning what you would document and how.
Jan
11
comment Which database engines will allow me to GRANT/REVOKE on a specific column?
Thanks, Peter - I don't have a copy of the specification, so I wasn't sure if it was covered there. I do happen to know that Firebird nee Interbase does NOT support this, and last time I tried it in MySQL, it didn't work (admittedly, that was a while ago in MySQL terms).
Jan
11
comment Are there any database engines which will intuit the join condition based on the existing foreign keys?
No real "concern", just wondering if this is something anyone is looking into addressing.
Jan
10
awarded  Quorum
Jan
10
awarded  Beta
Jan
9
awarded  Commentator
Jan
9
comment Are there any database engines which will intuit the join condition based on the existing foreign keys?
I know none of the common RDBMSes do this - as the question states, I put the question out there to see if anyone had heard of anything new in this area.
Jan
7
comment Which database engines will allow me to GRANT/REVOKE on a specific column?
I just realized this should be a "community wiki" question, but I don't have enough rep to make it so...
Jan
7
asked Are there any database engines which will intuit the join condition based on the existing foreign keys?
Jan
7
asked Which database engines will allow me to GRANT/REVOKE on a specific column?
Jan
7
comment Is there a good “rule of thumb” for translating EXPLAIN cost to (wall-clock) runtime?
Yeah, I figured this was the answer, I just thought there might be a really soft rule that could be used...but thanks for confirming. :)
Jan
7
comment Is there a good “rule of thumb” for translating EXPLAIN cost to (wall-clock) runtime?
Good explanation of how CBO numbers were based. Thanks!
Jan
7
awarded  Scholar
Jan
7
accepted Is there a good “rule of thumb” for translating EXPLAIN cost to (wall-clock) runtime?
Jan
5
awarded  Student
Jan
5
answered Guid vs INT - Which is better as a primary key?
Jan
5
comment Which collation should I choose for a muiti-language website?
The new title reads much better
Jan
5
awarded  Teacher
Jan
5
answered Is it possible to use SQLite as a client-server database?
Jan
5
comment When to use NULL and when to use an empty string?
+1 for pointing out this Oracle oddity...this was a HUGE "WTF" moment for me when I first started dealing with Oracle databases.