Slouch on Akiban

Transcript

1. javascript & json language of the interwebs
2. existing app from heroku developer
3. client - backbone.js server - node.js database - ??
4. CREATE TABLE hopes ( id uuid primary key default (uuid_generate_v4()), data json ); postgresql
5. JSON data is stored as BLOB
6. select * from hopes limit 1; -[ RECORD 1 ]- id | 38290295- aed4-417f-90bf-8c6d1d730e6d data | {"desc":"raspberry beret", “date”:”12-02-2013-02-11T23:03:54” ,“bumpcount:3}
7. That kinda sucks...
8. CREATE TABLE hopes ( id varchar(128) primary key, “desc” varchar(128), “date” varchar(128), bumpcount int ); akiban
9. No Need For BLOB!
10. can retrieve json from akiban through SQL or REST
11. select * from hopes limit 1; -[ RECORD 1 ]- id | 38290295- aed4-417f-90bf-8c6d1d730e6d desc | raspberry beret date | 12-02-2013-02-11T23:03:54 bumpcount | 3
12. select * from hopes limit 1; -[ RECORD 1 ]- JSON | {"id":” 38290295- aed4-417f-90bf-8c6d1d730e6d”,"desc ":"raspberry beret","date":"2013-02-11T23:03:54 ","bumpcount":3}
13. javascript inside the server
14. CREATE  PROCEDURE  avg_bump_count_func(OUT  ans  DOUBLE)    LANGUAGE  javascript  PARAMETER  STYLE  variables  AS  $$        function  avg_bump_count()  {            var  conn  =   java.sql.DriverManager.getConnection("jdbc:default:connection ",  "test",  "");            var  ps  =  conn.prepareStatement("SELECT  avg(bumpcount)   FROM  hopes");            var  rs  =  ps.executeQuery();            rs.next();            return  rs.getDouble(1);        }        ans  =  avg_bump_count();    $$;
15. Invoke through SQL call avg_bump_count_func(); ans -------------------- 3.6666666666666665 (1 row)
16. Invoke through HTTP... http://bit.ly/VQ0vO4
17. No need for developer to jump through hoops
18. simple requests for objects use REST to retrieve JSON
19. complex queries use SQL (and can also retrieve results in JSON)