--- title: Modern SQLite: Generated columns | daily.dev description: This post discusses the concept of generated columns in SQLite and how they can be used to calculate values based on other columns in the same table. It also... canonical: https://daily.dev/posts/modern-sqlite-generated-columns-yqe0z5esb twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Modern SQLite: Generated columns | daily.dev og:description: This post discusses the concept of generated columns in SQLite and how they can be used to calculate values based on other columns in the same table. It also... og:url: https://daily.dev/posts/modern-sqlite-generated-columns-yqe0z5esb og:image: https://api.daily.dev/og/posts/Yqe0Z5eSb.png og:image:alt: Modern SQLite: Generated columns og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Modern SQLite: Generated columns **[Anton Zhiyanov](https://daily.dev/sources/antonz)** · 1 min read · 5 upvotes · 0 comments ## Summary This post discusses the concept of generated columns in SQLite and how they can be used to calculate values based on other columns in the same table. It also explores a common use case of extracting JSON paths into separate columns and indexing them. Generated columns allow SQLite to be used as a document database by storing documents as JSON blobs and extracting fields as needed. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 1 upvotes · 0 comments - [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments - [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments - [CNCF Unveils Schedule for KubeCon \+ CloudNativeCon Europe 2026](https://daily.dev/posts/cncf-unveils-schedule-for-kubecon-cloudnativecon-europe-2026-ikhcoa5cb) · CNCF · 2 upvotes · 0 comments - [CNCF Debuts KubeCon \+ CloudNativeCon Japan 2026 Schedule](https://daily.dev/posts/cncf-debuts-kubecon-cloudnativecon-japan-2026-schedule-xp5pyudub) · CNCF · 1 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#sqlite](https://daily.dev/tags/sqlite) [View this post on daily.dev](https://daily.dev/posts/modern-sqlite-generated-columns-yqe0z5esb) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Modern SQLite: Generated columns","url":"https://daily.dev/posts/modern-sqlite-generated-columns-yqe0z5esb","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/modern-sqlite-generated-columns-yqe0z5esb"},"datePublished":"2024-05-08T13:32:58.209Z","dateModified":"2024-05-09T08:20:02.615Z","description":"This post discusses the concept of generated columns in SQLite and how they can be used to calculate values based on other columns in the same table. It also...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/0a58d7368691fe84f72e987666400cf3?_a=AQAEuiZ","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/0a58d7368691fe84f72e987666400cf3?_a=AQAEuiZ","isAccessibleForFree":true,"articleSection":"Anton Zhiyanov","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Anton Zhiyanov","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/29aa129ca24545f1a698d8a206ccc372","url":"https://daily.dev/sources/antonz"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/modern-sqlite-generated-columns-yqe0z5esb","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":5},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,sqlite","timeRequired":"PT1M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Anton Zhiyanov","item":"https://daily.dev/sources/antonz"},{"@type":"ListItem","position":3,"name":"Modern SQLite: Generated columns"}]} ```