Fri Jul 24 11:51:03 CEST 2009


Persistance.  Even though I like the idea of using ad-hoc data
structures to represent data, it does seem that SQL-based storage is
not going anywhere, so I'm going to spend a couple of hours getting
something setup in a standard way.

Probably best to start with a simple interface to reduce db ignorance
before using the more involved untyped ORM `snooze'.  I'm using [1] as
a guide.

PLT Scheme + SQLite

(planet "sqlite.ss" ("jaymccarthy" "sqlite.plt"))
(planet "sqlite.ss" ("soegaard" "sqlite.plt" 1 0)))

Mini SQLITE cheatsheet:

   .dump <table>
   select * from <table>;

Ok... This should be enough to try something with the apache db.  It
looks like it is a quite straightforward bridge between SQLite's SQL
dialect and Scheme.  Now I just need to learn SQL.

[1] http://scheme.dk/blog/2007/01/introduction-to-web-development-with.html
[2] http://www.sqlite.org/sqlite.html