I want to develop a simple program I can use to search records in databases

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.

file:///C:/Program%20Files%20(x86)/GatherBird/SQLGrep19/HelpFiles/GatherBird_SQLGrep.html#WhyyouneedSQLGrep

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.
SQLGrep1.jpg
SQLGrep2.jpg
SQLGrep3.jpg
SQLGrep4.jpg
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
 
John TsioumprisConnect With a Mentor Software & Systems EngineerCommented:
Well i don't know if you are willing to take an extra step and dive into Microsoft Access...just grab a good book and start developing...R & Python are both good languages but the learning curve for creating something is far greater than Access and as for the GUI everything is builtin and ready for immediate use.
0
 
Ganesh GuruduConnect With a Mentor Senior ConsultantCommented:
To Develop any Application/Software/product. you should consider below things .
  • You should have Creative/Logical mind thinking :)
  • Need to select programming language which you know or familiar with. it seems you already know the Python language. so you can make Web Application of this.
  • Choose what Database you want.(There are many Free Database in the internet)
  • considering web based application, you need web server to host this application. if its Windows not required.
  • You should have programming knowledge on selected language for both front-end and back-end.
  • Hosting and Domain depends on the requirement. if its internal application not required.

it seems this is enough to make or build any application.(Architecture and designing application and database is default considerable)
0
 
awking00Connect With a Mentor Commented:
First of all, what you want to develop is not a "simple" program. I would likely look to Java for such a project as it can create GUIs, connect to most database management systems, and utilize its Lucene search engine. However, even expert Java developers would probably take several months to complete such a task. You may be more successful in developing a query mechanism for each of the databases that you might encounter utilizing their individual packages, procedures, methods, and metadata capabilities. I wish you good luck with your project.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Thank you very much. I will look into Java as well and see what I can do with that. Access may be the quickest solution which I may go ahead and do then work towards the R or Python solution with a Java front end. I think that is possible. I appreciate you all very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.