The 2nd Monitor

6:00 PM

Opening SO in another tab to ask that question, but keeping this window open. In the mean time, anyone want to take a crack at this question? stackoverflow.com/questions/35835894/…

Pin Crash

@Hosch250 I tried but there's not a way that I could find to do perma-delete, seems like VBA has to first mark it as deleted (i.e. "move to deleted items") and then empty the deleted items from the server

Hosch250

You should be able to mark as deleted, then perma-delete.

Pin Crash

Right

Not sure if it'd be more efficient to do that for every item, or to let them build up and empty it on occasion, say a few times a day

Hosch250

That might be a premature optimization. Maybe not.

In the first place, why don't you just block all emails from the spamming addresses?

Pin Crash

I might be able to write a rule for the deleted items though, say when they reach X items, then go ahead and prema-delete them all

Duga

6:08 PM

You might want to take this here — cbay 13 secs ago

Pin Crash

@Hosch250 Because not all messages from those addresses are necessarily spam, there are some that come in that I have to pay attention to

It's unfortunate that those are about 1 in 500 or 1000

Duga

How exactly is requesting a resource for code review "not about programming"? — James B. Byrne 47 secs ago

This question as currently presented would be off-topic on Code Review, as the code to be reviewed must be included in the question (rather than a screenshot/image of it. Besides that, if the code works as intended and the author is looking for improvements, Code Review would be appropriate. — Phrancis just now

You should probably post this on Code Review instead. This code "works" but you want a more efficient solution. — rayryeng 7 secs ago

Shortstuff81000

OK, here's my SO question: stackoverflow.com/questions/35850884/…

Duga

The updated code is up on Code Review - codereview.stackexchange.com/questions/122165/… (let me know how i can improve this and do things correctly) — Latheesan 40 secs ago

@JamesB.Byrne He's asking for a directory service to find people. The programming is incidental. However, if there is specific, working code that OP wants reviewed and can post publicly, then Code Review may be helpful. If the code is not working, it could be part of another question here at SO. — Dan Lyons 37 secs ago

possible answer invalidation by denis on question by denis: codereview.stackexchange.com/posts/122102/revisions

Captain Obvious

6:26 PM

0

Q: MSSQL Database trigger to monitor insert/update event and update another table

I am working on a MSSQL Database (for a program called Sage 200). There are many tables in the database, however, I want to be notified of changes (new record inserted or existing record updated) via Trigger on a specific table. I also want to support multiple rows on this table being updated at...

0

Q: Checking if a 3D point is outside of a trapezoid

I have recently written if a 3D point is within a specified trapezoid. It does it by checking 3 different planes of the trapezoid. I place the relevant 2 coordinates from the 3D point into the current plane being checked, this will form four triangles within the plane, if this area is greater tha...

java performance

CommitStrip

6:39 PM

http://www.commitstrip.com/en/2016/03/07/whos-wrong/
CommitStrip
Who’s wrong?
CommitStrip
1457375563

Jeroen Vannevel

@CommitStrip For several years I always had the same pw for services that used my email as my email itself for precisely this reason

Pin Crash

@CaptainObvious Hey look isn't that the same Sage thing that @Mat'sMug has been working on?

Mat's Mug

Sage200. My API wraps Sage300. Don't ask me what the difference is ;-)

what he's doing is voiding his support agreement if he has one

Pin Crash

Ah, so they are modifying Sage's database?

Mat's Mug

you're not supposed to do anything directly with the db, only access it through their "View" API

yeah

Dan Pantry

6:42 PM

@Hosch250 I do, why?

I am, by the way, far from a jQuery expert... given that I quite despise it :p

2

Hosch250

@Shortstuff81000 wants help.

Pin Crash

@Mat'sMug Makes sense, I'd assume the vendor can't be held accountable to support a modified version of their product(s)

Mat's Mug

yeah, except their "view" API is one of the shittiest db access API I've ever seen. but my code uses it and writes like Entity Framework nonetheless :)

Malachi

@Shortstuff81000 where are you going with this? what is the next step?

Mat's Mug

that said I haven't seen a ton of db access API's.. but between Sage's "Views" and, say, DAO, ADODB, ADO.NET, Linq-to-SQL, Entity Framework, and NHibernate, I pick any but the former.

Malachi

6:49 PM

Where did she go?

Malachi

7:01 PM

@JohanLarsson you actually did address some exception handling when you mentioned the int.TryParse

Captain Obvious

0

Q: Guidance on grouping equal sets of numbers, so each group has a similar average

Goal: I am trying to build teams of 5 people. Each person has an integer elo (rank). My goal is to make all the teams as equal/fair as possible, by having the average elo of each team be as close as possible to one another. Approach: My initial thought was to go through the list of elos and take...

javascript sorting

0

Q: Nested try catch

I need to validate database connections in a separate function. Why is SonarQube plugin for Jenkins complaining about the open statement if I close it in the finally block? final String PING = "SELECT 1 from dual"; public boolean validateConnection(Connection conn, boolean isKeepAlive) { Prepa...

java

0

Q: Find csv item index

I'm quite new to Python and I have been trying to find a way to search a csv for a test string and return the index of that item in the csv. I am using the code below but find it hard to believe that there is not a function built in to the csv module to do this. I want to perform the 'lookup' s...

python csv

Johan Larsson

ok good, felt like a boring review, feels better now when you say you are somewhat happy with it

Duga

possible answer invalidation by Liam on question by Liam: codereview.stackexchange.com/posts/122120/revisions

Vogel612

hrngghhh dark souls...

y u so hard with slow weapons?

and why the crap is dodging so utterly useless depending on where you dodge to?

Liam

@Duga ?

Vogel612

7:07 PM

she just saw you edited the codeblock in your question

Liam

Is that automated (sorry I'm new)

Johan Larsson

yes duga is a bot

Vogel612

more here:

23

Q: Welcome to The 2nd Monitor!

So, you have found your way to the Code Review main chat room, The 2nd Monitor, perhaps for one of these reasons: You were invited or "pinged" by a site moderator or other user to discuss a post on the main Code Review site; You visited Code Review for the 1st or Nth time, and noticed the chat ...

discussion faq chat new-users

Liam

Thank you.
I actually had a question about that post.
Someone posted a much more idiomatic and cleaned up version of my code in an answer, is it acceptable to use that code in the original post? (because the focus is performance)

Dan Pantry

No, you shouldn't modify the original question after receiving an answer

That's what "answer invalidation" is

Vogel612

7:12 PM

that's exactly what the warning is about :)

Liam

hah good thing I asked then. Thanks

Vogel612

hmm.. I'm wondering whether I should rewrite the "tracking graduation progress" table into mathjax...

actually I should do something productive today.

Pin Crash

@Mat'sMug lol... Maybe you can sell Sage the thing you wrote as an upgrade to their product's DB access API ;)

Shortstuff81000

Sorry, @Malachi. I just finished lunch and now I'm researching. Seems my issue was already answered here: stackoverflow.com/questions/14220321/…

Mat's Mug

@PinCrash yeah.. where "you" is actually "my employer"... and then I can ask for a bonus :-)

Pin Crash

7:23 PM

There ya go!

Duga

This question would probably have been better if asked on Meta Stack Overflow, as you're really asking if SO is the appropriate place for code reviews or not. As such your question isn't about why your code doesn't work, which is the basic reason for SO, but instead is where to go when your code works but you want to improve it. — the Tin Man 52 secs ago

Shortstuff81000

@Malachi I'm still a little confused, though; it seems to me that no matter what function is opening the XML, any method can retrieve the data? Sorry, I know I'm getting my words mixed up. I'm trying my best to explain, but I'm confused. :D

Malachi

@Shortstuff81000 do you have a repo of your project? like on github or somewhere?\

Shortstuff81000

@Malachi No, but I can upload it to my Drive and share it with you. :D

@Malachi OK I think I can ask my question in fewer words; any function I write can access the XML DB if it has the variable "xml" in its arguments and employ the $(xml).find('Character').each(function () { function?

Malachi

yes.

Shortstuff81000

7:31 PM

Awesome! Now I just need to figure out my checked event functions for my buttons. They are checkboxes turned into a buttonset using jQuery UI. :D

Malachi

you should create a variable for your characters though

then you don't have to keep writing out $(xml).find('Character').each(function () {

you can create Character objects with the first function and wrap them into an array or whatever.

@Shortstuff81000, we need to get you going on Github or BitBucket so we can work on stuff together, then you can share with these guys more easily as well. that way we can clone the whole thing (if you want to have your project open source) and run it on our machines

Shortstuff81000

I did create a Character object. I could create an array of characters with XML data in it, and still limit the number of characters to 5. (player + 4 "guests"). It's going to be based on Clue a little bit. :D I shared my project with you @Malachi

@Malachi I'll check them both out. :D

Malachi

I won't be able to look at it while I am at work. I can wander from my path a little bit, but I don't want to push it the second week

Shortstuff81000

Haha I wouldn't, either. I just created a github account. :)

Captain Obvious

7:54 PM

0

Q: Wordpress downloader and unpacker

Wrote a small bash-script today that downloads the latest swedish wordpress archive , extracts it and writes wp-config.php Would appreciate any feedback that could improve it / prettify it. The script assumes that the database name & the username is always the same. #!/bin/bash #Download word...

bash wordpress

1

Q: Task Scheduler with Dependencies

I have need for a task scheduler determined by a directed graph. The tasks are held in a std::vector<task_type>, while the dependency graph is held in a adjacency_list<vecS, vecS, bidirectionalS> (bidirectionalS so that I have access to the in_degree() function). A single dispatch will start the ...

c++11 multithreading c++14 scheduled-tasks

Shortstuff81000

8:05 PM

@Malachi what is Gitmore? Do I need it?

I am creating a repository for the project now. :D

Malachi

I don't know about Gitmore.....

I haven't heard of that.......

my github is malachi26

Shortstuff81000

Awesome. Do I need to choose a license?

Pin Crash

@Shortstuff81000 Need, no; should, probably

Shortstuff81000

Which one, since it's a work in progress in need of collaboration? :D

Pin Crash

You want it to be totally open-source, anybody-can-use/contribute/view?

Mat's Mug

8:09 PM

using GitHub is easy: go here and click the star icon at the top - github.com/rubberduck-vba/Rubberduck

2

:p

Pin Crash

lol

Captain Obvious

0

Q: Reporting the status of the actions of a group of SKSpriteNodes

Working on a little Sprite Kit game, I had the problem that I wanted a couple of things to wait until a group of sprite nodes had stopped their animation. I decided to use a GCD dispatch group to monitor the sprites' actions. The nodes that I was concerned about were all instances of the same c...

objective-c concurrency grand-central-dispatch

1

Q: Converting custom format to XML Template without using any XML module

I've just finished writing a simple python 3 program which converts a custom input file to XML. It works as it is, but I think that I somehow messed up the code as I had to open several files, append to them, close them, loop through files and so on. I thought of splitting my code into methods,...

python design-patterns

Shortstuff81000

@PinCrash Yes

Pin Crash

@Shortstuff81000 MIT license probably would be fine then - See choosealicense.com

Shortstuff81000

Cool. Thanks, @PinCrash

Pin Crash

8:12 PM

NP

Mat's Mug

join the club wink-wink nudge-nudge

Pin Crash

@Mat'sMug "Pimp My ~~Ride~~ Repo"

Mat's Mug

yes, I'm github-star-whoring

I need to get to 376 stars and rank #1 - Rubberduck is currently #2 among all GitHub repositories that mention "VBA"

JohnP

Hey, quick question for the residents:

Is review of a DB table structure off topic? My instincts and a quick glance at the help section say yes, but...

ERD I should sayh, not a table structure.

Jeroen Vannevel

I would say no but I'm often an outlier on those things

Pin Crash

8:19 PM

We have reviewed DDL SQL code before, which includes DB structure. But reviewing an ERD diagram, yes that is off-topic, unless it comes with the DDL code as well

Mat's Mug

i.e. the DDL script itself, reviewed as such

if you have concerns about the data structure, you might want to ask on DBA.SE instead

JohnP

@PinCrash Ok, that's what I thought. Bugger. I'm writing a proposal for freelancer or whatever they call themselves now.

Pin Crash

@Mat'sMug ehhhhh I tried that before, a little iffy there too

Mat's Mug

ah, good to know

JohnP

@Mat'sMug I don't think it's on topic there either, although someone in chat might do it.

Pin Crash

8:21 PM

DB structure is usually tied to the business logic/data, which is something DBAs usually don't touch

JohnP

Is it a dichotomy that I'm a software professional, yet I want to bid out my personal projects at the lowest possible level?

Pin Crash

Depends, really.

Shortstuff81000

Hey, @Mat'sMug I saw you on github LOL! :D

2

That's awesome. :D

Mat's Mug

cool!

thanks :)

Shortstuff81000

You're welcome. I'm working on my readme file now. It should explain a lot when I'm done.

Jeroen Vannevel

8:40 PM

So much work involved with moving to another country

Before leaving: contact insurance, local government, tax office and UK embassy

After arriving: register at local government and contact Belgian embassy

That includes a shitload of documents and forms and doesn't even contain all the tax hassle that comes with it

Vogel612

@JeroenVannevel so where do you live now? Did you go to London?

Captain Obvious

0

Q: Progressively split and map a large, line-based string

Goal I have a large string (~10MB in ~400k lines). I want to "efficiently" split it on a delimiter and map the resulting sets of lines. Efficiently is defined as something that is fast (wall time), even when RAM may be limited. The delimiter is always a fixed string comprising a full line of th...

ruby

Duga

If you are seeking performance improvements in your code, you should ask at CodeReview — cricket_007 7 secs ago

Jeroen Vannevel

@Vogel612 Now I'm still in Belgium -- I'll go to Oxford and London March 20-25 to get a sense of the place and an in-person interview

Pin Crash

@CaptainObvious little iffy on that one... Hesitating between comparative review and GimmehTehCodez

Jeroen Vannevel

8:53 PM

But I'm heavily leaning towards living in London

I've got a few dates set up for when I go there, that might also influence my decision

Duga

possible answer invalidation by Gazta on question by Gazta: codereview.stackexchange.com/posts/122150/revisions

Pin Crash

> SQL Server procedures can have, at most, 2100 parameters.

3

*shudders*

RoboSanta

Naruto answer; accepted non-selfie answer with 0 score: Multiple regex replacements javascript regex

Ripe zombie; open question with answers, at least one answer having score 0, no answer having score > 0: 4 database queries, multiple loops in loops, slow processing time php sql-server laravel eloquent

skiwi

Does a thing such as computational complexity for integer linear programming exist?

Mat's Mug

9:18 PM

crickets

Pin Crash

Captain Obvious

1

Q: MySQL connection using a static connection

I have been using a static class to connect and retrieve information from a MySQL database and also reading about how static works in php. I'm still not sure if the code is bad or not and why (besides the usual static are dangerous). Also, code improvements suggestions will be appreciated. class...

php static

0

Q: Javascript: Functional programming with Promises

I'm only just starting to delve into the wondrous world of functional programming and Promises; to start with I've converted a bunch of procedural code in (what I believe to be) is a more readable approach using functional programming paradigms and Promises. The module is a simple wrapper of the...

javascript functional-programming promise

Mat's Mug

@CaptainObvious doesn't sound like a good idea

Pin Crash

    $count = count($parameters);
    $query = $count === 0 ? '' : str_repeat('?, ', $count - 2) . '?';
    $query = 'CALL' . ' ' . $method . '(' . $query . ');';

That's not how you SQL... D:

Vogel612

at least they prepare the query...

I ain't quite sure it's completely safe against bobby-tables, but alas...

Pin Crash

9:35 PM

I'm not a big fan of appending the SQL procedure/function name and parameters through a function though... that potentially exposes every stored script in the database

Surely there's a better way of doing that... I hope...

Vogel612

not to mention that relying on stored procs too much for application logic may be a bad idea in the first place

Pin Crash

lol IKR

Vogel612

nothing against stored procs, but .... business logic is business logic after all

and since the DB can't handle all of that part, why make it needlessly handle any of it (especially since SQL isn't really intended for that)

Unrelated: I like virtual Desktops... since when does Windows have them?

Captain Obvious

9:53 PM

0

Q: Simple WPF application - potential extensibility problem due to number of properties

I have created a simple application that has grown a little bit. Though most likely it won't grow anymore, I have looked back and I realized that it has become a little monster in terms of how many almost identical properties and methods I have created. Please let me know how this could be made m...

c# data-structures wpf xaml

Mat's Mug

@Vogel612 Win10 I believe. never used 'em

Vogel612

I really love how I can keep gaming stuff on one VD and SE / Spotify on another

and they still work similarly to alt-tabbing

Mat's Mug

IDK.. do I need that if I have 2 monitors?

Pin Crash

You can put a VM in each monitor :D

Vogel612

I find it easier instead of stacking 4-8 unrelated things onto each other to have two desktops with related things arranged nicely

Pin Crash

9:59 PM

Virtual Desktop == Virtual Machine??

Vogel612

@PinCrash then you only have one monitor per VM, that's not helping me organize my stuff :)

@PinCrash no,...

Pin Crash

Oh. My bad.

Vogel612

you got Windows 10 handy?

Pin Crash

Negative

Vogel612

it's a little like separate logins onto the same system that you can freely switch between

a little like opening two RDC's to the same remote machine in the same window

Pin Crash

10:01 PM

Oh, that's neat. So they run the same OS, but just have separate logins that are simultaneously accessible?

Vogel612

with the difference that you can move applications between them and it's not remote

Dan Pantry

I would say VDs are more like having two separate screens you can tab between than logsin (becaue that just makes it confusing)

How do you enable them?

NVM

Found it already :D

Vogel612

win tab or just use ctrl + win + d for new one

Dan Pantry

Wow, they're fast as well

Vogel612

you can close the current VD with Ctrl + Win + F4

Dan Pantry

10:04 PM

probably faster than ubuntu's

Vogel612

ubuntu kicked them out in the 14.04 release

Dan Pantry

wat

I have ubuntu 15 and they're still there

Vogel612

at least they're default disabled

Dan Pantry

Yeah, they are, but they are still there :)

