The 2nd Monitor

skiwi

12:00

> This is pretty fundamentally impossible, and probably honestly undesirable. Your hardware is racy, your OS is racy, the other programs on your computer are racy, and the world this all runs in is racy. Any system that could genuinely claim to prevent all race conditions would be pretty awful to use, if not just incorrect.

That's quite a racy quote

Duga

If you have working code which merely needs improvements then you're probably in the wrong place with this post. Code Review is where they handle existing / working code and do their upmost to improve it in terms of speed, security, sustainability, and longevity. Give it a try. They're good! In the meantime, you might want to look into moving your sheet into an array variable and do everything there. Here is something to get you started: stackoverflow.com/a/36875006/1153513 — Ralph 22 secs ago

N3buchadnezzar

@Zak Nah, they are identical :p

syb0rg

Monking

skiwi

<pmlomg @syb0rg

syb0rg

12:19

Low quality answer: codereview.stackexchange.com/a/132728/27623

Or NaA

Malachi

@syb0rg if the poster adds a reason why then it would be a good answer

no reason to delete, or flag, just downvote because it is not a good answer. it is an answer, just not a good one yet.

syb0rg

@Malachi It's also an answer to an off-topic question

In the process of being closed

I should probably change my commend on that answer actually to reflect that...

Malachi

it is still an answer and should not be deleted. it just doesn't have a description or a full review of the code

Dan Pantry

i think it being at -4 is good enough

Malachi

we have a gap in our protection against off-topic questions

Dan Pantry

12:34

his answers are not that great quality on SO either

I mean his latest one literally was drop that and use jQuery instead

@Mat'sMug @Phrancis github.com/danpantry/smelly-moist-coffee-bucket

heh

Phrancis

-.-"

Zak

Can anyone see anything obviously wrong/bad about my draft schema?

Dan Pantry

smurf code (blog.codinghorror.com/new-programming-jargon)

> When almost every class has the same prefix. IE, when a user clicks on the button, a SmurfAccountView passes a SmurfAccountDTO to the SmurfAccountController. The SmurfID is used to fetch a SmurfOrderHistory which is passed to the SmurfHistoryMatch before forwarding to either SmurfHistoryReviewView or SmurfHistoryReportingView. If a SmurfErrorEvent occurs it is logged by SmurfErrorLogger to ${app}/smurf/log/smurf/smurflog.log

I'd extend that to your tables

Phrancis

@Zak Why are your GUID columns BIGINT type and not UNIQUEIDENTIFIER type?

syb0rg

Are GitHub contribution graphs currently broken? I've definitely done more than just 2 contributions in the past year: github.com/syb0rg

Dan Pantry

12:37

People_Entities containing Person_First_Name and Person_Last_Name? just use First_Name and Last_Name

Zak

@Phrancis The design tool doesn't have an option for that.

Dan Pantry

Idk if its the convention but Title_Case looks weird, just use TitleCase

Phrancis

@Zak oh, gotcha

Dan Pantry

Also, on the topic of names: kalzumeus.com/2010/06/17/…

tl;dr don't have a first/last name column

just use "name"

Zak

@DanPantry But then how do I organise by lastName like every western company in the history of the world?

Phrancis

12:39

I do agree with Dan that the People_Entities and Company_Entities columns could use shortened names without the Person or Company prefix

Zak

Besides, they're all Nullable apart form the PK.

Dan Pantry

@Zak That would be view logic, not database logic.

Malachi

@syb0rg, I don't have a problem with people answering off-topic questions, but there is a line in the sand when it should be done. I wouldn't go as far as to say "don't do it"

Dan Pantry

And could be done by doing a string split on space, then checking the second parameter

Zak

@DanPantry And how is my view supposed to figure out the lastName if the DB doesn't know?

Malachi

12:40

most of the time answering an off-topic question leads to a bad answer though, I agree

Dan Pantry

If there's a second one, you sort by it, otherwise you just sort by the first one. you can't assume everyone in the western world has a first and last name.

Zak

@DanPantry Now we're just introducing a different (false) assumption. And a distinctly less-intuitive one,.

Dan Pantry

Having a first and last name is also a false assumption.

My colleague has the name Le-Thahn (no surname)

Malachi

anyone here do automated testing with Specflow and Selenium? --> sqa.stackexchange.com/q/20233/18919

Dan Pantry

Just use "Name". You can't reliably organise based on last name because not everyone has one

Zak

12:41

@DanPantry Sure, but it's an assumption our entire company/industry/government is built on. So I think it's a reasonable constraint to make.

Dan Pantry

@Zak Okay, fine. But I disagree

Phrancis

