Warning: mysql_real_escape_string(): No such file or directory in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): No such file or directory in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): No such file or directory in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): No such file or directory in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): No such file or directory in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): No such file or directory in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/jayshao/web/wp/wp-content/plugins/statpress-reloaded/statpress.php on line 1786
SQL | Jason E. Shao

What’s Jason Up to?

Some people have commented on updates to Facebook & Linked in, so thought I’d author a quick post detailing what I’m up to these days. For anyone who’s wondering, as of January of this year, I am no longer at CampusEAI – I’ve chosen to join ContextWeb, an advertising network/exchange vendor based in NYC, as ...

Sakai Conference: Easing Data Recovery

Indiana has built a database structure that has triggers (in Oracle) to copy changes to db tables into backup schemas (per table/schema). This allows them to recover deleted, or other data, by retrieving it and copying it back into the appropriate table. Resources on the file system are handled via snapshots (on a NetApp?) Some ...

I finally get REST. Wow.

I finally get REST. Wow. It’s depressing to think that SOAP started just about 10 years ago and that now that everything is said and done, we built RPC again. I know SOAP is really an XML messaging protocol, you can do oneway async stuff, etc, etc, but let’s face it. The tools make the ...

uP3 Day 2: Oracle & Users

Well, only got a couple of hours today to crack on uP3, but did manage to get it running on Oracle. After fixing the dbLoader thing, today it looks like everything is working (numerous restarts and cleans later). So, then went to add some users, which requires… manual SQL. Adding users required inserting rows into: ...

uP3 Day 1: Download & Install

Downloading uP3 quickstart was easy enough. Faizan exported RC1 from SVN and imported it into our CVS repository. build.properties seems not to have made it — maybe some kind of .cvsignore filter he had on Eclipse when he did the initial checkin. Tried hooking up to Oracle, ran into problems… Spent 30 min or so ...

Recent Updated Articles Works

Using a tip from at [the girlie matters] tips and tricks: lastn recently modified entries using mtsql I finally enabled the listing of my most recently updated entries. This is good, because I often go back and change or edit past entries. Now there’s a convenient drop-down box in my header with the last 5 ...