« first day (1144 days earlier)      last day (2889 days later) » 

11:01 AM
@Vogel612 Sounds like a multiplexer.
 
Prompt boxes look amazing on Safari <3
 
@Mast not quite. A Mux puts a certain input to a certain output given by an address
it's basically a MUX without the input, yea
 
@Vogel612 So how does it decide where to put what, if there's no selector?
 
or to see it the other way: a MUX is an address decoder with an additional OR at every output that's combined with a given input
@Mast it just puts 1 at the output for the given address and 0 everywhere else
 
Ah, ok.
 
11:06 AM
makes the whole thing even more pointless, I'd say :/
 
Zak
My boss just offered to get me an upgraded computer ^^
 
@Zak Nice! Now you can afford to ask for a Pentium 4
 
Zak
I said awesome, but I think it would be even more effective to upgrade every computer in the office.
So now I need to put together the business justification stuff.
 
Every other employee would've just taken the darn thing.
Zak goes the extra mile and gets everyone a new computer.
 
This is Zak, Zak likes to make work comfortable for everyone, be like Zak.
4
 
Zak
11:10 AM
On an unrelated note. Assuming I had a budget of £1,000 per computer. And I was looking to maximise ease-of-use (minimal freezing, crashing, loading etc.). What are the key considerations?
HDD vs SSD, RAM, Cores, GHz?
 
GHz will not be your bottleneck, unless you use single-core applications like Excel.
3
 
Enough RAM for developers, SSD would be nice to have depending on workload
 
Zak
Except for me, they're not going to be running anything computationally intensive beyond standard web/apps.
 
@Mast Unless you have Excel sheets that are several GB big?
 
@skiwi Are there any others?
 
11:12 AM
Would one of the newer i5 with 2/4, or 4/4, or 4/8 maybe? cores/threads be reasonable?
I still go for i7 myself but I've heard that i5 do really good even on gaming
 
some spam flags please
-1
A: Validate and Add Service Provider/Location in C#

Anil SarmadalThanks for sharing this wonderful blogs with us.ivr solution we are thankful to you because you always provides us very useful and wonderful information. you can find us on:

 
i7 is great if you do 20 things at once. I have no clue how many things the 'average' user does at once.
 
Zak
Basically, I want an experience where everybody else in the office is never stuck waiting for an application to load ever again.
 
and on the way to be gone, thanks
 
Zak
@Mast depends on how you count "things". Between various Office Files, the admin team having 20 things open at once isn't unusual.
 
11:14 AM
@Zak Different applications. Having 5x Firefox open doesn't count, that's more a RAM thing than a GHz thing.
 
I don't think Ghz really matters anymore in the world of today
 
You tell that to my Raspberry...
 
Zak
@Mast Outlook, Word, PDF, Excel, Windows Explorer, IE, Chrome, ACT (CRM DB), PowerPoint. Call it 10.
 
(For regular computers ;0)
 
@Zak Get a balanced computer. Peaks are wasted in that case.
I think hardwarerecs had a chart somewhere.
 
Zak
11:17 AM
@Mast So I guess anything with plenty of cores and an SSD would handle everything smoothly?
 
@Zak Let's put it this way, I have an i7-4770, 16GB DDR3 RAM and SSD here and everything runs smooth, I don't see any issues with lowering the Ghz a bit and perhaps less cores/threads
One thing to keep in mind is what brand of SSD you are going for, personally I think Samsung EVO series are worth it, but cheaper brands may offer worse experiences
 
If there's budget, definitely put an SSD in it. Quadcore i5 from a relatively modern series (5xxx and up), 2.7 GHz or so, and 16 GB of RAM.
 
@Zak SSD, £300 bare bones, plenty of RAM and a 1TB hard drive will set you back about £600.
 
@JoeWallis are you around ?
 
my 500GB SSD was £100, £300 for AMD 8 core + mobo + psu + case, ~£60 for 24GB of RAM (lol) and £70 for a 1TB HDD.
 
11:21 AM
Make sure the SSD is big enough though, everything under 100 GB is a waste IMO.
 
@Mast I grabbed a 64GB SSD for cheap money and I use it solely as boot drive
 
This is the SSD I have for Windows
 
that's just fine for increased boot time and responsive running while keeping it cheap wrt. storage
 