@Zak one recommendation would be to have a TimeInserted or DateInterted column on every table which defaults to the current timestamp

Dan Pantry

I thnk Account_Commission_Payments looks like it's trying to be a Payments table as well as a Join table at the same time

But that might be normalising too much

Quill

4

Dan Pantry

@Quill <:

skiwi

12:43

@DanPantry I'd advice against that when working with an existing model, @Zak has the first/last name split right now, there's no gains by removing it

Dan Pantry

Meh, I was under the impression he was making a new system

Zak

@DanPantry Sure, but the system runs on our company. And our company/industry runs on all sorts of huge systems which already assume people have first/last names.

For instance, we have to have a passport (or other govt. ID) on file for every client.

Gareth Rees

@N3buchadnezzar There's still room for further improvements — my solution is O(n^3 (log n)^2) but I think someone might be able to bring it down to O(n log n) by using the techniques for solving your question about binomial coefficients together with careful organization of the multiplications.

Zak

@DanPantry Payments is for money coming in. Commission splits will then be used to decide where it goes from there. X% to us, Y% to the adviser, maybe Z% to an introducer etc.

Phrancis

@Zak is that model representing all the fields or just the primary ones?

Malachi

12:47

@Quill LOL

Zak

@Phrancis All the ones I can currently think of.

skiwi

lol

> [Support] You have 4 damaged emails

Zak

Also going to have tables for tracking edits.

skiwi

It's not a damn letter, you dimwit phishers

3

Phrancis

I noticed all your PK/FK fields seem to be GUIDs, I have a feeling, if you write SQL queries a lot, you may get tired of having to deal with D201B551-3F49-42AA-8F68-5794CC2FFDD5 type numbers. However, if they are primarily just used for joins and indexing, then you should be fine

Dan Pantry

12:49

@Quill Trumpageddon

@Phrancis Aren't GUIDs "slow"? that's what I've heard

Zak

@Phrancis Yep. They're not there to be user-facing, just so I can track distinct entities/records etc.

Phrancis

@DanPantry uh, no, not particularly

Quill

@DanPantry LOL

Phrancis

18

A: Why do sequential GUID keys perform faster than sequential INT keys in my test case?

I modified @Phil Sandler's code to remove the effect of calling GETDATE() (there may be hardware effects/interrupts involved??), and made rows the same length. [There have been several articles since SQL Server 2000 relating to timing issues and high-resolution timers, so I wanted to minimise t...

Zak

@Phrancis Is there a built-in way to track record edits? Or do I have to build edit-tracking tables for all of them?

Phrancis

12:51

Looks like depending on the use case, GUIDs may be slightly faster or slightly slower

@Zak The latter. Most places I've seen use triggers on the primary tables to log audit records to another table

Gareth Rees

GUIDs solve the problem where each node in a distributed system needs to assign ids that are globally unique without consulting a centralized database. But if you are designing a centralized database, there should be no need to use GUIDs — there is only one database, so it can assign unique ids

skiwi

Was it GUIDs that are not strictly unique, but have the chance of your server literally disappearing from earth higher than the chance of a collision happening?

Dan Pantry

@skiwi GUIDs are unique enough that you'd encounter a collision after the heat death of the universe.

3

Zak

@GarethRees I feel like GUID has a specific technical meaning which I'm not aware of here. To me it just means (ID that does not appear anywhere else).

Phrancis

@skiwi Pretty much, yes

Dan Pantry

12:55

> While each generated GUID is not guaranteed to be unique, the total number of unique keys (2^128 or 3.4×10^38) is so large that the probability of the same number being generated twice is very small. For example, consider the observable universe, which contains about 5×10^22 stars; every star could then have 6.8×10^15 universally unique GUIDs.

Phrancis

@Zak A GUID is (more or less) a hash of a unique value that is (more or less) never ever repeated

skiwi

@DanPantry It's still hard to imagine that

Phrancis

The main difference of GUID/UUID vs. a regular ID (like an int) is the Global/Universal part

Dan Pantry

@skiwi Not surprising. It's a mind-crushingly huge number.

N3buchadnezzar

@GarethRees Yeah, I was actually thinking about that.

Dan Pantry

12:57

The caveat is obviously that GUIDs are much larger than ints.

Quill

Generally unreadable information digits & Usually unreadable information digits

N3buchadnezzar

Seems like over engineering though

Gareth Rees

Normally, if you're designing a database that needs to have a unique ID for each record in a table, then you can easily get the database server itself to generate unique IDs, for example by declaring a field PRIMARY KEY SERIAL in PostgreSQL or PRIMARY KEY AUTO INCREMENT in MySQL.

