Database viewer for server?
We have a few proprietary tools that store data in rather standard database, using those tools is a pain in the ass. (A common example is a part number database - with some details, and for example a link to a PDF manufactuer data sheet)
Getting access to that tool is an issue. For me - 99% of the time - If I could open a giant txt dump of the database and search it using EMACS or VI - I can find what I need.
What I'm looking for is a simple (Apache or IIS server) application that I can do that with HTML against the database.
Needs to be able to: (A django thing would be great, we already have a django instance)
a) Key point - Display and SEARCH only - no data entry. b) Existing well known database with a standard connector. c) Few canned SQL statements would generate the tables to display d) Dimensions are not small full database is 10K (rows) 200+ columns(attributes)
e) A KEYWORD search is required - per line: Example Goal find a 0602 resistor that is 220 ohms.
I would type "resistor" "film" "0602" and "220" - and click search. This would search the 10K line dump showing the lines that match.
Then I would have a smaller table, or I could add/remove search terms. (sort of like the keywords required for stack overflow questions)
Database contains a item picture (jpeg), and a HTTP link to a datasheet. Making those usable in this table would be fantastic.
Does something like this exist already? It seems it is a dumb common thing.
Nice to have - an exportable (copy/past) link that I can copy and paste into an email ie: I can email the parts guy _ Can I have (3) of these: <LINK_HERE> and they can easily see what it is.
KEY POINT: 99.9% of the time - people will use it read only with 1 report type. so it can be somewhat hard coded...