Hi folks.
I'm gradually hacking my Openguide installation into shape, getting some starter content in there. I'll start pushing it more publicly when I'm happy with it and think it's ready for the big bad world (and slashdotting, which is probably inevitable)
Here's the (current) URL. I'll ask for an openguides subdomain when I work out what I want to call it. Comments gratefully received. http://stout.rumble.net/cgi-bin/openguides/wiki.cgi
Now my question is this: how well does sqlite as my database scale? What are the caveats? According to the web site it is ACID and thus a "real" database (thought the "C" is kinda laughable since it doesn't enforce foreign key constraints).
What do I need to do if I decide to upgrade to a "real" RDBMS? Is it easy to move the data from one to the other?