Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Aug 01 17:01
    garrettjstevens closed #118
  • Aug 01 17:00
    garrettjstevens closed #117
  • Aug 01 17:00
    garrettjstevens closed #124
  • Jul 28 03:57

    garrettjstevens on Issue124_UIContextMenuToCopyFeature

    (compare)

  • Jul 28 03:57
    garrettjstevens closed #126
  • Jul 28 03:57

    garrettjstevens on main

    Add context menu item to copy f… (compare)

  • Jul 28 03:57
    garrettjstevens edited #126
  • Jul 28 03:52
    garrettjstevens synchronize #126
  • Jul 28 03:52

    garrettjstevens on Issue124_UIContextMenuToCopyFeature

    Updates (compare)

  • Jul 28 03:49
    garrettjstevens ready_for_review #126
  • Jul 28 03:48
    garrettjstevens synchronize #126
  • Jul 28 03:48

    garrettjstevens on Issue124_UIContextMenuToCopyFeature

    ready for test even paramaters … passing parameters to dialog Add close button to ApolloDetai… and 2 more (compare)

  • Jul 28 03:38

    garrettjstevens on Issue118_CopyFeaturesAndAnnotations

    (compare)

  • Jul 28 03:38

    garrettjstevens on main

    Add change to copy feature with… (compare)

  • Jul 28 03:38
    garrettjstevens closed #119
  • Jul 28 03:38
    garrettjstevens edited #119
  • Jul 28 03:34
    garrettjstevens ready_for_review #119
  • Jul 28 03:34
    garrettjstevens synchronize #119
  • Jul 28 03:34

    garrettjstevens on Issue118_CopyFeaturesAndAnnotations

    tmp commit tmp commit tmp and 6 more (compare)

  • Jul 26 21:38

    garrettjstevens on Issue117_View_ChangeLog

    (compare)

Helena
@hexylena:matrix.org
[m]
I can't remember if we posted it or not, but for other large Apollo users, we built this to work around slow loading of large large organism lists. For hundreds of organisms it can take load times from 10 minutes to 30 seconds. https://github.com/galaxy-genome-annotation/apolpi/
Curtis Ross
@cross12tamu
^ can confirm :)
Nathan Dunn
@nathandunn
yikes @hexylena:matrix.org . Looks like the current method collects organisms correctly but then instead of doing a join in a single query to get counts (as you do) it performs a separate query. Wish I had time to fix.
2 replies
Helena
@hexylena:matrix.org
[m]
There aren't that many routes with this issue that a shim works fine
Scott Cain
@scottcain
I’m going to create an Apollo instance for AGR that has the NIH origanisms in it (human, rat, mouse, zebrafish, worm, fly and yeast) in it, and (presumably) back it with Chado as a demonstration with the idea of promoting it as the tool to be used by sequence curators at the respective MODs to use. Can I just fire up docker-compose with Apollo and Chado and I’m off to the races?
(actually, the only organisms in it might be yeast, worm and fly, at least to start)
Garrett Stevens
@garrettjstevens
No, the Dockerfile for Apollo runs PostgreSQL. You'd probably want to set up your own Dockerfile using that one as a reference but changing the database stuff.
Scott Cain
@scottcain
I like postgresql :-)
Garrett Stevens
@garrettjstevens
If you want to use the postgresql db it sets up that's fine, I was just thinking your DB would be in your Chado docker image instead. TBH I don't really know how to integrate Apollo and Chado, but looking at the docs you might still need the buildt-in postgresql since Chado is just for exporting: https://genomearchitect.readthedocs.io/en/latest/ChadoExport.html
Nathan Dunn
@nathandunn
FYI @scottcain @hexylena:matrix.org had one setup long ago that used a compose file if that helps. However like @garrettjstevens said Chado should be baked in already. Looks like its using 1.31 here: https://github.com/GMOD/Apollo/blob/develop/Dockerfile#L37 . . if you just fix this line you can get one here, but converting these to use docker compose shouldn't be that hard either.
Scott Cain
@scottcain
Cool; at the moment I’m at the stage of “I feel like I should probably look into doing this” so we’ll see how things progress from here.
childers
@childers
I've been trying to move the log4j issues in apollo2.x forward with really limited success. Right now I'm trying to use the bridge files to get Apollo2 to the current log4j version without having to recode anything but it isn't working. It's building, and the deploy says it works, but the deployed WAR isn't recognized.
https://logging.apache.org/log4j/2.x/log4j-1.2-api/index.html
Nathan Dunn
@nathandunn
@childers I don't think that you want to use log4j2 with Apollo2. The log4j1 shouldn't have the critical vulnerabilities so it shouldn't be a problem.
Also, moving it would be difficult if not impossible since a lot of the other underlying dependencies use log4j1 . .
childers
@childers
@nathandunn Log4j1 has been EOL since 2015, and while it doesn't have any critical security issues, The one issue it has will not be fixed. Colin introduced me to grype, an awesome tool for finding vulnerabilities in a project. Apollo has 16 Critical and 75 High rated vulnerabilities. I'm just trying to get ahead of any possible IT security issues.
I forgot to say that I've been requested to make sure all log4j instances are up to date, hence me trying to sort out the bridging 1-> files
Nathan Dunn
@nathandunn
@childers oh for sure. I think Grails 2 (what Apollo 2 is built on) has been EOL'd https://objectcomputing.com/products/grails/grails-version-support-schedule . here is a relevant question here: https://stackoverflow.com/questions/70426705/upgrade-log4j-to-last-version
I guess what I am thinking are: (1) fixing log4j1 may not have a vulnerability and (2) it may not be possible to remove it from Grails 2 / Apollo 2 (3) hopefully most of the other critical issues are either fixable or not applicable, but its hard to say (4) it may make more sense to work with @garrettjstevens / @rbuels on pushing forward the next version of Apollo (1-2 years?).
childers
@childers
@nathandunn I didn't realize that it was grails that pinned the log4j version.
and also thanks for this response, I think I can maybe justify the log4j1 if there are no vulnerabilities. I'll focus on some of the other issues.
Scott Cain
@scottcain
@garrettjstevens do you expect that new development in Apollo will allow Chado as a persistant store for annotations?
Robert Buels
@rbuels
@scottcain no that's not in the plans right now
Ian Holmes
@ihh
@scottcain is that something that would be useful to AGR?
Nathan Dunn
@nathandunn
@scottcain , this is your chance to have Chado be THE persistant store for annotations
Scott Cain
@scottcain
@ihh That’s kind of an open question at the moment (usefulness to AGR); there has been some discussion that having a persistent store for sequence and structural annotations with some sort of API sitting on top of it would be nice, and it occurred to me that the combo of Chado and Tripal would give that (I think Tripal provides a swagger-like api for chado, I have to make sure of that). But if whatever Apollo chooses as a persistent store provided an API, that might be good too.
BUT—I will say that there are lots of small MODs that use Chado and some that use Apollo, so making sure that data can easily move between them is pretty important.
Also @nathandunn yes, of course :-)
Nathan Dunn
@nathandunn
If you embeded a module API within Tripal to talk to Apollo you would have a lot of happy people within the GMOD community. Those modules are pretty flexible in terms of what you can add (elasticsearch, etc). Of course, you will be entering a world of PHP potentially.
Scott Cain
@scottcain
Well, crap, I had two meetings today at 8:00 and missed them both. Notifications must be messed up on my phone. Hopefully the Apollo call went well.
Robert Buels
@rbuels
Running a little late for the team meeting, I’ll be there in a sec though
Nathan Dunn
@nathandunn
passing this along from @hexylena:matrix.org (who else) as its several cool things at once, though not sure if it is better here or in the JBrowse group: https://github.com/hexylena/jbrowse-chado-postgraphql + https://github.com/hexylena/chado-postgraphql + https://github.com/hexylena/jbrowse-chado-postgraphql/blob/c8b1296277611a5c804329e5f60c8dbae2e0f774/js/Store/SeqFeature/GraphQL.js#L115 . . .. not sure if of interest (or just interesting) to @scottcain / @rbuels / @garrettjstevens
Scott Cain
@scottcain
Certainly both interesting and of interest to me. She does great stuff!
Helena
@hexylena:matrix.org
[m]
Aw, cheers Scott!
It's a bit of a hack, but postgraphql was pretty neat and I wanted to try graphql at the time
I'm not sure I'm convinced by it in the end but, it's definitely potentially interesting.
Scott Cain
@scottcain
I know that there was discussion about Chado and graph databases a few years ago, so there are probably other people in the Chado community that might find this interesting.
Helena
@hexylena:matrix.org
[m]

Yeah, definitely. If the choice is between switching to a graph DB, and postgres+this, I'd love to see how far we can get with hacks like this before swapping out the DB

Postgres scales so much better, there are orders of magnitude more folks who understand postgres scaling, and I don't need to buy an expensive license for neo4j if it turns out I need to shard or scale.

Nathan Dunn
@nathandunn
I think that @rbuels and company are heading a different direction, but not sure. The JSON column support with postgresql might also be a great way to go, or simply a different approach to the UI.
Helena
@hexylena:matrix.org
[m]
I guess we'll see! I'd love to see json in postgres more, it's such a happy medium ground.
Scott Cain
@scottcain
There a definitely people in the Tripal community using the jsonb data type (in particular, I think Lacey uses it for breeding data)