[Greg Reid]

04/02/2019 at 9:45 am

Work has started on writing the appendices to be included in the revised AH course specification document.

One of the planned appendices is to exemplify how to use the most common programming languages to connect to a database. I have previously connected to a database before using Python’s MyPySQL module and know that I can find colleagues with examples in VB but I also wish to exemplify livecode and Java.

If you have example code for creating database connections using livecode or Java and would like to be involved in helping with this could you contact me (greg.reid@sqa.org.uk). A writing contract would be raised for any work you do preparing notes that I can incorporate into the appendix.

Thanks for your help
Greg

P.S. We have said each year that if you wish a part of the course exemplified further we are happy to add further appendices. If there is a specific area of the AH draft content grid that you wish to see in appendix form please let me know.
https://www.sqa.org.uk/sqa/files_ccc/AdvancedHigherComputingScience_SKU.pdf

[Denis Soames]

27/05/2019 at 2:22 pm

I wonder if PHP is a given for inclusion considering the need for server-side programming languages in the course and the goal of information systems design and development?

[Mark Hay]

27/05/2019 at 2:45 pm

Hi Greg,

For Python I was just going to use the default MYSQL Connector ( if it is of any use)

import mysql.connector

db = mysql.connector.connect(
host=’127.0.0.1′,
database=’Databasename’,
user=’root’,
password=’root’,
#mac only (not required for windows)
unix_socket=”/Applications/MAMP/tmp/mysql/mysql.sock”

)

print(“Connection ID:”, db.connection_id)

[Greg Reid]

27/05/2019 at 4:45 pm

I actually finished the first draft of this appendix today. With the help of a couple of others have incuded the following for Java, Python and VB:
Setup Advice
How to Connect to a MySQL DB
A few examples of executing SQL

@Denis The Apppendix for PHP will be released very soon.