|
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. |
On October 05 2014 23:06 Manit0u wrote:Or you could make a game about database management, where you have to choose between sqlite, mysql, postgresql, mongodb etc. and you do actual db design inside the game and measure performance on all dbs in order to pick one that is best  Server/DB admin RPG.
reminds me of the truck/train/bus/rcok/mountain simulators
|
How much longer till someone makes Simulator Simulator? It would simulate playing a simulator.
|
Hyrule19254 Posts
On October 03 2014 23:25 FFGenerations wrote:hi guys, can you please have a look at this and tell me why my Wscript.exe stays in task manager when i randomly close the application? I'm trying to figure out where to put this shit to catch whatever error it gets when you randomly close it..... it no longer shows an error message when you randomly close it, but wscript stays running in task manager + Show Spoiler +
On Error Resume Next
Do
Do While checkSortBy() = 0
If horizontalNumber = -1 Then
iret = iim1.iimClose
WScript.Quit(iret)
ElseIf checkNextLinkExists() Then
clickLink()
modifyControlValues()
Else
clickPreviousLink()
End If
Loop
extract()
clickPreviousLink()
Loop
objFileSystem.Close
strOutputFile.Close
iret = iim1.iimClose
WScript.Quit(iret)
first, On Error Resume Next is possibly the worst thing in any language ever
second, you have no exit for your outermost loop, so your program never ends
|
Hope this is good place to ask.
Any courses/sources you guys recommend for learning a bit about admin stuff? Like administrating a company network, virtualisation and similiar. I'm more a web guy and recently tried to get a job as a administrator/all-round IT guy - I thought I should be good candidate with my knowledge of software/hardware and some programming skills and thought that I could learn as I go the new things. But seems like noone wants that "learning passionate" and all want actual experience, which sucks greatly. So I'm going to try and learn few new things by myself, like I always do anyway~~
Thanks in advance.
|
This was a simple, common SQL interview question I just encountered, would someone be able to walk me through it?
Two tables:
Customers: id, name, address
Orders: id, cust_id, date
Write a query to get the name and id of customers whose total number of orders exceed 10 in the last week.
My attempt at the answer is along the line so:
select c.name, c.id
from Customers as c join Orders as o
on o_id=c.id
where o_date ?????
group by c.name
having COUNT(c.id) > 10
|
Hyrule19254 Posts
SELECT c.name, c.id
FROM customers AS c JOIN orders AS o
ON o.id = c.id
Basic stuff, and it's almost in English anyway
WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= o.date
The missing part should look something like that (untested). MySQL manual explains the things better than I can.
GROUP BY c.name
Takes the results and gives a single line for each entry by name (since you'll have more than 10 results for every id/name pair you want if you don't group them)
HAVING COUNT(c.id) > 10
Only select rows when there are more than 10 per customer id.
|
Just a quick question: does the 98-372 Microsoft .NET Fundamentals certificate hold any value? Will it make finding future job easier for me or attending the course (which seems pretty basic, but takes 2 weeks + exam) would be a waste of time?
On October 07 2014 03:38 OsaX Nymloth wrote:
Hope this is good place to ask.
Any courses/sources you guys recommend for learning a bit about admin stuff? Like administrating a company network, virtualisation and similiar. I'm more a web guy and recently tried to get a job as a administrator/all-round IT guy - I thought I should be good candidate with my knowledge of software/hardware and some programming skills and thought that I could learn as I go the new things. But seems like noone wants that "learning passionate" and all want actual experience, which sucks greatly. So I'm going to try and learn few new things by myself, like I always do anyway~~
Thanks in advance.
There are specialist SysAdmin courses (Windows and Linux/Unix respectively, which turn you into a certified admin). If you want to get into that (I'm doing some research on that myself as my boss asked me to aid with our server restructuring) here are some good links to read:
http://thenubbyadmin.com/2011/08/18/behold-a-buzzword-is-born-high-recoverability/
https://www.simple-talk.com/content/article.aspx?article=1332
It's nothing specific but you can find many references to useful stuff you should read about (and learn) either in those articles or in the articles linked in them.
|
I'm still pretty new to Tcl, but isn't this really weird:
set value [exec cat /file.tmp]
as opposed to using the normal open/read commands.
|
On October 08 2014 02:26 tofucake wrote:SELECT c.name, c.id
FROM customers AS c JOIN orders AS o
ON o.id = c.id Basic stuff, and it's almost in English anyway WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= o.date The missing part should look something like that (untested). MySQL manual explains the things better than I can. GROUP BY c.name Takes the results and gives a single line for each entry by name (since you'll have more than 10 results for every id/name pair you want if you don't group them) HAVING COUNT(c.id) > 10 Only select rows when there are more than 10 per customer id.
This is a really good start, just a few more things to hopefully help.
The join from orders to customers should be on c.id = o.cust_id not c.id = o.id. I know its nitpicky, but, screwing up a "simple select" probably wouldn't look good on an interview.
You probably also shouldn't assume that you can group by name, unless of course the interviewer stated that there was an unrealistic unique index on name. If there are 2 John Smiths then you would get a sql error telling you that c.id isn't apart of your group by clause. Assuming that id is used as it normally is, it is the more correct value to group by.
The last thing is uber nitpicky by me.. but I would personally write having count(o.id) > 10 . It would still be a correct sql statement the way it is currently written, but to me, if you were to say it in english, you wouldn't say counting the number of times that my id appears, but, as your problem statement reads, where the number of orders is greater than 10.
|
Hyrule19254 Posts
eh it's an interview question. They are more about showing you didn't lie on your resume about knowing SQL rather than seeing if you can point out issues that don't exist because it's an example setup and is assumed to always work perfectly.
|
Really depends on the interviewer. Some interviewers are pretty chill and understand you won't syntax done perfectly, and might make a few small errors. Some will point out that you have problems in your solution and see how you go about figuring out what the issue is, and rather than dock you for the initial error they will judge based on your followup problem finding/solving.
Some interviewers straight up dock you for missing semicolons and don't think it's a bad thing. :\
|
do they take into account how good is your google-fu?
|
I personally take google fu into account by assuming that any reasonable developer can solve problems with any language or can quickly learn syntax, if they can think through problems. It's the main reason I thought I was being helpful by pointing out the group by on name -- because if you can't spot the issue with assuming that name is unique it doesn't matter whether you lied about knowing SQL or whether you're the Lebron James of googling, you are going to get the problem wrong.
|
This is probably the best place to put this. Github has started a program for students which is amazing. I was already using namecheap, digitalocean and github(i recommend these 3 to any student in the field)
|
Okay, so it seems I was on the right path. Just wasn't sure on the date line and some nitpicky lil things I should probably work on.
Thanks.
|
Is there any sites like Codecademy for Java? I'd love to find a site to learn Java for beginners.
Any help appreciated.
|
On October 10 2014 23:02 Grettin wrote:
Is there any sites like Codecademy for Java? I'd love to find a site to learn Java for beginners.
Any help appreciated.
Wanted to suggest javablackbelt but it seems it's no longer there any more 
You could try javaranch, tutorialspoint or the netbeans learning trail.
But seriously, get the Thinking In Java book.
|
On October 10 2014 23:33 Manit0u wrote:Show nested quote +On October 10 2014 23:02 Grettin wrote:
Is there any sites like Codecademy for Java? I'd love to find a site to learn Java for beginners.
Any help appreciated. Wanted to suggest javablackbelt but it seems it's no longer there any more You could try javaranch, tutorialspoint or the netbeans learning trail. But seriously, get the Thinking In Java book.
Thank you. I'm going to check those out!
|
On October 10 2014 23:02 Grettin wrote:
Is there any sites like Codecademy for Java? I'd love to find a site to learn Java for beginners.
Any help appreciated.
When I was at university, we were given a Java book called "Java, Java, Java" by Ralph Morelli. There is a free pdf on the internet. I don't know how good it is compared to other beginner books though.
Edit: I rarely have a problem with Eclipse but when I do, it doesn't make any sense. :D
|
Hi guys, I had like a 10th idea for my Software Engineering final yr degree project
Application that allows user to
- connect with MyAnimeList API to myanimelist anime database (or some service/database???) and search anime
- create a list of anime that is stored in my own database
- using this list, generate a JPG/image of the list similar to https://www.dropbox.com/s/f3m7jfrkqg8580r/list2.png
- and hence share their anime list easily online in form of a jpg
OBVIOUS ISSUES
- has this been done before? http://appcrawlr.com/android/uranime-animelist clearly shows lists of anime in a compact format but can the user turn their lists into downloadable/sharable jpgs or something sharable? the app http://appcrawlr.com/ios/anime-manga-amino sports a near perfect rating , i will have to emulate these on my PC to try them out and see.... also http://appcrawlr.com/android/anime-trakr-anime-episodes
- speed. i would want user to be able to search anime in real-time. would connecting to myanimelist or something like that be very slow i.e. not realtime/autocomplete? https://itunes.apple.com/gb/app/anime-boxes/id525540312?mt=8 this one says it connects to Gelbooru anime image website and has autocomplete/autofill search feature
TECHNICAL BONUSES
(for good grade project i need to overcome technical challenges and not just UI etc ones)
- connect to an existing database/web service
- own database to store user accounts with multiple user anime lists. (myanimelist appears to allow users to have only 1 anime list and i would want to users to be able to make as many lists as they want eg their "fav horror anime")
- compatibility - can i use something like Adobe Air to make this multiplatform??? html5?? who knows
- combining the list of anime images to make 1 image?
- speed of searching & creating lists . the whole point is to be slick and super-fast so there's no point unless i can do this.
- hosting the user's generated image. restricting users to 10 image "slots" (but infinite list slots) on my own bandwidth costs? or can i cooperate with a proper image host?
- security!?!
pic
+ Show Spoiler +
WHAT DO I DO NEXT?
1) ive posted on myanimelist dev forum, hummingbird dev forum (think they are an anime forum) , i should continue to make posts/try to get contact with people who might be able to advise me.
2) however i feel a bit foolish until i am able to actually try the existing apps for myself and see exactly what they offer already. so i need to figure out how to emulate apps on my PC
3) not only apps but there are many anime list websites other than myanimelist that may offer web/database services or end-user services + Show Spoiler +
4) ???????????????????????????????
EDIT:
I guess I will update this post saying:
Do you think this is actually a challenging enough project for final year software engineering in the first place!? Immediate reaction from this guy in the anime thread was - no!
On October 11 2014 10:10 FFGenerations wrote:Show nested quote +On October 11 2014 09:49 Spazer wrote:On October 11 2014 07:03 FFGenerations wrote:Please extremely critically review my idea for Software Engineering Final Yr Project Here is the idea (from 2 minutes ago): + Show Spoiler +Tool that allows a user to create a list of anime shows by drawing from a master list and then share this online in a customisable graphical format e.g. anichart lists or the list at the top of anime thread https://www.dropbox.com/s/f3m7jfrkqg8580r/list2.pngThe primary purpose of this tool is to allow users to rapidly create a graphical collage of anime that they want to recommend or share with another person. I initially think the idea might be ok because a) really the ONLY important thing is that it has technical challenges/choices that need to be addressed - at a glimpse I see - database management? (sql?) - connectivity? (???) - compatibility/portability? (adobe air?) (web-based?) (facebook support?) - scalability? (ways to measure performance?) - graphical performance (benchmarking? other methods to measure?) - choice of technology? - existing products? b) is this a unique idea/system? IT MIGHT BE? - where did this image come from / how did it get generated?!?!?!?!? https://www.dropbox.com/s/f3m7jfrkqg8580r/list2.png (image from top of thread) - do sites like MyAnimeList offer image generation? (i just threaded their tech support to ask but do you know of other places?) i just knocked this up on google doc to illustrate my ap: PIC + Show Spoiler + I don't really see the difficulty the technical challenges/choices in this. All you'd have to do is do a bunch of API calls to myanimelist or just grab the xml files of the manga/anime lists. Then you're just conducting a search on said list and arranging things in a grid. Got any examples of prior final projects? Because this seems way too straightforward. OK after browsing for example anime lists i see there is a mobile ap which obviously the tlnet list was created from.
The list in the mod note was made manually. Thanks for the reply. Maybe you are right that it is too simple.... I mean, its very hard for me to tell since I have little experience in coding. The ideal intention would be to develop it using a modern or cutting edge technology that perhaps makes it very fast or very compatible/multiplatform ...or very something..... That in mind, don't you see any particular issues in the things I listed? How am I supposed to be able to tell if something like this is too easy or too difficult!?!! I have like 30 1st-class projects from my university that i downloaded and need to read. So yeah I'll do that next before getting my head too far stuck into something. Can you think of anything that would make this project interesting/challenging (in your opinion?)
|
|
|
|
|
|
EPT![[image loading]](http://i.imgur.com/JQC6JU1.jpg)
