297 reputation
29
bio website
location
age
visits member for 3 years, 3 months
seen Sep 7 '12 at 13:55

Aug
29
awarded  Notable Question
Mar
14
awarded  Popular Question
Sep
25
awarded  Popular Question
Jun
7
awarded  Popular Question
Jan
3
awarded  Yearling
Aug
1
comment Biological Sequences of UniProt in PostgreSQL
@jcolebrand, this is related to Blast. We have an export function that writes out the sequences to a FASTA format and that is a valid input to Blast. Then Blast can do high-throughput similarity searches against the sequences or against a larger database (but only Uniprot can be larger then Uniport). We also construct HMM from sets of sequences and use HMMER2 to search for similarity.
Jun
5
awarded  Nice Question
Jun
4
accepted What are the consequences of setting varchar(8000)?
Jun
4
revised What are the consequences of setting varchar(8000)?
added 120 characters in body
Jun
4
revised What are the consequences of setting varchar(8000)?
added 18 characters in body; edited tags
Jun
4
asked What are the consequences of setting varchar(8000)?
Apr
29
awarded  Quorum
Feb
28
comment How to version control PostgreSQL schema with comments?
Truly helpful, but I don't want to mark this as Answer just yet because I'm hoping to get a best practices answer.
Feb
27
revised How to version control PostgreSQL schema with comments?
added 8 characters in body
Feb
27
revised How to version control PostgreSQL schema with comments?
added 40 characters in body; deleted 9 characters in body
Feb
27
asked How to version control PostgreSQL schema with comments?
Jan
14
revised Can't rename columns in PostgreSQL views with CREATE OR REPLACE
edited title; added 18 characters in body
Jan
14
accepted Can't rename columns in PostgreSQL views with CREATE OR REPLACE
Jan
13
revised Can't rename columns in PostgreSQL views with CREATE OR REPLACE
edited title
Jan
13
comment Can't rename columns in PostgreSQL views with CREATE OR REPLACE
Yep, the error was only in "create or replace". Drop works. Thank you.