How do you maintain a library of useful SQL in a team environment?

Question

At my work everyone has sql snippets that they use to answer questions. Some are specific to a customer, while some are generic for a given database. I want to consolidate those queries into a library/repository that can be accessed by anyone on the team. The requirements would be:

1. Accessible
2. Searchable
3. Tagable (multiple tags allowed per sql)
4. Exportable (create a document containing all queries with certain tags)

I'm interested in what has been found to work in other team environments.

Answer 1

You could use a wiki.

You could get started with something as simple as Tiddly wiki.

Answer 2

A wiki is a great approach.

For database specific or project specific snippets it's also very useful to have links to where a similar construct occurs in the code. We use trac's wiki which gives nice integration with out SVN for this.