s c h e m a t i c s : c o o k b o o k

/ Cookbook.DatabaseChapter

This Web


WebHome 
WebChanges 
TOC (with recipes)
NewRecipe 
WebTopicList 
WebStatistics 

Other Webs


Chicken
Cookbook
Erlang
Know
Main
Plugins
Sandbox
Scm
TWiki  

Schematics


Schematics Home
Sourceforge Page
SchemeWiki.org
Original Cookbook
RSS

Scheme Links


Schemers.org
Scheme FAQ
R5RS
SRFIs
Scheme Cross Reference
PLT Scheme SISC
Scheme48 SCM
MIT Scheme scsh
JScheme Kawa
Chicken Guile
Bigloo Tiny
Gambit LispMe
GaucheChez

Lambda the Ultimate
TWiki.org

Databases

Introduction

Relational databases, along with the file system and structured markup, are one of the primary means of storing and exchanging data between applications. As such, they are an important part of any programmer's toolkit.

Database access in Scheme is generally achieved at the lowest levels through the use of an ExtensionLibrary?. These libraries are usually written to either the Scheme implementation's native FFI interface, or using a tool such as SWIG, which automates the creation of FFI wrappers for a number of Schemes, including PLT. With such an approach, you'll need access to a compiler for your platform (almost certainly a C compiler) and some knowlege of compiling C code. For PLT, another alternative would be to use David van Horn's c-syntax module to expose the low-level C interface for your database. PLT also provides the SrPersist? library for working with ODBC data sources. This would be a nice option for a database that has an ODBC provider but where no FFI library exists for PLT, or if you don't have access to a C compiler or the knowlege of how to use one.

At a higher level, Schematics provides SchemeQL, which provides a higher level interface on top of SrPersist?.

Recipes

Comments

WriteSqlInSchemeLikeSyntax: belongs here, but I did something wrong -- HiSeeComments

Fixed - the parent topic for recipes in the database chapter should be DatabaseRecipes -- AntonVanStraaten - 01 Jul 2008



(edit comments)

Comments

WriteSqlInSchemeLikeSyntax: belongs here, but I did something wrong -- HiSeeComments

Fixed - the parent topic for recipes in the database chapter should be DatabaseRecipes -- AntonVanStraaten - 01 Jul 2008

CookbookForm
TopicType: Chapter
ParentTopic: TOC
TopicOrder: 19

 
 
Copyright © 2004 by the contributing authors. All material on the Schematics Cookbook web site is the property of the contributing authors.
The copyright for certain compilations of material taken from this website is held by the SchematicsEditorsGroup - see ContributorAgreement & LGPL.
Other than such compilations, this material can be redistributed and/or modified under the terms of the GNU Lesser General Public License (LGPL), version 2.1, as published by the Free Software Foundation.
Ideas, requests, problems regarding Schematics Cookbook? Send feedback.
/ You are Main.guest