Re: [apollo] numeric number / id in url

[Helena Rasche]

Heya,

Yeah it's just the organism ID in the database, 

"select id from organism where public_mode is true" will find you some IDs that should work.

it's generated via the Hibernate adapter (which has a very weird ID generation algorithm, it's monotonically increasing but not sequential, there's gaps that I never understood why but apparently they do it to decrease database roundtrips, though if they'd just use the database correctly it wouldn't lead to more roundtrips but I guess "INSERT ... RETURNING ..." might not have existed when hibernate started.)

ciao,
Helena

On 3/12/24 03:45, Michael Thang wrote:

I want to know where can I retrieve the numeric number in the url below. Can I obtain it in the apollo database? how did it get generated for each organism on apollo. 

https://example.com/apollo/289915/jbrowse/index.html

Thanks,

--
To unsubscribe from this group and stop receiving emails from it, send an email to apollo+un...@lbl.gov.

[Nathan Dunn]

The SQL Query ID is a snowflake ID I believe - which is used to make pseudo-unique identifiers.   

To set analytics you can update google analytics ID to your own in the config: https://github.com/GMOD/Apollo/blob/5985ab8d98cc3b98625101f649c9f300efb5b555/grails-app/conf/Config.groovy#L393 - which should also have a docker option as well. 

You should be able to have more than one, as well as the original one is helpful for grants. 

Nathan

On Fri, Mar 15, 2024 at 8:28 AM Michael Thang <m.t...@qfab.org> wrote:

Hey Helena,

Thank you for the answer and SQL query ! Indeed, the ID generation is not sequential and the gap between each ID confused me. That's why I need to ask the question here. There is other question I related to the DB. Do you (or anyone in this fourm), by any chance, know how to retrieve the traffic statistic of accessing the jbrowse? I would like to find out how often our jbrowse that people visited.

Cheers,

Mike 

[Michael Thang]

Great! I also found the config.groovy and realized that the google analytic setting can be inserted into that file.

Mike