| Time |
S |
Nick |
Message |
| 05:11 |
|
|
wsiqueir joined #rest |
| 07:15 |
|
|
vladjapi joined #rest |
| 08:00 |
|
|
Coldblackice joined #rest |
| 09:56 |
|
|
wsiqueir joined #rest |
| 10:19 |
|
|
Macaveli joined #rest |
| 10:28 |
|
|
anth0ny joined #rest |
| 10:29 |
|
|
graste joined #rest |
| 11:23 |
|
|
Devastator joined #rest |
| 12:12 |
|
|
bluezone joined #rest |
| 12:16 |
|
|
mooncup joined #rest |
| 12:16 |
|
|
`0660 joined #rest |
| 12:37 |
|
|
pdurbin joined #rest |
| 13:07 |
|
|
ShekharReddy joined #rest |
| 13:15 |
|
|
tbsf joined #rest |
| 13:46 |
|
|
saml joined #rest |
| 13:55 |
|
|
tbsf joined #rest |
| 14:03 |
|
|
fuzzyhorns joined #rest |
| 14:18 |
|
|
wsiqueir joined #rest |
| 16:04 |
|
|
tbsf joined #rest |
| 17:09 |
|
|
graste joined #rest |
| 17:20 |
|
|
Macaveli joined #rest |
| 17:41 |
|
|
Coldblackice joined #rest |
| 18:10 |
|
|
Devastator_ joined #rest |
| 18:11 |
|
|
Devastator_ joined #rest |
| 18:24 |
|
|
leonarth_ joined #rest |
| 18:24 |
|
leonarth_ |
do you guys know of any Data Warehouse solutions that provide a REST API to query the data? |
| 18:48 |
|
|
Coldblackice joined #rest |
| 19:08 |
|
pdurbin |
leonarth: can you give us an example of a data warehouse solution? |
| 19:08 |
|
leonarth |
pentaho.com |
| 19:09 |
|
leonarth |
a system that connects to various DBs extracts data from them via SQL queries, stores it and makes it available via REST API calls |
| 19:09 |
|
whartung |
so you mean a system other than pentaho? |
| 19:14 |
|
leonarth |
yes, as Pentaho has a plugin that provides a sort of API to the data but is not REST and very confusing for the frontend devs to use |
| 19:17 |
|
whartung |
I doubt you will find a REST API. At that level, most of these folks just spew out HTTP and JSON apis |
| 20:20 |
|
leonarth |
whartung so what do you suggest? |
| 20:21 |
|
leonarth |
implement a middle layer that parses that bad API and spits REST? |
| 20:23 |
|
|
Macaveli joined #rest |
| 20:36 |
|
whartung |
it depends on how much you want your application to be a REST architecture vs simply being able to access the data "easily" via commodity HTTP and JSON utilities. |
| 21:42 |
|
|
daxim joined #rest |
| 21:59 |
|
|
fuzzyhorns joined #rest |
| 22:33 |
|
impl |
leonarth: once upon a time i spent a good few months writing such a thing to interface to greenplum, dynamically figuring out from the definitions of dimensions/facts how to map them to SQL... never found if there was a non-NIH solution though. but it is doable. |
| 22:39 |
|
leonarth |
I found something impl, whartung |
| 22:39 |
|
leonarth |
https://www.dreamfactory.com/ |
| 22:40 |
|
leonarth |
you give to this app a service (connection to a DB) and it automatically generates a rest API to read the tables, even modify, delete and update them |
| 22:40 |
|
leonarth |
I need only to read the data anyway |
| 22:40 |
|
whartung |
oh neat |
| 22:43 |
|
whartung |
so, just to point it out, because I'm a pedant and a bigot, this is not REST. It's just HTTP and JSON. |
| 22:43 |
|
whartung |
doesn't mean it's not neat. |
| 22:53 |
|
leonarth |
whartung but it's respecting all the REST principles |
| 22:54 |
|
leonarth |
pinciples -> 'architectural style' |
| 22:58 |
|
whartung |
not really. It's not using hypermedia ata ll |
| 22:58 |
|
asdf |
isn't it? i can't find any example responses |
| 22:58 |
|
asdf |
but yeah, i guess the docs are full of url patterns |
| 22:59 |
|
whartung |
look at Features, "Combine Databases" -- that (I assume) is a sample payload |
| 23:00 |
|
asdf |
hmm.. here's an example http://wiki.dreamfactory.com/DreamFactory/Tutorials/Edmunds_API |
| 23:00 |
|
asdf |
so yep, no hypermedia at all, oh well :( |
| 23:00 |
|
whartung |
yea, just raw json |
| 23:02 |
|
whartung |
something liek this might be nice for internal consumption, but I don't think I'd ever publish something in the wild against something like this |
| 23:03 |
|
asdf |
lots of people do |
| 23:03 |
|
whartung |
yea I know. A friend of mine made it a pastime to rob them blind of data. |
| 23:03 |
|
asdf |
haha, nice |
| 23:04 |
|
whartung |
I mean, folks would just itch if you posted: http://host.com/sql_query?q="select * from customers" |
| 23:04 |
|
whartung |
but don't seem to have an issue with http://host.com/customers |
| 23:05 |
|
whartung |
it's a great idea, but folks tend to not secure them with enough granularity. |
| 23:55 |
|
|
fuzzyhorns joined #rest |