Vogel612

well I didn't go enable them again, since they regularly crashed my lappie

you can still switch to another tty though

Alex

10:06 PM

Just find out about this 2nd monitor. Nice to meet you guys :)

Vogel612

Hello there, and welcome to the 2nd @Alex

Alex

@Vogel612 what's up ? ^_^

Vogel612

lurking mostly

and evangelizing Virtual Desktops

Alex

uuh, that's a sad morning then ^_^

Pin Crash

@Vogel612 That's neat! (nice music selection too)

Vogel612

10:08 PM

it's 11 PM here ...

@PinCrash Spotify mix of the week :)

Alex

here it's 00

Vogel612

It's weird though... the less I'm mandated to do, the less I'm motivated to do anything at all

Alex

yeah, me too. I'm now waiting for a response but I think that I'm gonna go meet my bed

Vogel612

Goodnight then, and see you around :)

Alex

sure, enjoy your lurking

g'might

night*

Pin Crash

10:12 PM

Later @Alex

Alex

see ya folks

Captain Obvious

10:29 PM

0

Q: Large Integer Class - Stores Integer Data as Char Array

I am working on a LargeInteger class to store Integers beyond the size of long long as a dynamic character array. I have overloaded most of the relevant operators to be used with the large integers. I would appreciate comments on my implementation. I would like to find a way to further streamlin...