boots up in a couple of seconds, runs everything super smooth
 
That would be an OS-only SSD, yea.
 
11:22 AM
Talking about motherboard, are the i7 ones considerably more expensive than i5 ones?
 
And all of my games run basically instantly
@skiwi aren't the i7/i5 the same chipset?
or socket, I should say
 
@Heslacher still needs some spam-flags :/
 
they should both fit in an am3+ socket
 
@Vogel612 I thought 3 would be enough. WHERE ARE THE MODS ?
2
 
it's 6...
also don't downvote spam. just spam-flag it
 
11:24 AM
@DanPantry I don't know actually
 
@Heslacher hi
 
Zak
@Vogel612 So we have to spam spam flags to remove spam?
 
hi @Quill
 
basically, yea
 
@Heslacher it was a joke
and it looks like they're asleep
 
11:25 AM
@Vogel612 Why not both?
 
@Vogel612 thats clear. By flagging as spam the downvote is delivered automatically
now its gone
 
Zak
@Mast Why does it matter what size the SSD is? (all our actual files are stored on a central server).
 
@Zak It should fit your OS and all the often-used software.
 
Zak and don't forget the updates
 
I'm voting to close this question as off-topic because questions about coding style belong on codereview.stackexchange.com. — Barmar 59 secs ago
 
11:27 AM
any ways of compacting what I have here guys ? dpaste.de/JFZm ^^
 
In hindsight you could probably do with less than 100, but the software I use is diverse and big.
 
@Zak Have you investigated if the connection from PC to central server might be a bottleneck?
 
@Dex'ter Yea, string it together.
 
you mean string.replace.replace... etc ?
 
Aye.
It's not pretty, but you wanted compact.
 
Zak
11:28 AM
@skiwi I'm going to. But generally no, loading files takes up a minimal % of peoples' time.
 
@Dex'ter use regex
 
I know... well, maybe I'll just leave it this way for others to understand it
 
Greetings, Programs.
 
Zak
Though if we're going to spend £10k on upgrading the rest of the hardware, may as well upgrade the server while I'm at it ^^
 
@Quill didnt come with the right one. I think I tried some things
 
11:30 AM
@Zak Yea, but upgrading the server may not solve your bottleneck. It depends on how many connections it's handling, what the speed of the connection is, etc.
 
@Zak Ok, I think a network card with a Gigabit connection is mandatory (to be future-proof), but likely that's already the case
 
Well, it looks...interesting: string_1 = (string.replace('\'', '').replace(',', ')').replace(' ', ''))[::-1].replace(')', '', 1)[::-1] haha =)
 
Zak
@skiwi Wait, network card?
 
Actually, I'm unsure what PCs have built-in, I just remember I needed a WiFi network card but unsure about cabled
 
@Zak yeah, PCs need network adapters to connect to the internet <_<
 
11:33 AM
@Mast waste and IIUC it kinda poisons the bayesian filter
 
Zak
@Quill TIL
 
actually you may want to consider something more interesting like a redundant network card or even (if you want to blow it heavy) two redundant network cards
that usually makes the router and your network architecture the bottleneck
and at that point you'd have to consider optical fibre backbones inside your network
 
@Vogel612 It does? That's odd at best.
 
but that's for companies with more than say 50 people
 
Zak
@Vogel612 We're currently running on ethernet cables.
 
11:36 AM
@Zak Which CAT?
 
@Zak That's silly. Why don't you get a proper floor?
 
@Mast and I didn't understand correctly:
47
Q: Why shouldn't I downvote spam that I've already flagged?

John BensinOne of the responses to the question about the mass of football spam said: The proper course of action is to flag the post as spam. Three spam flags will remove it from the front page, six will delete it. Don't edit it, don't downvote it, don't use another flag. Flag as spam and move on. As...

pushes stuff out of the front page, that still needs a tad of visibility to go up in flames
 
@Dex'ter Hi, just reading through the messages, will have a look
 
The link was broken; how was it spam?
 
@Vogel612 So we don't downvote spam so it gets read by more people.
 
11:37 AM
@JoeWallis yay, great
 
shrug
Thanks for the link though.
 
