Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Scrumdog – a program to download Jira Issues to a local database

whoek.com

Post reply on HN
Print view View original

51–60 of 63 posts

Re: Scrumdog – a program to download Jira Issues to a local database

#51

Post by nathanwallace »

tomrod wrote: post #46
nathanwallace wrote: post #34

Readers 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?

The Steampipe open source project and community are managed by Turbot [1]. We also have Steampipe Cloud [2] in preview if you'd prefer a hosted version focused on teams.

1 - https://turbot.com 2 - https://cloud.steampipe.io

Re: Scrumdog – a program to download Jira Issues to a local database

#52

Post by Jedd »

If you're forced to use Jira, and setting up a local replica database is surplus to your interest / requirements, I can recommend the Jira Assistant chrome extension.

The licence is a bit wonky (source-available, basically) but the feature set fills a few gaps with the regrettable stock UI.

https://jiraassistant.com/ or https://chrome.google.com/webstore/detail/jira-assistant-wor...

Re: Scrumdog – a program to download Jira Issues to a local database

#53

Post by emmelaich »

tgv wrote: post #22
zerop wrote: post #13

Atlassian may want to provide SQL interface to Jira data. JQL is limited in many ways.

There's an sql database backing Jira, but it looks rather ugly. I guess that's why they translate it.

I think it's more about access control. They don't do any access control at the db level afaik.

Re: Scrumdog – a program to download Jira Issues to a local database

#55

Post by earleybird »

pix64 wrote: post #54

Is possible to create single file applications in C# https://docs.microsoft.com/en-us/dotnet/core/deploying/singl...

While it is possible, it is certainly less than stellar compared to the other languages that were reviewed. Granted my experience was 1 - 2 yrs ago with .Net Core 5. I recall having to deal with setting different temp directories each time I wanted to run a another instance of a 'single binary' because the first thing it did was unzip the bundled runtime into the system wide TEMP directory. It certainly was a single file app but behaved more like an installer.

Whoever came up with that obviously didn't understand the why of single .exe applications.

Re: Scrumdog – a program to download Jira Issues to a local database

#56

Post by ako »

crestfallen wrote: post #25
nonameiguess wrote: post #15

My manager a few jobs back did something like this, but just using Microsoft Excel with Power Query. No need to even install sqlite. Normally, that probably isn't much of an obstacle, but this was in a classified environment where it was nearly impossible to get the local IT admins to install additional software on your workstation. Every corporate Microsoft box is going to already have the Office suite.

I'm curious about this. I would say I'm fairly versed in Excel but haven't dug too deep into Power Query / the data model. If you wouldn't mind, how is this done?

Looks like it's documented on the atlassian website: https://community.atlassian.com/t5/Jira-Core-Server-question...

Re: Scrumdog – a program to download Jira Issues to a local database

#58

Post by sokoloff »

bokchoi wrote: post #19
zerop wrote: post #13

Atlassian may want to provide SQL interface to Jira data. JQL is limited in many ways.

This is my favorite limitation: https://jira.atlassian.com/browse/JRACLOUD-21372

Wow. Going on 12 years to get exact text matches working; that sounds crazy.

Re: Scrumdog – a program to download Jira Issues to a local database

#59

Post by iampims »

simonw wrote: post #10

Absolutely love this. I have a whole bunch of similar tools for importing stuff from different services into SQLite but I never got up the courage to take on Jira! Here's my github-to-sqlite tool which imports GitHub Issues https://datasette.io/tools/github-to-sqlite - being able to query them in a local SQLite database is super-handy. I run a demo instance of the resulting database here: https://github-to-sqlite.dog…

Heads up:

> Error 500 cannot import name 'etree' from 'markdown.util' (/usr/local/lib/python3.8/site-packages/markdown/util.py)

Re: Scrumdog – a program to download Jira Issues to a local database

#60

Post by GekkePrutser »

I wish there was a program to enter hours into Jira (and related tasks of course) and upload them.

We have to use Jira for logging hours at work now because they think that makes us agile. Needless to say the only agile related thing we do is logging hours in Jira so that's a complete joke. Our project management department is full of complete idiots.

But Jira is such a dog to work with. Especially if you only enter stuff for the sake of it. It won't accept "7h33m", no it has to be "7h 33m". For every change you need to refresh all pages before they're picked up. It's ridiculously slow.

A frontend where I could just dump my made-up hours that would then take its time to upload that shit to Jira would really help me to be less stressed.

Post reply on HN