S
S
sphinxy2012-08-13 11:27:03
SQL
sphinxy, 2012-08-13 11:27:03

How to store archive of sql queries with search tags?

We are looking for a way \ program for storing an archive of sql queries and a quick search by tags.

The current situation is that programmers write different analytical queries to the database, several pieces a day, in a month or two queries with changes are repeated, you just need to take the old query and add it. The problem is the organization of storage and further search. Now requests in the form of files with meaningful names "customer statistics for the month of June.sql" are sorted into folders like "requests from Petrov, 2012".

We need at least tags and ease of use, ideally I pressed one button, selected tags from the list and threw them into the archive. Plus, it is desirable to be able to work with files.

Considered:
1) wiki. Approximately suitable, but inconvenient to create a new one - either attachments to the article, or ctrl-c->ctrl-v each time.
2) Any version control system. There are tags there, but rather as an additional feature without convenience, and versioning is not needed here.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
andreysmind, 2012-08-13
@andreysmind

gist.github.com/

W
Wott, 2012-08-13
@Wott

I would have attached a plugin to a wiki, WP, or any system where you can store and organize it to run this sql, perhaps with parameters, perhaps not simple but from tables, to use
phpMyAdmin and perhaps its relatives have the ability to save queries. You can again screw it with integration with a local wiki or blog. And one of them is the reverse one, because “look at the result” also needs to be shown
. And also “client statistics for the month of June.sql” you just need to save and actively use in the view, although complex queries in one view may not fit.

B
balloon, 2012-08-13
@balloon

Why not store analytical queries in the database too? Attach tagging to them and make a simple convenient navigator / editor / builder.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question