1
00:00:00,000 --> 00:00:01,800
Welcome back to the deep dive.

2
00:00:01,800 --> 00:00:06,120
Look, we know you want knowledge you can use fast, no fluff.

3
00:00:06,120 --> 00:00:09,680
Today, we're tackling something, well, almost universal.

4
00:00:09,680 --> 00:00:11,280
That moment, your simple spreadsheet

5
00:00:11,280 --> 00:00:15,520
just explodes into this unmanageable beast.

6
00:00:15,520 --> 00:00:18,360
Broken links, copy paste errors, you know the drill.

7
00:00:18,360 --> 00:00:21,200
Our sources today point towards something called Grist.

8
00:00:21,200 --> 00:00:23,760
It's being called the evolution of spreadsheets.

9
00:00:23,760 --> 00:00:24,600
Big claim.

10
00:00:24,600 --> 00:00:26,720
It is a big claim, but maybe a necessary one.

11
00:00:26,720 --> 00:00:29,120
If you're wrestling with Excel or Google Sheets

12
00:00:29,120 --> 00:00:31,560
hitting their limits, Grist offers a different path.

13
00:00:31,560 --> 00:00:33,760
So our mission today is to unpack that.

14
00:00:33,760 --> 00:00:36,000
How does it mix that easy spreadsheet feel

15
00:00:36,000 --> 00:00:38,120
with real database power?

16
00:00:38,120 --> 00:00:39,680
And crucially, what does that actually mean for you

17
00:00:39,680 --> 00:00:41,400
if you're just trying to get your data organized?

18
00:00:41,400 --> 00:00:44,720
Okay, but before we really get into the weeds of Grist,

19
00:00:44,720 --> 00:00:46,440
we absolutely want to thank the supporter

20
00:00:46,440 --> 00:00:48,920
of this deep dive, Safe Server.

21
00:00:48,920 --> 00:00:51,240
Safe Server is fantastic because they handle the hosting

22
00:00:51,240 --> 00:00:54,160
for exactly this kind of powerful software.

23
00:00:54,160 --> 00:00:55,320
Think of them as your partner

24
00:00:55,320 --> 00:00:57,120
for that digital transformation,

25
00:00:57,120 --> 00:01:00,280
making sure robust tools like Grist run smoothly.

26
00:01:00,280 --> 00:01:03,700
You can check them out at www.safeserver.de.

27
00:01:03,700 --> 00:01:06,540
All right, so let's unpack Grist.

28
00:01:06,540 --> 00:01:09,540
The sources call it a modern relational spreadsheet.

29
00:01:09,540 --> 00:01:12,900
What's behind that term for the everyday user?

30
00:01:12,900 --> 00:01:14,660
Yeah, that phrase relational spreadsheet,

31
00:01:14,660 --> 00:01:16,160
that's kind of the core idea,

32
00:01:16,160 --> 00:01:18,100
and maybe where the initial adjustment comes in,

33
00:01:18,100 --> 00:01:20,360
you still get that grid, that familiar spreadsheet look,

34
00:01:20,360 --> 00:01:23,420
but underneath, it's enforcing some database discipline.

35
00:01:23,420 --> 00:01:25,240
And probably the biggest single difference,

36
00:01:25,240 --> 00:01:27,700
especially if you're coming straight from Excel,

37
00:01:27,700 --> 00:01:29,260
is how columns work.

38
00:01:29,260 --> 00:01:30,100
This is key.

39
00:01:30,100 --> 00:01:33,000
In Excel, a column can be a total free for all, right?

40
00:01:33,000 --> 00:01:35,140
Dates, names, numbers, whatever.

41
00:01:35,140 --> 00:01:36,220
Total KO sometimes.

42
00:01:36,220 --> 00:01:37,140
Exactly.

43
00:01:37,140 --> 00:01:38,740
In Grist, columns are different.

44
00:01:38,740 --> 00:01:40,780
They have a name, sure, but critically,

45
00:01:40,780 --> 00:01:44,140
they hold one specific type of data, just one.

46
00:01:44,140 --> 00:01:47,620
One type, like you decide this is currency and that's it.

47
00:01:47,620 --> 00:01:50,260
Precisely, or this is a date,

48
00:01:50,260 --> 00:01:53,180
or this links to another table, it only holds that.

49
00:01:53,180 --> 00:01:55,620
And that structure, that discipline,

50
00:01:55,620 --> 00:01:57,660
is what stops things from falling apart

51
00:01:57,660 --> 00:01:59,300
when your data gets complex.

52
00:01:59,300 --> 00:02:00,700
It allows it to scale.

53
00:02:00,700 --> 00:02:03,860
Okay, I can see how that might feel restrictive at first,

54
00:02:03,860 --> 00:02:06,020
if you're used to just dumping anything anywhere.

55
00:02:06,020 --> 00:02:07,220
It can be, yeah.

56
00:02:07,220 --> 00:02:08,820
A bit of a mindset shift.

57
00:02:08,820 --> 00:02:11,340
But the payoff is reliability.

58
00:02:11,340 --> 00:02:13,940
And if you've ever used something like Airtable,

59
00:02:13,940 --> 00:02:16,380
this idea of linking tables, the relational part,

60
00:02:16,380 --> 00:02:17,980
will feel pretty natural.

61
00:02:17,980 --> 00:02:20,300
Grist actually has articles to help people

62
00:02:20,300 --> 00:02:22,500
make that jump from Excel or Sheets.

63
00:02:22,500 --> 00:02:23,420
That's helpful.

64
00:02:23,420 --> 00:02:25,660
Now you mentioned something about its physical format

65
00:02:25,660 --> 00:02:27,860
being interesting, Scolite.

66
00:02:27,860 --> 00:02:28,540
Yes.

67
00:02:28,540 --> 00:02:30,420
This is actually pretty cool, especially

68
00:02:30,420 --> 00:02:33,220
if you care about owning your data.

69
00:02:33,220 --> 00:02:35,220
Grist files are built on Scolite.

70
00:02:35,220 --> 00:02:36,020
Scolite.

71
00:02:36,020 --> 00:02:38,300
Isn't that like a super common database engine?

72
00:02:38,300 --> 00:02:40,580
The most widely deployed database engine on the planet.

73
00:02:40,580 --> 00:02:41,620
Yeah, it's everywhere.

74
00:02:41,620 --> 00:02:44,020
OK, but why does that matter for my spreadsheet file?

75
00:02:44,020 --> 00:02:45,620
Portability and control.

76
00:02:45,620 --> 00:02:46,780
Massively.

77
00:02:46,780 --> 00:02:47,900
Think about it.

78
00:02:47,900 --> 00:02:51,100
Your data isn't locked into some weird proprietary format

79
00:02:51,100 --> 00:02:53,420
only Grist can read because it's Scolite.

80
00:02:53,420 --> 00:02:55,140
Almost any standard database tool

81
00:02:55,140 --> 00:02:57,700
can pull out the basic text and numbers.

82
00:02:57,700 --> 00:03:00,140
So even if Grist disappeared tomorrow,

83
00:03:00,140 --> 00:03:02,460
your actual data is safe, accessible.

84
00:03:02,460 --> 00:03:03,740
You can back it up reliably.

85
00:03:03,740 --> 00:03:04,860
You're not trapped.

86
00:03:04,860 --> 00:03:06,300
That's actually a really big deal.

87
00:03:06,300 --> 00:03:09,460
Future-proofing your data from the get-go.

88
00:03:09,460 --> 00:03:10,740
All right, let's shift gears.

89
00:03:10,740 --> 00:03:11,860
Formulas.

90
00:03:11,860 --> 00:03:15,100
This is where spreadsheets often show their power,

91
00:03:15,100 --> 00:03:17,500
but also their pain points.

92
00:03:17,500 --> 00:03:19,140
VLO cup nightmares.

93
00:03:19,140 --> 00:03:19,700
Anyone.

94
00:03:19,700 --> 00:03:20,660
Hey, yeah.

95
00:03:20,660 --> 00:03:21,460
We've all been there.

96
00:03:21,460 --> 00:03:23,380
Gris takes a radically different approach here.

97
00:03:23,380 --> 00:03:26,460
We're talking like genuine data superpowers baked right in.

98
00:03:26,460 --> 00:03:27,020
Superpowers.

99
00:03:27,020 --> 00:03:27,420
Go on.

100
00:03:27,420 --> 00:03:28,740
OK, so the headline feature.

101
00:03:28,740 --> 00:03:31,620
Full Python syntax is supported directly in the formula cells.

102
00:03:31,620 --> 00:03:32,340
Whoa, hold on.

103
00:03:32,340 --> 00:03:33,340
Python.

104
00:03:33,340 --> 00:03:36,220
Like, the programming language inside a spreadsheet.

105
00:03:36,220 --> 00:03:39,020
Yeah, the programming language, including access

106
00:03:39,020 --> 00:03:40,780
to a lot of its standard library so you

107
00:03:40,780 --> 00:03:43,900
can do some seriously powerful data manipulation right there

108
00:03:43,900 --> 00:03:44,540
in the grid.

109
00:03:44,540 --> 00:03:49,540
That sounds incredibly powerful, but maybe a bit intimidating.

110
00:03:49,540 --> 00:03:52,180
Or even, like, overkill for just adding two numbers.

111
00:03:52,180 --> 00:03:53,180
It could seem that way.

112
00:03:53,180 --> 00:03:54,460
First, security.

113
00:03:54,460 --> 00:03:56,580
It runs in a controlled sandbox, so you're not

114
00:03:56,580 --> 00:03:58,820
opening massive security holes by default.

115
00:03:58,820 --> 00:04:00,800
It's designed carefully.

116
00:04:00,800 --> 00:04:03,620
And for the overkill part, grist gets that.

117
00:04:03,620 --> 00:04:06,460
It also includes lots of the familiar Excel functions,

118
00:04:06,460 --> 00:04:08,540
so the easy stuff is still easy.

119
00:04:08,540 --> 00:04:10,700
SUM, average, if they're there.

120
00:04:10,700 --> 00:04:12,900
Ah, OK, so it caters to both ends.

121
00:04:12,900 --> 00:04:13,940
Exactly.

122
00:04:13,940 --> 00:04:16,100
But when you do hit a wall with standard functions,

123
00:04:16,100 --> 00:04:18,300
maybe you need to parse complex text

124
00:04:18,300 --> 00:04:20,980
or do some non-trivial date calculations.

125
00:04:20,980 --> 00:04:24,340
Having Python right there is honestly a game changer.

126
00:04:24,340 --> 00:04:27,140
And I saw something about AI helping out with this.

127
00:04:27,140 --> 00:04:29,180
Because writing Python code isn't exactly

128
00:04:29,180 --> 00:04:30,740
common spreadsheet knowledge.

129
00:04:30,740 --> 00:04:31,220
Right.

130
00:04:31,220 --> 00:04:33,700
There's an AI assistant built in specifically tuned

131
00:04:33,700 --> 00:04:35,060
for writing grist formulas.

132
00:04:35,060 --> 00:04:36,580
You can basically tell it in plain English

133
00:04:36,580 --> 00:04:37,300
what you want to do.

134
00:04:37,300 --> 00:04:39,500
Like, show me the average sales for last month

135
00:04:39,500 --> 00:04:40,620
for the completed deals.

136
00:04:40,620 --> 00:04:41,900
Pretty much exactly like that.

137
00:04:41,900 --> 00:04:44,380
And it will generate the grist Python formula for you.

138
00:04:44,380 --> 00:04:47,100
It really lowers the barrier to using

139
00:04:47,100 --> 00:04:48,740
those advanced capabilities.

140
00:04:48,740 --> 00:04:50,420
That makes a lot more sense.

141
00:04:50,420 --> 00:04:53,420
OK, beyond just the raw power of formulas,

142
00:04:53,420 --> 00:04:57,060
what about making data entry cleaner, more organized?

143
00:04:57,060 --> 00:04:58,040
Yeah, good point.

144
00:04:58,040 --> 00:05:00,500
There are several features for that, things like choices

145
00:05:00,500 --> 00:05:01,980
and choice lists.

146
00:05:01,980 --> 00:05:03,140
Like drop down menus?

147
00:05:03,140 --> 00:05:06,500
Sort of, but often presented as colorful tags.

148
00:05:06,500 --> 00:05:08,620
It means you pre-define the allowed values,

149
00:05:08,620 --> 00:05:11,220
ensuring consistency, no more complete

150
00:05:11,220 --> 00:05:12,900
versus completed versus done.

151
00:05:12,900 --> 00:05:14,140
That alone would save headaches.

152
00:05:14,140 --> 00:05:14,820
Totally.

153
00:05:14,820 --> 00:05:18,020
And then there are references and reference lists.

154
00:05:18,020 --> 00:05:20,940
Because it's relational, you can properly link records.

155
00:05:20,940 --> 00:05:22,740
So this invoice record points directly

156
00:05:22,740 --> 00:05:25,460
to the correct client record in the client's table.

157
00:05:25,460 --> 00:05:27,380
No error-prone duplication.

158
00:05:27,380 --> 00:05:27,900
Nice.

159
00:05:27,900 --> 00:05:31,340
And I see specialized editors, too, for dates, currency.

160
00:05:31,340 --> 00:05:31,820
Yep.

161
00:05:31,820 --> 00:05:34,300
Those enforce the data types we talked about earlier.

162
00:05:34,300 --> 00:05:36,660
Make sure a date is a date, currency is currency.

163
00:05:36,660 --> 00:05:38,220
Helps keep data clean.

164
00:05:38,220 --> 00:05:39,300
And conditional formatting.

165
00:05:39,300 --> 00:05:41,420
Making cells change color based on rules.

166
00:05:41,420 --> 00:05:43,900
Yes, and that's also controlled by formulas.

167
00:05:43,900 --> 00:05:46,060
So you can set up quite sophisticated rules,

168
00:05:46,060 --> 00:05:48,780
like flag any task that's overdue

169
00:05:48,780 --> 00:05:50,660
and assign to a specific team.

170
00:05:50,660 --> 00:05:52,700
Visual cues based on real logic.

171
00:05:52,700 --> 00:05:53,300
OK.

172
00:05:53,300 --> 00:05:56,500
Moving from putting data in to getting insights out.

173
00:05:56,500 --> 00:05:59,660
Traditional spreadsheets often become this giant wall

174
00:05:59,660 --> 00:06:01,560
of text and numbers.

175
00:06:01,560 --> 00:06:04,740
How does Grist handle visualizing things?

176
00:06:04,740 --> 00:06:08,520
This is another strong point, drag and drop dashboards.

177
00:06:08,520 --> 00:06:10,500
You're not stuck just in the grid view.

178
00:06:10,500 --> 00:06:11,620
So charts and things.

179
00:06:11,620 --> 00:06:12,780
Charts, definitely.

180
00:06:12,780 --> 00:06:15,620
Card views, which are great for seeing individual records,

181
00:06:15,620 --> 00:06:18,260
calendar widgets, the usual suspects.

182
00:06:18,260 --> 00:06:20,940
But the really unique thing is how you can link these widgets

183
00:06:20,940 --> 00:06:21,580
together.

184
00:06:21,580 --> 00:06:22,220
Link them.

185
00:06:22,220 --> 00:06:23,140
How does that work?

186
00:06:23,140 --> 00:06:26,620
Imagine you have your main table of data, maybe a chart showing

187
00:06:26,620 --> 00:06:29,420
sales by region, and perhaps a detailed card view.

188
00:06:29,420 --> 00:06:32,100
You can lay them out together on a dashboard page.

189
00:06:32,100 --> 00:06:35,700
Then when you click on, say, a specific row in the main table,

190
00:06:35,700 --> 00:06:37,820
maybe representing a single project,

191
00:06:37,820 --> 00:06:39,660
the chart and the card view instantly

192
00:06:39,660 --> 00:06:41,740
filter to show only the data related

193
00:06:41,740 --> 00:06:43,660
to that specific project.

194
00:06:43,660 --> 00:06:45,900
So clicking filters everything else automatically.

195
00:06:45,900 --> 00:06:46,460
Exactly.

196
00:06:46,460 --> 00:06:48,940
It makes exploring your data incredibly dynamic

197
00:06:48,940 --> 00:06:51,660
without having to constantly create new siltered views

198
00:06:51,660 --> 00:06:53,580
or cram everything onto one sheet.

199
00:06:53,580 --> 00:06:55,820
It keeps the analysis separate but connected.

200
00:06:55,820 --> 00:06:57,460
That sounds much cleaner.

201
00:06:57,460 --> 00:07:00,460
Now, what about getting data into Grist easily,

202
00:07:00,460 --> 00:07:03,420
like from forms or recurring imports?

203
00:07:03,420 --> 00:07:05,100
Bank statements come to mind.

204
00:07:05,100 --> 00:07:09,740
Oh, the dreaded CSV import reconciliation.

205
00:07:09,740 --> 00:07:13,020
Yes, Grist has a feature called incremental imports,

206
00:07:13,020 --> 00:07:14,860
which is fantastic for this.

207
00:07:14,860 --> 00:07:15,900
Incremental imports.

208
00:07:15,900 --> 00:07:16,740
Yeah.

209
00:07:16,740 --> 00:07:20,340
Say you import your bank activity CSV for January.

210
00:07:20,340 --> 00:07:22,700
Then in February, you get the next CSV

211
00:07:22,700 --> 00:07:26,060
instead of dumping it all in and manually deleting duplicates.

212
00:07:26,060 --> 00:07:27,100
Which takes forever.

213
00:07:27,100 --> 00:07:27,900
Right.

214
00:07:27,900 --> 00:07:30,220
Grist can intelligently look at the new file,

215
00:07:30,220 --> 00:07:31,780
compare it to what's already there,

216
00:07:31,780 --> 00:07:34,060
and only import the genuinely new rows.

217
00:07:34,060 --> 00:07:35,900
It handles the deduplication.

218
00:07:35,900 --> 00:07:38,260
It's a huge time saver for recurring data.

219
00:07:38,260 --> 00:07:39,340
OK, that's brilliant.

220
00:07:39,340 --> 00:07:41,020
And for collecting new data.

221
00:07:41,020 --> 00:07:42,020
It has native forms.

222
00:07:42,020 --> 00:07:44,660
You can design simple forms directly within Grist,

223
00:07:44,660 --> 00:07:47,220
and the submissions feed straight into your tables.

224
00:07:47,220 --> 00:07:50,040
No need for a separate tool like Google Forms or Typeform

225
00:07:50,040 --> 00:07:51,380
if your needs are straightforward.

226
00:07:51,380 --> 00:07:52,180
Very useful.

227
00:07:52,180 --> 00:07:54,580
Now, collaboration means security.

228
00:07:54,580 --> 00:07:56,180
How does Grift handle permissions,

229
00:07:56,180 --> 00:07:58,500
especially if multiple people are using the document?

230
00:07:58,500 --> 00:08:01,500
It offers really granular access control, much more detailed

231
00:08:01,500 --> 00:08:02,580
than typical spreadsheets.

232
00:08:02,580 --> 00:08:03,940
Granular how?

233
00:08:03,940 --> 00:08:05,300
Like down to the column?

234
00:08:05,300 --> 00:08:09,140
Down to individual rows, columns, or even entire tables.

235
00:08:09,140 --> 00:08:12,020
OK, that's pretty standard for a database like Tools.

236
00:08:12,020 --> 00:08:14,140
True, but here's the clever part.

237
00:08:14,140 --> 00:08:16,740
The permissions aren't just static user rules.

238
00:08:16,740 --> 00:08:20,620
They can be dynamic based on the data itself or user attributes.

239
00:08:20,620 --> 00:08:22,220
Whoa, based on the data.

240
00:08:22,220 --> 00:08:23,140
Give me an example.

241
00:08:23,140 --> 00:08:25,660
OK, imagine a sales pipeline table.

242
00:08:25,660 --> 00:08:28,020
You could set a rule saying users can only

243
00:08:28,020 --> 00:08:30,860
see rows where the assign rep column matches

244
00:08:30,860 --> 00:08:32,460
their own user email.

245
00:08:32,460 --> 00:08:35,020
Or only users with the manager attribute

246
00:08:35,020 --> 00:08:37,220
can see the commission amount column.

247
00:08:37,220 --> 00:08:39,740
So the rules adapt to the data in real time.

248
00:08:39,740 --> 00:08:40,880
Exactly.

249
00:08:40,880 --> 00:08:44,140
That kind of dynamic data-driven access control

250
00:08:44,140 --> 00:08:47,260
is usually found in much more complex and expensive enterprise

251
00:08:47,260 --> 00:08:48,380
database systems.

252
00:08:48,380 --> 00:08:50,300
It's pretty powerful for collaborative work.

253
00:08:50,300 --> 00:08:52,780
And does it play nice with other tools, integrations?

254
00:08:52,780 --> 00:08:54,180
Yep, it's built to connect.

255
00:08:54,180 --> 00:08:56,740
There's a REST API, Zapier integration,

256
00:08:56,740 --> 00:08:59,260
web hooks are supported, and standard import

257
00:08:59,260 --> 00:09:02,100
text port with Google Drive, Excel, CSV.

258
00:09:02,100 --> 00:09:04,180
It aims to be a hub, not an island.

259
00:09:04,180 --> 00:09:07,340
This leads us nicely to a really defining aspect.

260
00:09:07,340 --> 00:09:10,140
Grist is open source, or at least open core.

261
00:09:10,140 --> 00:09:11,500
What does that mean, practically?

262
00:09:11,500 --> 00:09:13,660
Right, the core engine, grist core,

263
00:09:13,660 --> 00:09:17,340
is open source under the Apache 2.0 license.

264
00:09:17,340 --> 00:09:19,460
This is significant for a few reasons.

265
00:09:19,460 --> 00:09:20,420
Like what?

266
00:09:20,420 --> 00:09:22,900
Why should the average user care if it's open source?

267
00:09:22,900 --> 00:09:24,380
Three main things, I'd say.

268
00:09:24,380 --> 00:09:26,180
First, independence.

269
00:09:26,180 --> 00:09:28,340
You're not locked into Grist Labs forever.

270
00:09:28,340 --> 00:09:31,660
If you self-host, the core tool keeps working.

271
00:09:31,660 --> 00:09:33,940
Your data format, sweet light, is open.

272
00:09:33,940 --> 00:09:34,860
You have options.

273
00:09:34,860 --> 00:09:36,740
Second, trust.

274
00:09:36,740 --> 00:09:37,860
The code is public.

275
00:09:37,860 --> 00:09:40,460
Security researchers, or just curious developers,

276
00:09:40,460 --> 00:09:43,900
can inspect it, find vulnerabilities, contribute fixes.

277
00:09:43,900 --> 00:09:47,540
More eyes generally means more robust, trustworthy software.

278
00:09:47,540 --> 00:09:50,340
And third, flexibility, especially around cost.

279
00:09:50,340 --> 00:09:51,880
You can self-host grist core.

280
00:09:51,880 --> 00:09:53,300
If you have the technical know-how,

281
00:09:53,300 --> 00:09:55,100
you can run it on your own server, maybe

282
00:09:55,100 --> 00:09:57,460
for internal use, without paying subscription fees.

283
00:09:57,460 --> 00:10:00,460
OK, self-hosting sounds powerful, but maybe daunting.

284
00:10:00,460 --> 00:10:03,620
How easy is it to actually try this grist core thing?

285
00:10:03,620 --> 00:10:05,580
Surprisingly easy if you're comfortable

286
00:10:05,580 --> 00:10:06,860
with basic tech tools.

287
00:10:06,860 --> 00:10:08,420
The most common way is using Docker.

288
00:10:08,420 --> 00:10:10,580
It's often just one or two commands in your terminal,

289
00:10:10,580 --> 00:10:12,500
and you have a local grist instance running.

290
00:10:12,500 --> 00:10:13,060
Docker.

291
00:10:13,060 --> 00:10:15,180
OK, that's becoming pretty standard for developers.

292
00:10:15,180 --> 00:10:15,980
It is.

293
00:10:15,980 --> 00:10:18,020
Makes it quite self-contained.

294
00:10:18,020 --> 00:10:21,260
There's also a dedicated desktop app, if you prefer that,

295
00:10:21,260 --> 00:10:23,180
and even something called grist static,

296
00:10:23,180 --> 00:10:25,220
which lets you embed a read-only grist

297
00:10:25,220 --> 00:10:28,420
sheet in a static website without any back-end server

298
00:10:28,420 --> 00:10:28,980
needed.

299
00:10:28,980 --> 00:10:30,420
Lots of options, then.

300
00:10:30,420 --> 00:10:32,140
But you mentioned open core.

301
00:10:32,140 --> 00:10:34,420
That implies some parts aren't open source.

302
00:10:34,420 --> 00:10:37,500
What's the deal with the hosted version at getgrist.com

303
00:10:37,500 --> 00:10:39,500
versus this grist core?

304
00:10:39,500 --> 00:10:42,140
That's a key distinction, especially for businesses,

305
00:10:42,140 --> 00:10:43,100
maybe.

306
00:10:43,100 --> 00:10:45,820
Grist core is the full open source product.

307
00:10:45,820 --> 00:10:48,660
The hosted service, getgrist.com, includes that core,

308
00:10:48,660 --> 00:10:51,700
but adds some extra non-open source extensions.

309
00:10:51,700 --> 00:10:52,900
What kind of extensions?

310
00:10:52,900 --> 00:10:54,900
Things that might be more enterprise-focused,

