The 2nd Monitor

Duga

12:00 AM

There are 1419 unanswered questions

Quill

Ew. There's a tag called to-do-list

wow! That's a stellar feature!

Phrancis

0

A: Burn the [database] tag?

I actually follow this tag, so I figured I would take the opportunity to chime in a bit. I wrote a little SEDE query to find what other tags are being used along with database, besides the usual SQL and NoSQL culprits. I have not spent that much time looking at each one individually, but appa...

@Lyle'sMug ^^

So, @QPaysTaxes let me have a quick smoke, then I'll explain that stuff

Yes

Phrancis

12:19 AM

Why in the world are you writing Latin?

rolfl

Dulce et ducorum est, pro patria mori

Phrancis

So, @QPaysTaxes are you familiar with the syntax WHERE foo IN ( ... )?

rolfl

Yeah, how about the modern caesar? Veni, Vidi, Visa

I came, I Saw, I charged it.

It would be, yes.

Phrancis

@QPaysTaxes Assuming then you're also familiar with WHERE foo NOT IN ( ... ) right?

Right

So my idea was to make a data subset, although I wrote it wrong, that would exclude posts with certain Tags criterion

rolfl

Visa Inc.

Visa Inc. (/ˈviːzə/ or /ˈviːsə/) is an American multinational financial services corporation headquartered in Foster City, California, United States. It facilitates electronic funds transfers throughout the world, most commonly through Visa-branded credit cards and debit cards. Visa does not issue cards, extend credit or set rates and fees for consumers; rather, Visa provides financial institutions with Visa-branded payment products that they then use to offer credit, debit, prepaid and cash-access programs to their customers. In 2008, according to The Nilson Report, Visa held a 38.3% market share...

6 mins ago, by rolfl

I came, I Saw, I charged it.

Duga

12:32 AM

I'm voting to close this question as off-topic because it's a clear request for a code review. We have a SE site for code reviews. — sevenseacat 20 secs ago

Phrancis

So this might be due to SEDE database setup, but I would have expected something like this to work:

WHERE Posts.Id NOT IN (
  SELECT p.Id
  FROM Posts p
    INNER JOIN PostTags pt
      ON p.Id = pt.PostId
    INNER JOIN Tags t
      ON t.Id = pt.TagId
  WHERE t.Id = @DatabaseTag
    AND t.TagName LIKE '%sql%'
    AND t.TagName LIKE '%db'
    AND t.TagName = 'db2'
)

Legato

How's it going guys and gals.

Phrancis

Hey @Legato!

Legato

Eastern Standard Time?

:|

Hey @SirPython

SirPython

Hello, @Legato!

Pimp:

3

A: A code review without the code

I've more or less said this before in a different context, please forgive me that I'm too lazy to go find the link right now. No. These answers are not discouraged. Answers are under no obligation what so ever to contain any code at all. Some great reviews have been given that fall under this ...

Phrancis

12:46 AM

Whoa, finally got it working

Or... not

OMG finally it is

SELECT
    p.Id AS [Post Link]
  , p.Tags
FROM Posts p
  INNER JOIN PostTags pt
    ON p.Id = pt.PostId
  INNER JOIN Tags t
    ON t.Id = pt.TagId
WHERE t.Id = 2         -- 'database' tag
  AND p.Id NOT IN (
    SELECT
      PostTags.PostId
    FROM Tags
      INNER JOIN PostTags
        ON Tags.Id = PostTags.TagId
    WHERE
      Tags.TagName LIKE '%sql%'
      OR Tags.TagName LIKE '%db'
      OR Tags.TagName = 'db2'
  )

@QPaysTaxes ^^ does this make sense to you?

It joins data sets on a value/key as long as both references are not null

As opposed to LEFT JOIN and RIGHT JOIN which do allow nulls

Forgive the terrible aliases, but AND p.Id NOT IN (...) queries a subset of data that I want to exclude

And the inner WHERE clause uses simple string functions to filter the data subset

You don't know, until you know :)

It's more commons to use CTEs for things like that, but some DBMS don't support them

ahem... MySQL...

RubberDuck

1:01 AM

Tomorrow. just-sayin-hi

Captain Obvious

0

Q: C# Simple Binary Search Tree