The problem comes when you need to generate unique IDs in a distributed system without consulting the database. GUIDs provide a mechanism for this — basically each GUID is chosen randomly and the space of possibilities is so big that collisions are extremely unlikely.

Phrancis

Or PRIMARY KEY IDENTITY in T-SQL/SQL Server

Zak

Considering Moore's law, I think I'll go with GUIDs and if it ever becomes a problem, I'll deal with it then.

Donald.McLean

13:04

Greetings, Programs.

zʏᴀʙiɴ101

@Donald.McLean Npoljoh, Tron.

Donald.McLean

Or you could use Host address + serial, which should guarantee global uniqueness.

But depending on how you do it, might not be any smaller than GUIDs, and possibly more trouble to generate.

Captain Obvious

0

Q: SQLite Databse inserting + Unit tests in Java

Genereal Introduction This is my first project which involves a Database which involves testing (especially unit testing) where the quality is really important for me. The long term aim is to create two frontends for Android and normal Java and a backend with the database. That means, the a...

0

Q: python - merge-sort algorithm or kind of

I tried to reproduce the merge-sort algorithm. It was tough as my understanding of list was less than stellar, a few days ago. I will be honest, I'm ashamed of what I did but I tried to finish it the way I see it, with my knowledge at that time. I checked on the net and there are easier way to ...

python performance beginner mergesort

Jeroen Vannevel

what's that re-run code shortcut?

skiwi

lol: doc.rust-lang.org/nomicon/arc-and-mutex.html

@JeroenVannevel Ctrl %

4

Dan Pantry

13:19

Saw someone asking for 4 years React exp yesterday

6

> Initial release‎: ‎March 2013; 3 years ago

skiwi

Would be more funny if the company rejected the original creator because of lack of experience

5

Dan Pantry

I AM the experience

2

Zak

Google: 90% of our engineers use the software you wrote (Homebrew), but you can’t invert a binary tree on a whiteboard so fuck off.

Tweeted by mxcl on June 10, 2015 at 5:07 PM

Phrancis

@DanPantry Did you tell them that that's impossible? ;P

Dan Pantry

@Zak Christ, I dont' even know how to make a binary tree implementation let alone invert one.

I should really branch (hah) into algorithms

skiwi

13:25

@DanPantry Better branch into branch predictors instead

Gareth Rees

What does it mean to "invert" a binary tree anyway? Do they mean "reverse in place"?

Dan Pantry

There's a recursion joke to be made there, but there's a recursion joke to be made there.

Phrancis

@Zak Couldn't you just take the white board and turn it upside-down?

7

Legato

Greetings everyone.

Dan Pantry

@GarethRees sounds like it means, given parent A with child0 B and child1 C to flip them such that parent A has child0 C and child1 B

Phrancis

13:26

@Legato Monking

Dan Pantry

@Phrancis LOL.

Gareth Rees

That would be the "reverse in place" interpretation

Dan Pantry

@GarethRees Yes, sorry :) I only read to the first question mark.

syb0rg

@Legato Hello

Gareth Rees

Tree algorithms are kind of out of fashion at the moment, since many of their applications are better served by hash tables. This means that lots of nice tree algorithms that used to be important have been forgotten, for example Morris's algorithm for traversing a tree in O(n) time and O(1) space, or Sleator and Tarjan's "splay" algorithm that searches a tree and simultaneously optimizes the tree for a future search on the same or nearby keys

Phrancis

13:32

Is there a mod around?

I'm voting to close this question as off-topic because OPENQUERY is not a matter of code review but rather a database-specific question/problem. This would be better asked on DBA.SE but reworded according to their on-topic guidelines. — Phrancis 33 secs ago

I preemptively flagged that question for migration to DBA, but after further discussion they would prefer if it were re-posted and re-worded according to their guidelines

skiwi

I'm thinking (for some time already actually) about creating a relatively simple application to replace an Excel sheet, what are my options regarding databases? So far I see SQLite is an option to embed it in the application directory or run a full-blown PostgreSQL server somewhere and connect to it (needs online functionality though), any opinions?

Phrancis

@skiwi SQLite

Maintaining a server is a PITA if you don't really need it

skiwi

What about performance? To be fair, it won't be extremely big, talking about thousands fo records at most

Phrancis

SQLite performs quite well with that small amount of records

I wouldn't trust it as much with multiple millions of records but a few thousands should be no problem

Gareth Rees

SQLite is perfect for the single-user case, and it can easily handle millions of records. See here for a testimonial

SQLite performs poorly when you have multiple simultaneous writers — if that's your use case then it probably won't work for you

Mat's Mug

13:40

@Phrancis cool, declined :)

skiwi

Ah it's just a single user here, just really simple