Zak
@JeroenVannevel We didn't build this office. We might not be here permanently. Before me, nobody had the time or expertise to look into these things and it hasn't been business-critical up to this point.
@Mast Does it matter? The lowest these days is 100mb connections right?
 
@Zak do note that the 50 people number is completely arbitrary. It depends on your network needs. but at that point your company should have a dedicated IT department already
 
Zak
@Vogel612 I guess that's me ^^
 
if you identified the network as a bottleneck it may be useful to check with your boss if you can grab some expertise in that direction
 
11:40 AM
our IT department is an outdated sysadmin who still believes in webforms, jquery and stored procedures
2
 
alternatively you may want to investigate hiring a contractor
@Quill sprocs are not that bad
 
they're just unnecessary
 
meh... care to elaborate?
 
Zak
@Vogel612 We have a (contracted) IT dept. of sorts. They handle all the sys-admin type stuff (network security, connections, backups, etc.)
 
@Quill I think it's just another case of "golden hammer"
 
11:41 AM
0
Q: Checking whether a store is open or not by querying over its business hours

Sebastian Jennings AlmnesI currently have a method that checks if the store is open. It's working nicely, however on the main page I have quite a few stores. Whom again have different locations. Each of these locations again have opening hours. Now I'm not particularly good with SQL and DB querying and Skylight is compl...

 
what performance advantage do stored procedures give? they are basically just storing the SQL code to execute on the server so you don't have to transfer it every time and for a CRUD site, that's pretty useless
 
precached execution plans
 
it didn't help when the coder converted graphic designer was writing the procs either
 
sure for a crud site it's useless.
but aren't you confusing the misuse you know (which is obviously misuse) with what sprocs are intended to do?
 
I don't understand your question
 
11:46 AM
@Dex'ter You can use string.translate in Python2 it's nice, Python3 not so much. string.translate({ord(','): ')', ord('\''): '', ord(' '): ''}), I don't know of a nice way you can do the other bit. Unless you think ''.join(string.rsplit(')', 1)) is nicer, ;P The joys of no rreplace.
 
possible answer invalidation by thePav on question by thePav: codereview.stackexchange.com/posts/132598/revisions
 
@Quill you seem to be shearing sprocs the wrong way, because the way you see it used is obviously wrong
but you seem to not reflect on the difference between tool and usage of said tool
 
@Quill precached execution plans as @Vogel612 mentioned, also separation of concerns
 
@Duga seems to not invalidate answers
 
they give the same benefit that using an interface in C#/Java/TypeScript has
i.e, hiding implementation detail
SQL developers can modify sprocs, they might not feel confident modifying SQL code inside of an app
Sprocs can also be safer in terms of SQL injection concerns
 
11:52 AM
@JoeWallis I think I'll leave it this way. God have merci on this x_X
 
@Quill sidenote: studies show that even factually imperceptible speed differences make a huge difference on user-retention
 
also: you can unit test sprocs
you can't unit test arbitrary sql strings
 
when a website renders after 30ms it keeps measurably more users than when it renders after 40ms
 
without code duplication, anyway.
 
@DanPantry What is this myth?
 
11:54 AM
@DanPantry uh, you can unit test strings
 
I am going to have to post a question again soon. it has been a while
 
can... nobody said it was easy
 
@Quill So you have a couple of scenarios when using SQL inside of an app..
Either:
 
@Quill yea... by asserting they are equal to an arbitrary (and possibly wrong) string
 
@Dex'ter I can't think of anything nice, ): But it'd probably be great for Code Review when you get it working!
 
11:56 AM
@DanPantry That's interesting
 