At the moment I am learning algorithms and here I am trying to implement simple binary search tree. I would like to know your suggestions of whether I am on the right track or not, and how this can be improved. BinaryTree.cs class BinaryTree { private Node root; private int count; ...

c# algorithm

Phrancis

@QPaysTaxes For reference, here is my updated, working query: data.stackexchange.com/codereview/query/edit/322187

LMK if you have other questions :)

Owait

Here: data.stackexchange.com/codereview/query/322243/…

Copied the wrong URL

mjolka

@JeroenVannevel pastebin.com/sMuVTXKC

Duga

perhaps better for CodeReview? — Ben Knoble 50 secs ago

mjolka

damn, every time

i'll try again: @JeroenBeneditchCumberbatchGyllenhaal

Phrancis

1:07 AM

wut

Captain Obvious

0

Q: Function to return the sum of multiples within a range

A program that will return the sum of the multiples of any list of positive integers. So for example if I wanted to know the sum of every integer that was a multiple of 3 and 5 that is less than 10 I would add 3,5,6, and 9 to get 23. My function can do this for any number of positive integers, b...

python programming-challenge functions

mjolka

iway eakspay away ialectday ofway atinlay

then i should ask my university for a refund

Phrancis

@QPaysTaxes You might have better luck on Christianity.SE for someone who knows actual Latin

mjolka

caveat mentor

Phrancis

I think it's still taught in priest/pastor training, along with ancient Greek and Hebrew

Phrancis

1:25 AM

Ah, yes, good point

In any case, there's always Google Translate lol

mjolka

@JeroenVannevel have you considered splitting the name analyzer into smaller ones? one for fields, one for classes, one for structs, etc.

Phrancis

To be fair, Latin is a very old language

Lyle's Mug

@Phrancis thank you for the reply

I will have to just start editing them again and answer some questions.. I need to get my reputation up some more

Phrancis

@Lyle'sMug I'm curious what others would have to say about it

Lyle's Mug

lol I have to get to 20k for when we graduate

@Phrancis I as well. but I think you are right.

brb, I have to get kids into bed. it's past their bedtime.

Phrancis

1:35 AM

@Lyle'sMug Especially the gurus of databases, monkey and fishy

rolfl

I am in a monkey mood.

Phrancis

HAI

rolfl

especially in regards to database.

Lyle's Mug

@Phrancis I am surprised they haven't said anything yet, actually

rolfl

@Lyle'sMug - it's been a tough few days.

About tags in general, they are hard to be objective about, and consistent with.

as a mod, particularly, it is hard to differentiate what I think as a person, and what would be 'right' for the site.

Phrancis

1:39 AM

database if I'm not mistaken, with Id 2 could have been the 2nd tag created on the site (though this could very well be due to grabbing part of another site's tags data, and to alphabetical order)

rolfl

and, it is time consuming, and not-much-fun to try to write long posts about what i feel.... especially when tomorrow it may be something else, and I may just be contradicting something I said before.

Phrancis

Oldest non-SQL post with the tag was on 2011-01-28 07:56:03 : codereview.stackexchange.com/questions/359

rolfl

If this AAA (like java ) is the set of tags that make sense, and are easy.... and this ZZZ like code-review ) is the set that are stupid and make no sense, and are easy... then, this is what tags look like to me:

AAA

ZZZ

there's a lot of space in between.

I find it very hard to put a line in there......

As for database, well, I like it, but I can't justify my reasoning for it....

And, some of the questions make it make sense, but most are probably redundant.

of the redundant ones, the redundancy is not really a problem.... is it?

Phrancis

I would bet a quarter that those tagged with database relate to some form of another of DBMS we already have a tag for

But, taking the example I just cited, tagging it with sqlite seems inappropriate, since it's all Java

rolfl

The thing is, a database can be anything.... really, including a text file on disk, or an XML document, or an ObjectStore like Swift, or a file-system....

The abuse of the database tag is relatively benign, and does no harm

I don't see much reason to spend a lot of time investigating it.

Not at the moment, anyway

I would much rather everyone spent the time tackling a zombie, or 3

5

Phrancis

1:46 AM

@rolfl That may be the wisest thing I've heard today!

rolfl

Having said that, I don't want people to think it is unimportant..... keeping tags clean is important, but that is why being a moderator is sometimes a case of trusting the community.... and really "being the exception handler". In theory, you "all" should be making the decision, and mods just acting on the result ;-)

