搭建生物信息数据库 | Tomcat + MySQL | Django

生物信息数据库

搜遍全网都找不到一个开发生物信息数据库的教程。

其实有些数据库的工作量并不大,只是把线下的一些分析结果上传到服务器上,供用户搜索而已。 

网站上可视化的对象只有两个:表格和图片。

一些稍微复杂的结果就是network,这个有现成的插件可以实现,比较简单。

开发流程

找一个类似的、自己觉得还行的数据库网站,从模仿开始。

学会用Chrome看网页源码,了解其大致设计理念,实现方法。

安装Tomcat

MAC下安装配置Tomcat(小白向)

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

mac环境下安装mysql

mysql基本操作命令汇总--笔记

加路径:export PATH=/usr/local/mysql/bin:$PATH

JQuery安装

JavaScript教程 

可视化

Datatables

HighCharts

d3

in-house R scripts

证书

CC Licenses 

开发工具

eclipse

重要考虑

网站流量的管理,不要被用户的操作搞崩了。

webserver必须要考虑算法的速度,服务器性能,排队系统。 

一定要构建出网站的本地版,迎合大数据客户的需求。

Django

Django 文档

Django 教程

安装比较简单,pip install django

解决远程访问问题,Django运行访问项目出现的问题:DisallowedHost,修改 setting.py 文件,ALLOWED_HOSTS = ['*']

awesome-django

awesome-django-cn

`python manage.py runserver` 

GitHub协作开发环境

GitHub真的不只是一个code cloud而已,它是超级强大的团队协作和版本管理的平台。

GitHub怎么合作代码最安全?

如何使用 GitHub? - 基本操作

团队协作中的 Github flow 工作流程 - 团队协作

COPY一个网站

搜索:如何快速copy一个网站的html和css

论如何优雅的复制一个网站的所有页面 - SiteCopy

如何扒一个网站完整的HTML+CSS源码,让所有网站都成为你的模板库

如何快速克隆一个网站

基本的html、css、JS技能

HTML 教程

参考

示例: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.

示例:FerrDb: a manually curated resource for regulators and markers of ferroptosis and ferroptosis-disease associations

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/

练手教程

如何用初级的JavaWeb知识写一个较简单的网站(一)

如何用初级的JavaWeb知识写一个较简单的网站(二)

如何用初级的JavaWeb知识写一个较简单的网站(三)

原文地址:https://www.cnblogs.com/leezx/p/13685194.html