The 2nd Monitor

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

@Zak Nah, they are identical :p

Monking

<pmlomg @syb0rg

12:19 PM

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

Or NaA

@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.

@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...

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

i think it being at -4 is good enough

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

12:34 PM

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

-.-"

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

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

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

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

12:37 PM

People_Entities containing Person_First_Name and Person_Last_Name? just use First_Name and Last_Name

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

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

@Zak oh, gotcha

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

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

just use "name"

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

12:39 PM

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

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

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

@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"

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

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

12:40 PM

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

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.

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

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

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

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

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

12:41 PM

@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.

@Zak Okay, fine. But I disagree

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

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

@Quill <:

12:43 PM

@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

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

@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.

@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.

@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.

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

12:47 PM

@Quill LOL

@Phrancis All the ones I can currently think of.

lol

> [Support] You have 4 damaged emails

Also going to have tables for tracking edits.

It's not a damn letter, you dimwit phishers

3

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

12:49 PM

@Quill Trumpageddon

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

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

@DanPantry uh, no, not particularly

Quill

@DanPantry LOL

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

18

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...

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

12:51 PM

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

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

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?

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

3

@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).

@skiwi Pretty much, yes

12:55 PM

> 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.

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

@DanPantry It's still hard to imagine that

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

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

@GarethRees Yeah, I was actually thinking about that.

12:57 PM

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

Quill

Generally unreadable information digits & Usually unreadable information digits

Seems like over engineering though

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.

Or PRIMARY KEY IDENTITY in T-SQL/SQL Server

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

1:04 PM

Greetings, Programs.

@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.

Q: SQLite Databse inserting + Unit tests in Java

0

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?

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

@JeroenVannevel Ctrl %

4

1:19 PM

Saw someone asking for 4 years React exp yesterday

6

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

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

5

I AM the experience

2

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

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

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

I should really branch (hah) into algorithms

1:25 PM

@DanPantry Better branch into branch predictors instead

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

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

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

7

Legato

Greetings everyone.

@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

1:26 PM

@Legato Monking

@Phrancis LOL.

That would be the "reverse in place" interpretation

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

@Legato Hello

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

1:32 PM

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

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?

@skiwi SQLite

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

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

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

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

1:40 PM

@Phrancis cool, declined :)

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

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

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

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

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

1:41 PM

Eeek. who let the mug in?

@N3buchadnezzar The mug went in.

^

> 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

@zʏᴀʙiɴ101 OH YEAH

@skiwi Um, you think? ;p

Excel Is Not A Database™

3

1:46 PM

@Phrancis Not with that attitude it isn't

Any technology can be abused to act like a database

@skiwi Um yeah, even emails -.-

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

@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?

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

1:58 PM

I think PostgreSQL can do that as well.

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

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

Q: Database credentials and connector including encryption

0

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

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

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.

And more importantly a local database can never be offline

2:03 PM

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

@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

@Zak That's a pretty nifty site.

2:19 PM

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:

@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

Definitely.

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

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

Use cases!

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

2:22 PM

@Zak It's looking good so far

@skiwi Nope. The excel file is the database.

4

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

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

+1 Headaches now are better than migraines later

2

@DanPantry TS

2:24 PM

@Zak Who updats the database?

@skiwi The admin team.

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?

@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?

@Zak I thought you fixed that by using Access?

@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.

2:26 PM

Conflicted copies anyone?

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

@skiwi There are no copies.

Exclusive lock?

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

Good.

2:27 PM

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

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

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

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

@Phrancis Oh SNAP!?

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

2:29 PM

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

@skiwi lol don't remind me plz kthxbai

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...

I DID IT

I COMPILED SOMETHING WITH VISUAL STUDIO

I ACCOMPLISHED THE IMPOSSIBLE

Okay done yelling

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

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.

2:31 PM

@syb0rg cough

@Mat'sMug Yes? ;)

C++?

@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

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

Just missing arrow to Invoice_GUID I suppose

@Phrancis Haven't done it yet.

2:40 PM

@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?

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

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

Not necessarily going to use an actual GUID function.

a GUID is more "unique in that server"

Might just be serialisation

A guid is more... unique everywhere

2:43 PM

@DanPantry Unique in this universe

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

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.

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

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

back to work

2:47 PM

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

Eh... so you've gotta wait?

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

It's their mistake so maybe they can compensate somehow

And I have a two months notice period

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

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

2:50 PM

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.

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

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

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

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..

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

5

3:00 PM

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

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

lol

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

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

Q: Attempting to make this php code into a function

0

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

3:08 PM

@Duga handled

@CaptainObvious pseudo-code

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

@CaptainObvious Broken.

@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 :\

@Zak Switches should make that quite easy.

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

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

Q: Discord.js Bot - Improvements and Optimization Reccomendations

3:17 PM

0

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

@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.

@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)

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

The final stage is all-day, on-site

Ahh

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

3:29 PM

Best of luck.

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

Just don't make any rash decisions.

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

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

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

3:31 PM

@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

@DanPantry Are you sure the right people know?

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

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.

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

@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

3:33 PM

klkl. Let us know how it goes.

I will

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.

@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

What did he say?

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

3:35 PM

> 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

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

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

@Mat'sMug Happens.

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

0

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

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

3:44 PM

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.

I left a comment to that effect

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

@Duga Handled

Q: Finding permutation from given lexicographical rank

0

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

@Duga Smart guy.

3:59 PM

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

programming-challenge unit-testing functional-programming scala

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...

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

@Zak backups?

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

Q: ASP Controller and Seperation of Concerns

4:14 PM

1

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#

I *think* this is everything

@Zak That looks pretty thorough, nice work

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

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

4:27 PM

@MotokoKusanagi Hello

@MotokoKusanagi hi

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

@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

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

4:36 PM

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

Q: Convert from Python code to Java code

-1

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

@CaptainObvious JAVA == ~~death~~ close

4:51 PM

@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.

5:12 PM

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 ♪

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

0

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

5:29 PM

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

@Mat'sMug lies all lies!

lol

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

why did you do that to me?

►

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

if only it were Friday....

♪ don't forget the robot ♪

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

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

Q: Spreadsheets keys converter

5:37 PM

0

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

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

bad mod, very bad mod

ardaozkal

lmao

@ardaozkal Is it your video?

ardaozkal

no

I only get claims from sony

Good for you.

@ardaozkal How much?