Re: [Artemis-users] database entry connection failed (mysql problem)
Hi Andrew Yes, Artemis will be supporting chado. It will not be limited to postgres but will be using a chado schema. There are currently no plans to support a Bio::DB::GFF database. Regards Tim On 1/12/06 21:50, Andrew Stewart [EMAIL PROTECTED] wrote: I open Artemis Release 8, then proceed to File Database Entry, with the following values... Server: somehost Port: 3306 (for mysql) Database: test1 (the name of my mysql database) User: myuser Pass: mypass And get an SQL error that simply reports SQL Problems When returning to the Database Entry window within the same session, I notice that there are now a new set of values in place for each of the fields... Server : jdbc Port: postgresql: Database: /somehost:3306/test1 User: user=myuser Password: (blank) This has me scratching my head. Is postgresql the only supported rdb? Is chado the only support schema? Are there any plans to support mysql with a Bio::DB::GFF database? Thanks, Andrew -- Andrew Stewart Research Assistant, Genomics Team Navy Medical Research Center (NMRC) Biological Defense Research Directorate (BDRD) BDRD Annex 12300 Washington Avenue, 2nd Floor Rockville, MD 20852 email: [EMAIL PROTECTED] phone: 301-231-6700 Ext 270 ___ Artemis-users mailing list Artemis-users@sanger.ac.uk http://lists.sanger.ac.uk/mailman/listinfo/artemis-users ___ Artemis-users mailing list Artemis-users@sanger.ac.uk http://lists.sanger.ac.uk/mailman/listinfo/artemis-users
Re: [Artemis-users] database
Hi Brad Just to let you know that we are currently developing Artemis to be able to talk to a database (CHADO). Currently we have it reading from an internal test database. This is not available yet but will start to become part of the next few Artemis releases as it gets implemented. Regards Tim On 26/1/06 14:50, biarshin [EMAIL PROTECTED] wrote: I would like to set up a database for a small community studying a model organism. We would we like to have a small database running on our server that the community could access using Artemis. Users would use Artemis for doing gene annotations and browsing the genome. Ideally the users would have the option of either connecting to the online database or using a cached copy of the database residing on their local computer (which could be in flat file format since it would be a single user environment). My question is has anybody set up such as system using Artemis, and where might I get information on how to set it up. Specifically is there information available on how to set up a a centralized database for our genomic information that the users could browse with Artemis? Thanks, Brad ___ Artemis-users mailing list Artemis-users@sanger.ac.uk http://lists.sanger.ac.uk/mailman/listinfo/artemis-users ___ Artemis-users mailing list Artemis-users@sanger.ac.uk http://lists.sanger.ac.uk/mailman/listinfo/artemis-users