gothwalk: (Default)
( Apr. 5th, 2006 05:07 pm)
A question for the more technically minded among ye. I'm going to be doing some work on a database of local information for, and I'm think about how to structure it. At present, I'll want to flag entries in the database with various notes, and also attach tags to them, in the short-established Web2.0 style. Since there'll be an arbitrary number of possible tags for a given entry, and an occasionally changing number of flags, what's the best way to manage this?

Possibilities in my mind is to have one field, "flags", containing a comma separated list of words, and the same for tags. Another possibility is to have a field per flag, and let them be 1 or 0 - although I can't see that working for the tags. And finally, there's the possibility of a table co-relating flags/tags and entries separately.

I might just use tags overall, but I'd like to distinguish between the ones I set (flags) and the ones anyone else sets.

And a separate question - does anyone know how easy it is to get at phpBB's user storage, and if that login could be used elsewhere on the site, for comments, feedback, submissions, and the like?

I'm in an odd place on this; I know the stuff that can be done, I work with it every day, but in many ways, I haven't the slightest idea how to go about it anymore without developer support.
gothwalk: (Default)
( Jul. 2nd, 2002 03:33 pm)
I've been using Amphetadesk as a news aggregator for the last few weeks. Today, while poking at it, I came up with a few ideas and mailed them to the guy who makes it - Morbus Iff - fully expecting them to vanish into the ether. A few minutes later, I got a mail back saying that two of my ideas were going to be in the upcoming new release, and that the third would be as well, and he attached a new template file with a way to do it already. That's service, so y'all go and download Amphetadesk now.

What it does: It fetches the XML RSS feed from a wide variety of sites, and puts it all in one file on your desktop, downloading fresh material up to once an hour, whenever you're online. Cuts down the clicking through lots of weblogs and news sites to reading one local file, and clicking through if you want more information.

Morbus also runs, an excellent gaming site. Is there nothing the man can't do right?


RSS Atom

Most Popular Tags

Powered by Dreamwidth Studios

Style Credit

Expand Cut Tags

No cut tags