Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(311)

Side by Side Diff: experimental/webtry/DESIGN.md

Issue 235323006: permalinks working (Closed) Base URL: https://skia.googlesource.com/skia.git@sql
Patch Set: fix sql formating Created 6 years, 8 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View unified diff | Download patch
« no previous file with comments | « no previous file | experimental/webtry/setup/continue_install » ('j') | no next file with comments »
Toggle Intra-line Diffs ('i') | Expand Comments ('e') | Collapse Comments ('c') | Show Comments Hide Comments ('s')
OLDNEW
1 Design 1 Design
2 ====== 2 ======
3 3
4 4
5 Overview 5 Overview
6 -------- 6 --------
7 Allows trying out Skia code in the browser. 7 Allows trying out Skia code in the browser.
8 8
9 9
10 Security 10 Security
(...skipping 120 matching lines...) Expand 10 before | Expand all | Expand 10 after
131 131
132 $ mysql --host=173.194.83.52 --user=root --password 132 $ mysql --host=173.194.83.52 --user=root --password
133 133
134 Initial setup of the database, the user, and the only table: 134 Initial setup of the database, the user, and the only table:
135 135
136 CREATE DATABASE webtry; 136 CREATE DATABASE webtry;
137 USE webtry; 137 USE webtry;
138 CREATE USER 'webtry'@'%' IDENTIFIED BY '<password is in valentine>'; 138 CREATE USER 'webtry'@'%' IDENTIFIED BY '<password is in valentine>';
139 GRANT SELECT, INSERT, UPDATE ON webtry.webtry TO 'webtry'@'%'; 139 GRANT SELECT, INSERT, UPDATE ON webtry.webtry TO 'webtry'@'%';
140 140
141 // If this gets changed also update the sqlite create statement in webtry.go .
142
141 CREATE TABLE webtry ( 143 CREATE TABLE webtry (
142 code TEXT DEFAULT '' NOT NULL, 144 code TEXT DEFAULT '' NOT NULL,
143 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, 145 create_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
144 hash CHAR(64) DEFAULT '' NOT NULL, 146 hash CHAR(64) DEFAULT '' NOT NULL,
145 PRIMARY KEY(hash) 147 PRIMARY KEY(hash)
146 ); 148 );
147 149
148 Common queries webtry.go will use: 150 Common queries webtry.go will use:
149 151
150 INSERT INTO webtry (code, hash) VALUES('int i = 0;...', 'abcdef...'); 152 INSERT INTO webtry (code, hash) VALUES('int i = 0;...', 'abcdef...');
(...skipping 24 matching lines...) Expand all
175 curl "http://metadata/computeMetadata/v1/instance/attributes/password" -H "X -Google-Metadata-Request: True" 177 curl "http://metadata/computeMetadata/v1/instance/attributes/password" -H "X -Google-Metadata-Request: True"
176 178
177 N.B. If you need to change the MySQL password that webtry uses, you must change 179 N.B. If you need to change the MySQL password that webtry uses, you must change
178 it both in MySQL and the value stored in the metadata server. 180 it both in MySQL and the value stored in the metadata server.
179 181
180 Installation 182 Installation
181 ------------ 183 ------------
182 See the README file. 184 See the README file.
183 185
184 186
OLDNEW
« no previous file with comments | « no previous file | experimental/webtry/setup/continue_install » ('j') | no next file with comments »

Powered by Google App Engine
This is Rietveld 408576698