I've always wanted to challenge myself to write a program application. Not sure how difficult this would be but that is why you guys are here right? The images attached show a product called SQLGrep by Gatherbird Software. They have closed up shop and are no longer active. I loved this product. It did one thing really well which was search any connectable database for a specific record identifying the table and field where the record was located. Simply plug in integers strings dates any data type you need to find and walk away. A result set could identify the table name and field where this record could be found. The tool was great for the following:
You can find data without any knowledge of the database table layout.
No knowledge of SQL is needed.
Search for text, numbers, and dates like you would search a text document.
Find data that is in unexpected places.
Finds sub strings within a larger fields.
Great way to find bad records or erroneous data.
Helps to reverse engineer table schemas if you do not know how tables connect.
Set and forget continue working while it does the searching.
The link below shows a complete view of what the product does.
The problem is I still need this product but the company is non responsive. Sales of the product actually went towards charitable causes. It was a win win for everyone. So I thought could a product be made and could I do it?
My questions are if you wanted to build something like this that sat on a machine and could be set to run as it did before.
What development tool or tools would you use?
What components would need to make up this software application? I realize this is a robust question.
I assume it would need a connection to the database admin tools of any of the databases it could search. So ODBC admin Oracle PostGres etc.
Then you would need the GUI obviously.
Then a search script that knew what to look for and finally produce a result report that users can understand retrieving the identifying information? Not in that order probably?
Did I leave anything out?
If I need to break this up into multiple questions. I would love a suggestion of how. Thank you very much for your support! Hoping to learn something in the process.
On another Note, I have training access to the "R" language and Python purchased through a service but do not know if they could do this? Also I would be willing to give a copy of this tool to any valid support member who can contribute to the learning.