c++ reinventing-the-wheel

Captain Obvious

10:48 PM

0

Q: Student/Class App Java/MySQL

I posted a question about this code yesterday and have made several updates. I'd just like to know if there are any other major errors or spots for improvement. I have three MySQL tables: students student_id | student_name | hometown classes class_id | class_name | description student_x_cla...

java beginner mysql

Captain Obvious

11:29 PM

0

Q: Implementing Convex Hull Trick

I've been trying to do this CF problem for about 20 hours: http://www.codeforces.com/contest/631/problem/E The editorial (solution explanation) for this problem is here: http://codeforces.com/blog/entry/43551 I don't have enough rep here to post more than 2 links, but inside the editorial you c...

java algorithm

Hosch250

Welcome, @Alex.

Duga

Not sure, but this may be a good question for Code Review, not Stack Overflow. — Gliderman 39 secs ago

Pin Crash

Nobody, besides myself, has upvoted this superior answer and it makes me a little sad

DJanssens

11:47 PM

@PinCrash °/

rolfl

@PinCrash - something happen I should know about?

Monking all.

Pin Crash

@rolfl Don't think so, why?

rolfl

Name change is.... odd ;-) That's all.

Pin Crash

Oh that

Vogel612

@rolfl PPCG grad

Pin Crash