Duga

possible answer invalidation by DanA on question by Dan Andersson: codereview.stackexchange.com/posts/132726/revisions

Gareth Rees

Take a look at Well-known users of SQLite — if your application is like any of these, then you're good to go

skiwi

I think it's safe to say that SQLite will perform better than Excel?

Duga

I'm voting to close this question as off-topic because it belongs to codereview.stackexchange.com — blue112 33 secs ago

N3buchadnezzar

13:41

Eeek. who let the mug in?

zʏᴀʙiɴ101

@N3buchadnezzar The mug went in.

Mat's Mug

^

skiwi

> SQLite is the primary meta-data storage format for the Firefox Web Browser and the Thunderbird Email Reader from Mozilla.

Oh cool, it likely has nice Rust support as well

N3buchadnezzar

@zʏᴀʙiɴ101 OH YEAH

Phrancis

@skiwi Um, you think? ;p

Excel Is Not A Database™

3

Dan Pantry

13:46

@Phrancis Not with that attitude it isn't

skiwi

Any technology can be abused to act like a database

Phrancis

@skiwi Um yeah, even emails -.-

Gareth Rees

One nice thing about using SQLite as your data store is that you don't have to run your program to interact with it — you can just run the SQLite command line. For example, I can open Firefox's history database by running sqlite3 "~/Library/Application Support/Firefox/Profiles/*/places.sqlite" and then I can run SELECT * FROM moz_places LIMIT 2; or whatever

Phrancis

@GarethRees Oh that's very cool, didn't know that!

That means you could also write your own programs to connect to FF's database eh?

Gareth Rees

Yes, exactly — for example, if you wanted to export all your bookmarks you could execute SELECT * FROM moz_bookmarks;

Or even from the command line in a shell script: sqlite3 places.sqlite 'SELECT * FROM moz_bookmarks;' > bookmarks.backup

Mast

13:58

I think PostgreSQL can do that as well.

@Zak If you're looking for something cheap, go for StarUML indeed. Or dia.

Phrancis

@Mast Yeah all SQL should be able to do that, but server-based DBs are much more maintenance

Captain Obvious

0

Q: Database credentials and connector including encryption

I'm designing a small Java desktop application to interact with my database and this is a very important part of it as a majority of the operations will be involving the SQL Server 2012 database. I am using the SQL Server JDBC driver (v6.0) provided by Microsoft. I wrote a class to hold credenti...

java sql-server

Mast

Just log-in to the server and it no longer matters whether it's server-based or local, right?

Gareth Rees

In the single-user application case you'd rather not run a database server if possible because of the difficulties of installation, setup, upgrading, security and so on.

skiwi

And more importantly a local database can never be offline

Zak

14:03

@Mast I'm using this right now. Suits my (minimal) use case pretty well.

Duga

@Boneist That is incorrect - it can be used with both dates and timestamps. I just use it to explicitly state that the number 14 is 14 days so that there is no confusion during code reviews as to what the number means and the context in which it is being used. — MT0 35 secs ago

Mast

@Zak That's a pretty nifty site.

Zak

14:19

The more I try to anticipate problems, the more potential problems I keep finding. It's all getting very big and complicated.

Then again, I suppose this is going to be used to run an entire company.

No end in sight:

Phrancis

@Zak Better finding them at design time than after it's implemented. Trust me, designing/architecturing a database is not an easy task, but it's worthwhile to spend time upfront finding potential problems

Mast

Definitely.

Every problem you find and fix now saves you a headache later on.

Zak

Sure, but I'm feeling distinctly out of my depth here and I'm only *designing* it.

Gareth Rees

Use cases!

skiwi

Are you using endpoints for services to update your Excel file currently, or anything of that sort?

Phrancis

14:22

@Zak It's looking good so far

Zak

@skiwi Nope. The excel file is the database.

4

Phrancis

@Zak Implementing it is easier than designing it. If you need any help with implementation at any point just ping me

Gareth Rees

The way to be confident that your database design is good is to have a reasonably comprehensive list of use cases, and then check that it's straightforward to implement each use case using your design

Dan Pantry

+1 Headaches now are better than migraines later

2

Zak

@DanPantry TS

skiwi

14:24

@Zak Who updats the database?

Zak

@skiwi The admin team.

Mast

I've removed my downvote from here. Not sure whether it's a good answer now, but at least it's more than a code dump now. Can I get a second opinion on whether the notification is obsolete?

skiwi

@Zak And now I guess you're going to tell me that you need to write an email if you want to see the database updated? No internal client or whatsoever?

Mast

@Zak I thought you fixed that by using Access?

Zak

@skiwi Nope. There is literally just a spreadsheet on the shared drive, and when you need to record anything, you just open it up and start typing.

skiwi

14:26

Conflicted copies anyone?

Mast

I fully agree with Gareth here, you definitely want use cases to verify whether your design actually does what you need it to do.

Zak

@skiwi There are no copies.

skiwi

Exclusive lock?

Zak

But does mean only one person can have it open at the same time.

Mast

Good.

Zak

14:27

@skiwi Windows warns you when you try to open a file somebody else is in.

Mast

Never trust Windows to keep your files safe when running a company.

Phrancis

Writing a small application (even using Excel/VBA) to interact with the database is pretty trivial

Zak

@Mast Well, I do *kind of* have a list of use cases. I just have to recreate everything people currently do with the spreadsheet.

skiwi

@Phrancis Oh SNAP!?

Phrancis

Access is probably better than Excel at this, though, but it can be done either way

One thing Access is really good at is easily making forms, then just need ODBC driver to connect to SQL server and pass along the data

Mast

14:29

@Zak Everything is awfully broad. Unless you made a list and translated all actions into use cases.

Phrancis

@skiwi lol don't remind me plz kthxbai

Gareth Rees

Whenever I am designing a database schema, I start by writing down the use cases in a big list. I have one here: it starts (1) maintainer defines a device type; (2) maintainer defines test procedure for a device type; (3) operator executes test procedure for a device; (4) analyst defines pass/fail criteria for device based on test results for that device; (5) and so on...

syb0rg

I DID IT

I COMPILED SOMETHING WITH VISUAL STUDIO

I ACCOMPLISHED THE IMPOSSIBLE

Okay done yelling

Zak

@Mast I've been trying to. I keep thinking of new stuff though.

Gareth Rees

Each use case has a "role" (here, maintainer/operator/analyst) and some action that involves the database. From the use cases I can deduce the schema items — there have to be database entities representing device types, devices, test procedures, test runs, test results, and pass/fail criteria.

Mat's Mug

14:31

@syb0rg cough

syb0rg

@Mat'sMug Yes? ;)

Mat's Mug

C++?

syb0rg

@Mat'sMug Yep, that was trying to build using VS 2012

Which I had installed, but it wasn't finding for some reason

I should say too, I had to compile it with the command line, not in the program

Phrancis

@Zak why is your Invoice_Payments table not linked to anything?

Just missing arrow to Invoice_GUID I suppose

Zak

@Phrancis Haven't done it yet.

Mat's Mug

14:40

@Zak suggestion: have Id int not null, DateInserted datetime not null and DateUpdated datetime null columns in all tables. What motivates using a GUID for a PK?

Duga

You might consider posting this on codereview.stackexchange.com/questions/tagged/python — tehjoker 39 secs ago

Zak

@Mat'sMug When I say/think GUID, I'm just thinking "Unique in my database"

Not necessarily going to use an actual GUID function.

Mat's Mug

a GUID is more "unique in that server"

Zak

Might just be serialisation

Dan Pantry

A guid is more... unique everywhere

Zak

14:43

@DanPantry Unique in this universe

Dan Pantry

But not unique in the Marvel universe. Sorry deadpool, no transactions for you.

Mat's Mug

my understanding is that GUID collisions are technically possible if the GUIDs are generated on different machines, e.g. client-side. that's why a GUID should be generated on the server with the newid function.

Phrancis

@Mat'sMug You're a bit late to the conversation, we've discussed that pretty extensively already :)

Dan Pantry

Well.. turns out I'm not going to Dublin this week...

Mat's Mug

back to work

Dan Pantry

14:47

turns out that the communication between teh dublin and LA offices of Riot is somewhat lacking

So while Dublin has been like "yeah sure you can interview this week" LA have dragged their feet.. and Dublin have only just noticed that the interviewers are not in this week

Or next week

...And any later than that and my 2 months notice period starts to run into the time I need to be in a new place

skiwi

Eh... so you've gotta wait?

Dan Pantry

Well.. if something can't be worked out sharpish, I will have to turn down the job offer

See, my landlord wants me to move out end of aug/sept time

skiwi

It's their mistake so maybe they can compensate somehow

Dan Pantry

And I have a two months notice period

Yes, it is really going to come down to what LA can work out.

skiwi

