Interacting with a Database from Scheme

Question

Hi, i try to learn scheme and as a test project i wanted to create a very simple website with 1-2 database queries (MySQL preferred, but PostgreSQL would be ok, too).

I know it's not really schemes domain but i still want to see how far i can come. Sadly, it seems i'm already stuck at using a database and googling for "scheme database" or any other combination including this words was (as expected considering the double meaning of scheme in this case) not very helpful.

Can you give me any hints on how to access a database from a scheme program?

I read something about scheme code interfacing a mysql client program to do that but i'd prefer something more direct.

Thanks.

Answer 1

GNU Guile already has a database interface that supports Postgres, MySQL and SQLite. It is called Guile DBI. Other Scheme implementations you may try are: SISC (Can connect to any JDBC compliant database, including MySQL) and Spark-Scheme (Can connect to any ODBC compliant database, including MySQL and comes bundled with SQLite). Also note that most Scheme implementations has some form of Foreign Function Interface that will help you to write your own MySQL->Scheme Connector.