[<<][sweb][>>][..]

Thu Apr 16 16:10:07 CEST 2009

what to use a db for?

This might seem a stupid question, but I'm thinking about using a
database as a data cache only.  Is this a good idea?

Only if data flows unidirectional from a different store format
(ramblings.txt) to the db, and never in the other direction (i.e. post
comments).

I'm biased towards text files: "source code" for data.  I don't have a
good feel for dbs due to lack of experience.  How to design tables?
In snooze [1] [2], is it ok to sometimes add tables or should we use a
different table for things that might associated to objects?

Let's stick to the real problems:

  * ramblings should be sped-up.  reload is too slow with huge text
    files.

  * I'd like to add some kind of comment posts facility to the
    ramblings posts.

[1] http://planet.plt-scheme.org/display.ss?package=snooze.plt&owner=untyped
[2] http://planet.plt-scheme.org/package-source/untyped/snooze.plt/2/6/planet-docs/snooze/index.html

[Reply][About]

[<<][sweb][>>][..]