11:50 PM

in Cardshifter TCG, Mar 1 at 15:51, by Pin Crash

lol... celebrating PPCG graduation announcement with the anagram name tradition :)

DJanssens

Monking @rolfl

rolfl

Yeah, I noticed that. Miracles can happen.

I see emacs is getting elections now too, shortest beta in history.

Pin Crash

Wait there's a whole site about just emacs?

rolfl

Yup:

13

Q: 2016 Community Moderator Election Results

Emacs's first moderator election has come to a close, the votes have been tallied, and the 3 new moderators are: They'll be replacing the existing crew shortly — please thank them for volunteering, and share your assistance and advice with them as they learn the ropes! Please join me in tha...

discussion status-completed election

They have completed elections, which, for a site with a grand total of 124 questions on their meta site is impressive.

27

Q: Welcome to your Emacs site!

You might remember my post last week which confused and troubled a lot of you. I wasn't clear enough then, so I hope you'll let me try again: We love Emacs and we love empowering people to build Q&A sites. This community is all about getting answers to long tail Emacs questions. If you have an ...

discussion

September 2014 and elections in Feb 2016.

Pin Crash

Sweet, good for them. I keep hearing emacs is really cool (especially if you like Lisps) but haven't given it a try yet

Vogel612

11:57 PM

There's that joke about vim and emacs...

> There's vim. It's a good text editor.
And there's Emacs. It's a good Operating System.

2

rolfl

It's no joke.... ^^^^

DJanssens