+ Post New Thread
Results 1 to 12 of 12
Scripts Thread, SQL & PERL.... in Coding and Web Development; Evening All. I have in my first year of studying at uni part time whilst working full time. I have ...
  1. #1
    acrobson's Avatar
    Join Date
    May 2007
    Location
    Tyne & Wear
    Posts
    519
    Thank Post
    5
    Thanked 6 Times in 6 Posts
    Rep Power
    18

    SQL & PERL....

    Evening All.

    I have in my first year of studying at uni part time whilst working full time. I have an assignment on the horizon which will involve me knowing SQL and PERL.

    Can anyone offer any pointers as this will be very new to me. I have books on order and have been consulting such websites as sqlcourse.com and I am using Notepad++ as the text editor, but would really like to know a lot more info about the back end..end of things, as in how to actually view the end result of what you have put in......the GUI end I guess.

    Any suggestions or pointers would be most welcome.

  2. #2

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,422
    Thank Post
    645
    Thanked 967 Times in 667 Posts
    Blog Entries
    2
    Rep Power
    328
    Have a look at Perl Express as an IDE with built-in parser/viewer.

  3. #3
    acrobson's Avatar
    Join Date
    May 2007
    Location
    Tyne & Wear
    Posts
    519
    Thank Post
    5
    Thanked 6 Times in 6 Posts
    Rep Power
    18
    Cheers for that. I'll check it out now.

  4. #4

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,772
    Thank Post
    1,308
    Thanked 804 Times in 698 Posts
    Rep Power
    247
    Quote Originally Posted by acrobson View Post
    I have books on order and have been consulting such websites as sqlcourse.com and I am using Notepad++ as the text editor, but would really like to know a lot more info about the back end..end of things, as in how to actually view the end result of what you have put in......the GUI end I guess.
    What sort of thing is the assignment going to ask you to produce? When you say "GUI" do you mean client-side GUI or HTML output? The important thing to remember about SQL is that is based on set mathematics - you might want to revise (or learn) your A-level stuff on sets before you start. Don't neglect the database design at the start, don't just start programming and hope for the best. That said, once you've got the design stage out of the way skip the large step-by-step textbooks and just pagefault[1] on knowledge - any time you don't know what to do, type stuff in to Google and figure it out.

    [1] You'll be told what one of those is next year.

    --
    David Hicks

  5. #5
    acrobson's Avatar
    Join Date
    May 2007
    Location
    Tyne & Wear
    Posts
    519
    Thank Post
    5
    Thanked 6 Times in 6 Posts
    Rep Power
    18
    Quote Originally Posted by dhicks View Post
    What sort of thing is the assignment going to ask you to produce? When you say "GUI" do you mean client-side GUI or HTML output? The important thing to remember about SQL is that is based on set mathematics - you might want to revise (or learn) your A-level stuff on sets before you start. Don't neglect the database design at the start, don't just start programming and hope for the best. That said, once you've got the design stage out of the way skip the large step-by-step textbooks and just pagefault[1] on knowledge - any time you don't know what to do, type stuff in to Google and figure it out.

    [1] You'll be told what one of those is next year.

    --
    David Hicks

    I am studying Computer Forensics and 'Ethical' Hacking; it is to design a forensics analysis and retrieval tool. Basically, something which you can run to get information off a PC which otherwise may take hours or days and give a nice pretty GUI to view it in and not change any of the logs etc to keep it forensically sound.

    As for GUI, I want something, that when I'm type the SQL, I can run 'it' and see if flags up any errors and then go back amend it 'it', run it again and see whet it comes out like. If that makes sense?!?!

  6. #6

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,422
    Thank Post
    645
    Thanked 967 Times in 667 Posts
    Blog Entries
    2
    Rep Power
    328
    Ah, for a MySQL GUI have a look at HeidiSQL. Type your queries, run them, view results, see errors, and save them as snippets.

  7. #7
    acrobson's Avatar
    Join Date
    May 2007
    Location
    Tyne & Wear
    Posts
    519
    Thank Post
    5
    Thanked 6 Times in 6 Posts
    Rep Power
    18
    Quote Originally Posted by webman View Post
    Ah, for a MySQL GUI have a look at HeidiSQL. Type your queries, run them, view results, see errors, and save them as snippets.
    Looks spot on that, I shall take a look once I have finished my 2000 word assignment on 'echnology advancements since 1969'. I'm really interested in forensics and all things security wise, that's my 'area' sort of thing, just never had the chance or oppurtunity to turn my hand to programming.

    Got to start one day I guess!

    Cheers.

  8. #8

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,159
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    125
    Quote Originally Posted by dhicks View Post
    just pagefault[1] on knowledge - any time you don't know what to do, type stuff in to Google and figure it out.
    That's a brilliant expression! In computer terms, page faults are kind of bad but people who can "page fault on knowledge" are showing advanced skills :-)

  9. #9
    acrobson's Avatar
    Join Date
    May 2007
    Location
    Tyne & Wear
    Posts
    519
    Thank Post
    5
    Thanked 6 Times in 6 Posts
    Rep Power
    18
    Okaaaaay!

    I am looking at getting an academic version of MS Visual Studio from my course provider. Would this be any good you reckon?

  10. #10

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,772
    Thank Post
    1,308
    Thanked 804 Times in 698 Posts
    Rep Power
    247
    Quote Originally Posted by srochford View Post
    That's a brilliant expression!
    But not mine: it was coined by Joel Spolsky, as co-presenter on the Stack Overflow podcast. It neatly sums up the way that people actually work these days, and in some cases how some computing courses are now being taught - know your basic theory, but when it comes to specifics just stick the relevant keywords in to Google and figure it out as you go along. These are, after all, computers we're talking about here - most of "programming" these days involves working with a bunch of assorted processor architectures / OSs / languages / APIs, generally a selection of all of them all at once. Very little involves anything not created by human beings someplace, designed by someone with the intention of being easy (or possible, at least) to understand. It's not "real" science in the sense of unlocking the secrets of chemistry / physics / etc.

    --
    David Hicks

  11. #11

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,772
    Thank Post
    1,308
    Thanked 804 Times in 698 Posts
    Rep Power
    247
    Quote Originally Posted by acrobson View Post
    I am looking at getting an academic version of MS Visual Studio from my course provider. Would this be any good you reckon?
    What is it you're trying to get a nice GUI tool to show you? The results from an SQL query? Do you have a database that is that complex, or do you just need somewhere convenient to write lots of results so you can process them later? Perl isn't a Microsoft language, although I'm sure Visual Studio either handles it or can be set up to do so, but I get the impression that if someone is giving you a Perl exercise to do they might be intending that you get used to writing (and debugging) terminal applications. If you have a simple database design to deal with it might be worth trying to picture the results of an SQL query in your head before using a GUI tool, so you have the hang of what you're doing for future reference.

    --
    David Hicks

  12. #12

    Join Date
    Sep 2009
    Location
    North East
    Posts
    28
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    For perl:

    PerlMonks - The Monastery Gates

    and; your life long friend; CPAN

    cpan have almost all modules available for perl, although you can write your own perlmodules;

    if your lazy like me and can't be bothered say, writing the base64 tables module for unrealircd, then yeah =) all there! (now THAT was boring when i had to write that )

    even good old freezethaw!
    Last edited by AndySimmo; 6th November 2009 at 06:21 PM.



SHARE:
+ Post New Thread

Similar Threads

  1. Moodle & SQL Server 2005
    By ahunter in forum Virtual Learning Platforms
    Replies: 16
    Last Post: 31st October 2008, 01:19 PM
  2. SQL Server 2005 express & Win2k3
    By contink in forum Windows
    Replies: 8
    Last Post: 14th May 2008, 03:56 PM
  3. Perl Help
    By danIT in forum Coding
    Replies: 9
    Last Post: 1st August 2007, 12:35 PM
  4. SIMS & SQL Server
    By tscnmuk in forum MIS Systems
    Replies: 16
    Last Post: 20th July 2007, 01:58 PM
  5. SQL Table Location G&T
    By mark80 in forum MIS Systems
    Replies: 2
    Last Post: 16th May 2007, 01:46 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •