d2jsp
Log InRegister
d2jsp Forums > Off-Topic > Computers & IT > Programming & Development > Searchable Database > Looking For Some Ideas
Add Reply New Topic New Poll
Member
Posts: 10,957
Joined: Jul 9 2006
Gold: 2,065.00
Jul 15 2019 07:51am
Hello all.

not sure what the best program would be to start this "searchable" data base.

Basically my idea is have a cover page that anyone can view. (i want to be able to do it on my computer first, then upload to a web server when the time is right)

on the cover page have searchable features. Example, Part number or Asset number. Where anyone that goes on the page can pull up the part based on either search.

on the back end, i want to be able to set what data i want input. as far as Part number, Description, ext ext.

any advise/help would be great.


thanks


adam
Member
Posts: 12,703
Joined: May 17 2013
Gold: 12,935.00
Jul 15 2019 08:42am
So what you want is a database..? Postgresql/mysql etc.
Member
Posts: 10,957
Joined: Jul 9 2006
Gold: 2,065.00
Jul 15 2019 08:43am
Quote (Klexmoo @ 15 Jul 2019 10:42)
So what you want is a database..? Postgresql/mysql etc.


Yes, but i need it to have a "cover" page where someone can type in either the part number or asset number to a part. and have it populate the data. (bring up a second page with all the information) and even have it searchable with description.

i was thinking of Microsoft access but im not sure its going to be the best to do this.
Member
Posts: 12,703
Joined: May 17 2013
Gold: 12,935.00
Jul 15 2019 08:46am
Well that can be done fairly easily, but requires programming knowledge. I don't know of any pre-existing tools that do this for you.
Member
Posts: 10,957
Joined: Jul 9 2006
Gold: 2,065.00
Jul 15 2019 08:49am
Quote (Klexmoo @ 15 Jul 2019 10:46)
Well that can be done fairly easily, but requires programming knowledge. I don't know of any pre-existing tools that do this for you.


dang, well thanks for trying lol! ill keep this up incase someone knows of anything. Im using Excel right now, and it pretty much does everything, its just not as user friendly for some people.
Member
Posts: 6,988
Joined: Apr 16 2019
Gold: 50.00
Jul 21 2019 10:51am
Just get you a Web Server that has PHP/MySQL enabled and you'll be set. I can help you with the setup if you do choose to do that.

Member
Posts: 1,039
Joined: Jul 8 2008
Gold: 1,939.50
Jul 23 2019 06:05pm
Database + UI seems like the right way to go.
If you don't want a database you could save csv or json files and use those to store your data. Then you just need a html/css/javascript front end which queries the files. This approach will only work if you're the only person updating/writing the data (other users would need to update the files and could easily corrupt it). It also won't scale well.
Member
Posts: 17,591
Joined: Sep 27 2012
Gold: 3,260.00
Jul 30 2019 06:57am
Can do this for you. Pm me
Go Back To Programming & Development Topic List
Add Reply New Topic New Poll