What is the fastest way to create an online server that allows searching through a table
1
1
Entering edit mode
5 weeks ago
jamespower ▴ 60

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 • 281 views
ADD COMMENT
2
Entering edit mode
5 weeks ago
Zhilong Jia ★ 1.9k

using DT, creating a searchable table on the web,

shiny, building for a webserver,

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

ADD COMMENT

Login before adding your answer.

Traffic: 1688 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6