« first day (2970 days earlier)      last day (1881 days later) » 

2:56 AM
1 message moved to Trash
 
 
5 hours later…
7:42 AM
Morning
 
Morning
 
8:16 AM
Morning
 
8:30 AM
Morning
 
8:55 AM
> People's shoes are crashing after a Nike app stopped working.
> "App wont pair with left shoe," the top review reads.
> Nike sent out a firmware update intended to fix problems with the shoes. Downloading and applying that caused the Android app to break.
This has gone too far
 
yea... but like... isn't that like the Mitch Hedberg joke about escalators?
> "sorry your shoes cannot boot, now you can only use them as shoes"
 
@TomV HAHAHA. The shoes do have manual controls, meaning that people can lean down and tie them up"
Hey how do I do a cool inline quote like that?
 
prefix it with >
 
 
1 hour later…
10:12 AM
Morning
 
 
2 hours later…
12:10 PM
afternoon
 
12:25 PM
@dezso are you around?
or @Colin'tHart
how would I go about troubleshooting failed connections from tomcat to postgres, is there a failed login log anywhere or something?
Nevermind, the configuration json for the tomcat application contained an error
 
 
4 hours later…
4:16 PM
@TomV if there is a Postgres log, errors are all stored in there. (of course only if the connection already reaches the DB)
 
4:28 PM
@EvanCarroll are you on twitter?
 
4:47 PM
@ErikDarling yar @TheEvanCarroll
 
5:01 PM
I just suggested the usage guidance for unique-constraint, in case you or other people are interested in reviewing it. — MDCCL 5 mins ago
 
5:52 PM
I think we could make it a little bit shorter.
"Unique constraints ensure that the data contained in a column, or a group of columns, is unique among all the rows in the table."
Go into more info in the tag wiki.
 
6:05 PM
@MDCCL I tried to clean it up a little bit and wrote out the wiki dba.stackexchange.com/tags/unique-constraint/info feel free to roll it back if you like the other one better. Good luck with the tag!
 
6:24 PM
@EvanCarroll Thanks. The info you added is very useful IMO. I was (and currently am) working on that tag info too, so I'll suggest an extension to your contribution soon.
 
6:55 PM
@dezso thanks. What do you mean 'if' there is an error log? Should I configure that?
 
Think you're going way overboard with the tag wiki for unique-constraint.
What about Postgres partially unique constraints?
What about unique indexes?
 
@Colin'tHart That aspect is considered in my suggestion
 
Be my guest to make the tag wiki page the be-all-and-end-all documentation on unique constraints...
 
@Colin'tHart That may be added, but I consider that its a different kind of UNIQUE constraint
@Colin'tHart That's why it's a suggestion, feel free to reject it if you deem it appropriate
The peer review process seems to work well, IMO
 
34
Q: What is a tag wiki? How do I write a good one?

Ilmari KaronenAs the title says: What are tag wikis, and how do I write a good one? Return to FAQ index

Seems totally appropriate to me.
2
> general background information on the subject,
 
7:48 PM
One of the objectives with respect to these tag changes was attracting attention of DBA.SE users, and all the feedback can help in improving the site, even if it's only one tag (which I consider very important, BTW)
If my suggestion is approved and one single reader of the tag wiki find its information helpful, then my effort would be worthwhile.
In case it gets rejected, it has been an interesting exercise anyway.
 
8:20 PM
That tag wiki proposal should've been on documentation when that was still a thing
It would've been a mic drop there
 
 
2 hours later…
10:22 PM
Speaking of UNIQUE constraints, KEYs, etc., I just found an interesting question:
2
Q: Do candidate key concept exist only in theory?

anirI know the concept of candidate key in RDBMS theory. But do candidate keys really exist in actual SQL engines? I mean is there anyway to designate particular column or a set of columns as candidate key in any of database systems, say SQL Server, postgres, MySQL, Oracle etc.? Is there any reserved...

 

« first day (2970 days earlier)      last day (1881 days later) »