• View
• Edit
• History
• Print

Scheme-Amp-SQL-Database-Interactions

Rohan Golwala
December 10, 2008

Overview

The project aims to build an interface with a Database Server (PostgreSQL) running on a local host system which is controlled using the Scheme language which serves as an interface. It aims at performing the basic SQL queries as well as some higher-order query methods to help process results.

Screenshot

Concepts Demonstrated

• "Data Abstraction" as a concept in using the "map" and "filter" procedures in working with the SQL data.
• "Lists" are also used as an arguments for many functions.
• The use of the "lambda" procedures in many functions using the concept of "Functional Programming".

External Technology

The project integrates with SQL technology making use of a Database Server Software named 'PostgreSQL' which communicates with Scheme language. We can perform basic queries such as creating a table, insert data into table, etc. as well as high-order queries on the data in the Database Server using Scheme environment making use of the libraries such as "class.ss" and "spgsql.ss".

Innovation

The innovative thing that I did in the project was that I created complex querries using the simple SQL queries which lead to the concept of a "view" with the help of a primary key. The thing that was most innovative was that I displayed data from two different tables simultaneously in a single query which was interesting. Also, I used the map, filter, fold etc. functions which works also with the SQL queries which was interesting. Thus, I used the concept of these functions to perform some complex but rather easy operations. Lastly, I also worked on formatting the output which worked really well and hence the output looked organised. Also, I worked on creating a secured connection to the server which required a password.

Technology Used Block Diagram

Additional Remarks

I would like to thank the PLT-Scheme group immensely as they have been very helpful in making this project a success. There is no direct SQL library which you can start using immediately. I had to test it and search for it a lot. The main concept in the project was to set up a connection with the database which took a lot of time to figure it out. Once, that was done the rest of the things were rather easy and achievable compared to the previous operations.