Recent Updates Page 16 Toggle Comment Threads | Keyboard Shortcuts

  • Joel L 16:42 on April 7, 2011 Permalink |
    Tags:   

    @Brent – Don’t forget your task. Also, I suggest you do it as soon as possible, as it’ll be much harder to recall everything later.

     
  • Joel L 22:37 on April 4, 2011 Permalink |
    Tags:   

    (Re-)learn this https://developers.facebook.com/docs/reference/fql/

    Also, this http://fkingtiny.com/4m
    These are the slides I’ve sometimes used. The last few slides contain new and useful (ie.: required) things about SQL. Doesn’t have a lot of explanations, but Google will help you.

    Search for stuff like “sql beginner tutorial” and read and read and read.
    You need to develop an understanding of how relational databases work, and how to write SQL queries (like you did last thursday using the Facebook widget).

    Understand how to SELECT, INSERT and UPDATE data.

    Point is — if you prepare for the lessons, we’ll advance quicker, and you’ll actually get to build something cool. If not, all your time will be spent learning the very basics.

    (note: you can’t INSERT/UPDATE stuff using the facebook-sql-widget, as they don’t allow it.)

     
    • Brent 18:30 on April 6, 2011 Permalink | Log in to Reply

      Küsimus, et need tabelid, kust kohast SQL mulle selle info toob(või mida ma saan mainpuleerida), kus võimalikes kohtades saab see tabel olla, ma siis mõtlen, et Kas neti lehekülg, Excel või muu selline?

      • Joel L 20:34 on April 6, 2011 Permalink | Log in to Reply

        Tavaliselt on mingi database serveri tarkvara, nt MySQL, MSSQL (Microsoft SQL server), PostgreSQL jooksmas, mis reaalselt andmeid hoiab.

        See võib olla nt enda masinas, või kuskil cloud’is (e mõnes suvalises serveris kuskil internetis).
        Nt Uniserver, mis arvutiklassi masinates jookseb ja mida PHP jaoks kasutasite, sisaldab ka MySQL serverit.

        Aga SQL iseenesest on standartne (kuigi eri serveritel võivad olla erinevad lisavõimalused etc) keel päringute tegemiseks — 
        seetõttu kasutabki nt Facebook SQL-i ühe võimalusena oma API kasutamiseks – teatud inimesed on sellega juba tuttavad.

        Sisuliselt võivad siis andmed olla salvestatud paljudel erinevatel meetoditel. Võivad olla “reaalsed” tabelid (nagu näiteks mu slaididel näited, e MySQL), või ka mingi abstraktsem andmekogu.

        itgs.elevantstudios.com lehe facebooki-widget töötab põmst nii, et

        1. Sina kirjutad query, vajutad “run query”
        2. Veebileht (php) saadab sinu query Facebooki serverile
        3. Facebook saadab vastuse veebilehele
        4. Veebileht näitab vastuse andmeid ilusti tabelis

        On umbes arusaadav vastus?

  • Paavo Viilup 18:06 on April 4, 2011 Permalink |  

    Project matters 

    I uploaded the forms and the guidelines to TIKõpe. Feel free to consult them. We’ll figure out a project schedule tomorrow and use TIK Task for everything.

     
  • Taavi 10:33 on April 4, 2011 Permalink |
    Tags:   

    The client needs a portal for the librar… 

    The client needs a portal for the library information kiosk which would speed up the use of the kiosk. The portal needs to include links to various library databases, electronic catalogues and other sites users visit.

     
    • Sander 10:46 on April 4, 2011 Permalink | Log in to Reply

      This is a pointless post. Look down.

      • Sander 10:49 on April 4, 2011 Permalink | Log in to Reply

        If you’re doing it for the school library, you can use the school’s website. The database solution would be similiar to the original site, but instead of students you will have books.

    • Erik-Silver Toomere 10:47 on April 4, 2011 Permalink | Log in to Reply

      Make a neat looking webpage with lots and lots of links

    • alex 09:30 on April 5, 2011 Permalink | Log in to Reply

      Yeah a website is the best solution for this problem with sliding menus and what not

    • Taavi 09:52 on April 5, 2011 Permalink | Log in to Reply

      ………………………………………………………………………………………………………………………………………………….

  • Brent 10:32 on April 4, 2011 Permalink |
    Tags:   

    Problem? 

    The problem for my client is that, the current website is not up to date(information) and not appealing enough(the coloring and overall design) for the potential customer.

     
    • Sander 10:46 on April 4, 2011 Permalink | Log in to Reply

      Use the skills you’ve learned in ITGS class, and design a better looking and better functioning site.
      To keep stuff updated, your client can use a social networking solution like Facebook or Twitter.

      • Erik-Silver Toomere 10:50 on April 4, 2011 Permalink | Log in to Reply

        Make it prettier, update the information, sort it out so it makes sense and then add a Twitter feed to create a connection between the client and customer

    • alex 09:31 on April 5, 2011 Permalink | Log in to Reply

      Well yeah if the website needs to be updated then yeah a good colour scheme and many menus should be used

  • Erik-Silver Toomere 10:31 on April 4, 2011 Permalink |
    Tags:   

    Project problem 

    Client needs a system that would work as a birthday reminder so he could send a Thor damn gift basket if need be

     
    • Sander 10:46 on April 4, 2011 Permalink | Log in to Reply

      Think of a real problem.

    • Silver 10:53 on April 4, 2011 Permalink | Log in to Reply

      Use facebook? But yeah.. let him buy an electronic billboard

      • Erik-Silver Toomere 10:56 on April 4, 2011 Permalink | Log in to Reply

        He’s a lawyer who still uses IE, the hell is an electornic billboard?

    • Brent 10:54 on April 4, 2011 Permalink | Log in to Reply

      Use a smartphone, sticky notes, a calendar or a rock which you can use to carve dates into some other rock

      • Erik-Silver Toomere 10:56 on April 4, 2011 Permalink | Log in to Reply

        Sticky notes and calendars don’t do what he wants, a smartphone might but it’s harder to create

    • Taavi 11:03 on April 4, 2011 Permalink | Log in to Reply

      Create an app for iphone.

    • alex 09:32 on April 5, 2011 Permalink | Log in to Reply

      I think such an app already exists but yeah rethink the wording and the problem

    • Sander 09:36 on April 5, 2011 Permalink | Log in to Reply

      Use social networking, apps for phones, calendars etc.

  • alex 10:31 on April 4, 2011 Permalink |
    Tags:   

    Project problem 

    My client sews dance competiton dresses for children of all ages and it is difficult for her to sell these dresses to other dance clubs other than the club where her daughter dances. She wants to sell the dresses to everyone and not sit on the telephone all the time.

     
    • Brent 10:48 on April 4, 2011 Permalink | Log in to Reply

      Use Facebook to promote the dresses and stuff, by creating a user in facebook, for the company.
      Facebook commeting and thingies can help.

    • Sander 10:55 on April 4, 2011 Permalink | Log in to Reply

      If the transactions take place in the meatspace, use Facebook to organize and advertise.

  • Sander 10:31 on April 4, 2011 Permalink |
    Tags: ,   

    U mad? 

    My problem is that my client needs a way to sell her goods (in this case, soap) in a manner other than dealing face to face.

     
  • Silver 10:30 on April 4, 2011 Permalink |
    Tags:   

    There is no standardised way of delivering CAS diaries to authorised personnel and there is also the absence of the possibility of casual monitoring.

     
    • Brent 10:51 on April 4, 2011 Permalink | Log in to Reply

      Yes!

    • Taavi 10:53 on April 4, 2011 Permalink | Log in to Reply

      Does the way of delivering have to be standardised? If so then I do not want to give you a solution. As for the casual monitoring you could create a Tik Õpe like environment where one has to upload their diary by certain deadlines…

    • Erik-Silver Toomere 10:54 on April 4, 2011 Permalink | Log in to Reply

      Force everybody to create a CAS blog and then make a collective site for all of the blogs

      • Sander 10:58 on April 4, 2011 Permalink | Log in to Reply

        Use TIK TAK. That is, the messaging system that is never used. Or something of the sort.

        • Paavo Viilup 17:48 on April 4, 2011 Permalink | Log in to Reply

          Speak for yourself. The messaging system is used often, actually. It could be modified for the CAS diary project, but you’re not proficient enough yet.

    • alex 10:57 on April 4, 2011 Permalink | Log in to Reply

      The casual monitoring cannot be done unless to place cameras everywhere. The updating of diaries may be solved in one huge blog or a forum where everybody has their own space where to write. To ensure that everybody write regularly the same method as in do.tik can be used to set a time when the next thing has to be written and if not then it will be noted and writing for that day will be suspended.

      • Paavo Viilup 17:52 on April 4, 2011 Permalink | Log in to Reply

        I’m guessing casual monitoring refers to the ability of having an occasional look at the diary-in-progress, not having a world-wide surveillance network. I concur with TIK Task being a possible solution, but then that would not really work as a project.

  • Joel L 20:08 on March 30, 2011 Permalink |
    Tags:   

    And revise http://itgs.elevantstudios.com/guide/

     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel