1
00:00:00,000 --> 00:00:00,060

2
00:00:00,060 --> 00:00:01,560
>> DAVID Malan: Kull dritt, aħna huma lura.

3
00:00:01,560 --> 00:00:03,830
Dan għall-eċċitanti
konklużjoni, l-aħħar taqsima tagħna

4
00:00:03,830 --> 00:00:06,900
dwar l-ipprogrammar tal-web, li jiena
ħsibt aħna'd użu bħala terminu ġenerali

5
00:00:06,900 --> 00:00:08,440
jaqbad suġġetti ftit fadal.

6
00:00:08,440 --> 00:00:10,390
Għalhekk fl-aħħar tal-
jum, aħna ser fil-fatt jagħmlu

7
00:00:10,390 --> 00:00:14,830
xi ftit ta 'hands-on-ipprogrammar tal-web
bil-lingwa msejħa JavaScript.

8
00:00:14,830 --> 00:00:17,510
U naħseb aħna ser tagħti ħarsa
fuq xi ħaġa relatati ma 'immaġini

9
00:00:17,510 --> 00:00:20,040
u jiskopru xi ħaġa
segretament moħbija fil-immaġini,

10
00:00:20,040 --> 00:00:23,230
u wkoll tagħti ħarsa lejn l-Google
Mapep API, programmi applikattivi

11
00:00:23,230 --> 00:00:26,040
interface, bħala xi ħaġa
rappreżentattiva tat-tip ta 'software

12
00:00:26,040 --> 00:00:28,800
li l-aktar u
liberament disponibbli llum.

13
00:00:28,800 --> 00:00:32,029
>> Iżda għaliex ma we tagħti ħarsa
fi ingredjent għal din id-dinja

14
00:00:32,029 --> 00:00:34,070
li konna tip ta ġiet
filwaqt għall mogħtija teżisti

15
00:00:34,070 --> 00:00:36,720
għal xi żmien, database.

16
00:00:36,720 --> 00:00:39,150
Għall-aħħar ġurnata u
nofs konna jassumi

17
00:00:39,150 --> 00:00:42,910
li għandna aċċess għal database, iżda
liema problema ma 'database ssolvi?

18
00:00:42,910 --> 00:00:45,540
X'tikkontrolla do għalina?

19
00:00:45,540 --> 00:00:47,030
X'inhu?

20
00:00:47,030 --> 00:00:48,679
>> UDJENZA: [inaudible]

21
00:00:48,679 --> 00:00:51,720
DAVID Malan: Stivi l-informazzjoni kollha,
OK, u liema tipi ta 'informazzjoni

22
00:00:51,720 --> 00:00:53,186
jista 'ma tqiegħed fiha?

23
00:00:53,186 --> 00:00:54,590
>> UDJENZA: [inaudible]

24
00:00:54,590 --> 00:00:56,450
>> DAVID Malan: Kull tagħrif
inti jistabbilixxu dan, int ser tingħata lura.

25
00:00:56,450 --> 00:00:57,070
Dan huwa veru.

26
00:00:57,070 --> 00:01:01,900
U fuq sit jew web fuq l-internet tipiku
applikazzjoni, liema tipi ta 'informazzjoni,

27
00:01:01,900 --> 00:01:03,385
speċifikament, jistgħu inti tpoġġi fil-?

28
00:01:03,385 --> 00:01:04,260
UDJENZA: [inaudible]

29
00:01:04,260 --> 00:01:05,051
DAVID Malan: Utenti.

30
00:01:05,051 --> 00:01:07,000
Allura x'hemm utent?

31
00:01:07,000 --> 00:01:09,765
>> UDJENZA: [inaudible]

32
00:01:09,765 --> 00:01:11,640
DAVID Malan: OK, irreġistrata
utent tas-sit.

33
00:01:11,640 --> 00:01:15,100
U dak ma jfisser li
Informazzjoni utenti taħżen?

34
00:01:15,100 --> 00:01:17,260
Liema composés utent?

35
00:01:17,260 --> 00:01:18,331
A utent għandu xiex?

36
00:01:18,331 --> 00:01:19,206
UDJENZA: [inaudible]

37
00:01:19,206 --> 00:01:21,040
DAVID Malan: Yeah, personali
dejta, u I simili li.

38
00:01:21,040 --> 00:01:21,970
Ejja ikunu aktar preċiżi.

39
00:01:21,970 --> 00:01:25,275
Allura l-utent tipikament għandha isem,
x'iktar jista utent għandhom?

40
00:01:25,275 --> 00:01:26,150
UDJENZA: [inaudible]

41
00:01:26,150 --> 00:01:29,130
DAVID Malan: An OK addr--,
hekk l-ewwel isem, isem l-aħħar.

42
00:01:29,130 --> 00:01:29,630
Tajjeb.

43
00:01:29,630 --> 00:01:31,463
Attwalment, ejja tiffissa
li, minħabba li għaddej

44
00:01:31,463 --> 00:01:35,010
biex jiftħu opportunità għall
diskussjoni, xorta, aktar.

45
00:01:35,010 --> 00:01:39,090
L-ewwel isem, isem l-aħħar, sess.

46
00:01:39,090 --> 00:01:41,820

47
00:01:41,820 --> 00:01:43,481
ID ta 'xi tip.

48
00:01:43,481 --> 00:01:43,980
X'aktar?

49
00:01:43,980 --> 00:01:45,438
Smajt xi ħaġa oħra qabel, wisq.

50
00:01:45,438 --> 00:01:51,600
Email, indirizz postali.

51
00:01:51,600 --> 00:01:58,170
>> Mela ejja nieqaf hemm u issa jqisu
mhux dak li aħna qed ħażna fid-database,

52
00:01:58,170 --> 00:02:01,980
but-- u mhux għaliex, peress li huwa forsi
ovvju li ladarba inti tirreġistra utent,

53
00:02:01,980 --> 00:02:03,730
inti tixtieq li tiftakar lilhom għal xi żmien.

54
00:02:03,730 --> 00:02:05,480
Inti ma tridx li
biss jiġu maħżuna fil-RAM

55
00:02:05,480 --> 00:02:08,690
u jkunu forgotten-- hekk
ejja tiffoka fuq il-kif.

56
00:02:08,690 --> 00:02:11,700
>> Jirriżulta li fl
-dinja ta 'databases,

57
00:02:11,700 --> 00:02:14,410
hemm mill-inqas żewġ tipi f'dawn il-jiem.

58
00:02:14,410 --> 00:02:20,010
Xi ħaġa imsejħa database SQL,
Strutturat Mistoqsija Lingwa,

59
00:02:20,010 --> 00:02:24,770
jew, cutely imsemmi,
noSQL, li mhuwiex SQL.

60
00:02:24,770 --> 00:02:26,980
U l-aħħar hija
eżempju ta 'dak jista

61
00:02:26,980 --> 00:02:30,660
għandu jissejjaħ oġġett orjentati lejn,
jew maħżen oġġett, database

62
00:02:30,660 --> 00:02:36,010
li l-ħażniet l-oġġetti, u mhux, skuża
lili, kif aħna se malajr tara, ringieli.

63
00:02:36,010 --> 00:02:41,800
>> Allura aħna ser niffukaw għal ftit mument fuq
l-ewwel minn dawn, jiġifieri, SQL

64
00:02:41,800 --> 00:02:46,850
database, jekk biss għaliex dan huwa
hekk familjari diġà, lil xi ħadd

65
00:02:46,850 --> 00:02:51,070
li jkun użat Excel jew
Folji google jew Apple

66
00:02:51,070 --> 00:02:53,740
Numri jew kwalunkwe standard
programm spreadsheet,

67
00:02:53,740 --> 00:02:56,040
jew, b'mod ekwivalenti, jew
aktar sophisticatedly,

68
00:02:56,040 --> 00:02:58,610
xi ħaġa bħal Microsoft
Aċċess jew Oracle

69
00:02:58,610 --> 00:03:03,890
jew MySQL jew PostgreSQL, li kollha
huma ismijiet tal-prodotti għall-implimentazzjonijiet

70
00:03:03,890 --> 00:03:04,865
tal-idea li ġejja.

71
00:03:04,865 --> 00:03:10,350
>> Database relazzjonali hija sempliċement
xi ħaġa li għandha ringieli u kolonni.

72
00:03:10,350 --> 00:03:12,850
U billi ringieli u kolonni,
I litteralment tfisser xi ħaġa

73
00:03:12,850 --> 00:03:21,860
bħal dan, hekk fejn aħna jista 'jkollhom l
isem ta 'qasam u t-tip tiegħu fuq hawn.

74
00:03:21,860 --> 00:03:25,800
U fil-fatt, let me
issa jibdew mappa dawn.

75
00:03:25,800 --> 00:03:29,420
Allura fil-fatt, I do not know
għaliex I ġibdet chart separat.

76
00:03:29,420 --> 00:03:30,780
Ejja iżommu din sempliċi.

77
00:03:30,780 --> 00:03:34,830
>> Għandna dritt hawn il
bidu tat-tabella tagħna, fejn

78
00:03:34,830 --> 00:03:40,150
dan huwa l-isem tal-qasam
u dan huwa t-tip tad-data,

79
00:03:40,150 --> 00:03:41,660
u skond it-tip I tfisser dan li ġej.

80
00:03:41,660 --> 00:03:45,510
Huwa ta 'numru, huwa string,
string qasir bħal kelma,

81
00:03:45,510 --> 00:03:49,340
ma hija punt, huwa
data binarja, bħal immaġni?

82
00:03:49,340 --> 00:03:51,980
U ejja biss tease dan il
apparti għal ftit mument.

83
00:03:51,980 --> 00:03:57,575
Allura l-ewwel isem, in-numru,
spag, blokki kbar ta 'text--

84
00:03:57,575 --> 00:03:58,450
UDJENZA: [inaudible]

85
00:03:58,450 --> 00:03:59,616
DAVID Malan: Iva, hekk sekwenza.

86
00:03:59,616 --> 00:04:04,744
U f'kuntest database, aħna ser
tipikament sejħa dan il-qasam char.

87
00:04:04,744 --> 00:04:07,660
I ser biss jgħidu char għal issa imma aħna qed
ser tirfina dan fil-mument.

88
00:04:07,660 --> 00:04:09,180
qasam Karattru.

89
00:04:09,180 --> 00:04:11,365
isem l-aħħar probabbilment l-istess.

90
00:04:11,365 --> 00:04:11,865
Sess?

91
00:04:11,865 --> 00:04:16,230

92
00:04:16,230 --> 00:04:18,310
>> Maskili jew femminili, u għalhekk
jista 'jkun qasam char.

93
00:04:18,310 --> 00:04:21,380
Dan jista 'jkun jew kwotazzjoni, unquote
"Maskili" jew kwotazzjoni, unquote "mara"

94
00:04:21,380 --> 00:04:23,650
jew jista 'jkun m jew f.

95
00:04:23,650 --> 00:04:26,540
Jekk inti tixtieq li tkun aktar inklużiva,
jista 'jkollok bżonn terz valur

96
00:04:26,540 --> 00:04:28,640
jew xi tip ta 'qasam ieħor għal kollox.

97
00:04:28,640 --> 00:04:31,350
U għalhekk inti tista 'tuża falza vera.

98
00:04:31,350 --> 00:04:35,036
Il-qasam li jista 'jissejjaħ raġel, u
allura inti tista 'tgħid vera jew falza.

99
00:04:35,036 --> 00:04:38,160
Iżda dan ma jolqotx neċessarjament il
l-informazzjoni kollha li inti tista 'tixtieq.

100
00:04:38,160 --> 00:04:41,118
>> Għalhekk jirriżulta li hemm tip ieħor
ta kamp li jista 'jkun utli hawnhekk

101
00:04:41,118 --> 00:04:46,040
f'database tipiku, imsejjaħ
ENUM, fejn dan huwa qasam karattru,

102
00:04:46,040 --> 00:04:50,480
imma inti, il-disinjatur, isiru
tenumera-valuri possibbli,

103
00:04:50,480 --> 00:04:54,630
bħal kwotazzjoni, unquote "maskili", kwotazzjoni,
unquote "mara" u oħrajn.

104
00:04:54,630 --> 00:04:57,620
Allura li kwalunkwe valur
huwa fid-database tiegħek,

105
00:04:57,620 --> 00:05:00,670
huwa tabilħaqq bbażati fuq il-karattru, iżda
għandu jkun wieħed minn dawn il-valuri.

106
00:05:00,670 --> 00:05:03,520
Aħna probabbilment ma tkunx tixtieq xi
ENUM għall-ewwel isem jew l-isem aħħar.

107
00:05:03,520 --> 00:05:05,630
Inkella rridu naraw
li jiġu nnumerati, bħala l-isem

108
00:05:05,630 --> 00:05:09,570
joħroġ mill-litteralment kull
possibbli l-ewwel isem u l-aħħar isem.

109
00:05:09,570 --> 00:05:13,960
>> OK, hekk ID x'għandu ID jkun?

110
00:05:13,960 --> 00:05:15,200
Iva, hekk forsi numru.

111
00:05:15,200 --> 00:05:17,870
Mela ejja twaħħal mal
li għal issa, in-numru.

112
00:05:17,870 --> 00:05:22,010
U bħala għadd, numru huwa
ftit wisq wiesa issa.

113
00:05:22,010 --> 00:05:23,900
Għall-aħħar tat-tieni
jum, inħoss bħal aħna

114
00:05:23,900 --> 00:05:25,280
għandu jkun ftit aktar preċiż.

115
00:05:25,280 --> 00:05:29,280
In-numru jista 'jfisser simili, huwa
jista 'jkun xi ħaġa bħal 1.236.

116
00:05:29,280 --> 00:05:31,500
U li probabbilment mhux
dak li rridu nfissru minn ID.

117
00:05:31,500 --> 00:05:34,635
What do we probabbilment jfisser minn ID?

118
00:05:34,635 --> 00:05:36,382
>> UDJENZA: [inaudible]

119
00:05:36,382 --> 00:05:38,590
DAVID Malan: Oh, OK, hekk
forsi huwa lanqas numru.

120
00:05:38,590 --> 00:05:42,840
Forsi huwa attwalment identifikatur uniku
li l string, bħal isem l-utent.

121
00:05:42,840 --> 00:05:44,580
Allura assolutament, jista 'jkun.

122
00:05:44,580 --> 00:05:46,730
Naħseb li xi ħadd probabbilment
fisser numerika, għalkemm.

123
00:05:46,730 --> 00:05:48,460
Mela ejja jibqgħu ma 'dak.

124
00:05:48,460 --> 00:05:49,320
Liema tip ta 'numru?

125
00:05:49,320 --> 00:05:51,960
X'hemm aktar precise-- integer.

126
00:05:51,960 --> 00:05:56,710
Allura numru bħall 0, 1, 2, 3,
hekk aħna ser sejħa dan integer.

127
00:05:56,710 --> 00:05:58,909
U anke dakinhar, stajt
jiġu nitpicking, huwa

128
00:05:58,909 --> 00:06:00,700
mhux verament ftit
numru sħiħ ġenerali li trid.

129
00:06:00,700 --> 00:06:04,340
Inti probabilment ma jridux valuri negattivi,
sempliċement minħabba, hija biss iħoss stramb.

130
00:06:04,340 --> 00:06:06,070
Inti probabilment tixtieq interi pożittivi.

131
00:06:06,070 --> 00:06:07,920
Allura inti tista 'wkoll tesprimi
li f'database,

132
00:06:07,920 --> 00:06:09,450
iżda għal issa, aħna ser ngħidu numru sħiħ.

133
00:06:09,450 --> 00:06:10,650
>> Email?

134
00:06:10,650 --> 00:06:13,550
Din hija probabbilment just-- ta 'dak?

135
00:06:13,550 --> 00:06:14,460
>> UDJENZA: [inaudible]

136
00:06:14,460 --> 00:06:16,980
>> DAVID Malan: Huwa ta 'email,
iżda li karattri, id-dritt?

137
00:06:16,980 --> 00:06:19,813
Hija biss għandha karattru funky bħal
ta ' "fi" simbolu jew xi ħaġa oħra,

138
00:06:19,813 --> 00:06:21,580
iżda huwa għadu qasam karattru.

139
00:06:21,580 --> 00:06:23,900
U l-indirizz postali?

140
00:06:23,900 --> 00:06:25,360
qasam Karattru.

141
00:06:25,360 --> 00:06:31,400
Allura li l-bidu sbieħ, iżda
ejja jkun ftit aktar preċiż issa.

142
00:06:31,400 --> 00:06:34,540
>> Għalhekk jirriżulta li fl
database, inti spiss

143
00:06:34,540 --> 00:06:39,120
għandhom għażla fuq aktar raffinati
verżjonijiet ta 'dawn l-affarijiet.

144
00:06:39,120 --> 00:06:44,330
Fil-fatt, fid-database SQL tipiku, SQL,
jew b'mod iktar ġenerali, id-database relazzjonali,

145
00:06:44,330 --> 00:06:46,680
databases ringieli
u kolonni, inti spiss

146
00:06:46,680 --> 00:06:53,610
nikseb biex tispeċifika mhux biss it-tip ta 'l-
field-- let me tagħmel xi here-- kamra

147
00:06:53,610 --> 00:06:56,600
iżda wkoll it-tul.

148
00:06:56,600 --> 00:06:59,900
>> Allura kemm żmien huwa l-ewwel isem?

149
00:06:59,900 --> 00:07:07,060
I think, D-A-V-I-D. OK, ltqajna I
probabbilment biss reċidiv bħal nofs

150
00:07:07,060 --> 00:07:11,260
tan-nies fil-kamra, id-dritt,
peress ismijiet tiegħek huma itwal minn ħames

151
00:07:11,260 --> 00:07:16,608
ittri, hekk ħamsa jidher egoist ftit
u naive, hekk x'hemm valur aħjar?

152
00:07:16,608 --> 00:07:19,320

153
00:07:19,320 --> 00:07:24,330
10, id-dritt, u naħseb
aħna qed OK fil-kamra.

154
00:07:24,330 --> 00:07:26,254
13?

155
00:07:26,254 --> 00:07:27,541
30?

156
00:07:27,541 --> 00:07:29,540
Għaliex ma I jieħdu l-
approċċ ta 'qabel meta aħna

157
00:07:29,540 --> 00:07:31,081
kienu jitkellem dwar arrays u l-memorja?

158
00:07:31,081 --> 00:07:32,450
Għaliex ma I biss ngħid simili 1000?

159
00:07:32,450 --> 00:07:35,260
Isem Ħadd ma huwa għaddej
li jkun itwal minn 1,000.

160
00:07:35,260 --> 00:07:36,706
Imbotta lura.

161
00:07:36,706 --> 00:07:38,005
>> UDJENZA: [inaudible]

162
00:07:38,005 --> 00:07:40,130
DAVID Malan: Yeah, huwa
ħalja, id-dritt, speċjalment

163
00:07:40,130 --> 00:07:44,630
jekk l-ismijiet l-aktar huma biss ħames jew 10 jew
15 karattri, li l-ħela ħafna.

164
00:07:44,630 --> 00:07:45,810
Allura inti taf liema?

165
00:07:45,810 --> 00:07:48,020
Din hija tip ta 'mistoqsija iebsa.

166
00:07:48,020 --> 00:07:51,721
Issa, nistgħu ċertament tanalizza l-Ingliż
u ismijiet kwalunkwe lingwa oħra

167
00:07:51,721 --> 00:07:54,470
u ċifra barra, ukoll, dak li huwa l-
medja average-- ma verament

168
00:07:54,470 --> 00:07:57,150
jgħinu us-- x'inhu l-mass hija
probabbilment dak li aħna verament irridu.

169
00:07:57,150 --> 00:07:59,920
Iżda jirriżulta aħna anke jkollhom
xi għażla dwar it-tip hawn.

170
00:07:59,920 --> 00:08:03,400
>> Fi SQL database tipiku, inti
jkunu xi ħaġa imsejħa qasam char

171
00:08:03,400 --> 00:08:07,505
u wkoll varchar, V-A-R,
għall-qasam char varjabbli.

172
00:08:07,505 --> 00:08:08,630
U d-differenza hija din.

173
00:08:08,630 --> 00:08:12,400
Qasam char, inti l-disinjatur,
għandek jispeċifikaw minn qabel

174
00:08:12,400 --> 00:08:14,900
it-tul eżatt tal-qasam.

175
00:08:14,900 --> 00:08:20,530
Hekk forsi l-ewwel isem
bħall 20 iħoss tip ta 'periklu.

176
00:08:20,530 --> 00:08:23,950
Jista 'jkollhom jagħmlu xi googling biex
tara jekk dan huwa fil-fatt sigura biżżejjed.

177
00:08:23,950 --> 00:08:26,910
Hemm probabbilment isem ma 21
karattri, iżda għal issa, ejja ngħidu 20

178
00:08:26,910 --> 00:08:27,620
huwa sigur.

179
00:08:27,620 --> 00:08:30,070
>> Qasam char ikun jimplika
f'database li inti

180
00:08:30,070 --> 00:08:33,289
huma jużaw 20 u dejjem 20 karattru.

181
00:08:33,289 --> 00:08:37,419
Issa jekk huwa biss D-A-V-I-D, 15 minnhom
huma biss se tkun karattri vojta,

182
00:08:37,419 --> 00:08:40,450
iżda int xorta tuża 20 bytes kollha.

183
00:08:40,450 --> 00:08:46,302
Qasam varchar, għall-kuntrarju, ifisser il-
sekwenza għandha tkun sa 20 karattru

184
00:08:46,302 --> 00:08:48,260
imma jekk huwa biss ħamsa,
int biss ser tuża

185
00:08:48,260 --> 00:08:51,270
ħames, jew forsi sitta għal
valur speċjali fl-aħħar,

186
00:08:51,270 --> 00:08:54,980
bħal dik 0 iddiskutejna dak
ifisser it-tmiem ta 'karattru

187
00:08:54,980 --> 00:08:56,790
sekwenza fil-memorja.

188
00:08:56,790 --> 00:08:59,950
>> Allura meta taħseb
inti tista 'tagħżel char

189
00:08:59,950 --> 00:09:05,240
versus varchar, peress li l-kummerċ ta 'darba?

190
00:09:05,240 --> 00:09:09,321
Char użi li ħafna karattri, varchar
użi mhux aktar minn li ħafna karattri.

191
00:09:09,321 --> 00:09:10,196
UDJENZA: [inaudible]

192
00:09:10,196 --> 00:09:13,859

193
00:09:13,859 --> 00:09:16,900
DAVID Malan: OK, meta inti taf l-
tul tas-sekwenza pjuttost konvinċenti

194
00:09:16,900 --> 00:09:19,316
li biss l-użu char, "kawża jekk
tkun taf, biss jitqiegħed l-isfel.

195
00:09:19,316 --> 00:09:23,390
U forsi dan huwa veru għal b'żipp
kodiċi, fl-Istati Uniti, mill-inqas, 02138,

196
00:09:23,390 --> 00:09:26,660
huwa dejjem se jkunu ħamsa
karattri sakemm inti żid il-sing erbgħa.

197
00:09:26,660 --> 00:09:29,750
Imma inti jista 'jkollhom xi valuri għal
li inti dejjem taf it-tul.

198
00:09:29,750 --> 00:09:32,310
Jew simboli istat forsi,
bħal NY għal New York,

199
00:09:32,310 --> 00:09:33,811
u ATS għall Massachusetts fl-Istati Uniti.

200
00:09:33,811 --> 00:09:36,560
Forsi inti għandek xi sitwazzjonijiet
fejn dan huwa totalment raġonevoli,

201
00:09:36,560 --> 00:09:39,520
iżda minn dak loġika, għaliex huma
aħna anke overthinking dan?

202
00:09:39,520 --> 00:09:41,800
Għaliex ma we biss użu
varchar u allura aħna ser biss

203
00:09:41,800 --> 00:09:46,730
dejjem jużaw żewġ karattri xorta waħda, jew
dejjem jużaw ħames karattri xorta?

204
00:09:46,730 --> 00:09:50,300
Għaliex mhux biss jiffranka varchar għall
dak kollu, billi din il-loġika?

205
00:09:50,300 --> 00:09:51,677
Għandu jkun hemm qabda.

206
00:09:51,677 --> 00:09:52,552
UDJENZA: [inaudible]

207
00:09:52,552 --> 00:09:54,952

208
00:09:54,952 --> 00:09:56,660
DAVID Malan: Jista
tikteb xi ħaġa ħażina.

209
00:09:56,660 --> 00:09:58,090
Allura dan huwa veru.

210
00:09:58,090 --> 00:10:01,030
Iżda anke dakinhar, dawn ma jistgħux jużaw
memorja aktar minn I jalloka.

211
00:10:01,030 --> 00:10:03,340
I għadhom l-aħħar
jgħidu fuq it-tul,

212
00:10:03,340 --> 00:10:06,780
b'mod li ma jistgħux aċċidentalment tagħmel
li żball, iżda riflessjoni tajba.

213
00:10:06,780 --> 00:10:10,510
Huwa aktar sottili, imma hija relatata ħafna
għad-diskussjoni tagħna, fil-fatt, ta 'arrays

214
00:10:10,510 --> 00:10:12,390
u l-listi marbuta preċedenti.

215
00:10:12,390 --> 00:10:16,290
>> Jirriżulta li database, jekk
dan jaf li kollha tal-valuri huma

216
00:10:16,290 --> 00:10:19,250
ta 'tul fiss, anki jekk
xi wħud minn dawk il-valuri huma vojta,

217
00:10:19,250 --> 00:10:22,484
tip ta 'estetikament vojta,
D-A-V-I-D u mbagħad 15 blanks,

218
00:10:22,484 --> 00:10:24,650
jirriżulta li jekk kull
-qasam huwa l-istess tul,

219
00:10:24,650 --> 00:10:28,670
ferm simili firxa kellha kollu Jittieħed tagħha
lura lura lura biex lura hekk li

220
00:10:28,670 --> 00:10:33,480
inti tista 'biss flimkien ma' 1 biex jiksbu l-jmiss
valur,-istess idea f'tabella database.

221
00:10:33,480 --> 00:10:37,550
Jekk kollha ta 'karattru tiegħek
kordi huma l-istess tul,

222
00:10:37,550 --> 00:10:39,390
għandek dak li sejjaħ aċċess bl-addoċċ.

223
00:10:39,390 --> 00:10:41,850
Jekk il-kordi huma ta '
Tul 20, inti ma biss

224
00:10:41,850 --> 00:10:45,230
do flimkien ma '1 inti biss tagħmel plus
20, kif ukoll 20, flimkien ma '20, flimkien ma' 20,

225
00:10:45,230 --> 00:10:48,775
u inti tista 'malajr ħafna iscroll permezz
jew tfittxija kollha tad-data tiegħek permezz.

226
00:10:48,775 --> 00:10:54,420
>> Qasam char varjabbli, għall-kuntrarju,
mhux dejjem ikollhom 20 karattru.

227
00:10:54,420 --> 00:10:58,000
Jista 'jkollhom 20 u mbagħad
15 u mbagħad 19 u mbagħad 10,

228
00:10:58,000 --> 00:11:00,720
u hekk jekk inti tixtieq li tfittex
permezz ta 'dan, inti ma tistax sempliċement bl-addoċċ

229
00:11:00,720 --> 00:11:03,050
żid 20 bytes biex jiksbu għal dak li jmiss.

230
00:11:03,050 --> 00:11:07,280
Inti litteralment ikollhom biex tfittex permezz
minħabba li l-tarf tal-istruttura tad-data,

231
00:11:07,280 --> 00:11:08,340
jekk inti se, huwa ragged.

232
00:11:08,340 --> 00:11:11,480
Huwa tip ta 'tmur fi u barra bbażata
fuq it-tul attwali tas-sekwenza.

233
00:11:11,480 --> 00:11:14,460
Allura meta inti taf l-tul, kif
Kareem jgħid, uża qasam char,

234
00:11:14,460 --> 00:11:16,460
għaliex inti jiksbu dak
effiċjenza li jkunu

235
00:11:16,460 --> 00:11:19,170
kapaċi li jfittxu permezz ta 'dan aktar malajr
meta inti qed tfittex għal data,

236
00:11:19,170 --> 00:11:20,550
inkella l-użu ta 'varjabbli.

237
00:11:20,550 --> 00:11:24,450
>> Sfortunatament, għandi l-ebda tweġiba tajba
biex kemm żmien l-isem għandu jkun,

238
00:11:24,450 --> 00:11:26,360
iżda għal xi ħaġa bħal
isem, nixtieq ngħid

239
00:11:26,360 --> 00:11:28,470
a varchar huwa komuni
għaliex mhuwiex ser

240
00:11:28,470 --> 00:11:30,430
li jkun ta 'tul fiss għal kulħadd.

241
00:11:30,430 --> 00:11:33,650
20, I do not know, 20
iħoss stretta ftit.

242
00:11:33,650 --> 00:11:36,460
Ejja ngħidu biss 50, 50.

243
00:11:36,460 --> 00:11:39,210
Hija ma verament jiswik li
ħafna aktar li jgħidu 50 minflok 40,

244
00:11:39,210 --> 00:11:41,260
iżda f'xi punt, inti għandek bżonn
tagħmel sejħa sentenza.

245
00:11:41,260 --> 00:11:43,090
>> Komuni ħafna, franchement,
għall [? storiku?]

246
00:11:43,090 --> 00:11:47,670
raġunijiet, anki jekk huwa eċċessiv,
jiġifieri 255, minħabba li xi żmien ilu,

247
00:11:47,670 --> 00:11:51,440
fis-sistemi tad-database popolari, bħal
MySQL, għodda b'xejn open source

248
00:11:51,440 --> 00:11:53,790
li ħafna kumpaniji
simili, anki Facebook użati,

249
00:11:53,790 --> 00:11:56,654
dan kien in-nuqqas massimu
sabiex in-nies biss marru miegħu.

250
00:11:56,654 --> 00:11:59,070
Allura mhux raġonevoli, iżda aħna ser
jużaw ftit aktar intwizzjoni

251
00:11:59,070 --> 00:12:02,970
u jgħidu, żgur 50, li l-
probabbilment ftit eċċessiv.

252
00:12:02,970 --> 00:12:05,720
>> Sess, I do simili ENUM,
u għalhekk aħna jistgħu għalhekk

253
00:12:05,720 --> 00:12:08,760
tenumera raġel jew mara,
jew forsi b'mod aktar effiċjenti,

254
00:12:08,760 --> 00:12:13,420
m jew f jew xi symbology oħra, iżda
ENUM iħoss bħal għażla tajba hemmhekk.

255
00:12:13,420 --> 00:12:16,740
Biex ikunu ċari, sess
jista 'jkun biss varchar,

256
00:12:16,740 --> 00:12:19,090
u nistgħu biss kollha
jaqbel nies kif sbieħ,

257
00:12:19,090 --> 00:12:21,010
li dejjem tpoġġi l-istess valuri hemmhekk.

258
00:12:21,010 --> 00:12:22,720
Maskili jew femminili jew whatnot.

259
00:12:22,720 --> 00:12:27,800
>> Iżda l-problema allura, huwa li nistgħu
tagħmel żball, kif [inaudible] propost

260
00:12:27,800 --> 00:12:29,140
qabel f'kuntest differenti.

261
00:12:29,140 --> 00:12:32,780
Jekk nagħmlu żball, nistgħu jiksbu
Valuri skorretti fid-database tagħna.

262
00:12:32,780 --> 00:12:36,320
Allura x'hemm sbieħ dwar bażijiet ta 'dejta
bħal Oracle u MySQL u oħrajn,

263
00:12:36,320 --> 00:12:39,280
huwa li inti għandek din l-aħħar
saff ta 'difiża fejn

264
00:12:39,280 --> 00:12:43,010
tiegħek amministratur DBA, id-database,
min qed tfassal din it-tabella simili aħna

265
00:12:43,010 --> 00:12:46,440
huma verbalment, tista 'tpoġġi
fis-seħħ ta 'ENUM li

266
00:12:46,440 --> 00:12:51,250
jipproteġi kontra dik billi tispeċifika
irġiel, nisa, u għalhekk l-ebda waħda

267
00:12:51,250 --> 00:12:54,230
inkella mhux programmer tista aċċidentalment
daħħal kwalunkwe valur ieħor.

268
00:12:54,230 --> 00:12:55,480
Allura dan tkun ħaġa tajba.

269
00:12:55,480 --> 00:12:56,660
Din hija karatteristika.

270
00:12:56,660 --> 00:13:00,760
>> Allura ID, jekk wieħed jassumi ID numerika, dan
probabbilment għandha tkun numru sħiħ pożittiv.

271
00:13:00,760 --> 00:13:04,380
U aħna kultant ma jkollhom
opportunità li jiddiskutu tul.

272
00:13:04,380 --> 00:13:06,830
Inti ma tkunx tipikament
tispeċifika numru hawnhekk,

273
00:13:06,830 --> 00:13:11,310
inti minflok tispeċifika
dan huwa int, jew int kbir,

274
00:13:11,310 --> 00:13:12,980
kif dawn qed tipikament imsejħa.

275
00:13:12,980 --> 00:13:18,840
Iżda tipikament, integer
Ikun, ejja ngħidu, 4 bytes.

276
00:13:18,840 --> 00:13:23,694
U jekk huwa 4 bytes,
li kif ħafna bits?

277
00:13:23,694 --> 00:13:24,630
>> UDJENZA: [inaudible]

278
00:13:24,630 --> 00:13:26,610
>> DAVID Malan: 32 bits.

279
00:13:26,610 --> 00:13:30,270
Allura kif ħafna utenti jistgħu għandna fil
database tagħna, jekk dawn kollha jkollhom identità

280
00:13:30,270 --> 00:13:33,320
u dan ID għandu jkun uniku?

281
00:13:33,320 --> 00:13:36,780
32 bits tfisser li għandna mudelli
ta 'wieħed, tnejn, tlieta, erba, five--

282
00:13:36,780 --> 00:13:41,000
mudelli differenti hekk kif ħafna mill żerijiet
u dawk jista 'jkollok jekk ikun hemm 32?

283
00:13:41,000 --> 00:13:43,235
Dik hija l-istess ħaġa bħat
tistaqsi x'inhu tnejn għall-32?

284
00:13:43,235 --> 00:13:46,472

285
00:13:46,472 --> 00:13:48,430
Huwa numru kbir li
Ma nistax pjuttost tikseb id-dritt,

286
00:13:48,430 --> 00:13:50,270
imma naf li huwa bejn wieħed u ieħor 4 biljun.

287
00:13:50,270 --> 00:13:53,970
Allura dan ifisser it-tabella database tiegħek jista
jkollhom erba biljun utenti u li hu.

288
00:13:53,970 --> 00:13:56,410
>> Allura dan huwa interessanti
implikazzjoni disinn.

289
00:13:56,410 --> 00:14:00,840
Għadd deċenti ta 'kumpaniji
iddeċidew, forsi mhux tant

290
00:14:00,840 --> 00:14:04,860
għall-mejda utenti tagħhom, minħabba li jkollhom
4 biljun utenti hija problema rari.

291
00:14:04,860 --> 00:14:08,410
Din hija tip ta 'Facebook stil
problema, mhux problema kumpanija tipika.

292
00:14:08,410 --> 00:14:12,670
Imma forsi jekk għandek reġistri tat-tranżazzjonijiet
jew xi tip ta 'data li kontinwament

293
00:14:12,670 --> 00:14:15,610
gets miktuba fid-database tiegħek
li assolutament jista 'jkollhom biljuni

294
00:14:15,610 --> 00:14:18,900
u biljuni ta 'ringieli, u
tuża integer għal dan,

295
00:14:18,900 --> 00:14:22,750
x'inhu jiġri malajr kemm jista '
ikollok biex ringiela numru 4000000000

296
00:14:22,750 --> 00:14:26,210
u allura inti tipprova li daħħal il-
4000000000 u 1, biex ngħidu hekk?

297
00:14:26,210 --> 00:14:29,610
Jien simplifikazzjoni-numri daqsxejn.

298
00:14:29,610 --> 00:14:33,740
>> Tista maqtugħin lura, I jfissirx li inti
jkollhom jittrattaw qualche.

299
00:14:33,740 --> 00:14:37,910
U liema kompjuter tipikament do,
taħseb dwarha anki minn dalgħodu,

300
00:14:37,910 --> 00:14:42,430
jekk għandek valur 4-bit
bħal 1, 1, 1, 1, li,

301
00:14:42,430 --> 00:14:44,920
biss li jiġu kkonsolidati l għodu
flimkien mal-wara nofsinhar, liema

302
00:14:44,920 --> 00:14:48,369
ma dan in-numru jirrappreżenta fil binarju?

303
00:14:48,369 --> 00:14:49,410
OK, aħna ser jagħmilha aktar faċli.

304
00:14:49,410 --> 00:14:53,310
Xi jfisser dan in-numru
rappreżentati f binarju?

305
00:14:53,310 --> 00:14:56,794
OK, aħna ser jagħmilha aktar faċli, liema
ma dan jirrappreżenta fil binarju?

306
00:14:56,794 --> 00:14:57,460
UDJENZA: Tliet.

307
00:14:57,460 --> 00:14:59,670
DAVID Malan: Tliet, għaliex
għandna dawk column--

308
00:14:59,670 --> 00:15:00,450
[Rires]

309
00:15:00,450 --> 00:15:01,350
Whew!

310
00:15:01,350 --> 00:15:03,980
Kellna l-kolonna dawk
u l-kolonna twos.

311
00:15:03,980 --> 00:15:07,250
Allura jissoponi li, tabilħaqq, tagħna
[? infield?] ma kinux 32 bit,

312
00:15:07,250 --> 00:15:13,440
iżda kienu żewġ bits, nistgħu
jgħodd min-numru 0, 1, 2, 3 utent,

313
00:15:13,440 --> 00:15:18,040
u allura aħna qed tip ta '
lura għall-utent 00 ġdid.

314
00:15:18,040 --> 00:15:19,739
Allura dan huwa dak li tipikament jiġri.

315
00:15:19,739 --> 00:15:22,780
Jekk inti stajt qatt semgħu l expression--
probabbilment ma jkunux, imma jekk int have--

316
00:15:22,780 --> 00:15:26,500
overflow numru sħiħ, fejn inti
iżommu flipping kollha ta 'bits tiegħek

317
00:15:26,500 --> 00:15:29,640
li huma l-valuri akbar possibbli,
u mbagħad int barra ta 'bits,

318
00:15:29,640 --> 00:15:30,850
dak li tipikament jiġri?

319
00:15:30,850 --> 00:15:32,280
Għaliex għandi ngħid 00?

320
00:15:32,280 --> 00:15:33,220
Ukoll, dan huwa tlieta.

321
00:15:33,220 --> 00:15:34,230
Kif nista jirrappreżentaw 4?

322
00:15:34,230 --> 00:15:36,890

323
00:15:36,890 --> 00:15:38,915
Kif nista jirrappreżentaw il-
għal numru 4 fil binarju?

324
00:15:38,915 --> 00:15:39,790
UDJENZA: [inaudible]

325
00:15:39,790 --> 00:15:41,780
DAVID Malan: One-- yeah,
ma jgħidux 100 per se,

326
00:15:41,780 --> 00:15:44,190
minħabba li għandha l żbaljata
konnotazzjoni, iżda 1-0-0.

327
00:15:44,190 --> 00:15:48,920
Allura dak in-numru 1-0-0 huwa tabilħaqq
korretta, imma jekk inti biss għandek żewġ bits,

328
00:15:48,920 --> 00:15:50,820
dak usted verament isir?

329
00:15:50,820 --> 00:15:53,219
You ħadthom tinqaleb għal 00.

330
00:15:53,219 --> 00:15:54,760
U fil-fatt, dan huwa dak li jiġri.

331
00:15:54,760 --> 00:15:56,884
Attwalment, inti tista 'taħseb
dwar dan aktar familjari.

332
00:15:56,884 --> 00:15:59,350
Jekk inti recall, liema,
16-il sena ilu, id-dinja

333
00:15:59,350 --> 00:16:03,380
suppost kellha tintemm meta
il-problema Y2K ġara.

334
00:16:03,380 --> 00:16:04,330
Għaliex kien li?

335
00:16:04,330 --> 00:16:08,170
Ukoll kompjuters aktar, għall
deċiżjonijiet raġonevoli,

336
00:16:08,170 --> 00:16:15,320
kienu ħażna numri bħall-
sena 1975 jew is-sena 1999

337
00:16:15,320 --> 00:16:19,010
bi ftit użu ta 'żewġ ċifri
fil-memorja tal-kompjuter.

338
00:16:19,010 --> 00:16:21,950
Allura naturalment, dak li jiġri
meta ikollok is-sena 2000,

339
00:16:21,950 --> 00:16:25,790
inti tmur għal dan, jew minflok, yeah.

340
00:16:25,790 --> 00:16:30,120
Allura inti tmur għas-sena 2000, imma jekk
int biss billi jintużaw żewġ figuri li jistenna

341
00:16:30,120 --> 00:16:32,660
bħall-sena 00 u
sabiex inti ħadthom tinqaleb.

342
00:16:32,660 --> 00:16:36,820
U dan huwa għaliex ħafna sistemi
hemm bżonn li jiġu aġġornati fil-ħin.

343
00:16:36,820 --> 00:16:42,500
>> Allura ma 'dak imsemmi, kumpaniji bħal
Facebook run up kontra din il.

344
00:16:42,500 --> 00:16:46,147
Allura l-uniku mod biex jimmaniġġaw il-
sitwazzjoni, franchement, huwa li jantiċipaw dan.

345
00:16:46,147 --> 00:16:47,980
Jew l-aktar nodfa mod biex
jimmaniġġjaw din is-sitwazzjoni

346
00:16:47,980 --> 00:16:50,330
huwa li jiġu antiċipati sabiex inti ma
għandek tagħmel bidliet aktar tard.

347
00:16:50,330 --> 00:16:51,970
Allura minflok ta '8 bytes, inti taf liema?

348
00:16:51,970 --> 00:16:54,261
Jien ser tkun tħares 'ħsieb
hawn, anki jekk huwa

349
00:16:54,261 --> 00:16:56,760
ftit ottimista li
aħna qed tmur biex ikollhom 4000000000

350
00:16:56,760 --> 00:16:58,850
u 1-utenti fuq il-websajt tagħna.

351
00:16:58,850 --> 00:17:01,790
Imma ejja biss użu 8 bytes, jew
64 bits, li ġeneralment ikunu

352
00:17:01,790 --> 00:17:05,640
imsejħa numru sħiħ kbir, ħafna tekniku.

353
00:17:05,640 --> 00:17:10,280
U dan ifisser biss inti jista 'jkollhom
saħansitra aktar ċifri fin-numru tiegħek.

354
00:17:10,280 --> 00:17:12,599
Iżda dan huwa importanti
deċiżjoni tad-disinn,

355
00:17:12,599 --> 00:17:16,400
għaliex jekk inti tagħżel numru li
għandu ftit wisq bits ta 'expressiveness

356
00:17:16,400 --> 00:17:19,089
inti tista 'attwalment toħloq
bug fis-software tiegħek.

357
00:17:19,089 --> 00:17:21,750
>> Kull dritt, hekk ejja nagħlaq
bl-email u l-indirizz postali.

358
00:17:21,750 --> 00:17:26,369
Allura email, kemm żmien għandha
email address jkun?

359
00:17:26,369 --> 00:17:26,869
50.

360
00:17:26,869 --> 00:17:29,220
I really ma jkollu ebda idea, imma hija
probabbilment xi ħaġa bħal dik,

361
00:17:29,220 --> 00:17:32,261
għax inkella l-ebda wieħed għaddej biex
tikteb int jekk jiġrilha wisq twil, hekk 50,

362
00:17:32,261 --> 00:17:33,360
ejja jmorru magħha għal issa.

363
00:17:33,360 --> 00:17:35,770
indirizz postali, kemm żmien jekk dan ikun?

364
00:17:35,770 --> 00:17:38,325

365
00:17:38,325 --> 00:17:39,200
UDJENZA: [inaudible]

366
00:17:39,200 --> 00:17:41,900

367
00:17:41,900 --> 00:17:43,890
>> DAVID Malan: Mhuwiex
biss zip code, għalkemm.

368
00:17:43,890 --> 00:17:45,720
indirizz postali, Smajt.

369
00:17:45,720 --> 00:17:50,720
Allura dan huwa simili 1 BRATTLE Square,
comma, Cambridge Massa., comma, 02138.

370
00:17:50,720 --> 00:17:53,860
U fil-fatt, let me biss pull
up worksheet ftit hawn.

371
00:17:53,860 --> 00:17:56,510
Din il iħoss simili huwa
opportunità mitlufa.

372
00:17:56,510 --> 00:18:01,480
Jekk għandna 1 BRATTLE Square,
comma, Cambridge MA 02138,

373
00:18:01,480 --> 00:18:04,510
Inħoss bħal nistgħu nagħmlu aħjar
milli indirizz postali sempliċiment.

374
00:18:04,510 --> 00:18:07,100
Għaliex ma we jisplodu dan ftit?

375
00:18:07,100 --> 00:18:08,030
What am I jkollna fi?

376
00:18:08,030 --> 00:18:10,970
X'għandu għandna minflok għandna
għall ringieli tagħna hawn, forsi?

377
00:18:10,970 --> 00:18:12,260
>> UDJENZA: [inaudible]

378
00:18:12,260 --> 00:18:17,579
>> DAVID Malan: Yeah, hekk ejja
sejħa hija street_number,

379
00:18:17,579 --> 00:18:20,620
u underscore huwa biss komuni
Mod ta 'wara dak qisu ispazju,

380
00:18:20,620 --> 00:18:22,360
iżda mhux, fil-fatt.

381
00:18:22,360 --> 00:18:26,240
Triq, u mbagħad city-- sorry?

382
00:18:26,240 --> 00:18:28,440
>> UDJENZA: [inaudible]

383
00:18:28,440 --> 00:18:29,690
DAVID Malan: Stajna nagħmlu dan.

384
00:18:29,690 --> 00:18:30,702
Linja waħda, linja tnejn.

385
00:18:30,702 --> 00:18:32,410
Għaliex ma we se żżomm
sempliċi għal issa,

386
00:18:32,410 --> 00:18:34,840
iżda li assolutament
deċiżjoni aċċettabbli.

387
00:18:34,840 --> 00:18:38,180
U mbagħad istat, u mbagħad ejja
jkun ftit Istati Uniti iċċentrati għal issa

388
00:18:38,180 --> 00:18:42,040
u biss tagħmel zip code, sempliċement minħabba
dan ser iwassal għal żball interessanti

389
00:18:42,040 --> 00:18:43,090
jew problema hawn.

390
00:18:43,090 --> 00:18:44,655
Allura jissoponi li issa ż-indirizz tagħna.

391
00:18:44,655 --> 00:18:47,280
Huwa ftit aktar tedjanti li
aħna għandna kull f'dawn l-oqsma aktar,

392
00:18:47,280 --> 00:18:49,200
iżda issa nistgħu tag
affarijiet ftit aħjar.

393
00:18:49,200 --> 00:18:53,210
>> Numru Allura issa triq probabbilment
m'għandhiex tkun char, jekk dan?

394
00:18:53,210 --> 00:18:54,835
X'għandu jkun?

395
00:18:54,835 --> 00:18:55,710
UDJENZA: [inaudible]

396
00:18:55,710 --> 00:18:57,835
DAVID Malan: Forsi, numru
bħal integer mill-ġdid?

397
00:18:57,835 --> 00:19:00,170
A eqreb numru sħiħ big?

398
00:19:00,170 --> 00:19:02,170
Inti probabilment ma jgħixux
fil 4000000000 Main Street

399
00:19:02,170 --> 00:19:03,490
jew xi ħaġa crazy bħal dik.

400
00:19:03,490 --> 00:19:06,850
Allura numru sħiħ huwa probabbilment
multa, iżda għandha xi ħadd

401
00:19:06,850 --> 00:19:13,880
qatt għex f'indirizz simili
1A BRATTLE Pjazza, jew 1 u 1/2?

402
00:19:13,880 --> 00:19:17,030
Dawn l-affarijiet jeżistu, sfortunatament,
anki jekk int ma għexu hemmhekk,

403
00:19:17,030 --> 00:19:21,240
hemm dawn l-anomaliji
bħal appartament 1A, 1B, 1C.

404
00:19:21,240 --> 00:19:24,260
Allura inti taf liema, aħna probabbilment
m'għandhomx imorru mal numru sħiħ,

405
00:19:24,260 --> 00:19:27,440
inkella aħna qed tmur
li jitilfu xi bejgħ.

406
00:19:27,440 --> 00:19:29,920
>> qasam Char, forsi?

407
00:19:29,920 --> 00:19:30,870
I do not know kemm żmien.

408
00:19:30,870 --> 00:19:33,370
Huwa probabbilment mhux se tkun
dak twil, hekk 10 jew xi ħaġa.

409
00:19:33,370 --> 00:19:34,950
Ebda wieħed għaddej biex jikteb
numru itwal, forsi.

410
00:19:34,950 --> 00:19:37,070
Iżda għal darb'oħra, għandna probabbilment
jagħtu aktar riflessjoni għal dan.

411
00:19:37,070 --> 00:19:39,900
Forsi google, jagħmlu xi riċerka,
iżda aħna ser jmorru ma imsaren tagħna għal issa.

412
00:19:39,900 --> 00:19:44,565
Toroq, char, 50, I do not know.

413
00:19:44,565 --> 00:19:46,940
F'xi punt, l-ebda wieħed għaddej
li tikteb fuq envelop,

414
00:19:46,940 --> 00:19:49,350
wisq, sabiex hemm probabilment
xi limiti ta 'fuq hemmhekk.

415
00:19:49,350 --> 00:19:54,200
Belt,-istess, żgur, hekk char 50.

416
00:19:54,200 --> 00:19:59,120
>> Istat, jista 'jkun Istati Uniti iċċentrati għal issa.

417
00:19:59,120 --> 00:20:01,850
Għalhekk jista 'jkun lista, tant tip
ta 'sejħa sentenza, l-istat.

418
00:20:01,850 --> 00:20:04,000
Dan jista 'jkun bħal żewġ karattri.

419
00:20:04,000 --> 00:20:06,140
Allura fil-fatt, forsi, I tinżamm qal char.

420
00:20:06,140 --> 00:20:09,420
I probabbilment tfisser varchar,
biss għal xi wħud effiċjenza,

421
00:20:09,420 --> 00:20:12,240
iżda aħna ser terga 'lura għal
dik id-deċiżjoni fil-mument.

422
00:20:12,240 --> 00:20:16,150
Jista 'jkun char ta' tul 2 għall-istat.

423
00:20:16,150 --> 00:20:20,670
Jekk fl-Istati Uniti huma għandhom, bħall MA,
Massachusetts, NY, New York, NJ, New

424
00:20:20,670 --> 00:20:22,100
Jersey, u oħrajn.

425
00:20:22,100 --> 00:20:23,630
Għalhekk jista 'jiġi iffissat għal dik.

426
00:20:23,630 --> 00:20:25,900
DC għall f'Washington DC.

427
00:20:25,900 --> 00:20:29,915
>> Imma naħseb, Olivier, inti
propost approċċ ieħor.

428
00:20:29,915 --> 00:20:30,790
UDJENZA: [inaudible]

429
00:20:30,790 --> 00:20:33,670
DAVID Malan: Yeah, dan huwa ta '
ftit annoying li tip,

430
00:20:33,670 --> 00:20:37,890
iżda ENUM jista 'jagħmel aktar sens,
għaliex b'dan il-mod, għall-inqas fl-Istati Uniti,

431
00:20:37,890 --> 00:20:41,320
inti tista 'tenumera, jekk tediously, iżda
inti tagħmel dan darba biss fid-database tiegħek

432
00:20:41,320 --> 00:20:47,480
u qatt ma jerġa 'jkollhom biex jaħsbu dwar
dan, kodiċijiet kollha 50 b'żewġ karattri.

433
00:20:47,480 --> 00:20:48,660
So I simili ENUM.

434
00:20:48,660 --> 00:20:51,720
Ejja twaħħal ma 'dak hemm, għaliex
dan it-tip ta 'tinforza aktar rigorożità.

435
00:20:51,720 --> 00:20:53,620
U allura zip kodiċi?

436
00:20:53,620 --> 00:20:55,306
Naħseb Andrew kellhom ħasbu fuq li

437
00:20:55,306 --> 00:20:56,180
UDJENZA: [inaudible]

438
00:20:56,180 --> 00:20:57,240
DAVID Malan: Yeah, ħames jew disgħa.

439
00:20:57,240 --> 00:20:58,323
Ejja biss jżommha sempliċi.

440
00:20:58,323 --> 00:20:59,380
Just do ħamsa għal issa.

441
00:20:59,380 --> 00:21:03,070
Imma forsi I jistgħu biss
do integer, id-dritt?

442
00:21:03,070 --> 00:21:08,750
I tista ', imma inti taf liema, I magħmula
dan l-iżball darba, f'xi sens.

443
00:21:08,750 --> 00:21:13,110
Snin ilu, I kien jemigra minn
Microsoft Outlook għall-Gmail,

444
00:21:13,110 --> 00:21:18,640
u l-Prospettivi għandu mod ta 'l-esportazzjoni
kollha tal-kuntatti tiegħek bħala fajl Excel,

445
00:21:18,640 --> 00:21:21,280
fajl CSV, comma separati valuri fajl.

446
00:21:21,280 --> 00:21:23,950
UI għamel l-iżball, I
think, ta doppja tikklikkja dan,

447
00:21:23,950 --> 00:21:27,380
ladarba I jitniżżel l-esportazzjoni, li
kun żgur deher li stennejt.

448
00:21:27,380 --> 00:21:31,320
I irid ikun hit Save jew mikrija
auto-jiffrankaw il kick in jew xi ħaġa.

449
00:21:31,320 --> 00:21:35,100
Għaliex meta I imbagħad importat
fis Gmail, dan kollu maħduma.

450
00:21:35,100 --> 00:21:39,910
Iżda għas-snin, din il-ġurnata, u
Jien għamilt dan ħamsa, 10 snin ilu,

451
00:21:39,910 --> 00:21:44,380
Jien xorta jsibu ħbieb li għandhom
indirizzi li jixbhu dan l.

452
00:21:44,380 --> 00:21:45,700
Għaliex?

453
00:21:45,700 --> 00:21:47,900
>> UDJENZA: [inaudible]

454
00:21:47,900 --> 00:21:50,650
>> DAVID Malan: Hija ħadet
il 0, ukoll, pjuttost,

455
00:21:50,650 --> 00:21:53,810
ħa l-kodiċi zip kollha bħala
numru, u għalhekk huwa

456
00:21:53,810 --> 00:21:56,590
riskju ta '0 ewlieni li jfisser
ma jkollu ebda tifsira.

457
00:21:56,590 --> 00:21:59,470
U hekk 2138 jidher li jkun zip code tiegħi.

458
00:21:59,470 --> 00:22:07,100
U dan huwa, franchement, annoying Excel
Karatteristika li bihom Naħseb fil-kontumaċja,

459
00:22:07,100 --> 00:22:10,980
anki jekk huwa maħsub għal ftit
jkun it-test, Microsoft Excel

460
00:22:10,980 --> 00:22:13,780
jiddeċiedi, let me jkun utli,
oh u, nara numri biss.

461
00:22:13,780 --> 00:22:15,290
Ejja jittrattaw dawn bħala numri.

462
00:22:15,290 --> 00:22:16,790
U taqta 'l-żerijiet ewlenin.

463
00:22:16,790 --> 00:22:19,165
>> Jiena naħlef li Alla, kull koppja
ta 'xhur nsib l-indirizz,

464
00:22:19,165 --> 00:22:22,300
u barra ta 'tip ta' OCD, mmur lura
fi u żid 0, anki jekk I qatt ma

465
00:22:22,300 --> 00:22:23,700
tibgħat ittri nies jew xejn.

466
00:22:23,700 --> 00:22:25,510
Imma jien xorta jsibu fdalijiet ta 'dan il-.

467
00:22:25,510 --> 00:22:28,820
Allura dan huwa li jgħidu, hija din idea tajba?

468
00:22:28,820 --> 00:22:31,610
OK, l-ebda, minħabba li xi ħadd fil
Massachusetts, f'dan il-qasam,

469
00:22:31,610 --> 00:22:33,270
se jkun hemm o jwassal għalihom.

470
00:22:33,270 --> 00:22:38,070
Mela ejja jmorru ma simili
char, probabbilment, ħamsa.

471
00:22:38,070 --> 00:22:41,450
>> U hawn, tirrealizza aħna
tista 'tuża l-ENUM u aħna

472
00:22:41,450 --> 00:22:44,600
jista tenumera 10000
kodiċijiet possibbli zip,

473
00:22:44,600 --> 00:22:48,530
iżda li jħoss simili huwa probabbilment
jaqsmu linja ta ', bħal, benefiċċji.

474
00:22:48,530 --> 00:22:51,350
Jekk għandek l-input li
ħafna dejta fis-database tiegħek

475
00:22:51,350 --> 00:22:52,940
biex jipproteġu kontra xi ħaġa.

476
00:22:52,940 --> 00:22:57,400
Allura char realizzati inti tista tip
fil-H-E L-L-O kif zip code tiegħek,

477
00:22:57,400 --> 00:22:59,180
li mhuwiex, ovvjament, numeriċi.

478
00:22:59,180 --> 00:23:01,680
Hekk hemm ebda mod, fl
database tipiku,

479
00:23:01,680 --> 00:23:05,561
biex jispeċifikaw biss numerika u
biss ħames karattri twil,

480
00:23:05,561 --> 00:23:07,310
hekk aħna qed tmur biex ikollhom
biex tagħmel dan fil-kodiċi.

481
00:23:07,310 --> 00:23:11,100
Aħna qed tmur biex tagħmel dan fil-PHP jew
Java jew kwalunkwe lingwa nkunu

482
00:23:11,100 --> 00:23:14,230
jużaw fuq is-server biex jinfurzaw
dak it-tip ta 'restrizzjoni.

483
00:23:14,230 --> 00:23:14,860
>> Whoo!

484
00:23:14,860 --> 00:23:18,322
Kull dritt, hekk xi mistoqsijiet għadha biss?

485
00:23:18,322 --> 00:23:19,780
Ejja jagħmlu deċiżjoni oħra tad-disinn.

486
00:23:19,780 --> 00:23:22,500
Jirriżulta li inti
wkoll tikseb biex jagħżlu,

487
00:23:22,500 --> 00:23:26,600
meta titfassal SQL database, jew
database-- tipiċi relazzjonali fejn

488
00:23:26,600 --> 00:23:28,790
għal darb'oħra, relazzjonali biss
tfisser ringieli u kolonni,

489
00:23:28,790 --> 00:23:35,500
li kif inti torganizza data-- tiegħek
u jirrealizzaw li dak li dan ifisser huwa,

490
00:23:35,500 --> 00:23:37,740
Stajt ġiet qarrieqa fil
li, jien drawing-- din il

491
00:23:37,740 --> 00:23:40,190
huwa dak li sejjaħ il-schema
għal tabella database.

492
00:23:40,190 --> 00:23:42,810
Dan huwa simili l-
speċifikazzjonijiet għall-table--

493
00:23:42,810 --> 00:23:48,040
iżda meta niġu żmien
li attwalment jaħżen id-data,

494
00:23:48,040 --> 00:23:52,081
u aħna ser nagħmlu dan biss bl-eżempju hawn.

495
00:23:52,081 --> 00:23:55,080
Jien ser jiftħu Excel, għaliex
Excel se tagħti me ringieli u kolonni.

496
00:23:55,080 --> 00:23:58,050
U dan huwa eżattament dak Oracle u
MySQL u għodod oħra se tagħti me.

497
00:23:58,050 --> 00:24:02,270
Hekk jien biss ser tuża
huwa f'ġieħ-diskussjoni tal.

498
00:24:02,270 --> 00:24:05,250
Let me imorru quddiem u tiftaħ
dokument rappreżentattiv hawn,

499
00:24:05,250 --> 00:24:06,310
zoom ftit.

500
00:24:06,310 --> 00:24:15,200
Allura per eżempju, headers tagħna huma issa
ewwel isem, isem l-aħħar, is-sess, identità,

501
00:24:15,200 --> 00:24:20,980
email, in-numru tat-triq, triq, Whoops.

502
00:24:20,980 --> 00:24:25,710
Triq, belt, statali, kemm
dwar joqgħod fuq l-iskrin.

503
00:24:25,710 --> 00:24:29,080
>> Allura dak li dan ifisser huwa li meta
utent ewwel reġistri għall-website tiegħi,

504
00:24:29,080 --> 00:24:32,880
li għaddej biex tkun xi ħaġa simili
David, Malan, m, ejja ngħidu 1,

505
00:24:32,880 --> 00:24:42,910
malan@harvard.edu, in-numru tat-triq se
jkun simili 1 BRATTLE Pjazza, Cambridge, MA,

506
00:24:42,910 --> 00:24:44,780
02138, u mbagħad oħrajn.

507
00:24:44,780 --> 00:24:48,290
Allura meta nerġa 'ngħid li database relazzjonali
jew database SQL huwa ringieli u kolonni,

508
00:24:48,290 --> 00:24:49,350
I tfisser dan.

509
00:24:49,350 --> 00:24:51,900
Li d-data attwali hija maħżuna
fir-ringieli u kolonni.

510
00:24:51,900 --> 00:24:53,950
Dan huwa biss koinċidenza,
li konna nitkellmu,

511
00:24:53,950 --> 00:24:56,033
u I kien biss tpinġija dan
fir-ringieli u kolonni.

512
00:24:56,033 --> 00:24:58,320
Dan huwa biss il schema,
id-definizzjoni ġenerali.

513
00:24:58,320 --> 00:25:01,640
>> Allura ta 'dawn l-oqsma hawn,
jew b'mod ekwivalenti, hemm,

514
00:25:01,640 --> 00:25:06,270
li huma l-oqsma li taħseb
Jien probabbli li tfittxija fuq jekk jien utent

515
00:25:06,270 --> 00:25:09,200
jew jekk jien l-amministratur database?

516
00:25:09,200 --> 00:25:12,426
Bħal, liema oqsma am I
fil-fatt se tfittex fuq?

517
00:25:12,426 --> 00:25:13,830
>> UDJENZA: [inaudible]

518
00:25:13,830 --> 00:25:17,690
>> DAVID Malan: L-isem, yeah hekk
I bħall-fatt that-- yeah,

519
00:25:17,690 --> 00:25:19,750
posta elettronika jista 'jkun pjuttost komuni.

520
00:25:19,750 --> 00:25:21,440
Jiddispjacini, inti qal isem.

521
00:25:21,440 --> 00:25:24,030
Allura maybe-- u għal darb'oħra, aħna qed
tip ta 'jitkellem b'mod astratt.

522
00:25:24,030 --> 00:25:25,988
I do not know għaliex youd
tkun tiftix għal isem,

523
00:25:25,988 --> 00:25:29,340
iżda li jħoss raġonevoli jekk
int tiftix għal utent.

524
00:25:29,340 --> 00:25:31,170
Forsi jgħid, żgur, ID.

525
00:25:31,170 --> 00:25:34,100

526
00:25:34,100 --> 00:25:36,160
>> U huwa jiżolqux
inklinazzjoni, minħabba I tista

527
00:25:36,160 --> 00:25:38,890
contrive xenarju fejn
forsi boxxla tiegħi staqsa lili,

528
00:25:38,890 --> 00:25:40,417
kif ħafna rġiel għandna fis-sit tagħna?

529
00:25:40,417 --> 00:25:42,000
Kemm in-nisa nistgħu jkollhom fuq is-sit tagħna?

530
00:25:42,000 --> 00:25:45,210
U hekk f'dak il-punt, inti tista 'tixtieq
li tfittxija fuq il-qasam tas-sessi, wisq,

531
00:25:45,210 --> 00:25:45,940
u xejn iżjed.

532
00:25:45,940 --> 00:25:47,350
Allura hemm kompromess hawn.

533
00:25:47,350 --> 00:25:49,180
Għal darb'oħra, hemm ebda
risposta dritt, imma hemm

534
00:25:49,180 --> 00:25:53,760
hija karatteristika f'ħafna databases SQL
magħrufa bħala indiċjar, fejn

535
00:25:53,760 --> 00:25:56,100
inti, il-disinjatur, il-
amministratur database,

536
00:25:56,100 --> 00:26:01,730
nikseb biex jiddeċiedu minn qabel liema
Oqsma id-database għandha tottimizza

537
00:26:01,730 --> 00:26:02,980
għal tfittxijiet fuq.

538
00:26:02,980 --> 00:26:07,620
>> Inti tista 'naively ħafna jgħidu, jottimizzaw
dan, jottimizzaw li, jottimizzaw dan,

539
00:26:07,620 --> 00:26:10,300
jottimizzaw dan u dan,
u d-database se

540
00:26:10,300 --> 00:26:14,882
tagħmel xi ħaġa maġika taħt il-
barnuża, u jagħmel xi ħaġa b'mod

541
00:26:14,882 --> 00:26:17,090
li l-ħin li jmiss inti tfittex
fuq kwalunkwe wieħed minn dawn l-oqsma,

542
00:26:17,090 --> 00:26:18,400
se, fil-fatt, tkun iktar mgħaġġla.

543
00:26:18,400 --> 00:26:19,110
Dan huwa possibbli.

544
00:26:19,110 --> 00:26:20,530
Ma tikkanċella innifsu barra.

545
00:26:20,530 --> 00:26:22,500
Iżda għandu jkun hemm prezz imħallas.

546
00:26:22,500 --> 00:26:27,220
>> Jekk inti naively, jew over-b'entużjażmu
jiġifieri, indiċi kollha ta 'dawn l-oqsma,

547
00:26:27,220 --> 00:26:29,810
biex ngħidu hekk, jagħmluhom kollha
effiċjenti jitfittex,

548
00:26:29,810 --> 00:26:31,625
liema prezz huma inti probabilment tħallas?

549
00:26:31,625 --> 00:26:32,500
UDJENZA: [inaudible]

550
00:26:32,500 --> 00:26:33,090
DAVID Malan: Prestazzjoni.

551
00:26:33,090 --> 00:26:33,798
Xi trid tfisser?

552
00:26:33,798 --> 00:26:37,380
Ukoll prestazzjoni, għall-inqas fil-
kuntest Jien jiddiskutu, huwa aħjar issa.

553
00:26:37,380 --> 00:26:38,830
Dik hija d-definizzjoni ta 'indiċjar.

554
00:26:38,830 --> 00:26:41,180
Se tagħmel tfittxijiet aktar mgħaġġel.

555
00:26:41,180 --> 00:26:43,366
Allura waqt tonqos, biex ngħidu hekk.

556
00:26:43,366 --> 00:26:44,240
UDJENZA: [inaudible]

557
00:26:44,240 --> 00:26:45,031
DAVID Malan: Ispazju.

558
00:26:45,031 --> 00:26:46,520
Għalhekk għal darb'oħra, dawn huma l-kummerċ komuni.

559
00:26:46,520 --> 00:26:50,820
I tista 'tħaffef tiftix tiegħek, imma hija
se jiswik aktar bytes ta 'spazju.

560
00:26:50,820 --> 00:26:51,610
Għaliex?

561
00:26:51,610 --> 00:26:55,230
Ukoll, fil-kontumaċja, jekk ikollna ħadd mill
dawn l-istilel aħmar, ħadd minn dawn l-indiċi,

562
00:26:55,230 --> 00:26:58,797
kif jien qal, kif taħseb li tfittex
għal isem f'din id-database?

563
00:26:58,797 --> 00:27:00,630
Mela ejja tiġbed tagħna
attenzjoni għal dan l-eżempju.

564
00:27:00,630 --> 00:27:06,300
Jekk għandna David u Scully u Kareem
u Arwa u oħrajn f'dawn ringieli,

565
00:27:06,300 --> 00:27:06,910
per eżempju.

566
00:27:06,910 --> 00:27:08,390
>> Mela ejja do eżattament dan.

567
00:27:08,390 --> 00:27:13,990
Scully huwa fil hawn, u mbagħad
għandna Kareem, u Arwa,

568
00:27:13,990 --> 00:27:18,390
u kulħadd, jekk inti ma
jkollhom indiċi definit, biex ngħidu hekk,

569
00:27:18,390 --> 00:27:20,160
-aħjar li tista 'tagħmel huwa tfittxija lineari.

570
00:27:20,160 --> 00:27:23,470
Jekk inti tfittex għal Arwa, aħna mhux qed
ser ikunu jistgħu jaqbżu d-dritt tagħha

571
00:27:23,470 --> 00:27:24,140
malajr.

572
00:27:24,140 --> 00:27:26,556
Aħna qed tmur biex tibda fuq u
jmorru it-triq kollha lejn il-qiegħ,

573
00:27:26,556 --> 00:27:28,600
ma b'differenza oriġinali tagħna
Eżempju Mike Smith.

574
00:27:28,600 --> 00:27:33,470
>> Jekk, madankollu, I say, ħej, id-database,
indiċi l-kamp isem ewwel,

575
00:27:33,470 --> 00:27:37,000
allura huwa għaddej biex jagħmlu xi ħaġa
fancier u jappoġġjaw xi ħaġa

576
00:27:37,000 --> 00:27:38,130
bħal tfittxija binarja.

577
00:27:38,130 --> 00:27:39,820
Huwa probabbilment mhux tfittxija binarja per se.

578
00:27:39,820 --> 00:27:42,810
Bażijiet ta 'dejta għandhom tendenza li jużaw ieħor
istruttura tad-data msejħa b 'siġar,

579
00:27:42,810 --> 00:27:46,540
ma għandhomx jiġu mfixkla ma 'siġar binarju,
li ftit ikun aktar mgħaġġel biex tfittex

580
00:27:46,540 --> 00:27:48,500
xi ħaġa logaritmika fin-natura.

581
00:27:48,500 --> 00:27:53,510
Imma l-prezz li inti tħallas biex jibnu dik
karatteristika, li l-istruttura tad-data fil-memorja,

582
00:27:53,510 --> 00:27:54,570
huwa aktar bytes.

583
00:27:54,570 --> 00:27:57,170
Allura jista 'jieħu xi megabytes,
xi gigabytes, li jaf?

584
00:27:57,170 --> 00:27:58,410
Hija tiddependi fuq id-data.

585
00:27:58,410 --> 00:28:02,640
>> Allura f'xi punt, inti għandek tiddeċiedi,
huwa probabbilment mhux il-każ komuni.

586
00:28:02,640 --> 00:28:06,000
Allura dak li huma l-komuni attwali
każijiet, jekk int verament kellhom jagħżlu,

587
00:28:06,000 --> 00:28:10,080
dak li jista oqsma favoriti tiegħek tkun?

588
00:28:10,080 --> 00:28:10,580
Email.

589
00:28:10,580 --> 00:28:14,400
U I simili email għaliex email,
fit-teorija, għandu jkun uniku.

590
00:28:14,400 --> 00:28:17,650
U hekk tipikament, meta taf
bil-quddiem li waħda mill-oqsma tiegħek

591
00:28:17,650 --> 00:28:20,277
huwa jew se jkun uniku, li
tendenza li jkunu qasam tajba

592
00:28:20,277 --> 00:28:22,860
tiftix fuq, peress li l-mod,
meta inti tfittex xi ħaġa,

593
00:28:22,860 --> 00:28:26,194
int ser terġa 'lura wieħed jew
żero tweġibiet u mbagħad inti qed isir.

594
00:28:26,194 --> 00:28:28,110
Inti ma għandekx biex iżommu
infittxu f'oħrajn.

595
00:28:28,110 --> 00:28:31,992
>> U hekk f'dan il-każ hawnhekk, email,
sakemm inti ma tistax tirreġistra darbtejn

596
00:28:31,992 --> 00:28:33,450
bl-istess email, hija waħda tajba.

597
00:28:33,450 --> 00:28:36,710
ID b'definizzjoni, fil-
dinja tax-xjenza tal-kompjuter,

598
00:28:36,710 --> 00:28:39,610
jekk inti qed jitkellem dwar
ID, li kienu aħjar ikunu uniċi.

599
00:28:39,610 --> 00:28:42,970
Dik hija tip tal-konnotazzjoni
tal-identità jew identifikatur.

600
00:28:42,970 --> 00:28:46,440
U l-bqija ta 'dawn jistgħu jkunu,
ejja jsejħulhom sbieħ li haves,

601
00:28:46,440 --> 00:28:47,860
iżda mhux verament meħtieġa.

602
00:28:47,860 --> 00:28:49,976
>> U hekk f'database,
inti tispeċifika indiċi,

603
00:28:49,976 --> 00:28:51,350
imma int tista 'tkun saħansitra aktar preċiżi.

604
00:28:51,350 --> 00:28:56,060
Tista 'tgħid, ħej, id-database, tagħmel żgur
li kull ID f'din it-tabella hija unika.

605
00:28:56,060 --> 00:28:59,330
Lanqas Tħallix programmer
aċċidentalment tpoġġi fi email duplikat

606
00:28:59,330 --> 00:29:00,740
jew duplikat numru ta 'identifikazzjoni.

607
00:29:00,740 --> 00:29:03,140
Tant simili enums
tħarisna-istess mod, inti

608
00:29:03,140 --> 00:29:04,881
jista 'jkollhom dawk difiżi ta' livell aktar baxx.

609
00:29:04,881 --> 00:29:07,130
U għalhekk id-disinn database, b'mod
f'ċertu sens, huwa tip ta 'gost,

610
00:29:07,130 --> 00:29:08,380
għaliex inti tagħmel dan fid-difiża.

611
00:29:08,380 --> 00:29:11,460
Inti tip ta jassumi li inti taħdem
bil horrible, programmaturi horrible

612
00:29:11,460 --> 00:29:15,550
u inti tixtieq li tqiegħed f'kemm difiżi
kemm tista 'biex tipproteġi d-data tiegħek,

613
00:29:15,550 --> 00:29:18,940
imma fl-istess ħin trid
biex jgħinuhom iwettqu aħjar

614
00:29:18,940 --> 00:29:21,386
billi jagħżlu li
oqsma biex jottimizzaw għall.

615
00:29:21,386 --> 00:29:24,260
Imma inti ma tistax neċessarjament tagħmel dan fil
vakwu bħal aħna tip ta are here.

616
00:29:24,260 --> 00:29:26,480
You ħadthom ltqajna biex tkun taf liema huma
F'dawk il-każijiet komuni benessri.

617
00:29:26,480 --> 00:29:29,397
Jekk l-iżviluppaturi huma
implimentazzjoni ta 'ktieb l-indirizz,

618
00:29:29,397 --> 00:29:32,230
inti tista 'tajjeb ħafna tixtieq li tkun tista
li tfittxija fuq kważi kull qasam,

619
00:29:32,230 --> 00:29:33,830
biss min-natura ta 'l-applikazzjoni.

620
00:29:33,830 --> 00:29:37,910
Allura forsi inti tqatta
dak l-ispazju addizzjonali.

621
00:29:37,910 --> 00:29:39,090
>> Dritt, xi mistoqsijiet?

622
00:29:39,090 --> 00:29:41,820

623
00:29:41,820 --> 00:29:42,486
Yeah.

624
00:29:42,486 --> 00:29:43,470
>> UDJENZA: [inaudible]

625
00:29:43,470 --> 00:29:44,404
>> DAVID Malan: Le

626
00:29:44,404 --> 00:29:45,279
>> UDJENZA: [inaudible]

627
00:29:45,279 --> 00:29:47,840

628
00:29:47,840 --> 00:29:48,826
>> DAVID Malan: OK.

629
00:29:48,826 --> 00:29:49,701
>> UDJENZA: [inaudible]

630
00:29:49,701 --> 00:29:52,420

631
00:29:52,420 --> 00:29:54,850
>> DAVID Malan: Oh, hekk aħna
qed nitkellmu b'mod

632
00:29:54,850 --> 00:29:57,940
issa li l-kompletament lingwa agnostic.

633
00:29:57,940 --> 00:30:02,370
Allura aħna qed nitkellmu issa dwar
databases relazzjonali aktar ġenerali,

634
00:30:02,370 --> 00:30:04,760
jew databases SQL b'mod aktar ġenerali.

635
00:30:04,760 --> 00:30:06,870
>> UDJENZA: [inaudible]

636
00:30:06,870 --> 00:30:10,030
>> DAVID Malan: A kelma aħjar li tuża
hija, tista 'tintuża minn kwalunkwe lingwa.

637
00:30:10,030 --> 00:30:15,280
So I tista 'tikteb kodiċi JavaScript, Ċ
kodiċi kodiċi, C ++, Java kodiċi, kodiċi Ruby,

638
00:30:15,280 --> 00:30:19,010
li kollha jitkellmu ma '
database u tesegwixxi mistoqsijiet.

639
00:30:19,010 --> 00:30:22,310
Fil-fatt, li mhux ħażin
segue għal eżempju mistoqsija.

640
00:30:22,310 --> 00:30:25,720
U għal darb'oħra, aħna qed mhux se jmorru fil
Java jew Ċ ++ jew xi li aktar,

641
00:30:25,720 --> 00:30:29,420
iżda fil SQL, il-lingwa li fiha I iżommu
-rinviju, Strutturat Mistoqsija Lingwa,

642
00:30:29,420 --> 00:30:32,790
dan il nnifisha hija lingwa ta 'programmar,
imma hija maħsuba biex jintużaw għall-ebda

643
00:30:32,790 --> 00:30:37,330
sorpriża, strutturati mistoqsijiet query.

644
00:30:37,330 --> 00:30:38,660
>> Permezz I tfisser dan.

645
00:30:38,660 --> 00:30:41,190
Il-mod inti tagħżel id-data
minn database MySQL

646
00:30:41,190 --> 00:30:49,330
huwa inti litteralment tip fil-programm tiegħek
xi ħaġa simili tagħżel stilla minn utenti.

647
00:30:49,330 --> 00:30:52,200
I am wieħed jassumi li din it-tabella,
issa huwa msejjaħ utenti.

648
00:30:52,200 --> 00:30:54,860
I jistgħu sejħa hija xi ħaġa li rridu,
iżda dak it-tip ta jagħmel sens.

649
00:30:54,860 --> 00:30:57,240
U għalhekk tagħżel hija ferm
verb komuni, jekk inti

650
00:30:57,240 --> 00:30:59,290
għandha, SQL, li litteralment ma dan.

651
00:30:59,290 --> 00:31:02,730
What do you think stilla
ifisser f'dan il-kuntest?

652
00:31:02,730 --> 00:31:04,410
>> UDJENZA: [inaudible]

653
00:31:04,410 --> 00:31:05,380
>> DAVID Malan: Im sorry?

654
00:31:05,380 --> 00:31:06,300
>> UDJENZA: [inaudible]

655
00:31:06,300 --> 00:31:09,580
>> DAVID Malan: Mhux meħtieġ, huwa
aktar inklużiva minn dan, fil-fatt.

656
00:31:09,580 --> 00:31:11,700
Hu l-karattru wild card.

657
00:31:11,700 --> 00:31:14,740
Star kważi dejjem ifisser xejn,
għalhekk dan ifisser, f'dan il-każ,

658
00:31:14,740 --> 00:31:16,510
tagħżel kollox mid-database.

659
00:31:16,510 --> 00:31:20,730
Allura meta I say dan, I tfisser
tagħti me lura kull kolonna

660
00:31:20,730 --> 00:31:22,440
mit-tabella tiegħi imsejħa utenti.

661
00:31:22,440 --> 00:31:24,730
Allura tagħti me ta 'riżultati, kif huwa msejjaħ.

662
00:31:24,730 --> 00:31:28,210
Fi kliem ieħor, agħti lili kopja tal-
spreadsheet, huwa dak li jien jkollna fuq.

663
00:31:28,210 --> 00:31:34,890
>> Imma jekk jien qal tagħżel stilla minn utenti
fejn ID huwa ugwali 1, kemm hu kbir jekk

664
00:31:34,890 --> 00:31:36,640
sett riżultat tiegħi jkun allura?

665
00:31:36,640 --> 00:31:41,680
Jew b'mod ekwivalenti, kemm ringieli jekk
I jingħataw lura mid-database?

666
00:31:41,680 --> 00:31:45,860
Probabbilment wieħed biss, jekk ikolli tabilħaqq
ID trattati bħala identifikatur uniku,

667
00:31:45,860 --> 00:31:50,710
u jekk David tkun dik ID unika, jien
għandhom jingħataw lura wieħed u ringiela waħda biss

668
00:31:50,710 --> 00:31:53,220
li jkun fih l-informazzjoni David.

669
00:31:53,220 --> 00:31:56,390
Jekk jien qal dan meta ID
huwa ugwali 99, I għandhom jingħataw lura,

670
00:31:56,390 --> 00:32:00,320
f'dan il-kuntest, żero ringieli,
għall-inqas fil-mument.

671
00:32:00,320 --> 00:32:03,620
>> Madankollu, jekk jien ma verament kura
dwar dik l-informazzjoni kollha,

672
00:32:03,620 --> 00:32:06,970
I jistgħu biss jgħidu, fejn ma David jgħix?

673
00:32:06,970 --> 00:32:10,860
Kodiċi zip Agħżel minn
utenti fejn ID huwa 1.

674
00:32:10,860 --> 00:32:15,820
Dan se tagħżel għalija biss zip David
kodiċi u mhux l-intier ta 'dak ringiela.

675
00:32:15,820 --> 00:32:19,541
Għaliex jista I jagħmlu dan minflok
il-mistoqsija istilla, il-wild card?

676
00:32:19,541 --> 00:32:21,950
>> UDJENZA: [inaudible]

677
00:32:21,950 --> 00:32:24,590
>> DAVID Malan: Yeah, I jista 'biss bżonnha.

678
00:32:24,590 --> 00:32:26,350
Allura prestazzjoni hija għal darb'oħra t-tweġiba hawn.

679
00:32:26,350 --> 00:32:28,540
Għaliex jitolbu għal aktar
Informazzjoni milli għandek bżonn,

680
00:32:28,540 --> 00:32:32,020
minħabba li, anki jekk dan kollu dritt flimkien,
inti għad għandek biex tikkopja dak id-data,

681
00:32:32,020 --> 00:32:35,560
jidher, mid-database
fil-programm tiegħek b'xi,

682
00:32:35,560 --> 00:32:38,490
u li jinsab biss iblah jekk inti
biss bżonn ħamsa minn dawk numri,

683
00:32:38,490 --> 00:32:40,340
mhux l-intier tal-filliera.

684
00:32:40,340 --> 00:32:42,180
>> Allura kif nista daħħal utent?

685
00:32:42,180 --> 00:32:44,780
Ejja ngħidu l-utent ikollu biss
irreġistrata għall-ewwel darba.

686
00:32:44,780 --> 00:32:46,560
Is-sintassi normalment teżamina bħal dan.

687
00:32:46,560 --> 00:32:52,700
Daħħal in-utenti, u
allura aħna ngħid valuri,

688
00:32:52,700 --> 00:33:00,150
u allura aħna se ngħidu valuri
simili, ejja ngħidu, Lauren Scully,

689
00:33:00,150 --> 00:33:02,380
videographer tagħna dritt hawn.

690
00:33:02,380 --> 00:33:04,390
U l-qasam li jmiss huwa ġeneru.

691
00:33:04,390 --> 00:33:08,020
Allura aħna ser ngħidu kwotazzjoni, unquote
"F", allura għandna ID

692
00:33:08,020 --> 00:33:12,250
u jien ser say-- ejja
nippretendu hi li ma attwalment hawn,

693
00:33:12,250 --> 00:33:14,380
hekk aħna ser kontrina fl-istorja.

694
00:33:14,380 --> 00:33:16,530
Allura 2 se jkun identità tagħha.

695
00:33:16,530 --> 00:33:19,130
U allura l-kamp li jmiss
hawnhekk huwa l-email tagħha.

696
00:33:19,130 --> 00:33:22,140
Allura li għaddej biex tkun simili
Lauren Scully u oħrajn,

697
00:33:22,140 --> 00:33:24,360
u aħna ser biss dot dot
dot bogħod minn hawn fuq.

698
00:33:24,360 --> 00:33:26,890
Issa se jiksbu ftit
tedious, iżda l-inserzjoni mistoqsija

699
00:33:26,890 --> 00:33:28,310
finalment look bħal dik.

700
00:33:28,310 --> 00:33:30,970
>> Jekk irrid li jeħles mill
Scully, UH-oh, ejja tiddereġistra

701
00:33:30,970 --> 00:33:37,420
tagħha, hija tħassar kont tagħha,
ħassar minn utenti fejn ID jiġi daqs 2,

702
00:33:37,420 --> 00:33:38,500
se jeħles Scully.

703
00:33:38,500 --> 00:33:48,050
Jew nista 'ngħid aġġornament utenti stabbiliti,
ejja ngħidu, dak li nistgħu bidla?

704
00:33:48,050 --> 00:33:49,430
Ejja ngħidu hi jiċċaqlaq.

705
00:33:49,430 --> 00:33:53,730
zip sett huwa ugwali 021-- Nope,
li l-zip attwali tagħha.

706
00:33:53,730 --> 00:33:54,487
90,210.

707
00:33:54,487 --> 00:33:56,320
L-unika kodiċi ieħor zip
Naf fid-dinja.

708
00:33:56,320 --> 00:33:59,002
Allura li se tinbidel
zip tagħha code-- attwalment,

709
00:33:59,002 --> 00:34:00,460
li ma tinbidilx zip code tagħha.

710
00:34:00,460 --> 00:34:02,170
>> What did I biss do?

711
00:34:02,170 --> 00:34:04,292
Anki jekk il-sintassi huwa probabbilment ġdida.

712
00:34:04,292 --> 00:34:05,302
>> UDJENZA: [inaudible]

713
00:34:05,302 --> 00:34:08,010
DAVID Malan: Yeah, I mċaqalqa kulħadd
li Beverly Hills, California.

714
00:34:08,010 --> 00:34:11,920
So I għandhom attwalment
jiġifieri meta ID huwa daqs 2.

715
00:34:11,920 --> 00:34:12,820
U oħrajn.

716
00:34:12,820 --> 00:34:15,290
Allura SQL hija kollha dwar dawn
tipi ta 'struzzjonijiet.

717
00:34:15,290 --> 00:34:20,260
Agħżel, daħħal, tħassar, jaġġornaw,
ma 'dawn predicates fl-aħħar

718
00:34:20,260 --> 00:34:22,139
dawn il-klawsoli fejn, biex ngħidu hekk.

719
00:34:22,139 --> 00:34:25,170
U hemm ħafna aktar li tista
do, imma huwa verament ftit jeħodna

720
00:34:25,170 --> 00:34:29,750
li sempliċiment, jekk arcanely, jesprimu
dak li trid l-bażi tad-dejta li tagħmel.

721
00:34:29,750 --> 00:34:31,580
>> U allura l-bażi tad-dejta
se figura out awtomatiku, meta

722
00:34:31,580 --> 00:34:35,630
inti daħħal Lauren Scully fil-
database, fejn tpoġġi lilha fil-memorja

723
00:34:35,630 --> 00:34:38,230
sabiex inkunu nistgħu malajr ħafna jiksbu
tagħha bbażat fuq l-indirizz email tagħha

724
00:34:38,230 --> 00:34:42,610
jew ibbażati fuq numru ta 'ID tagħha jew oħrajn bħal dawn.

725
00:34:42,610 --> 00:34:43,391
Yeah, Dan.

726
00:34:43,391 --> 00:34:44,266
UDJENZA: [inaudible]

727
00:34:44,266 --> 00:34:46,364

728
00:34:46,364 --> 00:34:47,780
DAVID Malan: mistoqsija Verament tajba.

729
00:34:47,780 --> 00:34:50,370
Se dawn skripts jinbidlu minn
Microsoft Aċċess għall-Oracle

730
00:34:50,370 --> 00:34:52,290
li MySQL għal PostgreSQL?

731
00:34:52,290 --> 00:34:53,790
Ir-risposta qasira hija li dan jiddependi.

732
00:34:53,790 --> 00:34:58,697
Fit-teorija, hemm ħafna
subsett komuni sinifikanti ta 'SQL

733
00:34:58,697 --> 00:35:00,780
thats maqsuma bejn kulħadd
ta 'dawn implimentazzjonijiet.

734
00:35:00,780 --> 00:35:03,340
Madankollu, diversi manifatturi
għandhom karatteristiċi miżjuda

735
00:35:03,340 --> 00:35:07,120
għad-databases tagħhom biex jagħmlu ċerti affarijiet
lil hinn mill-ambitu ta 'dawn il-karatteristiċi,

736
00:35:07,120 --> 00:35:08,720
li jistgħu, fil-fatt, break.

737
00:35:08,720 --> 00:35:11,210
>> Allura l-mod iżviluppaturi
hedge kontra dan,

738
00:35:11,210 --> 00:35:14,350
hija li minflok kitba prima
kodiċi SQL bħal jien bil-miktub hawn,

739
00:35:14,350 --> 00:35:19,460
huma minflok jużaw librerija,
librerija komuni li hi stess

740
00:35:19,460 --> 00:35:23,650
huwa tip ta 'diplomi ta' livell u astratti
bogħod liema prodott inti qed tuża.

741
00:35:23,650 --> 00:35:25,710
U li tagħtik
funzjonijiet u l-proċeduri

742
00:35:25,710 --> 00:35:28,810
li jitolbu sabiex inti qatt ma
attwalment tikteb SQL prima.

743
00:35:28,810 --> 00:35:32,609
>> Fit-teorija, allura, inti tista 'bidla
prodotti minn Oracle lill-Microsoft

744
00:35:32,609 --> 00:35:34,650
jew viċe-versa jew xejn
inkella, u int litteralment

745
00:35:34,650 --> 00:35:36,920
bidla xejn dwar kodiċi tiegħek.

746
00:35:36,920 --> 00:35:40,180
Ir-realtà, madankollu, huwa, inti xi kultant
jieqfu karatteristiċi bħala riżultat.

747
00:35:40,180 --> 00:35:43,860
Inti jista 'jkollok għażlu prodott minħabba
huwa ltqajna dawn il-karatteristiċi ta 'valur miżjud,

748
00:35:43,860 --> 00:35:46,610
u int biss issa mhux
jużawhom konxjament.

749
00:35:46,610 --> 00:35:51,630
>> U anecdotally, aktar kumpaniji għandhom tendenza
qatt ma jitbiegħdu minn dejtabejż tagħhom.

750
00:35:51,630 --> 00:35:54,002
Allura filwaqt li dan huwa sbieħ li
għandhom karatteristika, ir-realtà

751
00:35:54,002 --> 00:35:55,960
huwa, jekk int taqlib
database tiegħek, int

752
00:35:55,960 --> 00:35:59,890
probabbilment jagħmlu għenieqed ta 'bidliet oħrajn
xorta waħda, li inti ma neċessarjament

753
00:35:59,890 --> 00:36:01,360
jeħtieġ li jantiċipaw li.

754
00:36:01,360 --> 00:36:03,720
Allura huwa forsi
il-problema inġinerija żejjed,

755
00:36:03,720 --> 00:36:05,670
imma huwa verament jiddependi fuq il-kuntest.

756
00:36:05,670 --> 00:36:09,960
Iżda fit-teorija, SQL hija maqsuma
madwar dawn il-prodotti varji.

757
00:36:09,960 --> 00:36:11,560
mistoqsijiet verament tajba.

758
00:36:11,560 --> 00:36:12,272
Yeah.

759
00:36:12,272 --> 00:36:13,147
>> UDJENZA: [inaudible]

760
00:36:13,147 --> 00:36:17,820

761
00:36:17,820 --> 00:36:21,480
>> DAVID Malan: Yeah, hekk
inti tista 'taħseb database

762
00:36:21,480 --> 00:36:25,020
huwa biss server, fl-aħħar tal
il-jum, u ġewwa ta 'dak server

763
00:36:25,020 --> 00:36:28,670
huwa mazz sħiħ ta '
tabelli, ringieli u kolonni.

764
00:36:28,670 --> 00:36:33,410
U meta inti tibgħat mistoqsija bħal din
mill-programm tiegħek, website tiegħek,

765
00:36:33,410 --> 00:36:39,340
miktuba fl Java, Ruby, Python, tkun xi tkun,
-server qed tirċievi din l-kmand

766
00:36:39,340 --> 00:36:41,660
u l-interpretazzjoni fil
litteralment l-istess mod

767
00:36:41,660 --> 00:36:43,660
aħna diskussa aktar kmieni ma '
lingwi interpretati,

768
00:36:43,660 --> 00:36:47,333
u mbagħad li jwettqu xi azzjoni fuq żero
jew aktar ringieli fit żero jew iżjed tabelli.

769
00:36:47,333 --> 00:36:48,208
UDJENZA: [inaudible]

770
00:36:48,208 --> 00:36:53,540

771
00:36:53,540 --> 00:36:55,070
>> DAVID Malan: Eżattament, eżattament.

772
00:36:55,070 --> 00:36:58,450
Allura l-pseudocode għal xi ħaġa
bħal dik tista 'tkun din.

773
00:36:58,450 --> 00:37:02,450
Fil fajl PHP tiegħek jew tiegħek
fajl python jew file Java tiegħek,

774
00:37:02,450 --> 00:37:09,210
inti jkollok kodiċi pseudocode, jew
-Scratch simili blokki kif, kieku żjarat utent

775
00:37:09,210 --> 00:37:19,870
acme.com/register~~V għall-ewwel darba,
imbagħad daħħal fil-utenti u oħrajn.

776
00:37:19,870 --> 00:37:22,619
U aħna se tittraduċi dan
aktar kodiċi konkreta fl-aħħar.

777
00:37:22,619 --> 00:37:24,660
Imma tassew, aħna għandna kollha
-sisien hawn,

778
00:37:24,660 --> 00:37:27,680
anke jekk aħna qed taqbeż is-site xi
mill-passi ta 'implimentazzjoni.

779
00:37:27,680 --> 00:37:31,560
>> So let me kkritikat l dak li aħna
wonderfully ma ftit mument ilu.

780
00:37:31,560 --> 00:37:36,470
Inti ħolqu pjuttost
tabella kompluta għall-utenti.

781
00:37:36,470 --> 00:37:38,920
Ċertament, nistgħu jimplimentaw
dan fil-modi differenti ftit,

782
00:37:38,920 --> 00:37:43,030
iżda inti għandek attwalment wasslu lilna
l-path-- u jien ngħid lilek,

783
00:37:43,030 --> 00:37:48,080
imma hija probabbilment fault-- tiegħi ta 'pjuttost
implimentazzjoni dejtabejż ineffiċjenti.

784
00:37:48,080 --> 00:37:49,950
Mhuwiex normalizzata.

785
00:37:49,950 --> 00:37:52,320
>> U mill normalizzat I jfisser
hemm se tkun,

786
00:37:52,320 --> 00:37:57,380
matul iż-żmien, redundancy sinifikanti,
u għalhekk ineffiċjenza,

787
00:37:57,380 --> 00:38:00,210
jiġifieri skart ta 'spazju.

788
00:38:00,210 --> 00:38:05,650
Ibbażat fuq biss dak li tara hawn, tista
inti envision meta dan l-iskart ta 'l-ispazju

789
00:38:05,650 --> 00:38:08,710
se jiġu minn, maż-żmien,
kif tirreġistra utenti aktar u aktar

790
00:38:08,710 --> 00:38:10,860
għall-website tiegħek?

791
00:38:10,860 --> 00:38:13,047
Liema data tista 'ssir żejda?

792
00:38:13,047 --> 00:38:19,084

793
00:38:19,084 --> 00:38:20,940
>> UDJENZA: [inaudible]

794
00:38:20,940 --> 00:38:22,686
>> DAVID Malan: Għaliex għandek jfissirx li?

795
00:38:22,686 --> 00:38:23,561
UDJENZA: [inaudible]

796
00:38:23,561 --> 00:38:32,180

797
00:38:32,180 --> 00:38:32,930
DAVID Malan: Yeah.

798
00:38:32,930 --> 00:38:35,622
U ejja nassumu għall-finijiet
tal-lum li dan huwa veru.

799
00:38:35,622 --> 00:38:38,330
Jirriżulta, u konna tgħallimna din il
il-mod iebes, li mhux veru.

800
00:38:38,330 --> 00:38:41,670
bliet b'xi mod multipli jkollhom,
b'xi, l-istess kodiċi zip,

801
00:38:41,670 --> 00:38:43,390
li pawżi dan il-intwizzjoni isbaħ.

802
00:38:43,390 --> 00:38:46,180
Imma ejja nassumu li huwa veru,
għaliex dan huwa kważi dejjem veru.

803
00:38:46,180 --> 00:38:51,390
Allura jissoponi li kodiċi zip huwa
dejjem assoċjat mal-istess belt

804
00:38:51,390 --> 00:38:53,600
u l-istat, li huwa tip
ta assunzjoni raġonevoli,

805
00:38:53,600 --> 00:38:54,840
iżda mhux korretta, jirriżulta.

806
00:38:54,840 --> 00:38:57,310
Iżda ipotesi raġunevoli
għal skopijiet lum.

807
00:38:57,310 --> 00:39:01,650
>> Imbagħad jissoponi li noqgħod fl-Cambridge,
MA, skont it-Tabella dan l-utent,

808
00:39:01,650 --> 00:39:04,100
u jissoponi li Lauren
Scully jgħix fil-Cambridge, MA,

809
00:39:04,100 --> 00:39:06,120
u jissoponi li Kareem
jgħix fil-Cambridge, MA,

810
00:39:06,120 --> 00:39:10,400
u Arwa jgħix fil-Cambridge,
MA, lkoll fil 02,138.

811
00:39:10,400 --> 00:39:15,890
Għaliex aħna ftakar Cambridge,
MA, 02138 għall-erba 'us?

812
00:39:15,890 --> 00:39:18,903
X'għandu jkun biżżejjed biex tiftakar?

813
00:39:18,903 --> 00:39:20,249
>> UDJENZA: [inaudible]

814
00:39:20,249 --> 00:39:21,540
DAVID Malan: Biss il-kodiċi zip.

815
00:39:21,540 --> 00:39:25,080
Biss li 02138 jeżisti, minħabba
inti taf dak li stajna nagħmlu?

816
00:39:25,080 --> 00:39:32,650
Nistgħu jiksbu fancy ftit hawn
u minn hawn, jiddefinixxu ieħor tabella

817
00:39:32,650 --> 00:39:35,850
fejn dan ikun ser tkun l-
isem, dan se jkun it-tip,

818
00:39:35,850 --> 00:39:38,840
dan se jkun l-
tul, u issa, jien

819
00:39:38,840 --> 00:39:42,900
ser sejħa dan ibliet il-mejda tiegħi.

820
00:39:42,900 --> 00:39:47,011
Dan kien jissejjaħ, ta
Naturalment, l-utenti tal-mejda tiegħi.

821
00:39:47,011 --> 00:39:49,885
U hekk x'għandi nressaq hawn fuq
għall-mejda ibliet tiegħi, do you think?

822
00:39:49,885 --> 00:39:53,605

823
00:39:53,605 --> 00:39:54,535
>> UDJENZA: [inaudible]

824
00:39:54,535 --> 00:39:55,930
>> DAVID Malan: Yeah.

825
00:39:55,930 --> 00:40:01,440
Allura zip u l-istat u l-belt.

826
00:40:01,440 --> 00:40:05,350
U għalhekk it-tip hawnhekk, aħna ser ngħidu
dan se jkun char 5 darb'oħra,

827
00:40:05,350 --> 00:40:06,750
bla ħsara għad-dibattitu ta 'qabel.

828
00:40:06,750 --> 00:40:14,810
Din se tkun ENUM, forsi bħal
qabel, u l-belt se tkun varchar 50.

829
00:40:14,810 --> 00:40:17,960
U hekk issa liema nista 'nikseb
litħassar minn din it-tabella

830
00:40:17,960 --> 00:40:21,995
jiġi eliminat dak l-ineffiċjenza?

831
00:40:21,995 --> 00:40:23,100
>> UDJENZA: [inaudible]

832
00:40:23,100 --> 00:40:23,850
DAVID Malan: Nizza.

833
00:40:23,850 --> 00:40:30,239
Istat u l-belt jmorru lil hinn, hekk stajt issa
eliminati l-ineffiċjenza potenzjali

834
00:40:30,239 --> 00:40:33,280
għall redundantly ftakar, Cambridge,
MA, Cambridge, MA, Cambridge, MA,

835
00:40:33,280 --> 00:40:35,712
Cambridge, MA, li, wieħed jittama
huwa qatt se jibdlu.

836
00:40:35,712 --> 00:40:37,670
U anki jekk dan huwa minnu, huwa
minorly annoying, issa

837
00:40:37,670 --> 00:40:39,750
li għandi għall-bidla
dan f'ringieli multipli,

838
00:40:39,750 --> 00:40:43,770
billi hawn, I jistgħu biss
bidla fil-post wieħed.

839
00:40:43,770 --> 00:40:46,890
>> Issa x'inhu l-kompromess, forsi?

840
00:40:46,890 --> 00:40:48,020
Dan kien super konvenjenti.

841
00:40:48,020 --> 00:40:50,730
Kieku d-data kollha tiegħi nicely flimkien.

842
00:40:50,730 --> 00:40:53,644
Imma x'hemm b'mod ċar il-każ issa?

843
00:40:53,644 --> 00:40:55,684
>> UDJENZA: [inaudible]

844
00:40:55,684 --> 00:40:58,100
DAVID Malan: Eżattament, u jien
ferħan uża l-kelma jissieħbu,

845
00:40:58,100 --> 00:41:01,320
għaliex dan fil-fatt l-keyword,
fid-dinja ta 'databases relazzjonali

846
00:41:01,320 --> 00:41:05,270
SQL, huwa ta 'kelma attwali inti
tista tip jew għall-inqas twassal.

847
00:41:05,270 --> 00:41:09,280
U fil-fatt, dak li aħna issa għandek tagħmel
biex tagħżel tagħrif sħiħ David huwa

848
00:41:09,280 --> 00:41:19,700
xi ħaġa simili tagħżel stilla minn
utenti, jissieħbu ibliet, on-- u issa

849
00:41:19,700 --> 00:41:24,010
Jien ser biss jimxu lejn tieni linja
b'tali mod li dan users.zip fits-- hija ugwali

850
00:41:24,010 --> 00:41:34,570
cities.zip, fejn users.ID huwa daqs 1.

851
00:41:34,570 --> 00:41:35,550
>> Allura x'inhu għaddej?

852
00:41:35,550 --> 00:41:38,970
Huwa ikrah tfittex, imma int tista tip ta
taqrah xellug għal-lemin, fuq s'isfel.

853
00:41:38,970 --> 00:41:41,030
star Agħżel minn utenti
huwa l-istess bħal qabel,

854
00:41:41,030 --> 00:41:42,930
iżda mhux minn utenti, per se.

855
00:41:42,930 --> 00:41:45,910
Huwa minn utenti jissieħbu ibliet.

856
00:41:45,910 --> 00:41:48,520
What am I li tgħaqqad dawn iż-żewġ tabelli fuq?

857
00:41:48,520 --> 00:41:51,820
Ukoll, apparentement, il-
tabelli utenti zip qasam,

858
00:41:51,820 --> 00:41:54,810
u dan il-perjodu huwa biss speċjali
sintassi biex jesprimu dik l-idea,

859
00:41:54,810 --> 00:41:58,130
u dan huwa t-tabelli ibliet zip qasam.

860
00:41:58,130 --> 00:42:01,580
Irrid dawk iż-żewġ li jkun daqs,
imma nixtieq li finalment jintgħażlu

861
00:42:01,580 --> 00:42:06,280
biss dawk ringieli fejn
ID fit-tabella utenti

862
00:42:06,280 --> 00:42:08,730
huwa ugwali 1, li ġara li jkun minjiera.

863
00:42:08,730 --> 00:42:11,781
>> U biss li jkun ċar, ta '
programmer, tipikament meta

864
00:42:11,781 --> 00:42:14,780
hardcode xi ħaġa bħall-numru
1, għax inkella l-websajt biss

865
00:42:14,780 --> 00:42:17,630
jappoġġja David jew l
ewwel utent, int

866
00:42:17,630 --> 00:42:20,720
minflok tagħmel
xi ħaġa simili ID, fejn

867
00:42:20,720 --> 00:42:22,510
dan jirrappreżenta
varjabbli, xi ħaġa li

868
00:42:22,510 --> 00:42:26,210
tista 'tbiddel matul iż-żmien, simili
fl-ispirtu ta 'dak li għidt qabel

869
00:42:26,210 --> 00:42:28,080
ma dawn it-tipi ta 'placeholders.

870
00:42:28,080 --> 00:42:30,396
Iżda għal issa aħna ser biss hardcode bħala 1.

871
00:42:30,396 --> 00:42:31,520
U hekk dak li jfisser dan?

872
00:42:31,520 --> 00:42:35,100
Ukoll, mod sabiħ li Ħares dan huwa
li jekk dan idejn hija t-tabella utenti,

873
00:42:35,100 --> 00:42:38,090
u dan idejn huwa l-żippijiet
mejda, aħna qed tip ta 'finding--

874
00:42:38,090 --> 00:42:41,330
u l-ponot tas-swaba tiegħi huma zip
minn hawn, u l-ponot tas-swaba tiegħi

875
00:42:41,330 --> 00:42:43,740
hawn huma zip, int
tip ta 'interlocking dan

876
00:42:43,740 --> 00:42:47,950
hekk li tikseb lura l-jirriżultaw
tabella oriġinali, billi tassew tgħaqqad

877
00:42:47,950 --> 00:42:49,590
-żewġ tabelli fil-grawnd komuni.

878
00:42:49,590 --> 00:42:50,840
U ma għandhom ikunu zip.

879
00:42:50,840 --> 00:42:54,460
Dan jista 'jkun xejn aktar ħaġa oħra, iżda
zip huwa sabiħ, għaliex wieħed, huwa qasir,

880
00:42:54,460 --> 00:42:56,470
tnejn, huwa dejjem l-
istess tul, b'hekk m'hemm l-

881
00:42:56,470 --> 00:43:02,270
effiċjenza reali għal dak li
Olivier propost hawn

882
00:43:02,270 --> 00:43:05,200
mal factoring l-b'żipp, u
[Inaudible] fejn ippropona li aħna jeħles

883
00:43:05,200 --> 00:43:07,110
tal-belt u l-istati.

884
00:43:07,110 --> 00:43:11,370
>> Allura dan huwa l-proċess
magħrufa bħala normalizzazzjoni.

885
00:43:11,370 --> 00:43:14,171
Kwalunkwe mistoqsijiet dwar dak?

886
00:43:14,171 --> 00:43:16,170
Well let me punt
dan hu t-tip ta 'għalf,

887
00:43:16,170 --> 00:43:19,202
anki jekk huwa pjuttost ta 'livell baxx,
din id-diskussjoni, li inti taħseb

888
00:43:19,202 --> 00:43:20,910
int tip ta 'jkollna
mitlufa fil-ħaxix ħażin,

889
00:43:20,910 --> 00:43:26,690
dan huwa manifestazzjoni ta abbundanti
opportunità għall-iżviluppaturi biex tkun ħażina.

890
00:43:26,690 --> 00:43:29,600
U fil-fatt, anke meta aħna, fil
korsijiet Stajt mgħallma, meta aħna kellna,

891
00:43:29,600 --> 00:43:32,290
per eżempju, esperjenza
programmaturi undergraduate

892
00:43:32,290 --> 00:43:35,920
jibnu websajts, ewwel daqqa t'għajn,
-websajts tista 'tidher terrific.

893
00:43:35,920 --> 00:43:38,280
U dawn ikollhom kollha ta 'l-
funzjonalità aħna mitluba,

894
00:43:38,280 --> 00:43:40,650
l-iżviluppaturi għamlet xogħol tajjeb.

895
00:43:40,650 --> 00:43:43,370
>> Iżda dawn ma kinux neċessarjament jaf
biżżejjed dwar id-disinn dejtabejż

896
00:43:43,370 --> 00:43:46,680
jew dawn ma naħsibx iebes
biżżejjed dwar it-tipi ta 'data

897
00:43:46,680 --> 00:43:49,220
u t-tipi ta 'utenti l-
websajt kien se jkollhom,

898
00:43:49,220 --> 00:43:53,240
u insibu, allura, sitt xhur wara,
wara li ħadthom gradwat jew imxiet fuq,

899
00:43:53,240 --> 00:43:56,016
li kkritikat dan, il-websajt tagħna
huwa verament, tassew bil-mod.

900
00:43:56,016 --> 00:43:58,890
U jien lanqas jitkellem dwar li jkollhom
miljuni jew eluf ta 'utenti.

901
00:43:58,890 --> 00:44:02,580
I tfisser ftit mijiet utenti fuq il-kampus,
kollha kemm huma simili li, per eżempju,

902
00:44:02,580 --> 00:44:04,870
shop għall-korsijiet fil
-istess ħin, dawn qed

903
00:44:04,870 --> 00:44:07,010
jużaw dik katalogu tal-kors
applikazzjoni semmejt

904
00:44:07,010 --> 00:44:10,410
u l-ħaġa hija jkollna verament
bil-mod minħabba li ma kienx hemm indiċijiet.

905
00:44:10,410 --> 00:44:13,740
Ma kien hemm l-ebda stilla ħamra, hekk li
jitkellmu, jew kellna mhux neċessarjament

906
00:44:13,740 --> 00:44:17,690
fatturati minn dejta komuni għall
nikseb xi tfaddil ta 'spazju.

907
00:44:17,690 --> 00:44:21,880
>> U hekk meta tgħarbel l-iżviluppatur
jew persuna database jew bħalhom,

908
00:44:21,880 --> 00:44:25,864
-tipi ta 'mistoqsijiet li wieħed jaħseb permezz
huwa saħansitra, meta jirrevedi kodiċi ta 'xi ħadd,

909
00:44:25,864 --> 00:44:28,530
ngħid, mhux neċessarjament tħares
kollha tal-kodiċi tagħhom, iżda jgħidu permezz,

910
00:44:28,530 --> 00:44:30,154
ejja nħarsu permezz tal-tabelli database.

911
00:44:30,154 --> 00:44:31,150
Liema huma inti ħażna?

912
00:44:31,150 --> 00:44:33,941
U mbagħad jgħidu, ukoll, stenna
minuta, għaliex huma inti tuża integer?

913
00:44:33,941 --> 00:44:36,224
X'jiġri jekk ikollna 4000000000
u 1 ta 'dawn ir-ringieli?

914
00:44:36,224 --> 00:44:38,140
U dawn it-tipi ta '
mistoqsijiet hija opportunità

915
00:44:38,140 --> 00:44:40,170
għall tip ta 'timbotta lura u
jiksbu sens ta ', fejn

916
00:44:40,170 --> 00:44:42,300
jekk int mhux komdu tagħmel
dan, wara li xi ħadd aktar tekniċi

917
00:44:42,300 --> 00:44:45,425
jistaqsu dawn il-mistoqsijiet, dwar jekk jew le
il-persuna verament jaf Jittieħed tagħhom.

918
00:44:45,425 --> 00:44:47,890
U dan hu t-tip ta
Jittieħed, wisq, li n-nies

919
00:44:47,890 --> 00:44:50,540
fuq l-internet li
huma awto-mgħallma, forsi

920
00:44:50,540 --> 00:44:53,920
jitgħallmu inqas spiss, għaliex inti
mhux bilfors jiltaqgħu ma 'dan

921
00:44:53,920 --> 00:44:56,630
kemm, għaliex inti tista 'tikseb
database u t-tħaddim,

922
00:44:56,630 --> 00:44:58,880
imma sakemm inti stajt taqra
up fuq tutorials jew kienu

923
00:44:58,880 --> 00:45:01,880
qal dwar normalizzazzjoni dejtabejż
u l-indiċizzazzjoni u l-prestazzjoni,

924
00:45:01,880 --> 00:45:04,255
dawn huma t-tipi ta 'affarijiet
li ser tweġġgħek.

925
00:45:04,255 --> 00:45:07,480
U inti tista 'taħseb, jew inġinier ħażin
jista 'jgħid, oh, ukoll, paga aħna aħjar

926
00:45:07,480 --> 00:45:09,600
għal database akbar
jew database aktar malajr

927
00:45:09,600 --> 00:45:13,360
jew biss tarmi l-flus għal dan,
iskala vertikalment, mhux neċessarjament hekk.

928
00:45:13,360 --> 00:45:16,920
Jekk inti tmur in-- u inti tista 'tmur fil
wara l-indiċi fact-- u żid,

929
00:45:16,920 --> 00:45:20,320
u jista 'jieħu ftit sigħat għall-
database biex jibnu dik id-data l-ġdida

930
00:45:20,320 --> 00:45:24,100
struttura li jien allużjoni għall qabel,
inti xorta tista 'tiffissa dan wara l-fatt,

931
00:45:24,100 --> 00:45:26,180
li dan huwa fejn inti
jibdew jiddistingwu

932
00:45:26,180 --> 00:45:28,830
disinjaturi tajba mill ħażina
disinjaturi, mhux biss estetikament,

933
00:45:28,830 --> 00:45:32,972
imma-prestazzjoni għaqli kif ukoll.

934
00:45:32,972 --> 00:45:33,555
Kwalunkwe mistoqsijiet?

935
00:45:33,555 --> 00:45:36,420

936
00:45:36,420 --> 00:45:37,480
Nru?

937
00:45:37,480 --> 00:45:41,980
Allura għal NoSQL, li kien it-tip ieħor
ta 'database li għalih jien alluda qabel,

938
00:45:41,980 --> 00:45:43,490
inti ma għandekx ringieli u kolonni.

939
00:45:43,490 --> 00:45:47,000
Minflok, inti għandek xi ħaġa
li jistenna ftit aktar bħal dan.

940
00:45:47,000 --> 00:45:48,630
Jien ser tuża sintassi komuni.

941
00:45:48,630 --> 00:45:51,270
ċingi kaboċċi jiġri
tintuża hawnhekk pjuttost ħafna.

942
00:45:51,270 --> 00:45:55,400
Inti jista 'jkollok xi ħaġa
bħall-ewwel isem huwa David,

943
00:45:55,400 --> 00:46:00,180
inti jista 'jkollhom l-aħħar
isem huwa Malan, kwotazzjonijiet,

944
00:46:00,180 --> 00:46:07,530
inti jista 'jkollhom ID is--
skuża me, ID whoops-- huwa 1,

945
00:46:07,530 --> 00:46:13,410
email huwa malan@harvard.edu, u jien mhux ser
jolqot ittajpjar l-bqija, u mbagħad

946
00:46:13,410 --> 00:46:14,380
xi affarijiet oħra.

947
00:46:14,380 --> 00:46:17,380
>> Fi kliem ieħor, dan huwa
rappreżentazzjoni testwali

948
00:46:17,380 --> 00:46:20,720
ta 'dak li ġeneralment sejħa
oġġett fi programm tal-kompjuter.

949
00:46:20,720 --> 00:46:26,079
U l-oġġett huwa ġeneralment biss
ġabra ta 'pari b'valur ewlenin.

950
00:46:26,079 --> 00:46:27,370
Għalhekk għal darb'oħra, din it-tema rikorrenti.

951
00:46:27,370 --> 00:46:30,440
Rajna pari b'valur ewlieni fil HTML,
rajna pari b'valur ewlenin issa

952
00:46:30,440 --> 00:46:34,020
fil-kuntest ta 'databases, u aħna
raw pari b'valur ewlenin fil-kuntest

953
00:46:34,020 --> 00:46:35,970
ta ', I think, lingwa qabel illum.

954
00:46:35,970 --> 00:46:36,890
Jżomm ġejjin up.

955
00:46:36,890 --> 00:46:39,620
U fil-fatt, dan huwa tassew
liema data jeħodna għall-

956
00:46:39,620 --> 00:46:44,240
data u metadata, jew valuri
u ċwievet, rispettivament.

957
00:46:44,240 --> 00:46:47,430
>> Allura mhux relazzjonali
database, xi ħaġa ibbażata

958
00:46:47,430 --> 00:46:50,680
dwar oġġetti, fejn inti biss jinġemgħu
kollox flimkien u poġġih

959
00:46:50,680 --> 00:46:55,640
fil-memorja, ġeneralment ikun
isaffru bħala, jew meqjusa, peress li dan.

960
00:46:55,640 --> 00:47:00,500
U jien ser leave li issa bħala
tip ta 'approċċ alternattiv.

961
00:47:00,500 --> 00:47:03,750
U wieħed mhuwiex neċessarjament
aħjar mill-oħra.

962
00:47:03,750 --> 00:47:07,310
Fil-fatt, ħafna fil Vogue
dawn il-jiem huma sistemi tad-database

963
00:47:07,310 --> 00:47:11,942
bħall MongoDB u REDIS u ftit
għodod oħra bħal dawn, disponibbli liberament,

964
00:47:11,942 --> 00:47:13,400
iżda huma dejjem aktar mt Vogue.

965
00:47:13,400 --> 00:47:18,850
Parzjalment minħabba li huma joffru addizzjonali
Karatteristiċi aktar minn dawn l-approċċi tabulari,

966
00:47:18,850 --> 00:47:20,850
iżda wkoll għaliex qed
ftit aktar faċli għall-użu,

967
00:47:20,850 --> 00:47:24,099
għaliex inti ma għandekx biex jaħsbu bħala hard
dwar ħafna minn dawn id-deċiżjonijiet tad-disinn.

968
00:47:24,099 --> 00:47:25,970
Allura pluses u minuses.

969
00:47:25,970 --> 00:47:29,740
Allura jirrealizzaw hemm għażliet
lil hinn minn dak li aħna biss qattgħu żmien fuq.

970
00:47:29,740 --> 00:47:32,310
>> Mela ejja tagħmel dan.

971
00:47:32,310 --> 00:47:37,870
Ejja tranżizzjoni ftit
lura issa għall-ipprogrammar tal-web,

972
00:47:37,870 --> 00:47:40,470
sabiex inkunu tip ta jikkonkludi
illum ma 'xi ħaġa

973
00:47:40,470 --> 00:47:43,930
Li l-ftit hands-on, mili
fil xi lakuni mill-bieraħ.

974
00:47:43,930 --> 00:47:45,340
Let me go għal dan l-ewwel.

975
00:47:45,340 --> 00:47:49,310
Allura tfakkar li l-bieraħ
kellna xi HTML kanoniċi

976
00:47:49,310 --> 00:47:55,110
paġni li kellhom fil-bidu, biss
HTML, u mbagħad sekondarjament kellhom CSS,

977
00:47:55,110 --> 00:47:56,620
folji stil cascading.

978
00:47:56,620 --> 00:47:59,830
Din hija tag ġdida li aħna ma
ara bieraħ, jew nitkellem fuq,

979
00:47:59,830 --> 00:48:01,490
hekk imsejħa tag iskrittura.

980
00:48:01,490 --> 00:48:05,830
>> Jinstabx inti tista 'attwalment ssodata
lingwa imsejħa JavaScript fil-web tiegħek

981
00:48:05,830 --> 00:48:08,310
-paġna u jagħmlu web tiegħek
paġni tagħmel xi ħaġa.

982
00:48:08,310 --> 00:48:09,710
Allura dak do I jfisser minn dak?

983
00:48:09,710 --> 00:48:12,630
Well, let me imorru quddiem u biss
jissellef dan il-kodiċi għal mument.

984
00:48:12,630 --> 00:48:15,860
Jien se jmorru fil Cloud9, l-ebda ħtieġa
li jmorru hemm infuskom għadha biss,

985
00:48:15,860 --> 00:48:21,350
u jien ser sejħa dan alert.HTML.

986
00:48:21,350 --> 00:48:23,650
Jien ser paste fil-fajl tiegħi hawn.

987
00:48:23,650 --> 00:48:32,070
U biss biex tiċċara dak li ghamilt, let
me go għal dan l-indirizz u jmorru biex iwissu,

988
00:48:32,070 --> 00:48:33,870
u inti tara l-Organizzazzjoni Dinjija Hello.

989
00:48:33,870 --> 00:48:35,440
>> Iżda din hija tip ta 'underwhelming.

990
00:48:35,440 --> 00:48:37,410
I trid tagħmel xi ħaġa
ftit differenti.

991
00:48:37,410 --> 00:48:40,610
Hekk jien ser fil-fatt jagħmlu dan.

992
00:48:40,610 --> 00:48:43,820
Jien se jmorru fil hawn e,
u fl bejn tags iskrittura tiegħi,

993
00:48:43,820 --> 00:48:53,460
jgħidu twissija ( "bonjour, dinja"); hekk avviż
huwa ftit sloppy, imma stajt ltqajna HTML,

994
00:48:53,460 --> 00:48:56,180
ġewwa minnhom hija
lingwa imsejħa JavaScript,

995
00:48:56,180 --> 00:48:59,420
u dan huwa dak li sejjaħ
sejħa funzjoni jew sejħa proċedura.

996
00:48:59,420 --> 00:49:04,500
Dan huwa verb, litteralment, f'dan il-każ,
u jiena jinvoka funzjonalità kodiċi

997
00:49:04,500 --> 00:49:06,310
li xi ħadd ieħor kiteb.

998
00:49:06,310 --> 00:49:09,630
>> Allura li l-funzjonalità hija
allert, sabiex ejja mur din il-paġna

999
00:49:09,630 --> 00:49:14,046
issa u kklikkja rikarigu, u issa int
tara xi ftit ta 'interattività.

1000
00:49:14,046 --> 00:49:15,420
Huwa tip ta 'skola qodma u ikrah.

1001
00:49:15,420 --> 00:49:18,580
Dan it-tip ta tfakkrek l
pop-ups, forsi, ta 'l-imgħoddi

1002
00:49:18,580 --> 00:49:22,030
iżda hija ma tagħmel xi ħaġa
ftit aktar programmatiku.

1003
00:49:22,030 --> 00:49:26,940
>> Allura aktar minn dan, ejja do
xi ħaġa aktar interessanti.

1004
00:49:26,940 --> 00:49:30,980
Let me go hawn u teħles minn dan.

1005
00:49:30,980 --> 00:49:33,840
U jien ser jimxi 'l quddiem u
joħloq forma bħal għamilna bieraħ.

1006
00:49:33,840 --> 00:49:34,840
Attwalment, inti taf liema?

1007
00:49:34,840 --> 00:49:37,350
Jien se jmorru fil
google.html, li aħna

1008
00:49:37,350 --> 00:49:43,027
bdiet fuq bieraħ, li dehru qishom
dan, permezz li aħna mfittxija għall-qattus

1009
00:49:43,027 --> 00:49:45,360
Iżda avviż hemm tip ta '
bug fil-verżjoni kurrenti.

1010
00:49:45,360 --> 00:49:49,770
Hija taħdem għall-qtates, iżda jissoponi li
Jien ma jikkooperawx u jien tip xejn,

1011
00:49:49,770 --> 00:49:53,290
u jien sempliċement ikklikkja jissottomettu.

1012
00:49:53,290 --> 00:49:54,540
C'est tip ta 'mġieba stramb.

1013
00:49:54,540 --> 00:49:57,300
Domt għall-Google reali,
ma tagħti me messaġġ ta 'żball.

1014
00:49:57,300 --> 00:50:00,590
Nixtieq li tgħid l-utent
għandek bżonn biex tagħtina valur.

1015
00:50:00,590 --> 00:50:01,780
>> Allura kif tista 'nagħmlu dan?

1016
00:50:01,780 --> 00:50:06,790
Well let me jmorru lura fis Cloud9 u
let me jmorru fil-quċċata tal-paġna tiegħi

1017
00:50:06,790 --> 00:50:11,980
u żid tag b'kitba bħal dan, fejn
Jien ser tip xi kodiċi JavaScript.

1018
00:50:11,980 --> 00:50:15,420
U jien ser jagħmlu dan li ġej.

1019
00:50:15,420 --> 00:50:22,910
Jekk (document.getelementByID-- u jfakkru
li tkellimna dwar dan qabel,

1020
00:50:22,910 --> 00:50:23,960
dik il-funzjoni.

1021
00:50:23,960 --> 00:50:25,310
Dak ID do I rridu nġibu?

1022
00:50:25,310 --> 00:50:33,050
I rridu nġibu Q, u jien ser
jiġifieri huwa ugwali xejn, bħal this--

1023
00:50:33,050 --> 00:50:38,220
attwalment let me użu kwotazzjonijiet doppja
biss għall consistency-- huwa daqs xejn,

1024
00:50:38,220 --> 00:50:46,650
imbagħad twissija ( "Daħħal l query") hawn.

1025
00:50:46,650 --> 00:50:49,200
>> So I jkollhom dak li jidher li jkun
xi ħaġa bħal kundizzjoni.

1026
00:50:49,200 --> 00:50:51,410
Rajna din l-idea ġenerali scratch.

1027
00:50:51,410 --> 00:50:54,240
Huwa bħal wieħed minn dawk puzzle
biċċiet li dehru qishom dan l.

1028
00:50:54,240 --> 00:50:55,780
U dak li jien qal?

1029
00:50:55,780 --> 00:50:59,520
Ukoll, stabbiliti hawn, l-avviż jien
se jagħmlu dan li ġej.

1030
00:50:59,520 --> 00:51:02,790
Jien ser tagħti din il-formola
qasam mhux biss isem ta 'Q, li

1031
00:51:02,790 --> 00:51:06,630
huwa dak gets mgħoddi lill-Google, imma jien
ser tagħtiha identifikatur lokali,

1032
00:51:06,630 --> 00:51:07,630
imsejħa wkoll q.

1033
00:51:07,630 --> 00:51:11,780
Imma I jistgħu sejħa dan xejn I
trid, jien biss ser jżommha sempliċi

1034
00:51:11,780 --> 00:51:14,570
u wkoll sejħa hija q, biss għas-sempliċità.

1035
00:51:14,570 --> 00:51:17,650
>> U issa jien se tagħmel
xi ftit aktar.

1036
00:51:17,650 --> 00:51:22,600
Fuq il-forma oqsma hawn, jien ser
żid dak li sejjaħ handler avveniment.

1037
00:51:22,600 --> 00:51:32,260
Fuq tissottometti, nixtieq li sejħa
funzjoni msejħa Ivvalida.

1038
00:51:32,260 --> 00:51:35,520
Dan ma jeżistux, f'dan il-
kelma, jew din id jivvalidaw verb,

1039
00:51:35,520 --> 00:51:38,560
għaliex dak li jien ser tagħmel
hawn issa hu li żżid xi kodiċi.

1040
00:51:38,560 --> 00:51:42,200
>> Jien se ngħid Validate funzjoni.

1041
00:51:42,200 --> 00:51:48,280
Jien ser inċiż dan u żid ieħor
Brace kaboċċi hawn u ieħor hawn.

1042
00:51:48,280 --> 00:51:50,110
Ikkunsidra dak li din issa qed tagħmel.

1043
00:51:50,110 --> 00:51:54,210
Għandi now-- think ta 'dan bħala ħoloq tiegħi
stess biċċa puzzle li ma jkunux qabel

1044
00:51:54,210 --> 00:51:57,440
jeżistu, u stajt sejjaħ dan puzzle
biċċa l-biċċa puzzle Validate.

1045
00:51:57,440 --> 00:52:01,620
L-għan tiegħu fil-ħajja huwa li teżegwixxi
l-erba 'linji ta' kodiċi ta 'ġewwa ta' dan.

1046
00:52:01,620 --> 00:52:04,940
>> jekk document.getElementByID
hekk kunċettwalment,

1047
00:52:04,940 --> 00:52:09,380
li ser jmorru fil--element,
l-element HTML li uniċi

1048
00:52:09,380 --> 00:52:12,930
idea hija biss q, u mbagħad anki jekk
il sintassi jistenna ftit stramb,

1049
00:52:12,930 --> 00:52:16,430
li ndaqs huwa ugwali ifisser biss ugwali.

1050
00:52:16,430 --> 00:52:20,950
Allura li jfisser li jekk l-element bl-
identifikatur uniku tal q, meta gotten,

1051
00:52:20,950 --> 00:52:25,700
m'għandha l-ebda valur, hija biss huwa daqs
kwotazzjoni unquote, xejn fil hemm,

1052
00:52:25,700 --> 00:52:27,170
allura dak li nixtieq do?

1053
00:52:27,170 --> 00:52:29,360
Irrid li Yell fil-utent.

1054
00:52:29,360 --> 00:52:31,710
>> U aħna mhux se jmorru dettal ħafna hawn.

1055
00:52:31,710 --> 00:52:32,960
Jien ser jirritornaw falza.

1056
00:52:32,960 --> 00:52:34,380
Dan huwa żball.

1057
00:52:34,380 --> 00:52:38,746
Inkella, jien ser jirritorna veru.

1058
00:52:38,746 --> 00:52:40,120
Allura kemm hija maħduma jew dan ma kienx.

1059
00:52:40,120 --> 00:52:41,800
Falza jew veru.

1060
00:52:41,800 --> 00:52:47,820
U issa jekk jien ma tagħmel xi żbalji,
let me jiffranka dan u rikarigu dan il.

1061
00:52:47,820 --> 00:52:50,940
U let me check biss doppju ta 'dak
I ma, fil-fatt, tagħmel xi typos,

1062
00:52:50,940 --> 00:52:52,690
so I ma embarras lili nnifsi.

1063
00:52:52,690 --> 00:52:54,240
Ejja naraw jekk dan jaħdem.

1064
00:52:54,240 --> 00:52:56,930
>> Allura issa jien ser qtates tip.

1065
00:52:56,930 --> 00:52:59,421
Għadu jaħdem, jew xogħlijiet nofs, mill-inqas.

1066
00:52:59,421 --> 00:53:02,170
Issa let me rikarigu dan, u issa ejja
me jippruvaw jissottomettu mingħajr ittajpjar

1067
00:53:02,170 --> 00:53:05,860
anything-- kkritikat dan, kissru.

1068
00:53:05,860 --> 00:53:06,430
Wieħed mill-mument.

1069
00:53:06,430 --> 00:53:09,380

1070
00:53:09,380 --> 00:53:12,660
Let me tiftaħ il-console,
[Inaudible] log, rikarigu-paġna.

1071
00:53:12,660 --> 00:53:13,576
Let me jippruvaw dan jerġa.

1072
00:53:13,576 --> 00:53:17,000

1073
00:53:17,000 --> 00:53:17,501
Oh, kkritikat dan.

1074
00:53:17,501 --> 00:53:18,000
Insejt.

1075
00:53:18,000 --> 00:53:18,630
I magħmula typo.

1076
00:53:18,630 --> 00:53:20,760
I remember dak li hu.

1077
00:53:20,760 --> 00:53:21,350
.value.

1078
00:53:21,350 --> 00:53:27,060
I fisser li jgħidu jekk il-valur
tal-element ID li hija q

1079
00:53:27,060 --> 00:53:29,800
huwa egwali għal dak, allura Yell fil-utent.

1080
00:53:29,800 --> 00:53:31,870
>> Allura issa let me jżommu n-nifs tiegħi mill-ġdid.

1081
00:53:31,870 --> 00:53:33,480
Here we go.

1082
00:53:33,480 --> 00:53:34,130
Hemm immorru.

1083
00:53:34,130 --> 00:53:35,010
Jekk jogħġbok tip query.

1084
00:53:35,010 --> 00:53:36,840
Allura huwa ma kiri lili permezz.

1085
00:53:36,840 --> 00:53:40,210
I jista 'jkun it-tip ta' jilgħab ma 'dan,
u minflok ta 'verifika għall-ebda valur,

1086
00:53:40,210 --> 00:53:46,720
Nista 'ngħid xi ħaġa simili,
mhux aktar tiftix għall-qtates,

1087
00:53:46,720 --> 00:53:51,150
u issa nistgħu biss aktar playfully let
it-tfittxija utent għall-klieb jekk hu jew hi

1088
00:53:51,150 --> 00:53:57,490
jixtieq, jew jekk immur fil hawn u
tfittxija għall-qtates, issa ma nistax.

1089
00:53:57,490 --> 00:53:58,690
>> Allura x'inhu l-takeaway hawn?

1090
00:53:58,690 --> 00:54:03,010
Allura wieħed, konna introdotti fil
dinja tagħna ta 'HTML u CSS,

1091
00:54:03,010 --> 00:54:04,320
funzjonalità programmazzjoni.

1092
00:54:04,320 --> 00:54:06,300
I jistgħu attwalment issa
jagħmlu deċiżjonijiet fil-kodiċi.

1093
00:54:06,300 --> 00:54:10,570
Preċedentement, kollha I tista 'tagħmel huwa mark up
kontenut testwali jew il-kontenut grafika

1094
00:54:10,570 --> 00:54:13,080
u għid liema tfittex
simili u fejn li jintwerew.

1095
00:54:13,080 --> 00:54:16,650
Issa I jistgħu attwalment jistaqsu
kwistjonijiet ta 'l-web page

1096
00:54:16,650 --> 00:54:20,010
u jagħmlu deċiżjonijiet ibbażati
fuqha, u fil-pront l-utent

1097
00:54:20,010 --> 00:54:22,780
jekk għandi bżonn biex Yell fi lilu jew lilha.

1098
00:54:22,780 --> 00:54:28,740
>> Mela ejja tipprova xi ħaġa
waħedna ma 'dan.

1099
00:54:28,740 --> 00:54:33,350
Jimxi 'l quddiem, let me tiftaħ il-pjastra jmiss
hawn, u biss josservaw ħaġa waħda.

1100
00:54:33,350 --> 00:54:37,250
Eżatt bħal ma 'CSS, nistgħu fattur barra
kodiċi JavaScript tagħna għal fajl separat,

1101
00:54:37,250 --> 00:54:40,660
inti tista 'tagħmel l-istess ħaġa
ma JavaScript kif ma CSS.

1102
00:54:40,660 --> 00:54:44,520
U inti tuża dak li juża sors
jattribwixxu tal-lametta iskrittura.

1103
00:54:44,520 --> 00:54:46,540
Iżda aħna mhux se jikkumplikaw l-affarijiet għal issa.

1104
00:54:46,540 --> 00:54:50,440
Minflok, jekk inti tista '
mur ma din il-paġna,

1105
00:54:50,440 --> 00:55:02,690
but-- let me jimxu madwar dan fil order--
mur, jekk inti tista ', din il-paġna hawn.

1106
00:55:02,690 --> 00:55:03,592
Dan il-URL hawn.

1107
00:55:03,592 --> 00:55:04,550
Huwa fil pjastri lum.

1108
00:55:04,550 --> 00:55:07,133
Inti jista 'jkollok biex jerġgħu jitgħabbew għaliex
Stajt miżjud koppja ta 'ħaġa.

1109
00:55:07,133 --> 00:55:09,970

1110
00:55:09,970 --> 00:55:13,890
>> Iżda jmorru hemm fejn xi puzzles tistenna.

1111
00:55:13,890 --> 00:55:16,670
U dan se tagħtina opportunità,
f'kuntest kemmxejn aktar divertenti,

1112
00:55:16,670 --> 00:55:20,610
dabble ma 'xi JavaScript.

1113
00:55:20,610 --> 00:55:25,505
U meta inti naslu s'hemm,
I ser jispjegaw dak li jistenna.

1114
00:55:25,505 --> 00:55:47,350

1115
00:55:47,350 --> 00:55:47,850
Get aħdar.

1116
00:55:47,850 --> 00:56:03,063

1117
00:56:03,063 --> 00:56:03,562
Set blu.

1118
00:56:03,562 --> 00:56:11,030

1119
00:56:11,030 --> 00:56:13,930
Settijiet aħdar, settijiet aħmar.

1120
00:56:13,930 --> 00:56:19,220

1121
00:56:19,220 --> 00:56:20,220
Oops.

1122
00:56:20,220 --> 00:56:22,330
Jiddispjacini.

1123
00:56:22,330 --> 00:56:27,630
>> Dan huwa l-estent ta 'tagħna
dokumentazzjoni għal din l-isfida.

1124
00:56:27,630 --> 00:56:29,920
U dan ikun sejjer jaħdem kif ġej.

1125
00:56:29,920 --> 00:56:33,340
Allura dak li għandek fuq din il
paġna huwa mazz sħiħ

1126
00:56:33,340 --> 00:56:38,024
ta 'puzzles immaġni minn buddy
fil Stanford University.

1127
00:56:38,024 --> 00:56:41,190
Allura dak li int tara hawnhekk huwa kważi
tip ta 'wieħed minn dawn il puzzles għajnejn magic,

1128
00:56:41,190 --> 00:56:43,815
imma jekk inti biss stare fil dan,
xejn għaddej biex pop fil inti.

1129
00:56:43,815 --> 00:56:46,000
Pjuttost, hija xi ħaġa
moħbija fil din id-dehra.

1130
00:56:46,000 --> 00:56:47,790
U huwa moħbija fil-mod li ġej.

1131
00:56:47,790 --> 00:56:51,740
Images, kif inti tista 'taf, jista' jkun
komposta minn biss tliet kuluri.

1132
00:56:51,740 --> 00:56:53,346
Xi aħmar, xi blu, u xi aħdar.

1133
00:56:53,346 --> 00:56:55,220
U nistgħu nagħmlu l-
kuluri fil-qawsalla

1134
00:56:55,220 --> 00:56:57,570
bit-taħlit dawn it-tliet kuluri b'xi.

1135
00:56:57,570 --> 00:57:01,940
>> Allura dan jistenna aktar aħdar u
blu, iżda bħala Nick jgħid hawnhekk,

1136
00:57:01,940 --> 00:57:04,060
din id-dehra puzzle ħadid huwa puzzle.

1137
00:57:04,060 --> 00:57:06,780
Fiha l-immaġni ta
xi ħaġa famużi, madankollu,

1138
00:57:06,780 --> 00:57:08,310
-immaġini tkun ġiet mgħawġa.

1139
00:57:08,310 --> 00:57:11,500
L-għan famuża hija fil-valuri aħmar.

1140
00:57:11,500 --> 00:57:13,810
Valuri Madankollu, il ħomor
kollha ġew diviżi b'10.

1141
00:57:13,810 --> 00:57:16,230
Allura dawn huma żgħar wisq b'fattur ta '10.

1142
00:57:16,230 --> 00:57:18,280
Allura fi kliem ieħor, Nick
ħadet immaġini oriġinali,

1143
00:57:18,280 --> 00:57:21,500
u hu desaturated kollha
tal-aħmar minnha,

1144
00:57:21,500 --> 00:57:23,850
jbaxxu l-ammont ta 'aħmar
linka, jekk inti se, fiha.

1145
00:57:23,850 --> 00:57:26,060
>> Il-valuri blu u ħodor
huma kollha biss bla sens,

1146
00:57:26,060 --> 00:57:30,000
Valuri każwali, aka istorbju iddisinjati
joskuraw l-immaġni reali.

1147
00:57:30,000 --> 00:57:32,250
Allura dak li Nick ma kien hu
attenwata l-aħmar u mbagħad

1148
00:57:32,250 --> 00:57:34,380
hu biss threw każwali
ammonti ta 'blu u ħodor

1149
00:57:34,380 --> 00:57:37,590
fil-immaġini biex tip ta joskuraw
x'hemm attwalment għadha hemm.

1150
00:57:37,590 --> 00:57:41,089
Int trid teqred dawn id-distorsjonijiet
li tiżvela l-immaġini.

1151
00:57:41,089 --> 00:57:44,255
L-ewwel, tistabbilixxi l-valuri blu u ħodor
għal żero biex tikseb minnhom barra mill-mod,

1152
00:57:44,255 --> 00:57:48,700
u ħarsa lejn ir-riżultat. imbagħad
immoltiplika kull valur aħmar b'10,

1153
00:57:48,700 --> 00:57:51,720
skalar lura sa l
bejn wieħed u ieħor il-valur finali tiegħu.

1154
00:57:51,720 --> 00:57:53,035
X'inhu l-oġġett famuż?

1155
00:57:53,035 --> 00:57:57,920
>> Allura kollha inti għandek dan ir-rettangolu
fil-browser tiegħek dritt issa.

1156
00:57:57,920 --> 00:58:00,830
U avviż li hemm xi
kodiċi starter, biex ngħidu hekk.

1157
00:58:00,830 --> 00:58:04,370
Dan huwa kodiċi JavaScript li
Nick kitbet għalik.

1158
00:58:04,370 --> 00:58:07,250
U avviż li hemm
linja fin-nofs li

1159
00:58:07,250 --> 00:58:10,380
jibda bil slash mmejla, li l-
x'hemm ġeneralment imsejjaħ kumment.

1160
00:58:10,380 --> 00:58:14,660
Dan ifisser li huwa frażi li l-programmer
li għandha l-ebda tifsira funzjonali.

1161
00:58:14,660 --> 00:58:16,520
Huwa biss CUÉ viżwali għall-bniedem.

1162
00:58:16,520 --> 00:58:18,670
>> Allura inti tista 'tmur quddiem u
ħassar biss dik il-linja,

1163
00:58:18,670 --> 00:58:22,214
u tkun super attent li ma
tħassar jew tbiddel xi ħaġa oħra.

1164
00:58:22,214 --> 00:58:25,130
U let me biss jimxu miegħek permezz
liema dan il-kodiċi ma u jien ser jitilqu minnu

1165
00:58:25,130 --> 00:58:28,580
lilek biex insemmu l-immaġini sigrieti.

1166
00:58:28,580 --> 00:58:32,226
Dan l-ewwel linja hawnhekk li stajt biss
enfasizzati jagħtik dan li ġej.

1167
00:58:32,226 --> 00:58:34,100
Min-naħa tax-xellug,
għandek dak li sejjaħ

1168
00:58:34,100 --> 00:58:39,140
varjabbli li Nick għandha arbitrarju,
iżda raġonevolment sejjaħ im għall-immaġni.

1169
00:58:39,140 --> 00:58:41,660
Min-naħa tal-lemin
ta 'dak is-sinjal ugwali,

1170
00:58:41,660 --> 00:58:45,240
hu qal jagħtu me ġdid
kwotazzjoni, unquote "immaġini sempliċi".

1171
00:58:45,240 --> 00:58:49,680
>> immaġni sempliċi, f'dan il-kuntest
huwa dak li sejjaħ klassi, ukoll,

1172
00:58:49,680 --> 00:58:53,910
huwa tip simili ta 'class--
teknikament prototype-- imma verament,

1173
00:58:53,910 --> 00:58:58,000
dan huwa tajtu lili oġġett ġdid,
l-kontenut tagħha huma l-fajl,

1174
00:58:58,000 --> 00:58:59,610
ħadid puzzle.png.

1175
00:58:59,610 --> 00:59:03,190
Fi kliem ieħor, Nick ħoloq
dan il-kunċett ta 'immaġni sempliċi

1176
00:59:03,190 --> 00:59:05,920
sabiex inkunu nistgħu, għal pedagoġika
skopijiet, play mal-immaġni

1177
00:59:05,920 --> 00:59:09,790
u l-bidla aħmar tagħha,
Valuri aħdar, u blu.

1178
00:59:09,790 --> 00:59:11,750
>> U kif qed nagħmlu dan?

1179
00:59:11,750 --> 00:59:15,360
Din il sintassi kemmxejn mistur hawn
huwa tip ta bħall-blokk irrepeti

1180
00:59:15,360 --> 00:59:19,140
li xi wħud minnkom raw fil Scratch preċedenti
illum, fejn inti tista 'tirrepeti 10 darbiet.

1181
00:59:19,140 --> 00:59:22,220
F'dan il-każ, Nick ma jkunx
hardcoded numru simili 10.

1182
00:59:22,220 --> 00:59:28,020
Minflok huwa qal, initialize
varjabbli msejħa x għal 0,

1183
00:59:28,020 --> 00:59:33,180
iċċekkja jekk x huwa inqas minn
il-wisa 'l-immaġini.

1184
00:59:33,180 --> 00:59:38,160
>> U dan biex ikun aktar xieraq, immaġini huwa l-
varjabbli, dot ifisser mur ġewwa ta 'dan

1185
00:59:38,160 --> 00:59:40,900
u nikseb wisa 'tagħha, u
imbagħad paren miftuħa, magħluqa

1186
00:59:40,900 --> 00:59:43,687
paren huwa biss mod ta 'programmer
kif tgħid dan huwa funzjoni.

1187
00:59:43,687 --> 00:59:44,520
Din hija proċedura.

1188
00:59:44,520 --> 00:59:46,430
Dan huwa funzjonalità
xi ħadd ieħor kiteb.

1189
00:59:46,430 --> 00:59:48,570
Jużawha u tagħti me lura risposta.

1190
00:59:48,570 --> 00:59:53,610
U allura x ++ huwa mod fancy ta '
qal, wara li inti ghamilt dan darba,

1191
00:59:53,610 --> 00:59:55,850
inkrement x b'1.

1192
00:59:55,850 --> 00:59:58,760
Fi kliem ieħor, dan
huwa mod ta 'programmer

1193
00:59:58,760 --> 01:00:05,760
tħeġġeġ lil linja li l-
ser jtenni fuq

1194
01:00:05,760 --> 01:00:10,410
kollha tal-kolonni fi immaġini.

1195
01:00:10,410 --> 01:00:14,790
>> Immaġini huwa biss grilja ta '
tikek, ringieli u kolonni ta 'tikek.

1196
01:00:14,790 --> 01:00:18,270
Dan huwa mod ta 'iterazzjoni
fuq kollha ta 'dawn il-kolonni.

1197
01:00:18,270 --> 01:00:20,770
U fuq ġewwa,
sadanittant, aħna qed jiġu mtennija

1198
01:00:20,770 --> 01:00:24,030
matul l-għoli, hawn
u hawn u hawn.

1199
01:00:24,030 --> 01:00:29,442
Allura dan huwa biss mod ta 'traipsing,
kważi simili typewriter iskola antika,

1200
01:00:29,442 --> 01:00:32,230
li jmorru biss fuq il-
immaġini kollu iteratively.

1201
01:00:32,230 --> 01:00:36,370
Anki li mhux pjuttost kompletament
ċar, ħu fuq il-fidi għal issa,

1202
01:00:36,370 --> 01:00:38,880
li dawn it-tliet linji
tal-kodiċi flimkien huma

1203
01:00:38,880 --> 01:00:43,090
ser jippermettu li inti iteratively tfittex
f'kull pixel, kull dot fil-immaġini.

1204
01:00:43,090 --> 01:00:43,790
>> X'hemm pixel?

1205
01:00:43,790 --> 01:00:46,250
Ukoll, li tkun ċara, jekk inħarsu
fil-oriġinali u zoom fi,

1206
01:00:46,250 --> 01:00:49,060
jekk int verament tpoġġi għajnejn tiegħek
l-iskrin tal-kompjuter, dan huwa

1207
01:00:49,060 --> 01:00:53,510
biss mazz sħiħ ta 'tikek, diversi
elf tikek ppakkjati flimkien hemmhekk.

1208
01:00:53,510 --> 01:00:56,180
U għalhekk dak li huma inti waslu biex jagħmlu?

1209
01:00:56,180 --> 01:00:59,240
Kull wieħed minn dawn il tikek,
definizzjoni finali,

1210
01:00:59,240 --> 01:01:06,350
hija r-riżultat ta 'dak li ġeneralment
imsejħa RGB, aħmar, aħdar, blu, li

1211
01:01:06,350 --> 01:01:09,940
għal darb'oħra, jistgħu jiġu kkombinati sa
jagħtuk l-ebda numru ta 'kuluri.

1212
01:01:09,940 --> 01:01:13,200
>> Fil-fatt, jekk inti tiftakar
minn ħafna, ħafna snin ilu,

1213
01:01:13,200 --> 01:01:17,320
skrins proġettazzjoni bħal dawn l-affarijiet
użati li jkollhom mhux lenti waħda iżda tlieta.

1214
01:01:17,320 --> 01:01:20,700
Waħda minnhom bżiq dawl aħmar, wieħed mill
minnhom bżiq dawl aħdar, wieħed minnhom

1215
01:01:20,700 --> 01:01:21,600
bżiq dawl blu.

1216
01:01:21,600 --> 01:01:24,391
U jekk inti kienu fi skola tan-nofs
bħal I kien fejn kienu qatt

1217
01:01:24,391 --> 01:01:27,000
allineati kif jixraq, inti kienu
dejjem jaraw films istorja

1218
01:01:27,000 --> 01:01:29,770
li kienu ftit mgħawġa,
minħabba li t-tliet kuluri ma kinux

1219
01:01:29,770 --> 01:01:30,970
jikkombinaw sew.

1220
01:01:30,970 --> 01:01:36,330
>> Iżda jirriżulta li kull wieħed
dawn il-valuri aħmar, aħdar, u blu,

1221
01:01:36,330 --> 01:01:37,980
jista 'jkollhom numru assoċjati magħhom.

1222
01:01:37,980 --> 01:01:42,500
Per eżempju, 0 għat aħmar ifisser l-ebda
aħmar, 0 għat aħdar jfisser l-ebda aħdar,

1223
01:01:42,500 --> 01:01:45,120
u 0 għat blu jfisser l-ebda blu.

1224
01:01:45,120 --> 01:01:49,403
Mela jekk ma jkollok ebda aħmar, l-ebda aħdar,
u l-ebda blu, liema kulur għandek?

1225
01:01:49,403 --> 01:01:51,009
>> UDJENZA: [inaudible]

1226
01:01:51,009 --> 01:01:52,800
DAVID Malan: Int tkun
hope so, huwa abjad.

1227
01:01:52,800 --> 01:01:55,333
Sfortunatament, dan operates-- sorry?

1228
01:01:55,333 --> 01:01:56,380
>> UDJENZA: [inaudible]

1229
01:01:56,380 --> 01:01:58,630
DAVID Malan: Allura inti fil-fatt
għandhom iswed, f'dan il-każ.

1230
01:01:58,630 --> 01:02:01,530
Mela jekk għandek ebda wieħed minn dawn
kuluri mixgħula, għandek iswed.

1231
01:02:01,530 --> 01:02:06,510
Madankollu, jekk għandek, ejja ngħidu ħafna
minnhom, simili ħafna ta 'aħmar, 255 ta' dan,

1232
01:02:06,510 --> 01:02:10,340
ħafna aħdar, u ħafna
ta blu, li huwa abjad.

1233
01:02:10,340 --> 01:02:12,230
Allura dawn huma l-żewġ estremi.

1234
01:02:12,230 --> 01:02:17,460
Allura billi din il-loġika, jekk għandi ħafna
ta 'aħmar u l-ebda aħdar u l-ebda blu,

1235
01:02:17,460 --> 01:02:18,485
liema kulur huwa li?

1236
01:02:18,485 --> 01:02:19,360
UDJENZA: [inaudible]

1237
01:02:19,360 --> 01:02:20,610
DAVID Malan: Dritt, ovvjament.

1238
01:02:20,610 --> 01:02:25,940
U allura l-ebda aħmar, lott ta '
aħdar, l-ebda blu, u mbagħad

1239
01:02:25,940 --> 01:02:29,590
jekk inti have-- ukoll, aħna ser biss finitura
dan, sempliċement minħabba, iżda dan, naturalment,

1240
01:02:29,590 --> 01:02:31,350
Issa, huwa blu.

1241
01:02:31,350 --> 01:02:33,030
U issa inti tista 'tgħaqqad dawn il-kuluri.

1242
01:02:33,030 --> 01:02:36,430
Issa bħala twarrib, jekk kwalunkwe inti għandek
qatt sar xi disinn ta 'website attwali,

1243
01:02:36,430 --> 01:02:38,360
inti tista 'attwalment
ara simboli bħal dan.

1244
01:02:38,360 --> 01:02:42,030
FFF-- u fil-fatt, huwa
probabbilment lanqas dik.

1245
01:02:42,030 --> 01:02:44,380
Huwa FFFFFF.

1246
01:02:44,380 --> 01:02:48,970
>> Ħadd qatt rat s F u E tal
u A through-- għalhekk jirriżulta,

1247
01:02:48,970 --> 01:02:52,970
tkellimna bieraħ dwar deċimali,
u llum, it-tip ta 'madwar deċimali.

1248
01:02:52,970 --> 01:02:54,570
Illum tkellimna dwar binarja.

1249
01:02:54,570 --> 01:02:59,010
Jirriżulta, hexadeċimali huwa ferm
sistema bażi komuni għall-użu fil-kompjuters.

1250
01:02:59,010 --> 01:03:04,960
Binarju huwa tnejn, deċimali huwa 10, hex hija 16.

1251
01:03:04,960 --> 01:03:08,640
U jirriżulta, kif do
inti għadd f'hexadecimal?

1252
01:03:08,640 --> 01:03:11,620
Żero, wieħed, tnejn, tlieta, erba,
ħames, sitt, seba ', tmien,

1253
01:03:11,620 --> 01:03:14,730
disa ', liema do you tuża wara disa?

1254
01:03:14,730 --> 01:03:16,600
X'hemm-numru li jmiss?

1255
01:03:16,600 --> 01:03:19,180
Aħna diġà użati żero.

1256
01:03:19,180 --> 01:03:20,570
I bżonn 16 ta 'dawn.

1257
01:03:20,570 --> 01:03:25,770
Żero, wieħed, tnejn, tlieta, erba,
ħames, sitt, seba ', tmien, disa',

1258
01:03:25,770 --> 01:03:27,520
għandek bżonn xi konvenzjoni arbitrarja.

1259
01:03:27,520 --> 01:03:30,810
>> U dak umanità iddeċieda xi żmien
ilu li wara disa 'taqa' l-ittra

1260
01:03:30,810 --> 01:03:34,450
A u mbagħad B u mbagħad Ċ Allura l-
mod inti għadd f'hexadecimal

1261
01:03:34,450 --> 01:03:37,040
huwa żero, wieħed, tnejn, tlieta, erba,
ħames, sitt, seba ', tmien, disa',

1262
01:03:37,040 --> 01:03:42,880
A, B, Ċ, D, E, F, u li se jgħoddu
inti-triq kollha, jirriżulta, sa 15.

1263
01:03:42,880 --> 01:03:47,850
Allura żero sa 15 huwa żero permezz
F. Issa għaliex hija li sinifikanti?

1264
01:03:47,850 --> 01:03:51,570
Ukoll, meta għandek żewġ F, il
li kif inti tesprimi 255.

1265
01:03:51,570 --> 01:03:54,350
>> Allura storja qasira, fil twil
-dinja ta 'Photoshop,

1266
01:03:54,350 --> 01:03:57,299
li softwer ta 'disinn grafiku,
fid-dinja ta 'żvilupp tal-web,

1267
01:03:57,299 --> 01:03:59,590
fejn għandek lottijiet ta 'kuluri,
naturalment, jilagħbu ma ',

1268
01:03:59,590 --> 01:04:02,350
spiss programmaturi se
jesprimu dawk f'hexadecimal,

1269
01:04:02,350 --> 01:04:05,260
sempliċement minħabba li hemm tendenza
li jkun ftit aktar sempliċi.

1270
01:04:05,260 --> 01:04:07,850
Anki jekk l-ewwel daqqa t'għajn
huwa ħafna aktar kumpless.

1271
01:04:07,850 --> 01:04:11,590
>> Allura fi kwalunkwe każ, dan huwa importanti
għaliex Nick fil Stanford

1272
01:04:11,590 --> 01:04:15,100
tatna sitt biċċiet ta 'funzjonalità
li inti, l-programmaturi jibża,

1273
01:04:15,100 --> 01:04:17,060
issa se jkollhom l-abbiltà li persuna tuża.

1274
01:04:17,060 --> 01:04:19,960
Mibnija fil din il-web
paġna huwa ta 'sitt funzjonijiet,

1275
01:04:19,960 --> 01:04:21,820
sitt proċeduri li Nick kiteb.

1276
01:04:21,820 --> 01:04:26,800
Tlieta minnhom inti se tikseb numru,
aħmar, aħdar, jew valur blu.

1277
01:04:26,800 --> 01:04:28,787
Tlieta minnhom se sett dak il-valur.

1278
01:04:28,787 --> 01:04:30,620
U dawn jissottolinja
huma biss placeholders,

1279
01:04:30,620 --> 01:04:32,600
sabiex inti jeħtieġ li tkun taf liema dawn huma.

1280
01:04:32,600 --> 01:04:36,240
>> Allura ma 'dawn it-tliet funzjonijiet,
l-ewwel ta 'dawn l-affarijiet

1281
01:04:36,240 --> 01:04:39,190
se tkun x-jikkoordina,
u t-tieni ta 'dawn l-affarijiet

1282
01:04:39,190 --> 01:04:40,700
se tkun y-jikkoordinaw.

1283
01:04:40,700 --> 01:04:44,650
Fi kliem ieħor, li dot li
pixel do inti tixtieq li tikseb l-aħdar tal-

1284
01:04:44,650 --> 01:04:46,480
jiksbu l-blu tal, jiksbu l-aħmar tal.

1285
01:04:46,480 --> 01:04:51,440
U allura hawnhekk, dan se jkun
x, dan se jkun valur y,

1286
01:04:51,440 --> 01:04:55,379
u dan se jkun hemm numru.

1287
01:04:55,379 --> 01:04:57,170
Mela ejja jagħmlu l-ewwel
Linja ta 'dan flimkien

1288
01:04:57,170 --> 01:05:00,220
u mbagħad I ser jitilqu minnu lilek
biex tipprova tiddeduċi l-bqija.

1289
01:05:00,220 --> 01:05:03,100
Allura skond l-istruzzjonijiet
fuq din il-paġna, għandna bżonn

1290
01:05:03,100 --> 01:05:08,960
biex iżidu l-aħmar b'fattur ta
10, u għandna bżonn biex tneħħi l-aħdar

1291
01:05:08,960 --> 01:05:09,930
u neħħi l-blu.

1292
01:05:09,930 --> 01:05:12,410
Nibdew bl-xenarji aħħar.

1293
01:05:12,410 --> 01:05:17,760
Mela jekk jien tixtieq li, u jien ser
li inċiż billi tuża xi spazji,

1294
01:05:17,760 --> 01:05:22,291
jekk irrid li jiġu stabbiliti l-aħmar,
l-aħdar, jew il-valur blu,

1295
01:05:22,291 --> 01:05:23,540
Jien ser tagħmel dan li ġej.

1296
01:05:23,540 --> 01:05:31,280
>> Image, im.setBlue, u mbagħad
ibbażat fuq l-istruzzjonijiet tiegħi hawn,

1297
01:05:31,280 --> 01:05:36,700
liema tliet affarijiet għandi
tip ġewwa ta 'parentesi issa?

1298
01:05:36,700 --> 01:05:41,960
I bżonn l-valur x, il
valur y, u liema numru

1299
01:05:41,960 --> 01:05:48,770
Għandu nressaq hawn jekk irrid biex jeħles
-blu, ibbażat fuq din l-istorja hawn?

1300
01:05:48,770 --> 01:05:49,630
Just żero.

1301
01:05:49,630 --> 01:05:52,420
Jekk irrid ebda blu, jien biss
se jibdlu għal żero.

1302
01:05:52,420 --> 01:05:54,465
>> Issa ejja biss terġa dak li dan qed tagħmel.

1303
01:05:54,465 --> 01:05:56,970

1304
01:05:56,970 --> 01:06:01,170
Għandi hawn fuq dawn quċċata
tieni u t-tielet linji,

1305
01:06:01,170 --> 01:06:04,080
I tellgħu żewġ linji,
loops nested, jekk inti

1306
01:06:04,080 --> 01:06:08,360
se, li ser ikollhom l-effett
ta 'progress mix-xellug għal-lemin,

1307
01:06:08,360 --> 01:06:11,590
fuq għal isfel fuq kollha ta 'l-x
valuri u l-valuri y.

1308
01:06:11,590 --> 01:06:15,167
Minħabba darb'oħra, l-istampa hija
biss grilja ta 'ringieli u kolonni.

1309
01:06:15,167 --> 01:06:17,000
Allura dan se tikseb
rid ta 'l-blu.

1310
01:06:17,000 --> 01:06:18,627
Let me leave fil-linja li jmiss lilek.

1311
01:06:18,627 --> 01:06:20,043
Kif nista 'jeħles ta' dan kollu aħdar?

1312
01:06:20,043 --> 01:06:23,747

1313
01:06:23,747 --> 01:06:25,140
>> UDJENZA: [inaudible]

1314
01:06:25,140 --> 01:06:26,151
>> DAVID Malan: Nizza.

1315
01:06:26,151 --> 01:06:28,260
>> UDJENZA: [inaudible]

1316
01:06:28,260 --> 01:06:30,850
>> DAVID Malan: Nizza.

1317
01:06:30,850 --> 01:06:36,120
U jien ser zoom out, u ħu
kura ta 'dak li inti stajt ma jsirx ebda typos.

1318
01:06:36,120 --> 01:06:39,390
U jekk int komdu
ma 'dak li inti ghamilt,

1319
01:06:39,390 --> 01:06:42,936
imorru quddiem u kklikkja l-buttuna
Mexxi / Save u ara dak ikollok.

1320
01:06:42,936 --> 01:06:46,982

1321
01:06:46,982 --> 01:06:48,690
U għal darb'oħra, aħna ħadna
biss tliet bidliet.

1322
01:06:48,690 --> 01:06:52,130
Aħna imħassar li l-ewwel
jikkummentaw u sostitwit

1323
01:06:52,130 --> 01:06:53,575
ma 'dawn iż-żewġ linji ta' kodiċi.

1324
01:06:53,575 --> 01:06:55,742

1325
01:06:55,742 --> 01:06:58,450
U huwa OK jekk inti għandek bżonn hit
il-buttuna Mexxi / Save koppja darbiet

1326
01:06:58,450 --> 01:07:01,190
biex jiffissaw xi ħaġa.

1327
01:07:01,190 --> 01:07:03,610
>> U let me wkoll zoom fl fuq tiegħi
kodiċi sabiex inti tista tifformulaha.

1328
01:07:03,610 --> 01:07:04,110
Tajba.

1329
01:07:04,110 --> 01:07:08,720
So I tara Andrew jkun dak
jidher li jkun żball.

1330
01:07:08,720 --> 01:07:11,110
Hu biss ltqajna big black
rettangolu fuq l-iskrin tiegħu.

1331
01:07:11,110 --> 01:07:13,120
ħaddieħor ma jkollu
rettangolu big black?

1332
01:07:13,120 --> 01:07:13,390
>> UDJENZA: Iva.

1333
01:07:13,390 --> 01:07:14,360
>> DAVID Malan: rettangolu iswed Big?

1334
01:07:14,360 --> 01:07:16,068
OK, so ejja jaħsbu
dwar xi tfisser din.

1335
01:07:16,068 --> 01:07:20,560
Aħna qal li żero, żero, żero,
sabiex l-ebda aħdar, l-ebda aħmar, ebda blu,

1336
01:07:20,560 --> 01:07:21,980
huwa ser jagħtuk iswed.

1337
01:07:21,980 --> 01:07:24,467
U jirriżulta li
ħafna mill-laptops tagħna

1338
01:07:24,467 --> 01:07:25,800
biss ma jkollhomx biżżejjed fedeltà.

1339
01:07:25,800 --> 01:07:27,750
Inti ma tistax pjuttost tell hemmhekk
huwa attwalment xi ħaġa hemmhekk.

1340
01:07:27,750 --> 01:07:30,340
U jekk inti-tip ta 'forsi dgħif
iskrin tiegħek quddiem u lura,

1341
01:07:30,340 --> 01:07:32,850
forsi inti tara
ftit xi ħaġa hemmhekk?

1342
01:07:32,850 --> 01:07:34,820
Forsi, tip ta ', tip ta'?

1343
01:07:34,820 --> 01:07:36,640
Mhuwiex perfettament iswed.

1344
01:07:36,640 --> 01:07:38,050
>> UDJENZA: [inaudible]

1345
01:07:38,050 --> 01:07:39,510
>> DAVID Malan: Spoiler!

1346
01:07:39,510 --> 01:07:42,610
Hemm xi aħmar hemmhekk, iżda
ftakar mill-ispeċifikazzjonijiet

1347
01:07:42,610 --> 01:07:44,940
tal-problema, Nick attenwata l-isfel.

1348
01:07:44,940 --> 01:07:47,860
Huwa desaturated kemmxejn,
iżda mhux it-triq kollha għal żero.

1349
01:07:47,860 --> 01:07:51,670
Mela jekk irridu li tkabbar l-ammont
ta 'aħmar, let me tipproponi dan trick.

1350
01:07:51,670 --> 01:07:53,750
Let me zoom fl fuq l-iskrin tiegħi.

1351
01:07:53,750 --> 01:07:58,678
U let me imorru quddiem u jgħidu
Ammont hija ugwali im.getRed (x, y).

1352
01:07:58,678 --> 01:08:02,440

1353
01:08:02,440 --> 01:08:05,790
>> Din il-linja tal-kodiċi qed tagħti me
xi ħaġa imsejħa varjabbli.

1354
01:08:05,790 --> 01:08:09,643
Għandi arbitrarju, iżda, forsi,
raġonevolment imsejħa varjabbli tiegħi dak,

1355
01:08:09,643 --> 01:08:10,143
apparentament?

1356
01:08:10,143 --> 01:08:13,530

1357
01:08:13,530 --> 01:08:14,340
Ammont.

1358
01:08:14,340 --> 01:08:14,980
ammont eżatt.

1359
01:08:14,980 --> 01:08:16,960
I jistgħu stajt imsejħa
xejn Irrid, imma jien

1360
01:08:16,960 --> 01:08:19,490
tuża din il-funzjoni l-oħra
li I deskritt qabel

1361
01:08:19,490 --> 01:08:25,359
biex tikseb l-ammont ta 'aħmar fuq y x virgola.

1362
01:08:25,359 --> 01:08:27,520
Għaliex ma nagħmel dan?

1363
01:08:27,520 --> 01:08:30,004
What do inti tixtieq li tagħmel hawn?

1364
01:08:30,004 --> 01:08:32,910

1365
01:08:32,910 --> 01:08:33,619
Ikollok bżonn li add--

1366
01:08:33,619 --> 01:08:34,493
UDJENZA: [inaudible]

1367
01:08:34,493 --> 01:08:36,279
DAVID Malan: Iva, forsi
immoltiplika lilha mill-10.

1368
01:08:36,279 --> 01:08:38,862
U jekk ma tafx dan, jien
se jimxi 'l quddiem u jagħmlu dan.

1369
01:08:38,862 --> 01:08:42,060
Jien ser jimxi 'l quddiem u
jiġifieri, Irrid li l-ammont ta 'aħmar

1370
01:08:42,060 --> 01:08:46,550
Nixtieq inkun x'ikun
hija fil-ħamra, il-ħinijiet 10,

1371
01:08:46,550 --> 01:08:50,330
u l-istilla, l-asterisk fuq tiegħek
tastiera huwa the-- ma jużawx x.

1372
01:08:50,330 --> 01:08:51,569
Uża l-istilla.

1373
01:08:51,569 --> 01:08:55,350
Thats kif inti immoltiplika l-affarijiet
fil-lingwi ta 'programmar aktar.

1374
01:08:55,350 --> 01:08:59,790
>> Dan skond l-intwizzjoni Kareem, il
maħżuna f'dan il-varjabbli imsejħa ammont,

1375
01:08:59,790 --> 01:09:03,649
huwa kif ħamra kemm irrid fil xy post.

1376
01:09:03,649 --> 01:09:11,500
Kif, issa, nista 'tagħmel dan
Pixel jkollu dak in-numru?

1377
01:09:11,500 --> 01:09:12,859
You ħadthom diġà għamlu dan qabel.

1378
01:09:12,859 --> 01:09:17,666
Tissettja l-aħdar u l-
blu għal ebda valur, għal żero.

1379
01:09:17,666 --> 01:09:18,540
UDJENZA: [inaudible]

1380
01:09:18,540 --> 01:09:20,040
DAVID Malan: Iva, tajjeb
inti ma tridx li 10.

1381
01:09:20,040 --> 01:09:21,460
Inti diġà għamlu l-matematika hawn.

1382
01:09:21,460 --> 01:09:24,779
Allura aħna qed jkollna l-valur ta 'aħmar,
li huwa għadd baxx, preżumibbilment.

1383
01:09:24,779 --> 01:09:26,180
Aħna multiplikazzjoni up b'10.

1384
01:09:26,180 --> 01:09:29,139
Dak li trid tagħmel ma
l-ammont varjabbli issa?

1385
01:09:29,139 --> 01:09:30,130
>> UDJENZA: [inaudible]

1386
01:09:30,130 --> 01:09:30,880
>> DAVID Malan: Nizza.

1387
01:09:30,880 --> 01:09:34,616
Allura im.set-- liema?

1388
01:09:34,616 --> 01:09:35,640
>> UDJENZA: setRed.

1389
01:09:35,640 --> 01:09:39,760
>> DAVID Malan: setRed, fil xy post.

1390
01:09:39,760 --> 01:09:40,260
Yeah.

1391
01:09:40,260 --> 01:09:41,200
U biss ammont.

1392
01:09:41,200 --> 01:09:44,257
Fi kliem ieħor, varjabbli
hija placeholder temporanju

1393
01:09:44,257 --> 01:09:45,840
li inti tista 'tpoġġi xi ħaġa li trid fil.

1394
01:09:45,840 --> 01:09:48,680
Aħna jiġri li tkun tqegħid ta '
Numru fiha, fil-mument.

1395
01:09:48,680 --> 01:09:51,569
Imxejna immultiplikat lilha mill
10 li jagħmilha akbar.

1396
01:09:51,569 --> 01:09:56,480
U issa jien tissostitwixxi dak il-varjabbli
bħal dik tielet argument, jew dħul

1397
01:09:56,480 --> 01:09:57,810
li jiġu stabbiliti aħmar.

1398
01:09:57,810 --> 01:10:00,440
U għalhekk li ladarba inti
finitura li, u jieħdu nota

1399
01:10:00,440 --> 01:10:02,330
tal-semi-colons u l parentesi.

1400
01:10:02,330 --> 01:10:06,290
>> Jimxi 'l quddiem u kklikkja
run / tiffranka mill-ġdid, u int

1401
01:10:06,290 --> 01:10:10,690
għandha tara, magically, dak li kien fil-fatt
hemmhekk. [? Arwa,] x'hemm hemmhekk?

1402
01:10:10,690 --> 01:10:16,412
Il-Torri Eiffel full-sħiħ
aħmar, pjuttost mhux dlam.

1403
01:10:16,412 --> 01:10:17,870
din għandha tkun aktar evidenti issa, iva?

1404
01:10:17,870 --> 01:10:18,840
KOLLOX SEW.

1405
01:10:18,840 --> 01:10:20,215
U Andrew, kaxxa mhux aktar sewda?

1406
01:10:20,215 --> 01:10:21,090
UDJENZA: [inaudible]

1407
01:10:21,090 --> 01:10:22,180
DAVID Malan: Kull dritt.

1408
01:10:22,180 --> 01:10:23,610
So I ser iżommu dan fuq l-iskrin.

1409
01:10:23,610 --> 01:10:27,010
Jekk inti tixtieq li jilagħbu ma 'dan
wara, I ser jirrikreaw dan għalik.

1410
01:10:27,010 --> 01:10:29,140
Iżda dan il-kodiċi hawn ma eżattament dan.

1411
01:10:29,140 --> 01:10:31,460
Għaliex ma we do wieħed ieħor.

1412
01:10:31,460 --> 01:10:33,880
Let me iscroll ftit.

1413
01:10:33,880 --> 01:10:36,760
>> Allura f'dan il-każ, il-proġettazzjoni
ma verament tagħmel dan ġustizzja.

1414
01:10:36,760 --> 01:10:40,486
Imma fuq l-iskrins tiegħek, inti probabilment
jkollhom kaxxa aħmar ħafna u ħafna iswed.

1415
01:10:40,486 --> 01:10:42,610
Dan, ukoll, hija puzzle li
turi xi ħaġa famużi.

1416
01:10:42,610 --> 01:10:44,193
Madankollu, l-immaġni ġie mgħawġa.

1417
01:10:44,193 --> 01:10:47,740
L-immaġni vera, din id-darba, huwa
fil-valuri blu u ħodor.

1418
01:10:47,740 --> 01:10:51,820
Madankollu, dawn ħadthom ġew diviżi kollha
sal-20 ta għalhekk il-valuri huma żgħar ħafna.

1419
01:10:51,820 --> 01:10:54,660
Il-valuri aħmar huma biss
numri bl-addoċċ, l-istorbju.

1420
01:10:54,660 --> 01:10:57,190
Jneħħu dawn id-distorsjonijiet
li tiżvela l-immaġini veru.

1421
01:10:57,190 --> 01:10:59,200
>> Mela Nick allura jgħidlek x'għandek tagħmel.

1422
01:10:59,200 --> 01:11:04,290
Tistabbilixxi l-valuri aħmar għal żero, u
allura ma jħassru dak li hu.

1423
01:11:04,290 --> 01:11:07,110
Imbagħad immoltiplika l-blu
u l-valuri ekoloġiċi b'20.

1424
01:11:07,110 --> 01:11:09,820
Allura huwa kważi l-
istess programm bħal qabel,

1425
01:11:09,820 --> 01:11:11,380
imma int rivers il-proċess.

1426
01:11:11,380 --> 01:11:13,780
U jien ser tpoġġi kodiċi tiegħi minn
qabel fuq l-iskrin fil-każ

1427
01:11:13,780 --> 01:11:16,650
inti tixtieq li tirreferi lura lilu
jew jilagħbu ulterjuri ma 'li wieħed.

1428
01:11:16,650 --> 01:11:18,100
Let me zoom fl fuq dan.

1429
01:11:18,100 --> 01:11:21,450
Iżda isolvu immaġni tar-ram
puzzle, numru tnejn.

1430
01:11:21,450 --> 01:11:37,623

1431
01:11:37,623 --> 01:11:40,580
>> UDJENZA: [inaudible]

1432
01:11:40,580 --> 01:11:44,010
>> DAVID Malan: OK, so dan wieħed jien
mhux ser jagħti kemm ideat.

1433
01:11:44,010 --> 01:11:47,220
So I would-- oh, ejja
ara, ikollok typo hawn.

1434
01:11:47,220 --> 01:11:49,621
Mela ftakar, dan il hawn
fil-fatt jeħtieġ li jmorru hemm.

1435
01:11:49,621 --> 01:11:52,870
Allura dak I kienet se tipproponi, jekk inti tixtieq li
tiffoka fuq dan wieħed, hemm ir-risposta.

1436
01:11:52,870 --> 01:11:57,060
Jekk inti tixtieq li tifformulaha li, din
għandhom jingħataw l-ewwel waħda tax-xogħol.

1437
01:11:57,060 --> 01:11:59,910
U allura inti tista 'tuża dan bħala
ispirazzjoni għat-tieni waħda.

1438
01:11:59,910 --> 01:12:02,230
Nizza.

1439
01:12:02,230 --> 01:12:02,730
Tajba.

1440
01:12:02,730 --> 01:12:05,430

1441
01:12:05,430 --> 01:12:08,180
>> U għall-kurjuż,
dan huwa eżempju sempliċi

1442
01:12:08,180 --> 01:12:11,080
ta 'xjenza jew arti
imsejħa steganography,

1443
01:12:11,080 --> 01:12:14,100
l-arti tal ħabi informazzjoni fi stampi.

1444
01:12:14,100 --> 01:12:16,890
Tipikament, stampi jista 'jkun
watermark sfaċċatament ħafna

1445
01:12:16,890 --> 01:12:19,500
b'logo fil-qiegħ
kantuniera, iżda b'mod ċar, int

1446
01:12:19,500 --> 01:12:22,070
jistgħu jkunu ħafna aktar sofistikata
dwar dan u fil-fatt

1447
01:12:22,070 --> 01:12:25,050
jinħbew immaġini oħra fil-Images
b'xi ma din it-teknika.

1448
01:12:25,050 --> 01:12:59,890

1449
01:12:59,890 --> 01:13:05,770
>> Ħu ieħor 30 sekondi, u mbagħad aħna ser
għall-inqas iħabbru liema għandek tara.

1450
01:13:05,770 --> 01:13:08,330
U jien ser iħallu l-tielet
wieħed bħala eżerċizzju fuq il-home,

1451
01:13:08,330 --> 01:13:11,353
jekk inti tixtieq aktar ta '
isfida dan il-weekend.

1452
01:13:11,353 --> 01:13:18,240

1453
01:13:18,240 --> 01:13:20,390
U naħseb Andrew jista
gotten l-ewwel.

1454
01:13:20,390 --> 01:13:22,645
X'inhu l-immaġni tat-tieni, Andrew?

1455
01:13:22,645 --> 01:13:23,920
>> UDJENZA: Istatwa tal-Libertà.

1456
01:13:23,920 --> 01:13:28,500
>> DAVID Malan: Istatwa tal-Libertà
se tkun ir-risposta din id-darba.

1457
01:13:28,500 --> 01:13:31,140
Għalhekk għal darb'oħra, biss ftit sempliċi
eżempji, l-għan tiegħu

1458
01:13:31,140 --> 01:13:35,040
huwa li jagħtuk sens ta 'kif
konna tradotta Scratch bl-istampi

1459
01:13:35,040 --> 01:13:40,410
blokki għal aktar tedjanti u aktar
kodiċi kkumplikata, iżda kollha ta 'l-ideat

1460
01:13:40,410 --> 01:13:42,980
għadhom eżattament l-istess,
għalkemm bl-introduzzjoni

1461
01:13:42,980 --> 01:13:48,380
issa tal-kunċett ta 'varjabbli, li
kapaċi li jaħżen xi ħaġa temporanjament.

1462
01:13:48,380 --> 01:13:51,750
>> Ejja nagħmlu waħda aktar hands-on,
biss biex issa jgħaqqdu l-tikek

1463
01:13:51,750 --> 01:13:53,880
għal xi ħaġa ftit aktar tad-dinja reali.

1464
01:13:53,880 --> 01:13:56,610
Meta int lest, jekk inti tista '
mur dan il-URL fuq l-iskrin.

1465
01:13:56,610 --> 01:14:00,610
Li wkoll fil-kopja tiegħek ta 'l-
slides, developers.google.com/maps~~V.

1466
01:14:00,610 --> 01:14:03,660
Ejja fil-fatt jagħmlu xi ħaġa
reali, biex ngħidu hekk, fuq il-web

1467
01:14:03,660 --> 01:14:07,600
tuża l-Google Maps API, jew
interface programmazzjoni applikazzjoni,

1468
01:14:07,600 --> 01:14:08,940
fil-mod li ġej.

1469
01:14:08,940 --> 01:14:12,341
>> Google, bħal ħafna kumpaniji,
jipprovdi ħafna ta 'funzjonalità ħielsa

1470
01:14:12,341 --> 01:14:14,840
li tista 'tuża biex jibnu tiegħek
applikazzjonijiet interessanti stess.

1471
01:14:14,840 --> 01:14:18,890
Fil-fatt, jekk inti stajt qatt jintużaw
Über biex tikseb kabina jew karozza,

1472
01:14:18,890 --> 01:14:21,640
inti probabilment taf li über għandha
Mappa u dan juri karozzi fuqha.

1473
01:14:21,640 --> 01:14:24,870
Dan huwa, bl-aħjar mod li nista '
tell, Google Maps API.

1474
01:14:24,870 --> 01:14:28,884
Dawn huma attwalment jużaw mapep Google,
iżda über ma tkunx kumpannija immappjar,

1475
01:14:28,884 --> 01:14:31,050
lanqas li kieku jkun
problema partikolarment interessanti

1476
01:14:31,050 --> 01:14:33,510
biex issolvi fuq quċċata ta 'tagħhom
problema servizz tal-karozzi.

1477
01:14:33,510 --> 01:14:35,510
U allura jkunu wieqfa,
għal darb'oħra, fuq l-ispallejn

1478
01:14:35,510 --> 01:14:37,520
ta 'oħrajn, Google f'dan il-każ.

1479
01:14:37,520 --> 01:14:42,850
Allura dawn jużaw mapep Google iżda tagħhom stess
servizzi tal-karozzi u l-karatteristiċi oħra bħal dawn.

1480
01:14:42,850 --> 01:14:47,770
>> Allura aħna qed tmur biex tieħu vantaġġ
ta 'dan li tagħmel dan li ġej.

1481
01:14:47,770 --> 01:14:50,230
U jekk stajt marret wisq malajr,
biss isejħuli fuq fil-mument.

1482
01:14:50,230 --> 01:14:53,500
Kuntenti li terġa wħud mill-għalf immaġini.

1483
01:14:53,500 --> 01:14:56,290
Għandek tara lilek innifsek
bi paġna bħal dan.

1484
01:14:56,290 --> 01:14:58,230
Hekk sbieħ Google, u
dawn qed fost l-aqwa

1485
01:14:58,230 --> 01:15:01,364
li tipprovdi mhux biss APIs,
iżda APIs ħielsa li inti

1486
01:15:01,364 --> 01:15:02,780
jistgħu jilagħbu ma 'jew l-użu kummerċjali.

1487
01:15:02,780 --> 01:15:06,450
Huma jibdew iċċarġjar inti jekk użu tiegħek
hija għolja, imma I marru quddiem bil-quddiem

1488
01:15:06,450 --> 01:15:10,490
u ffirmat jiftħilna għal kont ħielsa
li, wieħed jittama, 10 kompjuters

1489
01:15:10,490 --> 01:15:12,480
mhux se jiskwalifikaw magħna għal għarrieda.

1490
01:15:12,480 --> 01:15:14,320
Allura nisperaw li dan
dimostrazzjoni se taħdem.

1491
01:15:14,320 --> 01:15:18,840
>> U tinnota li dawn ikollhom APIs għal
Android, IOS, servizzi tal-web, u l-web,

1492
01:15:18,840 --> 01:15:19,620
kwalunkwe li hu.

1493
01:15:19,620 --> 01:15:20,700
Ejja niffukaw fuq il-web.

1494
01:15:20,700 --> 01:15:26,560
Allura ikklikkja l-kaxxa roża, web, u li
se jwassal inti, wieħed jittama, għal paġna

1495
01:15:26,560 --> 01:15:27,630
hawn.

1496
01:15:27,630 --> 01:15:29,335
U ħadthom ltqajna mazz sħiħ ta 'APIs.

1497
01:15:29,335 --> 01:15:31,210
U jista 'jkun ftit
enormi fl-ewwel,

1498
01:15:31,210 --> 01:15:33,000
imma jien ser steer lilna permezz ta 'dak li rridu.

1499
01:15:33,000 --> 01:15:38,500
>> Fil-quċċata xellug huwa l-Google Maps
JavaScript API, l-API JavaScript.

1500
01:15:38,500 --> 01:15:40,380
Allura aqbad u kklikkja li wieħed.

1501
01:15:40,380 --> 01:15:49,360
U li se jwassal inti issa għall-
ġejja paġna, demos u kodiċi tal-kampjun.

1502
01:15:49,360 --> 01:15:51,190
Let me zoom out hawn.

1503
01:15:51,190 --> 01:15:56,300
U let me nikseb us to-- iscroll
li fejn jgħid passi bi tnedija b'pass mgħaġġel.

1504
01:15:56,300 --> 01:15:57,970
iskrin tiegħek għandu look like mini.

1505
01:15:57,970 --> 01:16:01,130
>> U hemm żewġ passi, jiksbu
ċavetta u tibda tiżviluppa.

1506
01:16:01,130 --> 01:16:04,190
I diġà għamlu pass wieħed għall
magħna, jkollna hekk imsejħa ċavetta.

1507
01:16:04,190 --> 01:16:05,320
U din hija idea komuni.

1508
01:16:05,320 --> 01:16:09,210
API ewlenin hija ġeneralment biss
numru bl-addoċċ kbar jew spag

1509
01:16:09,210 --> 01:16:11,130
li inti suppost
biex paste fis kodiċi tiegħek,

1510
01:16:11,130 --> 01:16:15,280
b'tali mod li Google jaf min int meta
inti qed tuża servizz tagħhom, API tagħhom.

1511
01:16:15,280 --> 01:16:17,370
Ma jfissirx li aħna qed
ċċarġjata xejn.

1512
01:16:17,370 --> 01:16:21,030
U issa, ikklikkja, minflok
wieħed, ikklikkja tibda tiżviluppa.

1513
01:16:21,030 --> 01:16:25,990
Jekk inti tista 'biss mewġa lili
fuq jekk mhux ċert fejn ninsabu.

1514
01:16:25,990 --> 01:16:28,040
>> Allura aħna ser biss tobrox il-
wiċċ, hawnhekk imma dak

1515
01:16:28,040 --> 01:16:31,000
Ħsibt ikun konvinċenti
huwa li attwalment ikollhom lkoll,

1516
01:16:31,000 --> 01:16:34,240
jużaw Cloud9 tieqa waħda u
dan tutorja tieqa ieħor,

1517
01:16:34,240 --> 01:16:37,120
tikri fatt tikseb tagħna stess
applikazzjoni u t-tħaddim

1518
01:16:37,120 --> 01:16:40,920
li jinkorpora drawwa Google
Mappa fi webpage tagħna stess,

1519
01:16:40,920 --> 01:16:43,010
u mbagħad iżid waħda jew żewġ karatteristiċi.

1520
01:16:43,010 --> 01:16:45,520
Iżda aħna ser biss tobrox il-
wiċċ ta 'dak li nistgħu nagħmlu.

1521
01:16:45,520 --> 01:16:47,020
>> Hekk biss verifika sanità malajr.

1522
01:16:47,020 --> 01:16:49,740
Huwa kulħadd fl din il-paġna,
Google Maps JavaScript API?

1523
01:16:49,740 --> 01:16:50,872
Għandha tgħid jkollna beda.

1524
01:16:50,872 --> 01:16:53,330
Aħna mhux se jgħaddu
il-ħaġa sħiħa bi kwalunkwe mezz.

1525
01:16:53,330 --> 01:16:58,090
OK, fi tab oħra, jekk inti ma
għandhom dan miftuħ, ma jmorrux fis Cloud9

1526
01:16:58,090 --> 01:17:03,500
u nikseb yourself għal ftit
ġdid tab, finalment.

1527
01:17:03,500 --> 01:17:11,070
Għalhekk għal darb'oħra, c9.io mill-bieraħ,
c9.io, u biss toħloq fajl ġdid.

1528
01:17:11,070 --> 01:17:13,500
U jimxi 'l quddiem u sejħa
dan tkun xi tkun tixtieq.

1529
01:17:13,500 --> 01:17:16,495
I imsejħa map.html minjiera.

1530
01:17:16,495 --> 01:17:17,870
Sejħa hija xi ħaġa li jintemm fil html.

1531
01:17:17,870 --> 01:17:23,930

1532
01:17:23,930 --> 01:17:26,580
U inti għandek tkun bejn wieħed u ieħor
fejn I am f'dan il-proċess

1533
01:17:26,580 --> 01:17:31,470
biss bi pront Teptip fi vojta
tab imsejħa xi ħaġa bħal map.html.

1534
01:17:31,470 --> 01:17:35,808

1535
01:17:35,808 --> 01:17:38,148
Jew file, fajl ġdid din id-darba.

1536
01:17:38,148 --> 01:17:41,960

1537
01:17:41,960 --> 01:17:48,000
>> U issa, fuq ix-
Google Maps JavaScript API,

1538
01:17:48,000 --> 01:17:50,010
aħna ser skip qari
kollha ta 'dan it-test permezz.

1539
01:17:50,010 --> 01:17:53,760
Iżda avviż li dinja bonjour huwa
tabilħaqq kullimkien, inti tara dan issa.

1540
01:17:53,760 --> 01:17:58,020
Hello dinja għandha dan kbar ikkuluriti
Eżempju ta mazz sħiħ ta HTML.

1541
01:17:58,020 --> 01:18:03,590
Jimxi 'l quddiem u kopja u paste dan biss
HTML, hekk mit-tip dok fil-quċċata

1542
01:18:03,590 --> 01:18:08,810
-triq kollha lejn l-HTML tag qrib, mur
quddiem u kopja kollha tal that-- darb'oħra,

1543
01:18:08,810 --> 01:18:14,430
li taħt il-dinja bonjour example--
u paste dan in tab Cloud9 tiegħek,

1544
01:18:14,430 --> 01:18:17,996
hekk li issa l-iskrin tiegħek
għandu look bejn wieħed u ieħor bħall-mini.

1545
01:18:17,996 --> 01:18:22,280

1546
01:18:22,280 --> 01:18:24,520
>> U inti tista 'tiffranka, iżda
ma tagħbija għadha biss.

1547
01:18:24,520 --> 01:18:26,290
Ejja ewwel ħarsa lejn
il-kodiċi u ara jekk irridu

1548
01:18:26,290 --> 01:18:29,110
ma tistax tiddeduċi jew jitgħallmu
minn dak li huwa Google

1549
01:18:29,110 --> 01:18:30,860
kellha magħna bl-addoċċ kopja u paste.

1550
01:18:30,860 --> 01:18:33,334
Huma biss jixtiequ jgħinu,
litteralment, nikseb us tibda,

1551
01:18:33,334 --> 01:18:35,500
imma hemm Ma li ħafna
kumplessità fil-fatt hemmhekk.

1552
01:18:35,500 --> 01:18:40,100

1553
01:18:40,100 --> 01:18:42,210
Kwalunkwe mistoqsijiet għadha biss?

1554
01:18:42,210 --> 01:18:43,790
Aħna sikur biex nimxu 'l quddiem?

1555
01:18:43,790 --> 01:18:44,330
KOLLOX SEW.

1556
01:18:44,330 --> 01:18:46,800
>> Hekk malajr, ejja biss tagħmel
xi kontrolli sanità malajr.

1557
01:18:46,800 --> 01:18:48,800
Linja waħda ta 'dak I
tara, u wieħed jittama, inti

1558
01:18:48,800 --> 01:18:51,710
ara, xi jfisser, HTML DOCTYPE?

1559
01:18:51,710 --> 01:18:52,385
Kareem, recall?

1560
01:18:52,385 --> 01:18:53,260
UDJENZA: [inaudible]

1561
01:18:53,260 --> 01:18:53,968
DAVID Malan: Iva.

1562
01:18:53,968 --> 01:18:54,870
Hawnhekk tidħol HTML 5.

1563
01:18:54,870 --> 01:18:57,950
Sadanittant, linja tnejn fuq il-
iskrin hawnhekk tfisser ħej browser,

1564
01:18:57,950 --> 01:18:59,482
hawnhekk jidħol l-HTML attwali.

1565
01:18:59,482 --> 01:19:01,440
Linja tliet snin huwa ħej browser,
hawnhekk jidħol l-ras.

1566
01:19:01,440 --> 01:19:04,260
Linja erba huwa, ovvjament, ħej
browser, hawnhekk jidħol it-titolu.

1567
01:19:04,260 --> 01:19:07,780
X'jagħmel linja ħamsa do?

1568
01:19:07,780 --> 01:19:09,930
Attwalment, dan ma
verament tagħmel xejn għalina.

1569
01:19:09,930 --> 01:19:13,340
F'dan il-każ, hija biss resizes
il-paġna għal xi inadempjenza. Linja sitt,

1570
01:19:13,340 --> 01:19:16,140
aħna ma tkellmu dwar, iżda dan
jispeċifika l-kodifikazzjoni tal-karattri.

1571
01:19:16,140 --> 01:19:19,181
Hemm modi differenti biex jikkodifikaw il-fajls,
speċjalment għall-lingwi barranin.

1572
01:19:19,181 --> 01:19:21,100
UTF-8 biss tendenza li jkun l-inadempjenza.

1573
01:19:21,100 --> 01:19:26,580
>> Allura issa aħna ser tara fil-linja
seba permezz 16, xi CSS.

1574
01:19:26,580 --> 01:19:29,260
U anki jekk aħna ve ma bbenefikawx
kollha ta 'dawn l-affarijiet qabel,

1575
01:19:29,260 --> 01:19:30,810
nistgħu tip ta 'jiddeduċu.

1576
01:19:30,810 --> 01:19:37,075
Allura linja tmien mezzi, ħej browser, japplikaw
dawn kollha li ġejjin li għalihom żewġ tikketti,

1577
01:19:37,075 --> 01:19:37,575
apparentament?

1578
01:19:37,575 --> 01:19:40,650

1579
01:19:40,650 --> 01:19:41,701
L-HTML u l-korp test.

1580
01:19:41,701 --> 01:19:43,200
Allura l-virgola hija l-ħaġa ġdida hemmhekk.

1581
01:19:43,200 --> 01:19:46,140
U dan huwa biss mod ta '
li tispeċifika tags multipli fuq darba.

1582
01:19:46,140 --> 01:19:47,640
>> Imbagħad konna ltqajna-braces kaboċċi.

1583
01:19:47,640 --> 01:19:51,170
Allura apparentement, dan jirrakkonta l-browser,
jagħmlu l-għoli tal-paġna 100%.

1584
01:19:51,170 --> 01:19:54,170
Għalhekk anki jekk hemm ftit li xejn
kontenut, jagħmlu l-paġna kollha,

1585
01:19:54,170 --> 01:19:55,530
jagħmlu l-ħaġa timla l-paġna.

1586
01:19:55,530 --> 01:19:57,524
Agħmel il-mappa finalment timla l-paġna.

1587
01:19:57,524 --> 01:19:58,690
Marġni, xi jfisser?

1588
01:19:58,690 --> 01:20:01,559
C'est normalment simili arbitrarja
ispazju bajda madwar it-truf

1589
01:20:01,559 --> 01:20:04,350
li xi disinjatur browser biss
iddeċieda għandu jkun hemm, għaliex

1590
01:20:04,350 --> 01:20:05,540
tip ta 'jagħmel l-affarijiet ħarsa aktar nodfa.

1591
01:20:05,540 --> 01:20:06,498
Iżda aħna ma rridux li.

1592
01:20:06,498 --> 01:20:08,710
Aħna rridu l-mappa għaddej
-triq kollha lejn it-truf.

1593
01:20:08,710 --> 01:20:10,930
Ikkuttunar, simili fl-ispirtu għal marġini.

1594
01:20:10,930 --> 01:20:14,980
Marġini ifissru barra, mezzi ikkuttunar
ġewwa, imma hija l-istess tip ta 'ftehim.

1595
01:20:14,980 --> 01:20:17,520
Huwa xi ftit ta 'buffer
bejnek u t-truf.

1596
01:20:17,520 --> 01:20:21,170
>> U allura linja 13 hija tajba
opportunità għal reviżjoni malajr.

1597
01:20:21,170 --> 01:20:26,440
Xi jfisser Mappa sinjal qawwi
mean, jew mappa hashtag jfisser?

1598
01:20:26,440 --> 01:20:29,650
Xi jfisser li jirreferu għal, fil-prinċipju?

1599
01:20:29,650 --> 01:20:31,485
>> UDJENZA: [inaudible]

1600
01:20:31,485 --> 01:20:32,360
DAVID Malan: Eżattament.

1601
01:20:32,360 --> 01:20:36,900
Din il-proprjetà, din il-proprjetà CSS
japplika biss ħaġa waħda, il-lametta HTML

1602
01:20:36,900 --> 01:20:41,180
li għandha identità ta kwotazzjoni, unquote "mappa".

1603
01:20:41,180 --> 01:20:44,460
U issa ejja fast quddiem, iscroll
sal-qiegħ tal-fajl, li

1604
01:20:44,460 --> 01:20:49,860
mhix wisq bogħod, u avviż fuq il-linja
19, jekk inti paste eżattament bħal I ma,

1605
01:20:49,860 --> 01:20:53,405
Linja 19 għandha biss div, li hija
tqassim tal-paġna, li I bieraħ

1606
01:20:53,405 --> 01:20:54,820
imsejħa reġjun rettangolari.

1607
01:20:54,820 --> 01:20:55,820
Huwa ltqajna xejn fiha.

1608
01:20:55,820 --> 01:20:57,550
Huwa ta 'lametta miftuħ, lametta qrib.

1609
01:20:57,550 --> 01:20:59,490
Iżda hi ma jkollhiex ID unika.

1610
01:20:59,490 --> 01:21:02,090
>> Allura dak li jidher li jkun
jiġri hawn huwa Google

1611
01:21:02,090 --> 01:21:05,880
huwa readying paġna web tagħna biex
ikollhom għoli kompluta 100%,

1612
01:21:05,880 --> 01:21:09,680
u l-ebda ikkuttunar, l-ebda marġini, għaliex
dak li aħna qed tmur biex tqiegħed ġewwa

1613
01:21:09,680 --> 01:21:13,647
ta 'dan div, li ID unika hija
mappa, huwa mappa attwali integrati.

1614
01:21:13,647 --> 01:21:15,480
U irridu li timla
-paġna u mhux biss

1615
01:21:15,480 --> 01:21:17,560
jkun hemm xi rettangolu żgħira fin-nofs.

1616
01:21:17,560 --> 01:21:24,220
Allura linja 14 bl-istess mod jenfasizza, l-
Mappa innifsu għandu jkollha għoli ta '100%.

1617
01:21:24,220 --> 01:21:29,220
>> Allura issa Avviż bejn il-linji 20
u 28, dan huwa JavaScript kodiċi.

1618
01:21:29,220 --> 01:21:33,020
U dan huwa, anki jekk huwa
sintattikament ftit stramba,

1619
01:21:33,020 --> 01:21:34,730
hemm mhux kollu li ħafna jiġri hawn.

1620
01:21:34,730 --> 01:21:39,310
F'konformità 21, dan huwa jiddikjara
xi ħaġa imsejħa varjabbli.

1621
01:21:39,310 --> 01:21:42,030
Minflok ssejjaħ dan
ammonti, bħal għamilna qabel,

1622
01:21:42,030 --> 01:21:44,500
aħna qed aktar preċiż tgħid
var, li ifisser biss varjabbli.

1623
01:21:44,500 --> 01:21:46,520
Jista 'jkollna użati li fl-
kodiċi Nick, iżda huwa ma, so I

1624
01:21:46,520 --> 01:21:48,190
ma jolqot tagħmel dan lanqas.

1625
01:21:48,190 --> 01:21:50,240
Huwa varjabbli msejħa
Mappa, u allura hemm

1626
01:21:50,240 --> 01:21:53,360
funzjoni li l-
apparentament imsejħa initMap.

1627
01:21:53,360 --> 01:21:55,780
>> Allura dan huwa simili custom tagħna stess
biċċa puzzle scratch.

1628
01:21:55,780 --> 01:21:58,830
Imxejna ħolqot biċċa
funzjonalità imsejħa initMap,

1629
01:21:58,830 --> 01:22:00,980
u inti tista 'tip ta jiddeduċu
x'inhu għaddej hawn.

1630
01:22:00,980 --> 01:22:02,930
Min-naħa tax-xellug,
konna ltqajna varjabbli,

1631
01:22:02,930 --> 01:22:06,000
hekk aħna qed tmur biex tpoġġi dan li ġej
Ħaġa ġewwa dak varjabbli,

1632
01:22:06,000 --> 01:22:07,362
mill-lemin għax-xellug.

1633
01:22:07,362 --> 01:22:11,940
In-naħa tal-lemin jgħid, ħej
browser, agħti lili mappa Google ġdid.

1634
01:22:11,940 --> 01:22:16,490
U google.maps.map huwa biss mod funky
ta tispeċifika li din il-funzjonalità

1635
01:22:16,490 --> 01:22:19,790
jappartjeni għall Google Maps.

1636
01:22:19,790 --> 01:22:23,010
>> Wara l-parentesi, Rajna
dan qabel, ħej browser, jiksbu

1637
01:22:23,010 --> 01:22:29,210
lili l-elementi fil-paġna, il-
tikketta fil-paġna li ID unika is--

1638
01:22:29,210 --> 01:22:30,710
>> UDJENZA: [inaudible]

1639
01:22:30,710 --> 01:22:31,790
>> DAVID Malan: --map.

1640
01:22:31,790 --> 01:22:35,770
U dak li qed jiġri, ukoll,
din il-linja flimkien, linja 23,

1641
01:22:35,770 --> 01:22:38,630
essenzjalment qal,
ħej browser, mur jiksbu me

1642
01:22:38,630 --> 01:22:42,800
li div vojta fuq il-paġna
li ID unika huwa Mappa,

1643
01:22:42,800 --> 01:22:45,600
għaliex nixtieq li daħħal
fis it-- tinjetta fis dan,

1644
01:22:45,600 --> 01:22:49,520
jekk inti will-- mazz sħiħ ta 'kontenut
li jiġri li jkunu ġejjin mill-web,

1645
01:22:49,520 --> 01:22:50,427
sussegwentement.

1646
01:22:50,427 --> 01:22:52,010
U Google tagħmel kollha ta 'dan għalina.

1647
01:22:52,010 --> 01:22:55,350
>> Għalhekk għal darb'oħra, fl-aħħar nett tal-ġurnata,
għandna dan l-eżempju ta 'estrazzjoni.

1648
01:22:55,350 --> 01:22:58,610
Għandi l-ebda idea dak mappa huwa
jew kif timplimenta mappa API.

1649
01:22:58,610 --> 01:22:59,460
Aħna ma bżonn.

1650
01:22:59,460 --> 01:23:02,740
Jinħtieġ li tgħid il-mappa
fejn jitqiegħdu innifsu, u leave

1651
01:23:02,740 --> 01:23:04,880
dawk implimentazzjoni sottostanti
dettalji għal Google.

1652
01:23:04,880 --> 01:23:08,190
Issa li milli jidher
żewġ biċċiet ta 'data

1653
01:23:08,190 --> 01:23:11,940
li dan l-eżempju huwa
jipprovdu lill API Google.

1654
01:23:11,940 --> 01:23:16,450
Apparentement-ċentru tal-mappa,
u l-livell zoom, biex ngħidu hekk.

1655
01:23:16,450 --> 01:23:21,390
>> U ħadd ma tirrikonoxxix dawn
koordinati, latitudni u lonġitudni?

1656
01:23:21,390 --> 01:23:24,364
Probabbilment le, imma nistgħu mmorru lura
l-tutorja, litteralment tara.

1657
01:23:24,364 --> 01:23:25,780
Iżda aħna ser tara fi ftit mument.

1658
01:23:25,780 --> 01:23:29,880
livell zoom huwa valur bejn, jien ma
jafu, wieħed fil 13 jew xi ħaġa bħal dik.

1659
01:23:29,880 --> 01:23:32,880
Hija biss għandha x'taqsam ma 'kemm int
żżomjati fil-jew barra, u li hu.

1660
01:23:32,880 --> 01:23:35,690
U issa fl-aħħar nett tal
-paġna, avviż linja 29--

1661
01:23:35,690 --> 01:23:39,960
huwa ftit ikrah għaliex
huwa wraps-- din il-linja tal-kodiċi

1662
01:23:39,960 --> 01:23:44,570
huwa dak downloads għall-
brawżer API attwali Google.

1663
01:23:44,570 --> 01:23:47,500
Kollha tal-kodiċi li Google
inġiniera kitbu li jimplimentaw

1664
01:23:47,500 --> 01:23:50,000
din il-karatteristika kollu ta 'mapep embeddable.

1665
01:23:50,000 --> 01:23:51,470
>> Issa ejja ma tbiddel xejn.

1666
01:23:51,470 --> 01:23:54,761
Jekk inti qed ġejja flimkien, imorru quddiem u
biss ħlief dan il-fajl, jekk inti tabilħaqq għandhom

1667
01:23:54,761 --> 01:23:55,760
dak li għandi.

1668
01:23:55,760 --> 01:23:57,370
Mur fil-URL tagħha.

1669
01:23:57,370 --> 01:23:59,820
Tista 'tikklikkja l-buttuna Run
top up u li se jgħidulek

1670
01:23:59,820 --> 01:24:03,050
inti l-URL tal-web server tiegħek mill-ġdid.

1671
01:24:03,050 --> 01:24:06,010
U se twassal biex inti ġdid tab.

1672
01:24:06,010 --> 01:24:11,910
Jekk tikklikkja Iftaħ għall
map.html, u odds huma int

1673
01:24:11,910 --> 01:24:15,520
ser tikseb allert,
messaġġ ta 'żball, iva?

1674
01:24:15,520 --> 01:24:18,570
Error messaġġ, messaġġ ta 'żball?

1675
01:24:18,570 --> 01:24:21,170
>> Allura sfortunatament, l-iżball
Messaġġ mhix dik illuminanti

1676
01:24:21,170 --> 01:24:23,890
sakemm inti fil-fatt tiftaħ il-
console, li tab speċjali aħna

1677
01:24:23,890 --> 01:24:27,110
miżmuma ftuħ bieraħ u
ftit kmieni llum.

1678
01:24:27,110 --> 01:24:29,445
Imma I stumbled madwar
dan il preċedenti, so I diġà

1679
01:24:29,445 --> 01:24:30,820
dehret dak is-soluzzjoni hija.

1680
01:24:30,820 --> 01:24:34,440
Fil slides tal-lum, jew
pjuttost, fil Cloud9, avviż

1681
01:24:34,440 --> 01:24:36,430
li aħna ma tagħmel
xi ħaġa deliberatament.

1682
01:24:36,430 --> 01:24:40,690
Avviż li dan il-tikketta iskrittura fil
linja 29, jekk inti taqra permezz ta 'dan,

1683
01:24:40,690 --> 01:24:44,440
huwa simili maps.googleapis.com/
xi ħaġa, xi ħaġa, xi ħaġa,

1684
01:24:44,440 --> 01:24:46,430
imbagħad avviż xi ħadd,
wieħed mill-iżviluppaturi,

1685
01:24:46,430 --> 01:24:50,040
kiteb fil-kapital kollu
ittri, API ewlenin tiegħek.

1686
01:24:50,040 --> 01:24:51,700
>> Għandna bżonn li paste xi ħaġa fil hemm.

1687
01:24:51,700 --> 01:24:53,450
U dan kien il-pass
Jien għamilt għalina qabel,

1688
01:24:53,450 --> 01:24:57,190
u għal darb'oħra dawn jistgħu blacklist
us jekk f'daqqa, 12 jew aktar minna

1689
01:24:57,190 --> 01:24:59,470
tibda tuża l-istess ċavetta,
imma ejja ara dak li jiġri.

1690
01:24:59,470 --> 01:25:03,030
Mela jekk inti tmur fis lum
slides, slide waħda wara, hemm

1691
01:25:03,030 --> 01:25:07,070
din is-sekwenza funky li tħares stess ta 'test.

1692
01:25:07,070 --> 01:25:12,230
Jimxi 'l quddiem u biss kopja dak u
paste fejn jgħid API ewlenin tiegħek.

1693
01:25:12,230 --> 01:25:15,120
Dik hija l-waħda I ffirmaw għall.

1694
01:25:15,120 --> 01:25:17,700
>> U definittivament ma tippruvax
ittajpjar out manwalment,

1695
01:25:17,700 --> 01:25:21,210
għaliex iħoss mimli
ma typos, potenzjalment.

1696
01:25:21,210 --> 01:25:23,260
Hekk biss kopja u paste dan.

1697
01:25:23,260 --> 01:25:26,090
U li għaddej biex jagħmlu l-linja
itwal, imma issa, biss biex tkun ċara,

1698
01:25:26,090 --> 01:25:29,540
hija għandha tfittex ftit aktar
bħal dan, fejn ċavetta huwa daqs mhux

1699
01:25:29,540 --> 01:25:32,200
kapitalizzat yelling fi inti.

1700
01:25:32,200 --> 01:25:34,810
Save paġna tiegħek, mur lura
l-tab oħra, rikarigu,

1701
01:25:34,810 --> 01:25:36,770
u nittama li nara mappa ta 'fejn?

1702
01:25:36,770 --> 01:25:37,790
>> UDJENZA: Awstralja.

1703
01:25:37,790 --> 01:25:38,748
>> DAVID Malan: Awstralja.

1704
01:25:38,748 --> 01:25:41,200
Allura apparentement dawn huma l-
GPS koordinati tal-Awstralja.

1705
01:25:41,200 --> 01:25:44,491
U let me jimxu madwar għal ftit mument
u jgħinu lil xi ħadd min pjuttost mhux hemm,

1706
01:25:44,491 --> 01:25:47,729
iżda let me tipproponi, permezz Google, issib
l GPS koordinati ta 'Hometown tiegħek stess

1707
01:25:47,729 --> 01:25:48,770
jew pajjiż tiegħek dar stess.

1708
01:25:48,770 --> 01:25:51,436
U probabbilment Google tista 'ddawar dan il
up, jew il-Wikipedija jista 'jgħidlek.

1709
01:25:51,436 --> 01:25:54,410
Iżda jagħżlu żewġ valuri differenti
għall latitudni u lonġitudni,

1710
01:25:54,410 --> 01:25:57,530
mur lura fi u paste minnhom, u
allura rikarigu-paġna wara iffrankar

1711
01:25:57,530 --> 01:26:00,718
u ara jekk inti tista 'jkollha
Mappa għall Hometown tiegħek stess.

1712
01:26:00,718 --> 01:26:04,500

1713
01:26:04,500 --> 01:26:08,042
>> U meta inti qed isir mal
li, s-segwitu challenge--

1714
01:26:08,042 --> 01:26:11,250
u jien ser jagħtuk ftit inqas direzzjoni,
deliberatament, sabiex inti deliberatament

1715
01:26:11,250 --> 01:26:13,791
ikollhom ibatu għal koppja
minuti mad-dokumentazzjoni,

1716
01:26:13,791 --> 01:26:18,740
jibdlu l-mappa biex tkun le dan
kontumaċja cartoonish, iżda mappa satellita.

1717
01:26:18,740 --> 01:26:24,600
Allura inti attwalment ara satellita
xbihat minflok il-kuluri pretty.

1718
01:26:24,600 --> 01:26:29,710
>> U l-ħjiel jien ser jagħtuk
hija l-bidla tat-tip tal-mappa tal.

1719
01:26:29,710 --> 01:26:33,084
Mur lura għal dak jkollna
beda paġna għall-ispirazzjoni.

1720
01:26:33,084 --> 01:26:40,599

1721
01:26:40,599 --> 01:26:42,390
Kif jista 'jkollok miġbura,
jekk inti qed tfittex,

1722
01:26:42,390 --> 01:26:44,250
hemm daqstant aktar
affarijiet li tista 'tagħmel.

1723
01:26:44,250 --> 01:26:46,380
Xi wħud minnkom diġà
biddel it-tip mappa.

1724
01:26:46,380 --> 01:26:49,890
Iżda int tista 'do-- per eżempju, let me
mur għal xi ħaġa li għamilna għall-kors

1725
01:26:49,890 --> 01:26:52,050
I teach-- maps.cs50.net.

1726
01:26:52,050 --> 01:26:53,470
Waħda mill undergrads tagħna ma dan.

1727
01:26:53,470 --> 01:26:58,890
Aħna ċentru Mappa tagħna matul Harvard tarzna u
overlay kollha ta 'dawn l-ismijiet tal-bini,

1728
01:26:58,890 --> 01:27:01,070
u kellna lilu żid din.

1729
01:27:01,070 --> 01:27:04,270
Mela jekk jien trid tfittex għal,
per eżempju, Matthews Hall,

1730
01:27:04,270 --> 01:27:05,730
għandna ftit drop-down menu.

1731
01:27:05,730 --> 01:27:09,080
U naħseb hu juża bootstrap, il
librerija aħna diskussa aktar kmieni għal dan.

1732
01:27:09,080 --> 01:27:12,190
U jekk inti ikklikkja fuq Matthews
Hall, immedjatament

1733
01:27:12,190 --> 01:27:14,790
jumps il-mappa għal ċertu
lokazzjoni, u dan juri

1734
01:27:14,790 --> 01:27:16,440
inti stampa f'dan il-ftit pop-up.

1735
01:27:16,440 --> 01:27:18,670
>> Iżda anke dan ftit
pop-up, aħna ma implimentatx.

1736
01:27:18,670 --> 01:27:27,521
Jekk I iscroll isfel fuq tagħna jkollna
beda paġna u jfittxu għall-twieqi info,

1737
01:27:27,521 --> 01:27:29,770
tkun taf tara li xi wħud mill-
funzjonalità inti stess

1738
01:27:29,770 --> 01:27:31,561
tista 'żżid, għalkemm
kumplessità daqsxejn aktar,

1739
01:27:31,561 --> 01:27:33,970
hija xi ħaġa imsejħa tieqa info.

1740
01:27:33,970 --> 01:27:37,190
U jekk jien ikklikkja eżempju
hawn, u dan huwa dak gost,

1741
01:27:37,190 --> 01:27:40,530
inti tista 'tagħmel affarijiet bħal dan,
tikklikkja fuq markatur u mbagħad voila,

1742
01:27:40,530 --> 01:27:42,400
informazzjoni pops up.

1743
01:27:42,400 --> 01:27:45,874
>> Allura aħna ma pjuttost introduċew
karatteristiċi biżżejjed ta JavaScript

1744
01:27:45,874 --> 01:27:49,040
li jagħti stampa ta 'eżattament kif inti
jista wajer kollha ta 'dan il-għalf flimkien,

1745
01:27:49,040 --> 01:27:50,706
imma konna tip ta scratched-wiċċ.

1746
01:27:50,706 --> 01:27:53,140
Fil-fatt, dak I biss għamlet meta
Jien għafast fuq dak li jimmarkaw,

1747
01:27:53,140 --> 01:27:55,819
kien attivazzjoni avveniment, l-
hekk imsejħa ikklikkja fuq avveniment.

1748
01:27:55,819 --> 01:27:57,610
U aħna attwalment raw
avveniment aktar kmieni llum,

1749
01:27:57,610 --> 01:28:00,670
l-hekk imsejħa jissottomettu avveniment,
meta konna prevenzjoni

1750
01:28:00,670 --> 01:28:02,490
l-utent minn tiftix għal qtates.

1751
01:28:02,490 --> 01:28:06,560
Allura konna tip ta qabad u choosed
minn fost dawn il-karatteristiċi varji,

1752
01:28:06,560 --> 01:28:08,990
li jtik sens, wieħed jittama,
ta 'dak li inti tista' attwalment

1753
01:28:08,990 --> 01:28:11,000
tagħmel ma daqsxejn aktar
kumdità fl-ipprogrammar,

1754
01:28:11,000 --> 01:28:12,587
u r-riżorsi kompletament ħieles.

1755
01:28:12,587 --> 01:28:15,856

1756
01:28:15,856 --> 01:28:18,770
>> Kwalunkwe mistoqsijiet?

1757
01:28:18,770 --> 01:28:19,790
Nru?

1758
01:28:19,790 --> 01:28:22,542
Dan huwa ċ-ċans finali tiegħek,
-inqas illum, il-Ġimgħa,

1759
01:28:22,542 --> 01:28:25,000
biex tikseb xejn off sider tiegħek
sabiex inti walk out ta 'hawn

1760
01:28:25,000 --> 01:28:27,067
tħossok kunfidenti u komdi.

1761
01:28:27,067 --> 01:28:27,566
Iva.

1762
01:28:27,566 --> 01:28:29,740
>> UDJENZA: Għaliex ma
inti żid ħaġ'oħra?

1763
01:28:29,740 --> 01:28:32,720
>> DAVID Malan: Oh my goodness.

1764
01:28:32,720 --> 01:28:35,260
I bżonn għall-mistrieħ dan il-weekend, I think.

1765
01:28:35,260 --> 01:28:36,180
Mistoqsijiet oħra?

1766
01:28:36,180 --> 01:28:37,055
>> UDJENZA: [inaudible]

1767
01:28:37,055 --> 01:28:44,130

1768
01:28:44,130 --> 01:28:46,810
>> DAVID Malan: Inti can-- fl
Internet Explorer, mistrieħ fil-paċi,

1769
01:28:46,810 --> 01:28:49,310
inti użati biex ikunu jistgħu jitqiegħdu VB
iskript, b'kitba bażika virtwali,

1770
01:28:49,310 --> 01:28:50,643
iżda li verament qatt maqbuda fuq.

1771
01:28:50,643 --> 01:28:52,490
Allura l-risposta qasira hija biss JavaScript.

1772
01:28:52,490 --> 01:28:55,144

1773
01:28:55,144 --> 01:28:55,810
Mistoqsijiet oħra?

1774
01:28:55,810 --> 01:28:58,427

1775
01:28:58,427 --> 01:28:59,760
Kull dritt, ukoll, let me jagħmlu dan.

1776
01:28:59,760 --> 01:29:02,070
Let me grab kollegi tagħna barra.

1777
01:29:02,070 --> 01:29:04,500
Huma għandhom xi evalwazzjoni
forom li huma jixtiequ kulħadd

1778
01:29:04,500 --> 01:29:06,310
li jonfqu ftit minuti mili barra.

1779
01:29:06,310 --> 01:29:08,775
Huma jridu jiġbru dik il-formola u kwalunkwe
rinunzji li inti jista 'jkollok barra.

1780
01:29:08,775 --> 01:29:10,240
Huma ser ikollhom ukoll ċertifikati.

1781
01:29:10,240 --> 01:29:12,380
Jien guessing hemm
għadhom xi snacks barra.

1782
01:29:12,380 --> 01:29:14,360
Let me jgħaddu dawn jitwettqu, u jekk int
xi mistoqsijiet fil-frattemp,

1783
01:29:14,360 --> 01:29:17,120
I ser jimxu madwar aktar individwalment
u nistgħu jiksbu bdejt.

1784
01:29:17,120 --> 01:29:17,879
Iva, ovja.

1785
01:29:17,879 --> 01:29:18,754
UDJENZA: [inaudible]

1786
01:29:18,754 --> 01:29:26,737

1787
01:29:26,737 --> 01:29:28,570
DAVID Malan: Li
normalment veru dawn il-jiem.

1788
01:29:28,570 --> 01:29:30,730
Ċertament ma 'web
softwer, inti jegħleb

1789
01:29:30,730 --> 01:29:32,901
fuq oħrajn int jew
estetikament jużaw affarijiet

1790
01:29:32,901 --> 01:29:35,400
bħall bootstrap, sabiex inti ma
jkollhom jimplimentaw l-livell baxx

1791
01:29:35,400 --> 01:29:37,169
dettalji ta 'menus u
buttuni u dak kollu li.

1792
01:29:37,169 --> 01:29:39,210
Inti jegħleb fuq xi ħadd
bħall-Google sabiex inti

1793
01:29:39,210 --> 01:29:42,050
m'għandhomx għalfejn tibni über
negozju u negozju mmappjar,

1794
01:29:42,050 --> 01:29:44,850
u kull numru ta simili
applikazzjonijiet kif ukoll.

1795
01:29:44,850 --> 01:29:46,350
>> Fil-fatt, logins huma popolari, wisq.

1796
01:29:46,350 --> 01:29:48,500
Jekk inti ħadthom użati Spotify jew
kull numru ta 'websajts,

1797
01:29:48,500 --> 01:29:51,210
inti ser login għal xi
websajts permezz Facebook.

1798
01:29:51,210 --> 01:29:53,350
Allura x'hemm sbieħ, hemm
huma APIs għal logins

1799
01:29:53,350 --> 01:29:56,570
illum, sabiex inti ma għandekx
li jkollhom l-utenti tiegħek tabella stess

1800
01:29:56,570 --> 01:29:59,440
u kollha ta 'database tiegħek stess
neċessarjament bl-istess mod.

1801
01:29:59,440 --> 01:30:01,795
Tista let Facebook jagħmlu dak kollu
ta 'dik kumplessità għalik.

1802
01:30:01,795 --> 01:30:03,920
Allura huwa żmien eċċitanti,
onestament, fil-programmazzjoni,

1803
01:30:03,920 --> 01:30:07,200
għaliex hemm parti terza tant
servizzi li inti tista 'tibni fuq quċċata ta'.

1804
01:30:07,200 --> 01:30:10,890
>> U għal darb'oħra, il-prezz li inti tħallas huwa
jew finanzjarju jew waqfien.

1805
01:30:10,890 --> 01:30:13,750
Jekk Google jinżel,
sabiex ma über, forsi,

1806
01:30:13,750 --> 01:30:15,690
imma forsi li l-
raġonevoli kompromess.

1807
01:30:15,690 --> 01:30:18,040
U għal darb'oħra, li kienet waħda mit-temi,
nisperaw, għall-aħħar ftit jiem,

1808
01:30:18,040 --> 01:30:18,780
Huwa dawn kompromessi.

1809
01:30:18,780 --> 01:30:20,738
U rarament huwa jmur hemmhekk
li tkun risposta tajba.

1810
01:30:20,738 --> 01:30:25,700
Huwa verament huwa l-aħjar
ta 'tnejn jew aktar tweġibiet.

1811
01:30:25,700 --> 01:30:26,682
>> Għaddi dawn madwar.

1812
01:30:26,682 --> 01:30:36,830

1813
01:30:36,830 --> 01:30:41,110
>> U dawn il-kontijiet Cloud9 se jkompli
għax-xogħol, fit-teorija, al dejjem.

1814
01:30:41,110 --> 01:30:45,000
Inti tista 'ssib jekk inti tistenna ftit jiem
jew ġimgħa jew aktar biex log lura fis minnhom,

1815
01:30:45,000 --> 01:30:49,170
jista 'jieħu bħal wieħed jew
ħames minuti biex tiftaħ back-up,

1816
01:30:49,170 --> 01:30:54,090
iżda li biss għaliex dawn jitqiegħdu
li jorqdu biex jiffrankaw fuq ir-riżorsi.

1817
01:30:54,090 --> 01:31:10,527