DEIM Forum 2015 C5-1 SuperSQL SSedit 223-8522 3-14-1 E-mail: {yusuke,masato,goto}@db.ics.keio.ac.jp, toyama@ics.keio.ac.jp SuperSQL SQL SuperSQL SSedit SuperSQL SuperSQL link FOREACH 1. SuperSQL SQL SQL SQL SuperSQL HTML PHP Web SuperSQL SuperSQL SSedit SuperSQL SSedit SuperSQL 2 SuperSQL 3 SSedit 4 5 6 7. 2. SuperSQL SuperSQL SuperSQL SQL [1] [2]. SQL SELECT GENERATE< media >< TFE > GEN- ERATE. < media > HTML PDF. < TFE > Target Form Expression,, 2. 1 ( ), 3. (,). : Name Tel name tel (!). : Name! Tel (%) name tel 3. HTML. : Name % Tel name tel 2. 2 [ ]!,[ ]!,[ ]! [! [, ]! ]!
. ([ ],) : [Name] name1 name2 name10 ([ ]!). name1 name2 : [Name]! name10 2. 3 (@) < >@{ < > } = [employee.name@{width=200 color=red}]! 2. 4 2. 4. 1 link ( HTML ) link FOREACH link FOREACH link FOREACH Q1.ssql GENERATE HTML [e.name % {e.salary e.syear}]! FROM employee e link FOREACH Q2.ssql Q3.ssql. Q2.ssql GENERATE HTML [link(e.name file="q3.ssql" att=e.id)]! FROM employee e Q3.ssql FOREACH e.id GENERATE HTML [e.salary e.syear]! FROM employee e link FOREACH file=link att= FORE- ACH URL () 2 ( 2 ) link att1 att2 att3.. FOREACH (,). 3. SuperSQL : SSedit 3. 1 SSedit. 3. 2 SSedit 3 1 2 3 3. 2. 1 GENERATE < media > FROM ; SuperSQL.ssql HTML
1 2 3 * 3. 2. 2.ssql 3. 2. 3 /preference 3. 3 1 SSedit MacOS 1 Ctrl(Command)+Enter Esc or Ctrl(Command)+W SSedit Ctrl(Command)+S Ctrl(Command)+Z UNDO Ctrl(Command)+Y REDO Ctrl(Command) - +Alt(option)+ - Ctrl(Command)+D - - Ctrl(Command)+/ - - @ Ctrl(Command)+K Ctrl(Command)+H Ctrl(Command)+F [e.id % {e.name@{color=yellow} {e.byear e.syear}}]! 4. 4 SSedit SuperSQL.(2.1,2.2 )
TFE @{width100} (asc1) 4 5. 5. 1 5. 1. 1 1 Ctrl(Command)+F 1 5 5 5. 1. 2 5 6 5. 2 % 2 1 ( ) 1 50 6 100 html 1 2 link FOREACH link FOREACH ( ) link FOREACH 1 ( ) link FOREACH 2 SuperSQL ( ) 7 link ( xxx link1-1.ssql) ( xxx foreach1-1.ssql) xxx link1-1.ssql xxx foreach1-1.ssql : % link att % 8
10 7 att 2 att att 2 (,). 8 att 5. 3 SuperSQL 10 simpleviewer 5. 4 SuperSQL SuperSQL 11 9 5. 5 1 FROM. 1. 9 CSS ( ) 1 6. SuperSQL
SSedit SuperSQL SuperSQL SSedit SuperSQL emacs vi ssql SuperSQL 6. 1 SuperSQL 12 10280 1155 SSedit 9125 90 SSedit SSedit SSedit 6. 2 2 12 16 1 SuperSQL 13 SuperSQL SuperSQL SSedit SSedit 2 SuperSQL 12 26 1 1 1 21 ITC 12 27 1 5 SSedit SSedit SSedit 7. SuperSQL SuperSQL SSedit SuperSQL %
SuperSQL SSedit SSedit SuperSQL [1] SuperSQL: http://supersql.db.ics.keio.ac.jp/ [2] M Toyama: SuperSQL: An Extended SQL for Database Publishing and Presentation Proceedings of ACM SIG- MOD 98 International Conference on Management of Data pp 584-586 1998 [3] : SuperSQL Web 2009 [4] : SuperSQL 6 (DEIM) 2014 [5] pgadmin: http://www.pgadmin.org/ [6] SQLiteStudio: http://sqlitestudio.pl/