If you're interested in what's been taking up our time (Jamal, 200_success, and myself), mostly, it's been other meta issues, communicating with the SE staff (CM's and so on), and trying to communicate concerns about how the recent beta-clarifications affect Code Review, and what it means to us as a site.

Phrancis

That, it does

Not always a bad thing though

rolfl

The vast majority of beta sites have appreciated the clarification, but a few, like us, may be affected negatively.

(at least, that's a big concern I have anyway).

263

Q: Graduation, site closure, and a clearer outlook on the health of SE sites

Back in April of 2010, Joel shared our assumptions about the role of small sites in the newly minted Stack Exchange network: If a site does not have enough activity at the end of 90 days, it will be closed down. Any existing Q&A will be archived and made available for download, but the site...

discussion featured beta-phase beta-sites graduating-sites

13 mins ago, by rolfl

I would much rather everyone spent the time tackling a zombie, or 3

Legato

^

rolfl

2:02 AM

9

A: What IS a Code Review?

Ideal situation - asker Code Review is where you go to get feedback on your code that teaches you at least one new way to do things (better). Premise: you bring your code - and you have it in a state where it represents the best you can do. Expectation: someone helps you see things differently...

Legato

Though, don't underestimate yourself. I think it's easy to do to that, I have no idea how I ended up with as many questions answered as I have...and it's all within a short span of time (When school stuff didn't take up all my time).

rolfl

> Premise: you bring your experience - there's always going to be someone who has less experience than you in something.

Legato

@rolfl While I think that's true, in general, it's doubtful when we talk about this stuff. The second I tell you something you don't know It'll shock me.

I haven't been as active but I lurk CR, and your awesome answers are still a study in and of themselves. :P

rolfl

I am very good at giving the impression I know a lot, and I likely have many more years experience than you, but I am embarassingly narrowly-focused....

Legato

I do try when I get the chance.

Phrancis

2:07 AM

1 hour ago, by Phrancis

You don't know, until you know :)

Jeroen Vannevel

@mjolka What would that solve?

Phrancis

@Legato ^

Legato

?

mjolka

@JeroenVannevel splitting them up? let the user turn them off individually

Phrancis

(not Jeroen's the one above)

nhgrif

2:08 AM

@rolfl "ObjectStore like Swift"? Huh?

Legato

Yeah, I saw.

Jeroen Vannevel

Aha.

rolfl

@nhgrif wiki.openstack.org/wiki/Swift

Jeroen Vannevel

mmm I'm not opposed to it but that would make for a lot of work I don't feel like doing right now

mjolka

fair call

nhgrif

2:09 AM

CoreData?

rolfl

wiki.openstack.org/wiki/Swift

Phrancis

@Legato I started here asking questions about MySQL a year ago. Now I'm starting to answer questions in other, non-DB languages, on occasion. We all get better with time :)

Jeroen Vannevel

If one day there is a demand for it, I'll force myself to do so

I had a quick look at the diff you showed but I'll look at it in more detail tomorrow or friday

probably friday since I have an exam to prepare tomorrow

mjolka

@JeroenVannevel sounds good. if you like it i'll be happy to submit it as a pull request -- would be nice to have more activity on my github account

Phrancis

@QPaysTaxes What is it with people and not wanting to sew?

rolfl

2:11 AM

@nhgrif Do you have some sort of alert for "swift" ?

nhgrif

swift-is-magic

Legato

Yeah. I'm still so happy I joined the site and grateful to the people on here. I've gotten a lot better as a result, and it's why I want to use it more. I still am amazed at even my answer quality, and it's 90% just the result of using the site. I like that I was helped and could pass on the knowledge/awesomeness.
I do worry about having nothing to contribute but more questions though.

Jeroen Vannevel

@mjolka a PR would be easier to review, yeah. It works with the latest version of master?

nhgrif

Nah, I have finally just had a few moments to drop in...

Phrancis

@QPaysTaxes There's your answer :)

mjolka

2:12 AM

@JeroenVannevel yep. i'll see if GetNamingConvention could be used to simplify the analyzer as well (not just the code fix)

Phrancis

Tailors sew because X. Coders code because X. Figure X out, and you got the answer to life, the universe, and everything.

Jeroen Vannevel

One thing I'm unclear about is why there are 3 naming convention-related variables

rolfl

@Legato and others .... you don't need to be an expert to have a different perspective/suggestion on questions. You just need to know 1 thing that is more/different than the person asking the question.

mjolka

@JeroenVannevel ?

Jeroen Vannevel

Oh wait. This is the naming convention analyzer

That makes sense then

Legato

2:13 AM

@Phrancis But 42

Jeroen Vannevel

Yeah, throw your changes in a PR. Much easier to review

mjolka

@JeroenVannevel will do

rolfl

DA's HHGTTG

nhgrif

@rolfl Exactly... after all, I know nothing about PHP...

Lyle's Mug

@Phrancis that post could use sqlite

Jeroen Vannevel

2:14 AM

somebody perform the heimlich on @rolfl

rolfl

@nhgrif and I have a C# tag badge.

Legato

I have a streak of 42 on my Github, I'm waiting for the day someone catches the reference. :P

nhgrif

speaking of... today, across the corner from my office, we watch emergency responders performing CPR...

Phrancis

@QPaysTaxes Change 'tailor' to 'hobby tailor'

rolfl

@nhgrif Successfully?

nhgrif

2:15 AM

Not sure, entirely.

Phrancis

Oh, right

nhgrif

But apparently, one of the firefighters is the husband of one of my coworkers, so I suppose we'll find out sometime.

They took him away in ambulance.

Lyle's Mug

@rolfl you should pin this.

Phrancis

@QPaysTaxes There :p

Legato

@Lyle'sMug star it!

Lyle's Mug

2:16 AM

@Legato did that before I replied to it! :)