- You're using an ORM to generate it
- Loading SQL from files and executing it (please don't do this)
- Having long, arbitrary strings of SQL in your code
If you're using an ORM, you can of course test the ORM but then SQL developers cannot test it
The 2nd option is stupid
the third option is also stupid, and requires SQL developers to understand the code around it
Using sprocs is great in a team where you have developers AND sql developers, not just full stack developers
Source: This is the scenario we have in my current place
 
if you use an ORM, you don't really need SQL developers
 
That's hilariously wrong
 
Hosting an internal API on your database server machine seems like a sane method though, but it's probably not the fastest
 
@DanPantry meh... you don't "need" them per se.
 
11:59 AM
There is some stuff you simply cannot do performantly in C# f.e
 
but it's good to have them because ORMs are incredibly inefficient
 
dynamic searches are very hard to do in a strongly typed language without a sproc and without an external service like Elasticsearch
 
@Quill I've never been able to write a program fully in ORM-language yet, I've always had to resort to SQL :/
 
The only reprieve for us there was to use a sproc
 
0
Q: Small error in form processing loop and suggestions on a more efficient process

pacificI have a form processing that I am sure can be done more efficiently and there is an error in the result set although not "life threatening" just not correct. The purpose of the page is to associate an item with a program and at the same time associate a designation within the program -- B and F...

 
Zak
12:04 PM
huh. The last time I looked at bitcoin it was at $300, today it's at $670. When did that happen?
 
When Ethereum got hacked, probably
 
@Zak I really should invest in bitcoin.
Also, our app is causing the Chrome pop-up blocker to go nuts
 
too late for that... it's just a matter of time till the bubble bursts
 
because it has an ngClick on a <div> which opens a window - Chrome will block this
The solution, apparently, is to disable the pop-up blocker. For all users. Without an ad-block.
Instead of changing the <div> to be a <button>.
The fledgling security engineer in me has alarm bells going off in his head.
 
@forsvarir you're right; deleted meta answer
 
12:08 PM
@DanPantry You should've done that when it was $1 each actually
 
Monking
 
hey @syb0rg
 
@Vogel612 solution to this: spam flags increase a post's visibility
 
@Pimgd yea that would be totally helpful....
> "Hey my question doesn't get any views... I know I'll raise a spam-flag to bump it on the frontpage"
 
bad flags lead to flag bans, right
 
in scala, probably not
in ColdFusion: Yes. By a lot.
 
TIL what target attribute does in <a>
 
_blank?
 
not quite
 
yeah it does
main purpose
 
12:15 PM
@JeroenVannevel s/purpose/usage
 
nvm, there's something funky going on there. 3 elements are created..
 
@JoeWallis let's suppose I have something like: for row in c.execute('some query) print(row). Any good way of modifying only the first row ?
 
@JeroenVannevel _blank is a "magic" one, it always opens in a new window
what target actually does is allows you to choose an alias
if you reuse that target on another link, the link will be opened in that tab if its already opened
 
oh that's how you do that. huh.
 
a[target='foo'] - if this is clicked twice, the second link will replace the content of the first tab
 
12:18 PM
ooh fancy
 
@Dex'ter Like i = iter(c.execute(...));next(i);for row in i?
 
that's a bit of an old technique though, isn't it? Is there really a mainstream use for it nowadays
 
weird and I'll likely never use it. But fancy
 
I thought of making a counter and when it has the value = 1 to modify it
 
@Quill not sure. sometimes you want a window to always open in a new window, rather than in the same window. we have that in our current CRM
 
12:19 PM
I think my bank website does that. and it's really annoying to lose a tab because the "target owner" decides to overwrite it
 
could be a small micro-optimisation though
 
micro-optimisation and bad UX
 
if you have target='docs' and someone clicks the link twice, the browser could determine that target='docs' has the same url as the one being clicked and not reload it
 
apparently there's a burnlist on MDN for stuff, so I hope that's on it
although that might be for JS functions
 
12:22 PM
yeah, I know. I'm saying MDN has a burn list of features that aren't used or are ready to die
 
Do you have a link? I can't find it.
 
apparently they did analysis of a whole bunch of pages and are burning functions used less than 0.03% of the time
 
That sounds like an incredibly bad idea.
0.03% is not zero
 
Most of the functions I read on that part of the list I've never even heard of
 
@Dex'ter I'll show you in the Nth
 
12:23 PM
@JoeWallis Sorry, are we interrupting a CR discussion? if so we should go to the NTh, not you.
 
Not CR related dw
 
Can anyone point me to where this source code might be at? codereview.stackexchange.com/questions/60627/…
Google's not helping me much
 
@Vogel612 Already found that, tried searching for "color" and didn't find anything in it
 
