Why are you hosting compiled binaries on GitHub and no source code...
[deleted]
Scrumdog – a program to download Jira Issues to a local database
41–50 of 63 posts
Re: Scrumdog – a program to download Jira Issues to a local database
#42Earlier quoted context omitted.
Are you referring to the April outage? Technically 14 days is multi day, but when it can be measured in weeks, you might as well.
> Technically 14 days is multi day, but when it can be measured in weeks, you might as well. What does that mean? Two days is multi day. Even 25 hours is multi day.
I believe they’re saying that we might as well say “multi-week” rather than “multi-day”, given that it was 14 days!
Multi day seems to imply a time period of 2-5 days, not 14…
Re: Scrumdog – a program to download Jira Issues to a local database
#43Readers may also enjoy Steampipe[1], an open source [2] tool that uses Postgres FDW's for live SQL queries against Jira, Confluence, GitHub, GitLab, AWS, Slack and many more tools [3]. 1 - https://steampipe.io 2 - https://github.com/turbot/steampipe 3 - https://hub.steampipe.io
There is also git-bug [1], an offline bug tracker fully embedded in git which can bridge to Github, Gitlab, Jira
Re: Scrumdog – a program to download Jira Issues to a local database
#44Earlier quoted context omitted.
There were zero issues with performance/reliability that caused the outage, they just deleted hundreds of customers data, and had to manually restore the data due to lack of automated restore scripts.
Reliability is measured from a customer's perspective, not from a geeky vendor-oriented perspective of a backend service. When the vendor deletes data, the vendor's reliability quotient decreases, because that data is no longer available to the customer.
Once again we learn the hardware that accessibility is not the same thing as reliability.
Re: Scrumdog – a program to download Jira Issues to a local database
#45Just to get ideas, what custom reports are users looking for that can not be built by Jira.
I've been wanting to suck in Jira tickets to my own database so that I can full-text index them along with code, docs, customer requests, Slack, etc. Then when you're looking for information, you only have to go to one place.
(My ulterior motive is to write a blog post that's like "how I used the product I make at work to index all information at the company". I can usually just do a linear scan across the backlog to find the issue I want, but hey, when marketing and software combine, I can't complain.)
If there's some service I can buy that does this, though, I'd rather use that.
Re: Scrumdog – a program to download Jira Issues to a local database
#46Readers may also enjoy Steampipe[1], an open source [2] tool that uses Postgres FDW's for live SQL queries against Jira, Confluence, GitHub, GitLab, AWS, Slack and many more tools [3]. 1 - https://steampipe.io 2 - https://github.com/turbot/steampipe 3 - https://hub.steampipe.io
Steampipe sounds interesting (and will be looking into scrumdog too).
Is Steampipe a community + services model, or just open source + community?
Re: Scrumdog – a program to download Jira Issues to a local database
#47Just to get ideas, what custom reports are users looking for that can not be built by Jira.
In my case, I find it hard to query related issues of different types. It's kind of hard to explain unless you see how we use Jira, but I basically want to do joins. You can do some interesting things with the Structure plugin, or issueFunction() from the Adaptavist ScriptRunner plugin. The other thing I've done is to pull a few REST queries into a single-page app., but that takes more work.
Re: Scrumdog – a program to download Jira Issues to a local database
#48I built a very similar tool for my company to download a set of DataDog logs into SQLite. Products like Jira and DataDog have their own query engines for sure, but you really can't beat the capabilities of true SQL for deeper analysis.
link?
Wish I could! It's locked away in a private company repo.
Re: Scrumdog – a program to download Jira Issues to a local database
#49Jira's querying and reporting facilities leave a lot to be desired. I have some scripts to pull the data down into a sqlite database so I can query it much better.
Re: Scrumdog – a program to download Jira Issues to a local database
#50Missed naming opportunity: should have been “scrumbag”.
if he sold it for high enough, could be a Scrumdog millionaire