Java store in BLOB

http://www.kodejava.org/examples/279.html


http://www.kodejava.org/browse/55.html

Oracle Thin Driver setup

Download Squirrel SQL Client.

Installation and running both needs Admin Right.


Use Oracle Thin Driver and load the ojdbc14.jar

jdbc:oracle:thin:@[:<1521>]:

getting the most interactive fds

SELECT actor_id, message, comments.count, comments.comment_list, likes.count, likes.sample from stream where source_id=me() and (likes.count > 0 or comments.count > 0)

==============================================

SELECT actor_id, message, comments.count, comments.comment_list, likes.count, likes.sample from stream where source_id in (SELECT target_id FROM connection WHERE source_id=me()) and (likes.count > 0 or comments.count > 0)


SELECT actor_id from stream where source_id in (SELECT target_id FROM connection WHERE source_id=me() and target_type='user')

===============================================================
select uid, name from user where uid in (
SELECT actor_id, message from stream where source_id in (SELECT uid2 FROM friend WHERE uid1=me())
)

SELECT target_id, message from stream where source_id=me()

select uid, name from user where uid in (
SELECT actor_id from stream where source_id=me())


Get user's post:
SELECT post_id from stream where source_id=me()

Get those friend's comment on user's post:
select fromid from comment where post_id in (
SELECT post_id from stream where source_id=me())

Get those friend's comment on user's posts:
select uid, name from user where uid in (
select fromid from comment where post_id in (
SELECT post_id from stream where source_id=me()))

Get those friend's that likes user's posts:
select uid, name from user where uid in (
SELECT likes.friends from stream where source_id=me()
)

Discuss 工作版Post

30歲前有超過20k一個月的你,付出了多少?

http://www.discuss.com.hk/viewthread.php?tid=13947885&extra=page%3D2

給工作3-5年職場新生代的面試建議

http://www.dotblogs.com.tw/jimmyyu/archive/2010/10/15/18372.aspx

CSS Menu using image sprite

http://line25.com/tutorials/how-to-create-a-css-menu-using-image-sprites

Javascript Ajax Upload Plugin

https://github.com/valums/ajax-upload

The Ultimate HTML5 Tutorials and Useful Techniques

http://www.dzinepress.com/2011/04/the-ultimate-html5-tutorials-and-useful-techniques/

Useful JavaScript and jQuery Tools, Libraries, Plugins

http://www.smashingmagazine.com/2011/04/07/useful-javascript-and-jquery-tools-libraries-plugins/