311
00:10:54,900 --> 00:10:58,340
maybe specific integrations like an Azure back-end option,

312
00:10:58,340 --> 00:11:01,700
advanced audit logging features, or the newer, more general

313
00:11:01,700 --> 00:11:05,100
purpose Grist AI assistant that goes beyond just formula.

314
00:11:05,100 --> 00:11:05,980
Why does that matter?

315
00:11:05,980 --> 00:11:07,900
Transparency, mainly.

316
00:11:07,900 --> 00:11:10,740
If your organization needs certain compliance features,

317
00:11:10,740 --> 00:11:12,820
like detailed audit trails, you need

318
00:11:12,820 --> 00:11:14,740
to know if that specific feature is

319
00:11:14,740 --> 00:11:18,220
part of the open source publicly auditable code,

320
00:11:18,220 --> 00:11:20,740
or if it's a proprietary extension provided

321
00:11:20,740 --> 00:11:21,700
by Grist Labs.

322
00:11:21,700 --> 00:11:23,320
They're pretty clear about it, but it's

323
00:11:23,320 --> 00:11:25,420
important to understand which components are which,

324
00:11:25,420 --> 00:11:27,580
especially if you choose to self-host and enable

325
00:11:27,580 --> 00:11:28,700
those enterprise features.

326
00:11:28,700 --> 00:11:29,380
Got it.

327
00:11:29,380 --> 00:11:30,740
Transparency is good.

328
00:11:30,740 --> 00:11:32,140
OK, let's try and wrap this up.

329
00:11:32,140 --> 00:11:33,980
Key takeaways for someone listening.

330
00:11:33,980 --> 00:11:36,620
Grist seems to tackle spreadsheet chaos

331
00:11:36,620 --> 00:11:39,980
head on by mixing that familiar grid with strict database

332
00:11:39,980 --> 00:11:42,980
rules, especially that one data type or column rule.

333
00:11:42,980 --> 00:11:43,580
Right.

334
00:11:43,580 --> 00:11:46,340
And it massively boosts what you can do with your data

335
00:11:46,340 --> 00:11:48,060
by digging Python into the formulas,

336
00:11:48,060 --> 00:11:50,580
but makes it accessible with things like the AI assistant.

337
00:11:50,580 --> 00:11:52,780
And maybe most critically for the long term,

338
00:11:52,780 --> 00:11:55,460
its open source foundation and use of SeqWite

339
00:11:55,460 --> 00:11:58,860
mean you actually control your data, no vendor lock-in.

340
00:11:58,860 --> 00:11:59,940
Exactly.

341
00:11:59,940 --> 00:12:02,380
Which leads me to a final thought maybe a bit provocative

342
00:12:02,380 --> 00:12:03,700
for you to chew on.

343
00:12:03,700 --> 00:12:07,620
Given this combination powerful open scripting, like Python,

344
00:12:07,620 --> 00:12:11,680
plus a universal open data format like SeqWite,

345
00:12:11,680 --> 00:12:14,220
what does this trend really mean for all those closed off

346
00:12:14,220 --> 00:12:16,980
proprietary low code platforms out there?

347
00:12:16,980 --> 00:12:19,300
Are we maybe seeing the start of a shift?

348
00:12:19,300 --> 00:12:21,840
A move away from platforms that deliberately

349
00:12:21,840 --> 00:12:23,980
make it hard to get your data out or work

350
00:12:23,980 --> 00:12:25,500
with it using other tools?

351
00:12:25,500 --> 00:12:28,340
Is openness becoming the new competitive advantage?

352
00:12:28,340 --> 00:12:30,500
That is definitely something to think about,

353
00:12:30,500 --> 00:12:33,060
the future of data ownership and flexibility.

354
00:12:33,060 --> 00:12:33,900
Excellent stuff.

355
00:12:33,900 --> 00:12:36,180
Thank you for walking us through Grist today.

356
00:12:36,180 --> 00:12:38,140
Thanks all of you for joining this deep dive.

357
00:12:38,140 --> 00:12:41,280
And one last huge thank you to our sponsor, Safe Server.

358
00:12:41,280 --> 00:12:44,180
Meet reliable hosting for powerful software like Grist

359
00:12:44,180 --> 00:12:46,120
or help with your digital transformation.

360
00:12:46,120 --> 00:12:46,960
Check them out.

361
00:12:46,960 --> 00:12:49,680
You can find more info at www.safeserver.de.