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
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ganesh GuruduSenior 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
John TsioumprisSoftware & 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
awking00Information Technology SpecialistCommented:
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
RUA Volunteer2?Tableau 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.