@syb0rg did you try "colour", the correct spelling? /s
(don't try that, there are no results)
 
12:31 PM
You would better be better off at Code Review for improvements on your implementation — Rakete1111 7 secs ago
 
Thanks @JoeWallis ^^
 
@DanPantry I viewed it at work and can't seem to find it right now <_<
I'll go through my history at work tomorrow and see if I can find it
 
@Duga No
 
@Rakete1111 No, Code Review is not a place for broken code since it is off topic over there. He asked on the right site. — syb0rg 33 secs ago
 
that was larger than I anticipated ;-;
 
12:35 PM
I wanna review that snake game, but I can't compile it rn
 
in case you wanted to be confused, take a look at javascript's equality comparison options:
`==` - performs type coercion. don't
`===` - performs exactly equality, treats `Number.NaN != Number.NaN`, `+0` === `-0`
`Object.is` - same as `===` but without the exceptions.
Only JS could make 0 === 0 even harder than it needs to be
 
I was going to say that I wrote a thing on this, but then I remembered it was in the docs beta <_<
 
0
Q: Basic Express + NodeJS REST API

dragfireI've created a REST API Endpoint for my website's Dashboard. 'use strict'; let express = require('express'); let Router = express.Router(); let debug = require('debug')('HAYUM: Dashboard API'); let db = require('../../db'); let mongodb = require('mongodb'); // REST API Endpoints for Dashboard ...

 
@CaptainObvious use strict followed by let of immutable bindings. why do people not use const :(
 
Zak
@skiwi Reminds of stories from the early days of Bitcoin, when people were buying pizza for 10,000 BTC
 
12:46 PM
@Zak LOL
reminds me when I didn't invest in it because no where was using it.
:))))))))))
Just another reason for me to hate 15 year old me.
 
Reminds me of when Dogecoin was a thing
 
Darn you 15 year old Dan and your lack of knowledge of economics.
 
Zak
@DanPantry Also, the word is "Speculate"
 
@Zak "I should really invest in speculate".
Just doesn't have the same ring to it.
/s
 
Zak
@DanPantry Personal analysis: Bitcoin may or may not be a good long-term investment. Etherium is finished long-term (regardless of how the current crisis shakes out).
 
12:51 PM
I think Etherium has a SE community.... I wonder how fast that'll collapse beside the currency
 
Zak
Etherium is based on a legal system where whatever the code does is legal. Which means if (like the recent hacker), you can find an edge case in a smart contract that gets the contract to send you money, then that is perfectly legal, just like exploiting a loophole in a legal contract.
It is, in essence, a monetary system based on the assumption that smart-contract code is completely bug-free, because any bug allows people to legally steal all your money.
And I just can't imagine a future where code is bug-free. When whole companies full of million-dollar lawyers can still screw up billion-dollar contracts, what hope does mass-market computer-code have?
 
Sounds like a great question for code review. SO is typically reserved for issues (e.g. not working) in code. — Ryan Wildry 56 secs ago
 
I didn't know I introduced Janos to chat: meta.codereview.stackexchange.com/a/1757/27623
 
@syb0rg wow :)
I was about to say "wow, a diamond in so few years?"
then realised 2014 was a whole 2 years ago
now I'm going to sit in a corner and rock back and forth
 
lol, someone joined the #rust-beginners channel and asked a question about the Rust game
5
 
12:56 PM
I still write 2014 when I have to write the date.
 
@syb0rg Yes, you're old.
 
Zak
awww
@Jamal Good joke! People do notice the higher quality of the posts here over other Stack Exchange sites. You are the one that makes that happen! :) — syb0rg Apr 11 '14 at 2:54
 
@skiwi lol, how fast did they get kicked?
 
> I feel more appreciated here compared to Stack Overflow. Maybe because of the smaller volume, it's more likely that good contributions don't get overlooked. This is a good place for programmers who pay attention to details.
 
@Quill He noticed pretty quickly :P
(and left)
 
12:58 PM
This is exactly why I stick around CR too, feels like there's a better sense of community
 
Zak
> Okay, fine, I'm just here to edit posts, but would prefer not to propose Edit Review SE... ;P
 
@Zak What happened, my metal heart is so cold now
 
CR is like a small quirky village. SO is like a bustling city. It's nice to go to the city sometimes because it has everything there and it can be convenient, but there are a lot more a-holes. In contrast, in a small village, everyone knows each other and there's a real sense of family :)
That's my annual dose of soppiness. You're welcome.
 

« first day (1144 days earlier)      last day (2889 days later) »