Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
hiccuphippo
3 days ago
|
parent
|
context
|
favorite
| on:
SQLite JSON at full index speed using generated co...
In 2 they show how to add virtual columns to an existing table, in 3 how to add indexes to existing virtual columns so they are pre-cooked. Like a cooking show.
meindnoch
3 days ago
|
next
[–]
>In 2 they show how to add virtual columns to an existing table
No, in section 2 the table is created afresh. All 3 sections start with a CREATE TABLE.
reply
hiccuphippo
3 days ago
|
parent
|
next
[–]
Yes, it seems each section has its own independent database so you have to create everything on each of them.
reply
upmostly
3 days ago
|
prev
[–]
Literally exactly as I meant it. I watch a lot of cooking shows, too, so this analogy holds up.
reply
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
