EPTLets hope it go well
The Big Programming Thread - Page 714
| Forum Index > General Forum |
Thread Rules 1. This is not a "do my homework for me" thread. If you have specific questions, ask, but don't post an assignment or homework problem and expect an exact solution. 2. No recruiting for your cockamamie projects (you won't replace facebook with 3 dudes you found on the internet and $20) 3. If you can't articulate why a language is bad, don't start slinging shit about it. Just remember that nothing is worse than making CSS IE6 compatible. 4. Use [code] tags to format code blocks. | ||
|
Wrath
3174 Posts
Lets hope it go well | ||
|
LaNague
Germany9118 Posts
On March 27 2016 03:07 FFGenerations wrote: is offering websites to small business a thing? like you cold call businesses with shit websites and offer to make something for them with a portfolio . coz that's what i thought people would like to do. but maybe theres not much actual money in it (considering how much you guys get paid working higher brow jobs) ive had people call me with such offers for my fathers company when i was working in his office for a bit. its not really shit, its just utterly unremarable. Mostly some random designers from Berlin, guess they got attracked by the startup and art scene and spewed out pretty quickly. | ||
|
FFGenerations
7088 Posts
On March 29 2016 03:03 WrathSCII wrote: Well guys, tomorrow is my big day, if I succeed in this front-end interview, I could finally throw away my current life that I may be regretting. But who knows? Lets hope it go well well thats the kind of attitude they are probably looking for :D | ||
|
Blisse
Canada3710 Posts
On March 29 2016 03:03 WrathSCII wrote: Well guys, tomorrow is my big day, if I succeed in this front-end interview, I could finally throw away my current life that I may be regretting. But who knows? Lets hope it go well Good luck! Don't regret your current life though! | ||
|
Shield
Bulgaria4824 Posts
| ||
|
Cyx.
Canada806 Posts
On March 30 2016 02:01 Shield wrote: I'm reading 'Effective Modern C++'. Damn, C++ has become even more complex but I guess C++ jobs will still be well (or even better) paid, right? Has anyone tried to get familiar with C++11/14 yet or has anyone read that book? I'm actually in the middle of it right now too, it's my build time reading :D It's a really good book, although almost all of it has been disseminated to stackoverflow at this point so if you've been keeping up to date there's not a *ton* of new stuff in there, just collected wisdom from the last 5 years or so It's a really good book though, and C++11/14 is a significantly better language than C++98/03 was. | ||
|
Shield
Bulgaria4824 Posts
On March 30 2016 03:24 Cyx. wrote: I'm actually in the middle of it right now too, it's my build time reading :D It's a really good book, although almost all of it has been disseminated to stackoverflow at this point so if you've been keeping up to date there's not a *ton* of new stuff in there, just collected wisdom from the last 5 years or so It's a really good book though, and C++11/14 is a significantly better language than C++98/03 was.I'm very confused with all the little details as I don't want to forget any details so I'm not caught offguard while I design a class. Other than that, the more I read, the more I understand how little of C++ I know, haha. The book definitely helps though. I've not read explanation yet why pass by value could be a good thing other than that the compiler may use move semantics. I'm not aware of all the rules when this is supposed to happen though. | ||
|
Chocolate
United States2350 Posts
| ||
|
Wrath
3174 Posts
Basically you want to compare 2 90MB unsorted text files. A way that came up to my mind is using Cygwin to use Linux sort command and "merge" both files into a 3rd file without duplicating records. Number of records is the same in both files. Logically if the 3rd file got the same record count as the other 2 files, does that mean that those files are identical? | ||
|
xtorn
4060 Posts
http://www.theverge.com/2016/3/30/11331014/microsoft-windows-linux-ubuntu-bash | ||
|
Acrofales
Spain18161 Posts
On March 31 2016 04:27 WrathSCII wrote: How do you compare 2 txt files each of them is around 90MB. You need to know if they are identical or not. They contain data in rows format but those are not sorted the same way in both files. Basically you want to compare 2 90MB unsorted text files. A way that came up to my mind is using Cygwin to use Linux sort command and "merge" both files into a 3rd file without duplicating records. Number of records is the same in both files. Logically if the 3rd file got the same record count as the other 2 files, does that mean that those files are identical? Was that one of your interview questions? How did it go? If you need an exact answer, you'll have to do something like that (sort both alphabetically and then do an exhaustive row by row comparison). If you don't need an exact answer, a far easier and quicker way is to count every character. If the counts are the same you can be virtually certain that they are the same, but not 100%. On the other hand, if they are different you can be 100% certain the text files are different. | ||
|
Ropid
Germany3557 Posts
On March 31 2016 04:36 xtorn wrote: Holy mother of all that is sweet and pure. http://www.theverge.com/2016/3/30/11331014/microsoft-windows-linux-ubuntu-bash Here's someone from Canonical writing about it: http://blog.dustinkirkland.com/2016/03/ubuntu-on-windows.html On March 31 2016 04:27 WrathSCII wrote: How do you compare 2 txt files each of them is around 90MB. You need to know if they are identical or not. They contain data in rows format but those are not sorted the same way in both files. Basically you want to compare 2 90MB unsorted text files. A way that came up to my mind is using Cygwin to use Linux sort command and "merge" both files into a 3rd file without duplicating records. Number of records is the same in both files. Logically if the 3rd file got the same record count as the other 2 files, does that mean that those files are identical? If you are already using that sort tool, couldn't you just completely finish the job with the rest of the tools? Like so on the command line: diff -q <(sort one.txt) <(sort two.txt) The slowest about this is the sort tool. It's something like 5 seconds for 90MB text. | ||
|
Nesserev
Belgium2760 Posts
| ||
|
Shield
Bulgaria4824 Posts
std::string hello = "Hello!"; Are you able to access "Hello!" after this line? I don't think so. So, it has to be rvalue then but the standard considers it lvalue, I think. | ||
|
Nesserev
Belgium2760 Posts
| ||
|
enigmaticcam
United States280 Posts
I'm managing the ETL between our 3rd party pricing system and our ERP. We get pricing like this: ItemCode Distributor Month Price 123 123 201501 8 123 123 201505 8 123 123 201506 8 123 123 201507 8 I have to convert it to this: ItemCode Distributor Start End Price 123 123 201501 201501 8 123 123 201505 201507 8 I wanted to do it without using any cursor or do-while loop. Also have to consider that there can be well over 1 million rows to process. Turns out to have been one of the more challenging SQL I've had to write in a long time. You can't just do a basic group by with a min and max on the Month, otherwise it would set the price to be from 201501 to 201507, which isn't correct. I was able to do it by first finding all the prices that have no price for the previous month, assigning a unique ID to each one, and then running a recursive query to find the next month with the same price for each ID. It would pass the parent ID to each subsequent child. Once that was complete, then I could just do a group by using the ID. Simplifying it, but hopefully you get the idea. With proper indexes, it runs quick enough to handle the large row count. It was a nice accomplishment to follow one of the busiest weeks I've had in a while. | ||
|
Wrath
3174 Posts
Was that one of your interview questions? How did it go? No it is not, just a problem I faced yesterday. Thanks for asking... I... had better interviews... | ||
|
Blisse
Canada3710 Posts
On April 01 2016 01:25 enigmaticcam wrote: I thought I'd share my programming achievement for the day. I'm managing the ETL between our 3rd party pricing system and our ERP. We get pricing like this: ItemCode Distributor Month Price 123 123 201501 8 123 123 201505 8 123 123 201506 8 123 123 201507 8 I have to convert it to this: ItemCode Distributor Start End Price 123 123 201501 201501 8 123 123 201505 201507 8 I wanted to do it without using any cursor or do-while loop. Also have to consider that there can be well over 1 million rows to process. Turns out to have been one of the more challenging SQL I've had to write in a long time. You can't just do a basic group by with a min and max on the Month, otherwise it would set the price to be from 201501 to 201507, which isn't correct. I was able to do it by first finding all the prices that have no price for the previous month, assigning a unique ID to each one, and then running a recursive query to find the next month with the same price for each ID. It would pass the parent ID to each subsequent child. Once that was complete, then I could just do a group by using the ID. Simplifying it, but hopefully you get the idea. With proper indexes, it runs quick enough to handle the large row count. It was a nice accomplishment to follow one of the busiest weeks I've had in a while. Yeee, nice :p I can't imagine doing it in SQL but it looks super close to how you would implement union-find/merge :o On April 01 2016 04:32 WrathSCII wrote: No it is not, just a problem I faced yesterday. Thanks for asking... I... had better interviews...  aww, better luck another time | ||
|
enigmaticcam
United States280 Posts
On April 01 2016 08:08 Blisse wrote:I can't imagine doing it in SQL but it looks super close to how you would implement union-find/merge :o What's a union-find/merge?! Man, I need to take an algorithm class so I can know about these ahead of time without having to spend hours to work up my own. | ||
|
Manit0u
Poland17557 Posts
How would I write a computer program to calculate (find a and b) 6 = a^3 + b^3 where a and b can be any integer (positive or negative)? I desperately need solution to this equation and I'm too noob at this stuff... | ||
| ||