Oh I was thinking the notice period was for your job (though that wouldn't really make sense) but housing is important too

Dan Pantry

14:50

Because as far as I am concerned it is either this Thursday/Friday, or MAYBE sometime next week or not at all. Unless I can work some kind of miracle out.

The notice period IS for my job

it just overlaps with the time I would need to be out of my place

So the idea was that I could have the onsite this week, get the offer over the weekend, hand in resignation, bish bosh, be in Ireland before I had to be out of my place

But..... if it can't be this week, the earleist it can be is week beginning 4th of july, which puts my resignation AT BEST on the 4th sept. which is probably too late. and also after I have to agree to a new project or not.

skiwi

What about resignation on your current place? What's the notice period for that?

Dan Pantry

Thing that sucks is that I made this all very clear back in May when I was first approached... :S

skiwi

I'm assuming the one for your landlord needs to be extended yearly or something like that

Dan Pantry

2 month notice period in my current place. It COULD be negotiated down based on my remaining annual leave

but that is a very big could..

Zak

*other employee about to temporarily rewire the internet ports* "Don't worry Zak, it's not your computer". It was my computer.

5

skiwi

15:00

At least he wasn't rewiring the power plugs...

Zak

Well, at least we now know that port #1 actually starts in the middle of the office and not on one of the ends.

skiwi

lol

Zak

Protip: Always validate your wiring assumptions before you start pulling plugs.

Duga

possible answer invalidation by Eirik Fuller on question by Eirik Fuller: codereview.stackexchange.com/posts/132469/revisions

Captain Obvious

0

Q: Attempting to make this php code into a function

I have some PHP code that I am trying to improve by putting it into a function. The problem is that it edits specific variables outside of itself. Here is a general layout: $edit0 = ""; $edit1 = ""; pseudo while loop { if(!empty($day0[1])) { if(strcmp($day0[1],"...

php

0

Q: Random Mockito Stubbing Error

I have the following code snippet from a unit test using Mockito which has happily been passing for months/years. TableRowCount downloadRowCount = new TableRowCount(tableDownloads); //create the item that will appear in the table row MyHSAItem item = createMyHSAItem(); Mockito....

java unit-testing mocks

Zak

15:08

@Duga handled

Phrancis

@CaptainObvious pseudo-code

Mast

@DanPantry Just tell them your situation and ask them to figure it out.

@CaptainObvious Broken.

Dan Pantry

@Mast They know my current situation.

They knew it in May, they have been told it now, they knew it on Monday when It old the interviewer, they knew it last Thursday when I told the other interviewer.. who seemd to have no idea about what was said in May

communication 101 :\

Mast

@Zak Switches should make that quite easy.

@DanPantry Did you tell them what's at stake?

Zak

@DanPantry Worth sending an email to everyone involved re-iterating what needs to happen by when or else you'll have to decline?

Captain Obvious

15:17

0

Q: Discord.js Bot - Improvements and Optimization Reccomendations

Just finished creating my first bot using Discord.js for the chat application, Discord. This is my first bot and first javascript program I have ever created. I'm mainly interested in ways I can optimize the code and make it a bit cleaner. Any help or suggestions is greatly appreciated. Github R...

javascript node.js

Dan Pantry

@Mast It's very much implied. I've requested a meeting with the LA team head tonight. It's just wait and see until then.

Phrancis

@DanPantry Do they not do Skype/video/phone interviews? I find it a bit silly to need to see someone in person for an interview when not practical (as is the case here apparently)

Dan Pantry

@Phrancis They do.. we've done four skype interviews

The final stage is all-day, on-site

Phrancis

Ahh

Dan Pantry

Again, it was practical up until the point where apparently 3 of the interviewers were not in on Thursday/Friday, not really sure whose ball dropped that was

Mast

15:29

Best of luck.

Dan Pantry

Not really sure what to hope for here

I cant' take time off next week, week beginning 4th july is too late, tomorrow is apparently no-go. sounds like it's going to have to have me refuse the offer

Mast

Just don't make any rash decisions.

Dan Pantry

Well, I'm going to try very hard to end it on amicable terms if I have to

Zak

@DanPantry Make sure they know that they need to fix this or you'll have to refuse.

Mast

Stop assuming, stop worrying and make sure it works out.

Dan Pantry

15:31

@Zak they are very aware of what has to be done in order for me to be able to actually be able to interview

Either I have to interview tomorrow/friday or it will have to be on a weekend.

The fact I'm having to prod them is really leaving a bitter taste in my mouth, though

Zak

@DanPantry Are you sure the right people know?

Mast

That's HR. HR in a company is never optimal.

Dan Pantry

I still haven't heard from the HR person about flights at all. The only reason I even know I can't interview tomorrow is because I was checking up every single day with the team lead.

Zak

@DanPantry I'd keep checking up with them. And check up with any/all other senior people you've interviewed with.

Dan Pantry

@Zak Well, I mean, the interviewer I interviewed with LA had no idea about the fact I could only itnerview this week until last week, despite me telling the team lead a whole 3 weeks prior.. so it's possible information is not being shared effectively.

@Zak Senior person is the one who told me I won't be interviewing tomorrow.

The only other one is the one I am talking to tonight hopefully

Zak

15:33

klkl. Let us know how it goes.

Dan Pantry

I will

Mast

If you haven't heard anything by Friday, make sure your potential boss knows as well. If anyone has a stake in all of this, it's him.

Dan Pantry

@Mast my potential boss is the one I have been prodding literally every day

I had an interview with him on monday and he said I should hear by monday evening.. then tuesday evening.. then wednesday afternoon.. then nope, you're not interviewing because interviewers are not in

Mast

What did he say?

Dan Pantry

Almost feels like he is too nice to say that they aren't interested, frankly

Mat's Mug

15:35

> We still don't know what problem your code is solving, and that should be in your title. There are major differences between how SO and CR work, explained in detail here and of course, in our How to Ask page. It might seem counter-intuitive at first, but trying to narrow down your post (as you would on SO) to a specific problem with your code is actually making it harder to helpfully answer. Tell us what edit0 and edit1 are, what their purpose is, what problem your code is solving

...and OP deleted their post

Mast

I'd almost suggest flat-out asking that next Friday.

Dan Pantry

I'll discuss this later. I only have half hour left, I should do some work. TTYL.

Mast

@Mat'sMug Happens.

Captain Obvious

0

Q: How can this be shortened and/or optimized?

I've recently started programming and have been working through some problems such as the one below: Write a program that finds all files with a given prefix, such as spam001.txt, spam002.txt, and so on, in a single folder and locates any gaps in the numbering (such as if there is a spam001.txt ...

python beginner python-3.x

syb0rg

@CaptainObvious We might need a meta post on promoting better titles somehow

Mast

15:44

I put the whole test. It makes little difference. The point is about the error being received. The code is written, you would need to read better the description. Please reopen. Thanks. — user1472672 20 mins ago

He's not getting it...

@syb0rg We'd have to make it obligatory to read or it won't make a difference.

Phrancis

I left a comment to that effect

Duga

possible answer invalidation by StormsEdge on question by StormsEdge: codereview.stackexchange.com/posts/132534/revisions

syb0rg

@Duga Handled

Captain Obvious

0

Q: Finding permutation from given lexicographical rank

I wrote the following little piece of Python code to take in some integer, and return a permutation that has that rank in the lexicographical ordering of permutations. While this works, I'm worried that the number of calls to pop() and append() might be slowing this down. This function is part of...

python performance

0

Q: Filtered date range function

I want to write a function to produce an inclusive range of Day such that Saturdays are excluded. import Data.Time.Calendar import Data.Time.Calendar.WeekDate let sel3 (_, _, x) = x let dateRange d1 d2 = takeWhile (<= d2) [ d | d <- map (flip addDays d1) [1..], (sel3 . toWeekDate) d /= 6] I b...

haskell

Mast

@Duga Smart guy.

Duga

15:59

This is probably more suited for codereview.stackexchange.com — Metro Smurf 11 secs ago

Captain Obvious

0

Q: Hamming distance in Scala

Problem Write a program that can calculate the Hamming difference between two DNA strands. GAGCCTACTAACGGGAT CATCGTAATGACGGCCT ^ ^ ^ ^ ^ ^^ Code object Hamming { def compute(s1: String, s2: String): Int = { if (s1.length != s2.length) throw new IllegalArgumen...

programming-challenge unit-testing functional-programming scala

0

Q: Permutations part two

This is a follow up from the question Making Permutations in Python faster. The goal is to make some function that can return the number of possible permutations with repetitions. As Gareth pointed out there is a nice formula for this problem See https://en.wikipedia.org/wiki/Permutation#Permuta...

python performance python-2.7

N3buchadnezzar

@Zak backups?

Zak

@N3buchadnezzar Our IT service company handles all the sys-adminy stuff (Network security, backups, phone system, software/hardware provision etc.)

Captain Obvious

16:14

1

Q: ASP Controller and Seperation of Concerns

This was originally posted here. I'm hoping Code Review will be a little more helpful in giving me a concrete direction. I've been working on a project based off of this tutorial. Unfortunately, the controller classes in this are quite dense and have terrible separation of concerns. I should h...

c# asp.net asp.net-mvc

0

Q: Code Compression/Eloquence for private properties and public accessors

Notes before you proceed: I use Petapoco for DB Queries and Petapoco CRUD Wrapper for methods like Get(id), Save(), etc. But, it should not matter because Petapoco is not exposed here. This question is for code Eloquence and reducing the bulkness of code. Here it goes. I have a class, say Acc...

c#

Zak

I *think* this is everything

Phrancis

@Zak That looks pretty thorough, nice work

syb0rg

Code is now included: codereview.stackexchange.com/q/132754/27623

Duga

Stack Overflow is not a code writing/refactoring service. If you have more specific questions on refactoring working code, you can try Code Review. Please include specific goals and previous attempts of improving your code. — ryanyuyu 55 secs ago

@ryanyuyu just a note. Code Review doesn't need previous attempts (and, in fact, they just get in the way). We just want the current, working, version of the code. — Zak 32 secs ago

Motoko Kusanagi

hey all

syb0rg

16:27

@MotokoKusanagi Hello

Zak

@MotokoKusanagi hi

Mat's Mug

Thanks for including code, I've reopened the post... but now I can't help wanting to see more - can you edit and include the full code for bot.on? The missing closing brace indicates there's more than that going on here... — Mat's Mug ♦ 12 secs ago

hi!

Motoko Kusanagi

i'm debating whether or not i should make my irc project in c; and include a javascript interpreter, or spend a lot less time and just write it in python

syb0rg

@MotokoKusanagi Well I'm biased towards C... so I'm probably not the best to ask haha

2/5 dependencies built on Windows for Khronos

Phrancis

@MotokoKusanagi Depends if you want to learn/get better at C / JavaScript, or just get it done and move on

Duga

16:36

You might want to push this code to codereview.stackexchange.com to get more understanding of basics.. — Leon 52 secs ago

Captain Obvious

-1

Q: Convert from Python code to Java code

I am currently learning Stacks and Queues and I found a good resource in Python on codility, But i write Java for now. Please how best can I convert this code from Python code to JAVA, in the most efficient way. queue =[0] * N head, tail = 0, 0 def push(x): global tail tail = (head + 1) ...

java python stack

syb0rg

@CaptainObvious JAVA == ~~death~~ close

Zak

16:51

@JanHudec Fair enough, I guess I'm not really cut out for drugdealership. Such a missed opportunity. — sanchises Apr 10 '15 at 10:21

> While getting into orbit is something of an obstacle, are there no locks on airlocks? Is space like Canada?

"Is space like Canada?" lol.

Mat's Mug

17:12

as in, "no locks"? ... ...... you guys know that "How I Met Your Mother" does not depict actual Canada through Robin, right?

♪ let's go to the mall ♪

Captain Obvious

0

Q: Django Model Manager for all members who haven't made a commit or pull request between the last 60-90 days

This goes with an application that tracks Git activity in our repos. I have a base manager that excludes any members that haven't been flagged as removed from the system (removed members are still kept in the DB for persistence). Then I need to perform queries on subsets of users based on their a...

python django

Duga

17:29

Welcome to Stack Overflow! Consider posting on codereview.stackexchange.com instead. (also, the "optional" tag refers to the concept of optionals in programming) — PWhite 44 secs ago

Malachi

@Mat'sMug lies all lies!

Mat's Mug

lol

Malachi

why did you do that to me?

Robin Sparkles-Let's Go To The Mall' (full version).

►

♪♫that's what it's all bout♪♫

if only it were Friday....

♪ don't forget the robot ♪

skiwi

Reading through kalzumeus.com/2011/10/28/dont-call-yourself-a-programmer in extension of what @Zak suggested yesterday

> Engineers are hired to create business value, not to program things:

Doesn't that quote depend a lot on what companies you apply to?

I mean if you apply for a development position in a company that is not developing a certain software suite / service, then you ought to expect that you will only be used for automating existing processes

Malachi

> The real world inspiration for the character is Canadian singer Alanis Morissette ...

Captain Obvious

17:37

0

Q: Spreadsheets keys converter

i was trying to solve this problem. as it mentions: In the popular spreadsheets systems (for example, in Excel) the following numeration of columns is used. The first column has number A, the second — number B, etc. till column 26 that is marked by Z. Then there are two-letter numbers: ...

c++ c++14

Malachi

Dang it @Mat'sMug --> youtube.com/user/VEVORobinSparkles

bad mod, very bad mod

ardaozkal

lmao

zʏᴀʙiɴ101

@ardaozkal Is it your video?

ardaozkal

no

I only get claims from sony

zʏᴀʙiɴ101

Good for you.

@ardaozkal How much?

Captain Obvious

17:48

0

Q: Can I please get some feedback on my coding technique for object oriented php?

I'm looking at getting a job as a php developer. I have submitted tests, but not heard back from them. Can I please get some feedback on my coding technique for object oriented php? Here is a test I was set and the code I submitted. Can you please tell me where I'm going right and where I'm goi...