[ramblings tom@zwizwa.be**20090725130815 Ignore-this: 1bfb3f12b3115ef6feef6ecdf93b3c3d ] hunk ./doc/sweb.txt 2082 + +Entry: Databases +Date: 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 + +(require +(planet "sqlite.ss" ("jaymccarthy" "sqlite.plt")) +(planet "sqlite.ss" ("soegaard" "sqlite.plt" 1 0))) + +Mini SQLITE cheatsheet: + + .help + .tables + .dump + select * from
; + +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 + +Entry: PLaneT +Date: Fri Jul 24 12:01:36 CEST 2009 + +I'd like to figure out how to: + + - install offline + + - find dependencies + +From the sqlite deps, what is + + sake: build tool (like `make') + + + +