« first day (429 days earlier)      last day (3574 days later) » 

9:03 PM
The approach I would select would depend on the RDBMS used by the server, if they were both the same this would be very easy to do with SQL
 
Getting a dia scanner to work is cumbersome
 
Make a sproc and just call it from Java and let SQL engine decide what the best execution is
 
@Nobody But can an API provider? All it can do is disable communications if it even has permissiosn for it; but an user then can still store it in a string and later on upload it
 
@skiwi i think it was a joke :p
 
could be yea ;)
 
9:06 PM
"if you don't want anyone to know anything about you, don't talk to anyone"
 
@skiwi @DaggNabbit: It was mainly a joke (what use would be such an application?) but you could theoretically enforce boundaries that cannot be crossed such as: disallowing to send/receive, swiping persistent memory ...
 
@ckuhn203 Re-Gratz on 2k and on that Nice answer! :P
 
well, I must go, my people need me!
bye @all
 
@rolfl Please take a look at the comments on my answer here and tell me what you think: codereview.stackexchange.com/questions/56305/…
 
@Phrancis You owe me a beer ;-)
s/User.ID/Users.ID/g
@SimonAndréForsberg Meh, I am taking a JDQ holiday ;-)
(not really).
I upvoted your answer before, you are right.
 
9:12 PM
@rolfl lol, understandable
 
He upvoted and accepted an answer of mine though (a critical one ;-)
so, I can't complain.
 
@Nobody if you really wanted to be paranoid about it you could set up a dummy profile with an empty contacts list and just use that
 
much
 
@SimonAndréForsberg I almost suggested that he drop using tests since anyway he doesn't even use them correctly. I'm so tired of saying all those questions
 
@rolfl There is hope!
I'm considering to start doing my own implementations on the GeekForGeeks questions...
 
9:13 PM
@Simon - there's something 'off' about the way that JD uses Code Review.... though I can;t think of any rules he's circumvented other than that his questions all feel hypothetical
But that's a blurry rule anyway
What my beef boils down to is that we keep saying the same things again and again, and again.
Which, is really my problem, not his.
If I don't want to say things again, then I should just not say things.
 
^ that's my policy
 
@rolfl I understand what you mean, but I don't really consider his questions to be hypothetical. They're just... interviewical.
I wonder how many interviews he's been to.
 
Funnily enough, (is it ironically enough), as an interviewer, things I look for are the ability to pay attention to detail.... and to anticipate problems. The actual problem does not matter too much. How much does the person ask, what do they assume, and what do they anticipate.
I feel that his answers are all 'flat', he assumes too much, asks too little, and anticipates only the obvious
 
@rolfl I don't like plural table names, it makes queries look funny IMO
 
@Phrancis - that may be true, but when the table is called Users, you should probably select from Users.
2
 
9:20 PM
^^ Right...
 
User is a different table ;-)
 
My SO meta question is up to 78 votes! Wowzer.
78
Q: Why can't we change our close-vote reason?

nhgrifThis answer does a fair enough job explaining why you can't vote-to-close on a question once you've retracted a close vote. But I'm curious, why can't I change my close-vote reason without retracting my close vote? For example, this question started as a question that was too broad. There was...

 
@rolfl His answers? Do you mean his questions or the answers to his questions?
 
I mean, his answers to the interview questions, which he offers to us to review.
 
Meanwhile, this user codereview.stackexchange.com/users/14608/bazola is going to post the entirety of the source code of the dwarf game he's making for the iOS app store...
I mean, if he doesn't offer me the game for free, I'll just copy & paste my answers into Xcode and compile it on my own.
3
 
9:28 PM
Well hey. Look at that! Thanks for pinging me @marc-Andre. I hadn't noticed.
 
@rolfl Oh, those. Well.. the way you write a code review isn't really "interactive", but I understand what you mean.
 
meh, TTGH
@Simon - 4 of you on the wall.
(but I am @ Max, you are not).
 
Today, I discovered the SQL function COALESCE() and it annoyed me.
 
Sure, but I've been doing SQL for 8 or 9 months now and until today, I only knew about ISNULL()
SQLite isn't SQL.
SQLite is for local database on the device.
iOS has SQLite too.
 
9:36 PM
Sure but the principles are the same.
 
Yeah, the language is mostly the same.
 
@nhgrif we were talking about this post for a while here, I think before you got here
0
Q: Android Pulling Contacts

JeffComptonI'm trying to loop through android contacts and upload them to our server. What I have now is unusably slow. The query itself is taking about two and a half minutes for 10,000 contacts and it appears to stop parsing data after the first batch. private static void syncContacts() { Res...

 
And it's a decently efficient way at storing data.
He's trying to upload contacts to a server. Not sure how SQLite would apply.
 
