Looking for ideas

Monday, February 21. 2011

Congratulations and thanks to all concerned in getting the SQL/MED / Foreign Data Wrapper feature done. Now it's committed, I'm going to build a few. I have a couple of ideas, but I'm also trying to come up with useful but possibly a bit more way out things to wrap. Twitter has already been suggested as a data source, so I'm trying to thing of similarly slightly wacky ideas

Posted by Andrew Dunstan in PostgreSQL at 01:37 | Comments (13) | Trackbacks (0)

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

Git!

#1 Anonymous on 2011-02-21 03:38 (Reply)

RSS and Atom 
iCal 
IMAP 
 
HTTP could be interesting in and of itself...

#2 Justin Pitts on 2011-02-21 04:13 (Reply)

How about the GitHub API?

#3 Theory (Homepage) on 2011-02-21 04:22 (Reply)

Now, if we had DDL triggers we could tie it to this Github API and get integrated database versioning <img src="/andrew/templates/default/img/emoticons/smile.png" alt=":-)" style="display: inline; vertical-align: bottom;" class="emoticon" />

#3.1 Gurjeet Singh on 2011-02-21 06:47 (Reply)

No, not really. These are read-only data objects, at least for now.

#3.1.1 Andrew Dunstan on 2011-02-21 07:24 (Reply)

Reaaly?! I didn't know that; I haven't been following -hackers too closely. 
 
Even so, if can we have RULEs on FDW tables (not sure if we can) we can call functions as part of INSTEAD OF INSERT that make appropriate HTTP API call to Github.

#3.1.1.1 Gurjeet Singh on 2011-02-21 07:36 (Reply)

Does it already support XML. Those are the type of feeds I need to contend with. Usually nothing fancy but pretty much like the output you get form query_to_xml. 
 
Also JSON would be nice since I have a couple of services that spit that out and would be nice to consume directly.

#4 Regina (Homepage) on 2011-02-21 09:25 (Reply)

MySQL, 
DBI

#5 Pavel Stehule (Homepage) on 2011-02-21 09:32 (Reply)

Those aren't really very exotic. I'm expecting lots of people to work on those.

#5.1 Andrew Dunstan on 2011-02-21 18:10 (Reply)

It can be wrong expectation <img src="/andrew/templates/default/img/emoticons/smile.png" alt=":-)" style="display: inline; vertical-align: bottom;" class="emoticon" /> - when everybody expects so somebody will do same work and nobody does it in reality.

#5.1.1 Pavel Stehule (Homepage) on 2011-02-23 10:39 (Reply)

How about writing some great documentation about how to implement an SQL/MED wrapper, with an example project to read something relatively simple? 
 
That way it would help get more of us implementing many more wrappers...

#6 Chris Mellish (Homepage) on 2011-02-21 10:39 (Reply)

Part of the reason for doing this is to construct exemplars. I'm doing a talk on it next month.

#6.1 Andrew Dunstan on 2011-02-21 18:14 (Reply)

Things which come to mind: 
- RRD 
- Graphviz DOT

#7 Frans on 2011-02-23 18:06 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	Enclosing asterisks marks text as bold (word), underscore are made via _word_. Standard emoticons like :-) and ;-) are converted to images. Wiki format allowed
	Remember Information? Subscribe to this entry