rolfl

@nhgrif Life is .... fickle. And watching it expire is.. affecting. I have found it disconcerting and uncomfortable to process in the past

I still call my dad when these types of things happen

Phrancis

@QPaysTaxes I hate sewing. Needles, thread, all that stuff. Hate it. Why? No idea. I can't point my finger at the tailor though and say, why exactly don't you dislike sewing?

Legato

When the world gives you a Jeffrey...

rolfl

@QPaysTaxes a git project?

Phrancis

@QPaysTaxes Probably about to the same extent hobby tailors do to projects where they have to code a lot...?

rolfl

2:19 AM

When I was in high (boarding) school, I used to break in to the matron's office so I could sew my ripped clothes.

Phrancis

QED!

rolfl

and anyone who does a coding project should commit often.

Lyle's Mug

anyway I need to code while my wife finishes her episode of Roseanne

later guys!

Legato

priorities

Phrancis

Later @Malachi :)

rolfl

2:20 AM

@Lyle'sMug Anything you can code in a partial Roseanne, is not challenging enoug h;-)

Lyle's Mug

I am recreating my website in MVC

trying to set up Bootstrap in VS 2013 Web Express actually

nhgrif

I think, after today, the orientation stuff is actually done, so from now on, I can for the most part code/relax at work.

Phrancis

@QPaysTaxes Yup, looks like it :)

nhgrif

It's pretty laid back.

Lyle's Mug

I am thinking that she just started the episode, she is watching a youtube video, so there are probably more than one in a row. I probably have at least another 15 minutes

Duga

2:24 AM

This would be a good question for StackExchange CodeReview. — ben rudgers 30 secs ago

mjolka

@Lyle'sMug i think VS Community has superseded VS Web Express

Lyle's Mug

I was looking to see if they were going to do like Adobe and Office 365 with their Visual Studio

@mjolka will everything transfer across nicely from web express to community?

Duga

This already has an accepted answer, although @Jonathan is welcome to take his working code and post it to Code Review, if he wants it reviewed — Phrancis 32 secs ago

Captain Obvious

0

Q: currency to words jquery

// Convert numbers to words // copyright 25th July 2006, by Stephen Chapman http://javascript.about.com // permission to use this Javascript on your web page is granted // provided that all of the code (including this copyright notice) is // used exactly as shown (you can change the numbering...

jquery numbers-to-words

mjolka

@Lyle'sMug i haven't tried it myself, but i would hope so

Lyle's Mug

2:26 AM

I think I will stick with Web Express, at least until I am done with these 3 websites and have them published

Phrancis

@CaptainObvious :|

return result; //i added the word cent to the last part of the return value to get desired output

    str += 'and '; //i change the word point to and
    str1 += 'cents '; //i added another word called cent

^ ORLY? YA, RLY.

For some reason, it seems there are schools of coding that think more comments compensate for better coding.

