Lemmy: Bestiverse
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
RSS BotMB to Hacker NewsEnglish · 9 hours ago

SQLite JSON at Full Index Speed Using Generated Columns

www.dbpro.app

external-link
message-square
0
fedilink
2
external-link

SQLite JSON at Full Index Speed Using Generated Columns

www.dbpro.app

RSS BotMB to Hacker NewsEnglish · 9 hours ago
message-square
0
fedilink
SQLite JSON Superpower: Virtual Columns + Indexing - DB Pro Blog
www.dbpro.app
external-link
One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.

Comments

alert-triangle
You must log in or register to comment.

Hacker News

hackernews

Subscribe from Remote Instance

You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !hackernews@lemmy.bestiver.se
lock
Community locked: only moderators can create posts. You can still comment on posts.

Posts from the RSS Feed of HackerNews.

The feed sometimes contains ads and posts that have been removed by the mod team at HN.

Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 311 users / day
  • 1.76K users / week
  • 3.88K users / month
  • 9.52K users / 6 months
  • 2 local subscribers
  • 3.23K subscribers
  • 38K Posts
  • 17.8K Comments
  • Modlog
  • mods:
  • patrick
  • RSS Bot
  • BE: 0.19.5
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org