Custom Protein Expression
Functional Protein, 95% Purity
Fast turnaround (2-3 weeks)
1-10 mg from E. Coli expression
for only $1790
No outsourcing to China or India


in vitro Protein Synthesis
Full-length protein in 1 week
95% Purity, From any gene
(toxic or membrane proteins)
Isotopic Labelling for NMR

50 µg~3 mg, $390 to $2500
Excellgen

MySQL

How to compile PHP with MySQL support (RedHat, CentOS)

Simply two steps to add MySQL support to your PHP

1, yum remove php-common php

2, yum install php php-mysql php-common php-mbstring php-mcrypt php-devel php-xml php-gd 

Comments

How to Integrate Sphinx with MySQL

1, Sphinx can be MySQL’s storage engine

CREATE TABLE t1
(id INTEGER NOT NULL,
weight INTEGER NOT NULL,
query VARCHAR(3072) NOT NULL,
group_id INTEGER,
INDEX(query)
) ENGINE=SPHINX CONNECTION="sphinx://localhost:3312/enwiki";

SELECT * FROM enwiki.searchindex docs
JOIN test.t1 ON (docs.si_page=t1.id) InsertText
WHERE query=”one document;mode=any” limit 1;

2, How to configure Sphinx with MySQL

Sphinx engine/plugin is not full engine:
still need to run “searcher” daemon

Need to compile MySQL source with Sphinx to integrate it
MySQL 5.0: need to patch source code
MySQL 5.1: no need to patch, copy Sphinx plugin to plugin dir

Technorati :

Comments

How to reset MySQL table sequence

ALTER TABLE tbl AUTO_INCREMENT = 100;

Comments

Next Page » Next Page » Next »

Sponsored Links Lab Supply Mall http://www.labsupplymall.com

Protein expression & purification: E. Coli, insect and mammalian cells
Fast turn around, 3 mg of >95% purity functional protein. No outsourcing to China or India. $2500, $1800
Functional Recombinant Proteins by in vitro Protein Synthesis, 3 days, 95% Purity
Full-length, high quality protein, high yield, high throughput, any genes (toxic, low GC content), membrane proteins, isotopic labelling. $598, $398
GeneExpresso DNA Transfection Reagent
Low Cytotoxicity, Higher Transfection Efficiency than Lipofectamine 2000. $188, $138