rolfl

@Mat'sMug - you lurking? I would like to discuss your meta answer: meta.codereview.stackexchange.com/a/5421/31503

Your answer is that there are too many broken-code questions....

Mat's Mug

always lurking

what about it?

rolfl

the way I see it, is that the bulk of broken code questions are bad referrals to the site, and bad precedents.

Mat's Mug

perhaps

rolfl

2:33 AM

Your answer is about percentages....

My feeling is that the solution is the opposite of what you are hinting at....

Phrancis

Commented-out code is ignored by the compiler, so no, it will not make it run any slower or any faster. It does seem like your code doesn't work as intended though, which would make it off-topic here. — Phrancis 1 min ago

rolfl

you are hinting that we need to make sure people stop asking bad questions.

How about if I suggest that instead the solution is to ask twice as many good questions ... and then the % results would be in line with expectations

Mat's Mug

@rolfl sure. except we'd need twice the reviewers.

rolfl

true.

That aligns with my answer and hosch250's.

Mat's Mug

what I'm hinting at, is that people don't read. no matter how many walls of site rules you show them, they'll just scroll to that "proceed" or "yeah yeah shut up and let me post" button.

rolfl

2:37 AM

That's true for all sites, not just us.

Mat's Mug

@rolfl exactly. and I believe the red box works on Stack Overflow, otherwise they wouldn't still have it.

rolfl

I think the volume of those click-ignore-click users is a healthy sign

we have a high visibility and a high referral rate

what we don't have is a high "regulars" component

people who know how to ask questions that are not closed

Mat's Mug

60% of questions don't get closed...

rolfl

It should be.... 90%

Mat's Mug

@QPaysTaxes that

@rolfl yes, we agree on that

ok maybe 85% for realistic-ness

@rolfl codereview.stackexchange.com/help/badges/133/inquisitive

rolfl

2:42 AM

@QPaysTaxes Like this?

Did you read it?

Mat's Mug

I read "read this"

rolfl

@Mat'sMug Yes, inquisitive is a good benchmark.

Mat's Mug

and 21 awardees / 50K users is a drop in the ocean

rolfl

@Mat'sMug - data.stackexchange.com/stackoverflow/query/199310/…

We are ranked 20'th overall (sort by ranking), and have 21, and our peers have 4X that

Phrancis

@QPaysTaxes People don't read text, except that which they are interested in

Most people, I'd say

rolfl

2:46 AM

Funnily enough, programmers has only 16

Phrancis

I talk to people all day long who have paid significant money to have the text, and they still usually don't read it

Mat's Mug

a red box with 5-10 words will be automatically read, at least subconsciously

and that will automatically drop the off-topic % by a ton

or "Are you sure your code works as intended? See our [help/on-topic] for details." ..hmm even that is too long.

Phrancis

@rolfl How do you join Posts with CloseReasons? Seems clunky, does it have to go through the Votes data set?

Mat's Mug

nah

rolfl

Mat's Mug

2:51 AM

^^

> Wait! Does your code work?

rolfl

@Phrancis I don't believe you can.... not directly.

mjolka

Mods Hate Him! How One User Discovered The One Weird Trick For Posting Great Questions!

4

Phrancis

@mjolka LMAO

Mat's Mug

@mjolka I'm missing something...

mjolka

@Mat'sMug slate.com/articles/business/moneybox/2013/07/…

Mat's Mug

2:53 AM

lol ok

mjolka

also knowyourmeme.com/memes/trainers-hate-him

Mat's Mug

lol

Phrancis

@rolfl Surely there's got to be a key somewhere that link those? But I've been looking and looking

Wait a minute... I think I may have found it!

rolfl

@Phrancis I think it's in the comments column of the post history for history type 105 or something

Phrancis

PostFeedback seems to link Posts -> PostFeedback -> Votes

rolfl

2:59 AM

138

Q: Database schema documentation for the public data dump and SEDE

Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via archive.org, and also makes that information queryable over the Internet at the Stack Exchange Data Explorer (SEDE). Over time, as new features and other bits of data are introduced to Stack ...

support faq data-explorer data-dump

Phrancis

@TODO RTFM

rolfl

> If PostHistoryTypeId = 10, this field contains the CloseReasonId of the close reason (listed in CloseReasonTypes):

Comments ^^^

Transcript for