My thought was, if you're talking about copying/moving a large amount of data (in his case 150K records) you would do yourself a favor to use SQLite instead
 
I think it's just an extra step.
I don't know how the contacts are stored in the device for Android (or iOS for that matter)
 
9:38 PM
@rolfl I'm not sure I am going to be max today either.
 
But to use SQLite, you'd have to fetch the contact from the device however it's stored, then insert it into the device's SQLite database, then when you were done doing that for all contacts, go back through them all again to upload to the server.
 
That may be the case but if he had a sproc on device side he could just call it from Java and pass it to his server as a single transaction no?
Don't know much about Java so I'm not going to attempt an answer but that sounds like it would be more logical...
 
I don't know how easy it would be to pass data in SQLite format into SQL or whatever his server expects.
I think best solution might be creating a separate thread and uploading each contact individually asynchronously.
Or in batches of 5/10, whatever
 
Flat data file like CSV perhaps? All RDBMS should be able to take that and parse it out.
 
Plus, that way if there's a network problem, you haven't loaded in 50% of a csv file that the server may or may not be able to make sense of
 
9:42 PM
@nhgrif i'd guess they're already in an sqlite db on Android; they use sqlite a lot
since sqlite db just lives in a file you could probably just shoot that file over to the server, maybe compress it first if it's not already
 
If it's already in a SQLite database, then SQLite may be relevant, and you're right, it's highly likely that's how it stored.
Actually, given the wide range of Android devices and the tendency for the lower end devices to not have the best hardware, the best solution is might be to upload it in whatever format it currently exists in rather than waste time parsing on what may be a crappy processor, and just let your server sort it all out.
I will say, one of the things that annoys me as an iOS developer is hearing people say "But Android devices are cheaper!" It's the same with PCs. Yes, you can get a non-Apple device for cheaper than you can get an Apple device, but if you want the same hardware specs as an Apple device, you're going to pay almost the same amount you would for an Apple device.
Higher end Android devices are better than Apple devices, yes. They also cost more. Lower end Android devices are not better than Apple devices, but they do cost less.
 
thinking about it more you probably don't have access to the file itself, just some API to fetch records and whatnot, so it's probably a PITA
 
PITA?
 
0
Q: Iteratively copy wildcard named folder and files

user47819I'm new to Python. I'd like to iteratively copy all wildcard named folders and files from the C drive to a network share. Wildcard named folders are called "Test_1", "Test_2", etc. with folders containing the same named folder, "Pass". The files in "Pass" end with .log. I do not want to copy...

 
9:54 PM
Ah.
@CaptainObvious Off-topic.
 
@DaggNabbit and I would think if one was an app dev for a device that uses SQLite that I would want to use that server-side as well
 
Not necessarily.
No server-side scripts in SQL server, for starters.
No partitioning on SQLite
SQLite isn't quite as good with concurrency
And there's no user-access control in SQLite
SQLite doesn't support CTEs. SQLite is also quite limited in the datatypes.
Also, SQLite has a max DB size of 32TB.
I don't know about other DB options, but Microsoft SQL Server max DB size is something over 500,000TB
 
Ah yeah those are all good reasons
Thanks for pointing that out @nhgrif
And without further ado, SELECT CURRENT_TIMESTAMP] AS 'TTQW'; GO
Bye @all!
 
10:12 PM
Bye!
Almost to 14K... and almost out of votes.
 
@Jamal Santa wants to let you know that I'm only 6 behind rep-cap today.
@Phrancis Incorrect syntax ] near ] AS 'TTQW'; GO
 
@SimonAndréForsberg Ho ho ho
 
Ho ho thanks.
2169 to target.
The worst part is that now I have uneven repscore again...
 
Multiple of 3.
Multiples of 3 are not uneven.
Nor are multiples of 5.
 
10:23 PM
@nhgrif Technically, everything where x % 2 != 0 is uneven.
Multiples of 5 are the best on SE.
 
BOOL isUneven(int x) {
    return (x % 2 == 0) || (x % 3 == 0) || (x % 5 == 0);
}
 
@Jamal That's what I did earlier today!
 
10:36 PM
0
Q: JQuery delayed unexpected differing result

user47820Please find my code here: http://jsfiddle.net/jJyJv/ As you can see when you scroll down the header "shrinks" as expected but does not come back when you scroll up the back as I would have expected. Sometimes just a small part of the header comes back then a few seconds later it fades back in or...

 
aren't they supposed to put their code in the question, not in a link?
 
yes
 
@DanLyons - Thanks. I just found the relevant section in the asking help.
 
the code you are looking for is in another castle :)
4
 
This is not the code you're looking for.
 
10:54 PM
Where is the bed I am looking for?
TTGTB
 

« first day (429 days earlier)      last day (3574 days later) »