Re: 2018-03 CFM

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: 2018-03 CFM
Дата
Msg-id 20180302121802.GC29307@e733.localdomain
обсуждение исходный текст
Ответ на Re: 2018-03 CFM  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: 2018-03 CFM  (David Steele <david@pgmasters.net>)
Re: 2018-03 CFM  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
Hello Magnus,

> You do realize we have the actual source database available, I hope? Since
> it's our own system... There is no need to scrape the data back out -- if
> we can just define what kind of reports we want, we can trivially run it on
> the source database. Or if we want it more often, we can easily make a
> webview for it. It's basically just a "map this URL to a SQL query"...

I don't think commitfest.cputube.org has the SQL data on whether patch
pass the tests. It just displays SVG images from travis-ci.org. Also
unfortunately both commitfest.postgresql.org and commitfest.cputube.org
currently don't have any kind of public API and don't allow to export
data, e.g. in CSV or JSON.

I guess it would be nice if both services supported export, in any
format, so anyone could build any kind of reports or automation tools
without parsing HTML with regular expressions or depending on other
people.

If I'm not mistaken, there was a discussion regarding public APIs.
I wonder what prevents adding it, at least a simple export of everything.
After all, it is indeed just mapping URL to a SQL query. For instance,
this one:

select array_to_json(array_agg(row_to_json(tbl))) from tbl;

--
Best regards,
Aleksander Alekseev

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Better Upgrades
Следующее
От: ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Дата:
Сообщение: Re: perltidy version