This is a test version of Biostars. For the public version, visit https://www.biostars.org.
What is the fastest way to create an online server that allows searching through a table

Hi,

I have a a large dataset which has information in columns of the table of a protein name and a gene name. I would like to put it online on a public server in some way that is searchable by the scientific community by protein name and by gene name, and possibly links to other established databases such as UniProt.

I saw that there is the possibility of using mySQL, but before diving into learning mySQL (which I am not sure how long it could take), I am curious about what the community of BiosStars suggest, in case there are faster alternatives.

I code in R normally and I saw the R Shiny, could this be a good alternative to mySQL to build an online seacrhable database? What are the pros/cons from people's experiences?
https://cran.r-project.org/web/packages/shiny/index.html

Thank you for your thoughts, James

database searchable online query
• 1,484 views • link
updated by Zhilong Jia Zhilong Jia • written by jamespower • jamespower

1 answer

using DT, creating a searchable table on the web,

shiny, building for a webserver,

and dplyr, interacting with mysql, will be a quick way.

• 0 views • link
written by Zhilong Jia Zhilong Jia

Log in to answer this question.

More posts like this