生物信息数据库
搜遍全网都找不到一个开发生物信息数据库的教程。
其实有些数据库的工作量并不大,只是把线下的一些分析结果上传到服务器上,供用户搜索而已。
网站上可视化的对象只有两个:表格和图片。
一些稍微复杂的结果就是network,这个有现成的插件可以实现,比较简单。
开发流程
找一个类似的、自己觉得还行的数据库网站,从模仿开始。
学会用Chrome看网页源码,了解其大致设计理念,实现方法。
安装Tomcat
https://tomcat.apache.org/download-90.cgi
报错:
$ sudo sh ./startup.sh Unable to find any JVMs matching version "(null)". No Java runtime present, try --request to install. Neither the JAVA_HOME nor the JRE_HOME environment variable is defined At least one of these environment variable is needed to run this program
MacOS X does not come with Java Development Kits (JDKs) pre-installed. Run java -version in the terminal and you may be prompted to install Java.
Unless you already have JVM installed, in which case you will see the build version number.
安装java,`java -version`
运行Tomcat
sudo sh ./startup.sh ##### sh ./shutdown.sh
此时应该可以正常打开http://localhost:8080/
安装MySQL
加路径:export PATH=/usr/local/mysql/bin:$PATH
JQuery安装
可视化
Datatables
HighCharts
d3
in-house R scripts
证书
CC Licenses
开发工具
eclipse
重要考虑
网站流量的管理,不要被用户的操作搞崩了。
webserver必须要考虑算法的速度,服务器性能,排队系统。
一定要构建出网站的本地版,迎合大数据客户的需求。
Django
安装比较简单,pip install django
解决远程访问问题,Django运行访问项目出现的问题:DisallowedHost,修改 setting.py 文件,ALLOWED_HOSTS = ['*']
`python manage.py runserver`
GitHub协作开发环境
GitHub真的不只是一个code cloud而已,它是超级强大的团队协作和版本管理的平台。
GitHub怎么合作代码最安全?
如何使用 GitHub? - 基本操作
团队协作中的 Github flow 工作流程 - 团队协作
COPY一个网站
搜索:如何快速copy一个网站的html和css
如何扒一个网站完整的HTML+CSS源码,让所有网站都成为你的模板库
基本的html、css、JS技能
参考
示例:CancerSEA: a cancer single-cell state atlas
CancerSEA is freely available to the research community at http://biocc.hrbmu.edu.cn/CancerSEA or http://202.97.205.69/CancerSEA and requires no registration or login. CancerSEA is deployed using tomcat (version 7.0.47) and tested in Mozilla Firefox, Google Chrome, and Apple Safari browsers. All the data are stored and queried by MySQL (version 5.6.40). Tables are visualized by Datatables (version 1.10.16). Graph charts are generated by HighCharts (version 6.1.0), d3 (version 5.4.0) and in-house R scripts.
Development of FerrDb
FerrDb was developed with HTML, CSS and JavaScript. JavaScript libraries jQuery (https://jquery.com/) and jQuery UI (https://jqueryui.com/) were used to enhance interactive features of the website. DataTables (https://datatables.net/) was used to display the data in tables. Cytoscape.js was used to visualize regulation networks on the web page (11). Annotation data sets were stored in JSON files, which were used as the core database to drive FerrDb. To keep gene symbols in FerrDb consistent with those in the HGNC database (https://www.genenames.org/), HGNC’s REST API (application programming interface) was used to verify genes in FerrDb. The FerrDb website was hosted by an Apache (http://www.apache.org/) web server that was deployed as an Amazon AWS EC2 instance (https://aws.amazon.com/) running Ubuntu 16.04 LTS (https://ubuntu.com/).
示例:A machine-compiled database of genome-wide association studies
http://mulinlab.org/vsampler/index.html
http://biocc.hrbmu.edu.cn/CancerSEA/home.jsp
http://www.zhounan.org/ferrdb/
http://gwaskb.stanford.edu/