Scientist Solutions: Life Science Discussions
 Refer a Friend    Link To Us    Bookmark Us       

      
 » Home » Bioinformatics » Software Developers » Database Poll

Other Topics
11/18/2008 05:28 AM
Most suitable docking too ...
11/18/2008 05:02 AM
Most suitable computer la ...
11/18/2008 01:26 AM
AutoDock
11/17/2008 11:50 PM
Promoter
11/17/2008 02:35 PM
free softwares
11/17/2008 11:06 AM
SAS Programing
9/9/2008 12:51 PM
What is the most common b ...
9/2/2008 08:27 PM
how to find a motif, whic ...
8/24/2008 12:16 PM
How to start? (PDB Viewer ...
8/4/2008 11:04 PM
Transcription Factor moti ...
7/9/2008 07:31 PM
What is your programming ...
11/15/2007 03:40 PM
Sequence Search Solution
9/3/2007 08:27 PM
Bioinformatic Software De ...
3/26/2007 08:47 PM
Scibuntu (ubuntu linux di ...
3/14/2007 03:28 PM
Transcription Factor moti ...
2/14/2007 06:23 AM
Bioinformaticians looking ...
8/9/2006 09:39 PM
extremely fast Smith-wate ...
4/20/2006 02:38 PM
Database Poll, What DBMS ...
4/19/2006 01:19 PM
Inference engine for comp ...
2/22/2006 10:56 PM
about the coupling of GPC ...
12/7/2005 01:37 PM
Software Development
6/21/2005 03:27 PM
Error in using SeqIOTools
6/14/2005 04:13 PM
PERL
1/13/2005 10:32 PM
HT-GO-FAT
Subscribet to topic
Add Reply  Add New Topic  Add New Poll
bottom of page RSS Feed 

Topic Feed

 

Database Poll

 [View Printable]
joaquin939

Tadpole

See
Similar
Scientists





Group: Member
Posts: 44
Joined: Feb 06, 2005







 Send a personal messsage to joaquin939 Reply with a quote from this post Go to the top of the page

POLL: What DBMS is used primarily in your lab? Mysql, Microsoft, Oracle??

.........................

 Posted Nov 22, 2005, 17:24 PM
Sandy

Frog Laureate

See
Similar
Scientists





Group: Member
Posts: 117
Joined: Nov 23, 2004







 Send a personal messsage to Sandy Reply with a quote from this post Go to the top of the page

joaquin939 said:
POLL: What DBMS is used primarily in your lab? Mysql, Microsoft, Oracle??


We are using Oracle in our lab and are very happy with it. We had to hire a team to install this DBMs and after it was done we had to get used to it but we are OK with it right now.

.........................

Posted Dec 01, 2005, 20:17 PM
frasermoss

Frog Laureate

See
Similar
Scientists



View Blogs


Group: Admin
Posts: 693
Joined: Feb 22, 2005







 Send a personal messsage to frasermoss Reply with a quote from this post Go to the top of the page

We are currently using Overworked&underpayed labmanager 3.0, combined with Grapevine 2.5 and HowthehellshouldIknow 9.1.

Sorry I could not resist.....

Serious answer is that our Department uses Filemaker Pro on the whole but is trying to migrate away....but only trying at the moment...

.........................
"Opportunity is missed by most people because it is dressed in overalls and looks like work". Edison

Posted Dec 02, 2005, 4:56 AM
joaquin939

Tadpole

See
Similar
Scientists





Group: Member
Posts: 44
Joined: Feb 06, 2005







 Send a personal messsage to joaquin939 Reply with a quote from this post Go to the top of the page

I'm not familiar with Filemaker Pro

.........................

Posted Dec 05, 2005, 17:17 PM
samm

Frog Laureate

See
Similar
Scientists



View Blogs


Group: Moderators
Posts: 409
Joined: Mar 03, 2005







 Send a personal messsage to samm Reply with a quote from this post Go to the top of the page

Filemaker Pro runs on the Mac OSX platform as far as I know. We are currently using FmP 7 on OS X.3.9
Frasermoss, what are you guys migrating to?

Dist with FmP is somewhat complicated, so we do fall back to Grapevine 2.5 and HowthehellshouldIknow 9.1 sometimes (esp since Overworked&underpayed labmanager 2.0 has quit on us)!

.........................

Posted Dec 05, 2005, 18:48 PM
joaquin939

Tadpole

See
Similar
Scientists





Group: Member
Posts: 44
Joined: Feb 06, 2005







 Send a personal messsage to joaquin939 Reply with a quote from this post Go to the top of the page

Ok, we use MySQL, mainly b/c its free. It provides all the functionality we need, especially now with 5.0.

.........................

Posted Dec 08, 2005, 22:20 PM
rgood

Frog Egg

See
Similar
Scientists





Group: Member
Posts: 1
Joined: Apr 25, 2006







 Send a personal messsage to rgood Reply with a quote from this post Go to the top of the page

samm said:
Filemaker Pro runs on the Mac OSX platform as far as I know. We are currently using FmP 7 on OS X.3.9
Frasermoss, what are you guys migrating to?

Dist with FmP is somewhat complicated, so we do fall back to Grapevine 2.5 and HowthehellshouldIknow 9.1 sometimes (esp since Overworked&underpayed labmanager 2.0 has quit on us)!


FMPro runs well on both Windows and mac platforms. The data structures and data files are easily moved between OSs. For inexperienced database users FMPro provides good tools for interface development.

FMPros main advantage and disadvantage is it is designed as a one stop solution. It provides a developemnt environment as well as a back end database all in one product. IMHO it makes it great for small to medium size developments and prototyping but less than ideal for really large datasets that need the full power of a relational or oo database.

.........................

Posted Apr 25, 2006, 14:33 PM
mcono

Frog Egg

See
Similar
Scientists





Group: Member
Posts: 2
Joined: Apr 25, 2006







 Send a personal messsage to mcono Reply with a quote from this post Go to the top of the page

joaquin939 said:
Ok, we use MySQL, mainly b/c its free. It provides all the functionality we need, especially now with 5.0.

Yeah verily-I would just add that the main reasons are it is free, it scales from small office use to really big(see all genomes at (ENSEMBL) applications, it has all functions of Oracle, and it is available for MAC, PC and linux and has a number of excellent GUIs (some free) and with apache, perl and or php makes for an easy to setup and manage web interface!

.........................

Posted Apr 25, 2006, 15:54 PM
mcono

Frog Egg

See
Similar
Scientists





Group: Member
Posts: 2
Joined: Apr 25, 2006







 Send a personal messsage to mcono Reply with a quote from this post Go to the top of the page

joaquin939 said:
POLL: What DBMS is used primarily in your lab? Mysql, Microsoft, Oracle??

MySql, I would just add that the main reasons are it is free, it scales from small office use to really big(see all genomes at (ENSEMBL) applications, it has all functions of Oracle, and it is available for MAC, PC and linux and has a number of excellent GUIs (some free) and with apache, perl and or php makes for an easy to setup and manage web interface!

.........................

Posted Apr 25, 2006, 15:56 PM
bgood

Frog Laureate

See
Similar
Scientists





Group: Moderators
Posts: 151
Joined: Apr 12, 2006







 Go to homepage of bgood Send a personal messsage to bgood Reply with a quote from this post Go to the top of the page

I'm a big advocate of MySQL as well. Its caused me the least amount of headaches and has the blessing of truly extensive documentation.

But.. I'm pretty sure that it does not actually have ~all of the functionality of full-fledged Oracle. It doesn't implement stored procedures for example.

If you have heaps of money to buy it and pay for a fulltime Oracle certified DBA then I doubt you could really get better performance. This of course does not describe many in the bioinformatics domain, but some may be lurking out there somewhere..

.........................

Posted Apr 25, 2006, 23:33 PM
djcruikshank

Frog Egg

See
Similar
Scientists





Group: Member
Posts: 4
Joined: Aug 15, 2006







 Go to homepage of djcruikshank Send a personal messsage to djcruikshank Reply with a quote from this post Go to the top of the page

MySQL is OK for light weight database usage, but if you are planning serious database applications you will want either Oracle or MS SQL Server in order to have the tools and optimization capabilites.

.........................

Posted Sep 03, 2007, 20:20 PM
top of page Add Reply  Add New Topic  Add New Poll

Forum Jump