• View
• Edit
• History
• Print

SchemeAndDatabase

Qizheng Yu
December 10,2009

Overview

I use scheme to build a connection to the database. So, I can administrate the messages in the database using scheme GUI.

Screenshot

Concepts Demonstrated

List of String, string-append are used to sort the information the DB API returns from DB.

Local state variables are used as pointer to select messages in the database.

Recursive procedure are used to manipulate the information from DB.

External Technology

Scheme GUI provides user interface when we interact with database.

spgsql.ss is used to build a connection between scheme and database.

POSTgreSQL is the database.

Innovation

I thought scheme is a kind of dead language, but when is use scheme to manipulate a database rather than C++,Java,C#... I found we can still do a lot with scheme. Such as scheme use structure to store messages from database, this is similary with C/C++. This is really a new discovery for me.

Technology Used Block Diagram

Additional Remarks

I'm trying to implement fuzzy search, but actually I only accomplished part of it. For example, if I want to find all my classmates who were born in nov, so when I search by keywords no,n,o,v,nov, it works. But if I use keywords such as NOV,N,Nov, it doesn't work.