msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

See How Easily You Can Post to Twitter From an Oracle DB

Posting to Twitter from inside an Oracle database is not something new (OraTweet, ORA_Tweet). However, what if you could post to Twitter by simply executing a SELECT statement without using any custom PL/SQL code?

Try the following in your SQL*Plus. It will ask you for your Twitter username and password and the status message that you want to post:

eddie@db11gr2> set define !
eddie@db11gr2> set verify off
eddie@db11gr2> set sqlterminator off
eddie@db11gr2> SELECT HTTPURITYPE(
  2    UriFactory.escapeUri(
  3      'http://query.yahooapis.com/v1/public/yql?q=
  4        USE "http://awads.net/yql/twitter.xml" as tw_t;
  5          INSERT INTO tw_t (status, username,password)
  6            VALUES("!status","!!username","!!password")
  7              &format=json
  8              &env=store://datatables.org/alltableswithkeys&format=xml&callback=cbfunc')).getclob()
  9    json_response
 10  FROM dual
 11  /
Enter value for status: Tweeting from SQL*Plus.
Enter value for username: sqlyql
Enter value for password: sqlyqlpw

JSON_RESPONSE
--------------------------------------------------------------------------------
cbfunc({"query":{"count":"1","created":"2010-05-02T02:02:14Z","lang":"en-US","re
sults":{"status":{"created_at":"Sun May 02 02:02:14 +0000 2010","id":"1322057475
5","text":"Tweeting from SQL*Plus.","source":"<a href=\"http://apiwiki.twitter.c
om/\" rel=\"nofollow\">API</a>","truncated":"false","in_reply_to_status_id":null
,"in_reply_to_user_id":null,"favorited":"false","in_reply_to_screen_name":null,"
user":{"id":"139255376","name":"sqlyql","screen_name":"sqlyql","location":null,"
description":null,"profile_image_url":"http://s.twimg.com/a/1272578449/images/de
fault_profile_1_normal.png","url":null,"protected":"false","followers_count":"1"
,"profile_background_color":"9ae4e8","profile_text_color":"000000","profile_link
_color":"0000ff","profile_sidebar_fill_color":"e0ff92","profile_sidebar_border_c
olor":"87bc44","friends_count":"0","created_at":"Sun May 02 01:59:28 +0000 2010"
,"favourites_count":"0","utc_offset":null,"time_zone":null,"profile_background_i
mage_url":"http://s.twimg.com/a/1272578449/images/themes/theme1/bg.png","profile
_background_tile":"false","notifications":"false","geo_enabled":"false","verifie
d":"false","following":"false","statuses_count":"1","lang":"en","contributors_en
abled":"false"},"geo":null,"coordinates":null,"place":null,"contributors":null}}
}});


Elapsed: 00:00:01.92

The above is made possible using HTTPURITYPE and YQL, the Yahoo! Query Language. Awesome combination!

Note that on June 30, 2010 Twitter will be shutting off basic authentication on the Twitter API. After that date, the above will stop working unless the YQL query is modified to use OAuth.

Are you on Twitter? Follow me at eddieawad and the rest of the Oracle Tweeple at eddieawad/oracle.

2 Comments | Filed in Oracle | Tags: , ,


Following a Few of Quality Will Give You The Quantity You Need

Great advice from Mitch Joel: Too many people are looking for too many ways to follow too many people and places. Your best bet is to do the opposite. Don't add more noise to your life. start removing the noise. It's not important to follow every Blog, and it's impossible to listen to every Podcast. If you've spent more than five minutes on Twitter, the river of tweets and the speed with which they flow makes every conversation look, feel and last a couple of seconds (at most). Become a better filter. If you're following someone and they're really not adding any value to your life (your growth, development and education), drop them. If you follow a Blog but never get to it because life happens, drop it. If you're a publisher of content (text, audio, video, images, whatever…) think about what you're publishing (noise vs. value).. More…

4 Comments | Filed in Links, Tips | Tags: , , , , ,


Yahoo Launches SQL Interface to Twitter

The new YQL set of tables for Twitter enables any developer to use simple SQL-like queries to retrieve and post Twitter data. For simple user queries, getting a user’s twitter profile data is as simple as something like “SELECT * FROM twitter.status WHERE id=’8036408424?;“.More…

Comments Off | Filed in Links | Tags: , ,


A Quick Update

I owe you, my dear reader, a quick update. If you have been following me on Twitter, you already know that on April 23 I started a new job with a new employer. In the last three weeks, I have been adapting myself to the new environment. This is not easy to do after being in the same job and the same employer for 9 years.

My new position is still “Oracle Developer” and I’m still based in Portland, Oregon USA. I will be doing SQL and PL/SQL development, Fusion Middleware development like Portal, OID, Business Intelligence and SOA/BPEL, in addition to E-Business Suite. I will be exposed to a broader and different set of Oracle technologies compared to my previous job. As always, I will share my new experiences with you through my blog.

One thing I will not continue doing is ColdFusion. Even though I have not blogged about it for a while, now I know for sure that I will not be using nor blogging about ColdFusion at all. As a result, I have changed the title of this blog to: News, views, tips and tricks on Oracle and other fun stuff. No more ColdFusion.

Because of this transition, my blogging activities have dropped recently. There is a lot of useful stuff I want to blog about. I promise I’ll find the time to write and hit the publish button. However, somehow I always find the time to Twitter. Hey, how much time does it take to write a 140 character blog post?! You can always follow me there.

Thank you for being a loyal reader.

9 Comments | Filed in Personal | Tags: , , ,


Different Ways to Follow Oracle OpenWorld 2007

Whether you’re attending Oracle OpenWorld this year or not, the following Web 2.0 services will keep you informed about up to the minute happenings during the conference:

Official Stuff

Unofficial Stuff

Contribute Stuff

If you are attending OpenWorld this year, here is how you can contribute to the mashup of services above:

  • Snap photos and email them to future09ideas@photos.flickr.com. Your photos will appear in the openworld07 flickr tag stream, be added to the oow07 flickr group and show up in the oow twitter channel.

  • If you are on twitter (if not, here is a guide to get you started), and want your tweets to show up on twitter.com/oow and eventtrack, just follow twitter.com/oow and prefix your OpenWorld related tweets with @oow.

Cool Stuff

Check out the following interesting blog posts from Jake and Dennis related to oow and eventtrack:

6 Comments | Filed in Oracle | Tags: , ,


FriendFeed Invites and Six Cool Twitter Applications

Thanks to Jake, I now have a bunch of my “Web 2.0 accounts” aggregated into one place at FriendFeed: del.icio.us, Flickr, Google Reader, Google Shared Stuff, LinkedIn, YouTube and Twitter.

You can subscribe to my feed here. FriendFeed is great. I like it. It is currently in private beta testing. However, if you’re interested, just leave a comment below and I’ll send you an invite.

Speaking of twitter, I’m starting to like it more. You really have to pick the right friends you follow, otherwise you’ll be overwhelmed by useless chatter. Too bad my employer has blocked twitter, but that’s not a problem. I use:

  1. twittermail to post tweets by email from work
  2. itweet to read and post tweets from my iPhone
  3. twitbin to read and post tweets from my Firefox sidebar from home
  4. twittergram to post voice tweets from my iPhone (or any phone)
  5. jott to convert my voice into text tweets from my iPhone (or any phone)
  6. twitterfeed to publish any RSS feed to twitter.

I use twitterfeed in many different ways, like for example posting photo tweets from my iPhone to Flickr->twitter. I also publish my blog feed to my twitter account. Moreover, OraNA, Oracle and OOW twitter accounts use twitterfeed as well.

There are many other twitter applications, but the ones above are my favorites.

8 Comments | Filed in Technology | Tags: , ,


Oracle OpenWorld 2007 – Social Networking, Twittering, Flickring and Unconferencing

Justin Kestelyn twittered and blogged about the new Oracle OpenWorld Community Guide page on OTN, and more specifically about this year’s unconference. An unconference is a conference where the content of the sessions is driven and created by the participants. It also means that anyone has the opportunity to be a presenter at OOW. That will be interesting!

This year’s official OpenWorld community tools include Oracle OpenWorld Connect, a twitter channel and a del.icio.us feed.

Speaking of twitter, here are some (unofficial) Oracle related twitter channels that I have created:

And here is my channel twitter.com/eddieawad.

In addition to blogging, I will be twittering live events and mini interviews during this year’s OOW conference, so stay tuned.

Moreover, like in 2005 and 2006, I have created the 2007 Oracle OpenWorld Flickr group. Feel free to join and contribute to the photo pool.

Finally, if you have an Oracle related blog, do not forget to join the Oracle Bloggers group at Oracle OpenWorld Connect.

See you in a few weeks.

3 Comments | Filed in Oracle | Tags: , ,


The Oracle Community on Twitter

It’s here. If you want to participate in the growth (or even death) of the Oracle community on Twitter, head over to twitter.com/oracle and add Oracle as your friend. You have to “Join for Free” first, before you can add friends.

Once you add Oracle as a friend, Oracle will add you back as a friend. The result is this page where you can see all Oracle friends twittering with each other.

According to Kathy Sierra:

Twitter, is the solution to the one problem we all have: it’s just too damn hard to keep updating our blog every few minutes to tell the world what we’re doing at that very moment. Twitter lets you make tons of nano-posts (postlets?) to a kind of nano-blog (bloglet?) And indeed, it’s every bit as stimulating as it sounds…. I can think of dozens of reasons why Twitter is a wonderful thing (like for separated families, etc.) But talk about an event horizon… Twitter is the new Crackberry.

In case you are still wondering what this Twitter thing is, it is a global community of friends and strangers answering one simple question: What are you doing? Answer on your phone, IM, or on the web! Of course, you can post whatever you want, not just what you are doing.

Sean has already planted the seed of a ColdFusion Twitter channel.

By the way, my Twitter handle is eddieawad.

Comments Off | Filed in Oracle | Tags: