[Year 12 IT Apps] Database programs that are BYOD friendly.

Thu Sep 18 09:22:16 EST 2014

Thanks for those links Brett,

You're on the money about WAMP-like USB servers. I have played with XAMP & WAMP with students but shied away from using MySQL with any but the most competent kids. I'll have a play with MySQLMaestro.

[Laurie Savage]

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Groves, Brett G
Sent: Wednesday, 17 September 2014 6:00 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Database programs that are BYOD friendly.

Hi Ben,

You can setup MySQL servers on non IOS devices very easily - WAMP or XAMP will do the job, they just install like a normal program and then run Apache, MySQL and PHP services for you. You can then teach the students basic SQL. They pick it up much more easily than I expected when I experimented with it in class.

You can run the whole thing off a usb if you want to.

To shortcut having to teach them a great deal of PHP syntax to interact with the database use the freebie version of PHP Generator form the SQL Maestro group (http://www.sqlmaestro.com/products/mysql/phpgenerator/), it will do most things the Pro version will do as far as students need (I've been using to rapid develop applications for school - it's quite easy and powerful)

If you have an existing Access database you want to quickly upload to MySQL with foreign keys etc intact then you can use AccessMySQL convertor from Bullzip (freebie too)

I believe there is now an app for IOS to manage MySQL but I don't think you can do any setup. That said PHPMyAdmin is very easy to use and there is no end of support for it on the net.

I think it's a good idea to start students on something that is very real world and translates to technologies they will encounter down the track that integrate with a whole host of web technologies like JQuery etc etc

Later on if you have students come back to Access it's trivial to get Access to talk to MySQL so it incorporates a remote table with two way data writing.

Be brave give it a go!

Kind Regards,

Brett Groves
[logosmall]
Melba College
eLearning Leader
03 9725 8277 Ext 221
0415 910011
eLearning Resources for Educators<http://melba.vic.edu.au/curriculum/elearning/>
Newsletter sign up<http://melba.vic.edu.au/curriculum/elearning/elearning-newsletter/>
Past Issues<http://us7.campaign-archive1.com/home/?u=3552e93cf6fe9d34510f19694&id=1cc14525a0>

From: itapps-bounces at edulists.com.au<mailto:itapps-bounces at edulists.com.au> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Baas, Benjamin B
Sent: Wednesday, 17 September 2014 9:53 AM
To: itapps at edulists.com.au<mailto:itapps at edulists.com.au>
Subject: [Year 12 IT Apps] Database programs that are BYOD friendly.

Hi All,

I'm sure this question has been asked before, but are there any teachers out their using database programs that are BYOD friendly or does anybody know of any BYOD friendly options.

Cheers,

Ben.

Benjamin Baas
[Description: cid:image001.png at 01C9CA67.50F474D0] Alkira Secondary College
*   Nurture Ave, Cranbourne North | PO Box 4314, Narre Warren South 3805
'   +61 3 5991 3500      6 +61 3 5991 3599     * www.alkirasecondarycollege.com.au<http://www.alkirasecondarycollege.com.au/>
Alkira Secondary College believes in Personalised learning for all, and  Respect for the individual

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.

Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20140917/13eecc43/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 9242 bytes
Desc: image001.jpg
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20140917/13eecc43/image001-0001.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.gif
Type: image/gif
Size: 1503 bytes
Desc: image002.gif
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20140917/13eecc43/image002-0001.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 1700 bytes
Desc: image003.png
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20140917/13eecc43/image003-0001.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Laurie Savage.vcf
Type: text/x-vcard
Size: 10275 bytes
Desc: Laurie Savage.vcf
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20140917/13eecc43/LaurieSavage-0001.vcf 