WIDE

Store any unstructured JSON data. Retrieve it with an expressive and efficient query system.

WIDE is a library and service hosted on Val Town. Authenticate and use it with your Val Town credentials, or fork it and connect it to your own Clickhouse Instance.

(read more about wide events)

import { ValSession } from 'https://esm.town/v/maxm/valSession';\nimport { Wide } from 'https://esm.town/v/maxm/wide';\n\n// Use your Val Town API Token to create a session\nconst wide = new Wide(await ValSession.new(Deno.env.get(\"valtown\")))\n\n// Write any data.\nawait wide.write([\n  { user: {id: 1, name: 'Alice', email: 'alice@example.com' }},\n  { user: {id: 2, name: 'Bob', email: 'bob@example.com' }},\n  { user: {id: 3, name: 'Charlie', email: 'charlie@example.com' }},\n]);\n\nawait wide.fields(\"user.\")\n// => [\n//  { fieldName: \"user.email\", fieldType: \"string\", count: 3 },\n//  { fieldName: \"user.id\", fieldType: \"number\", count: 3 },\n//  { fieldName: \"user.name\", fieldType: \"string\", count: 3 }\n// ]\n\nawait wide.values(\"user.email\") \n// [\n//   { value: \"bob@example.com\", count: 1 },\n//   { value: \"charlie@example.com\", count: 1 },\n//   { value: \"alice@example.com\", count: 1 }\n// ]\n\nawait wide.search({\n    start: new Date(Date.now() - 1000 * 60 * 10),\n    end: new Date(),\n    filters: [{ fieldName: \"user.name\", operator: \"equals\", value: \"Alice\" }],\n})\n// [{ user: { name: \"Alice\", email: \"alice@example.com\", id: 1 } }];\n

\n \n

\n Source\n

\n \n\n\n `,\n { headers: { \"Content-Type\": \"text/html\" } },\n );\n}","deleted","label",[109],"6ddbe58c-252d-11f0-8a67-569c3dd06744","README.md","6ddbe604-252d-11f0-8a67-569c3dd06744",1,["D",1732383111722],0,"# WIDE\nStore any unstructured JSON data. Retrieve it with an expressive and efficient query system.\n\nWIDE is a library and service hosted on Val Town. Authenticate and use it with your Val Town credentials, or fork it and connect it to your own Clickhouse Instance.\n \n```ts\nimport { ValSession } from 'https://esm.town/v/maxm/valSession';\nimport { Wide } from 'https://esm.town/v/maxm/wide';\n\n// Use your Val Town API Token to create a session\nconst wide = new Wide(await ValSession.new(Deno.env.get(\"valtown\")))\n\n// Write any data.\nawait wide.write([\n { user: {id: 1, name: 'Alice', email: 'alice@example.com' }},\n { user: {id: 2, name: 'Bob', email: 'bob@example.com' }},\n { user: {id: 3, name: 'Charlie', email: 'charlie@example.com' }},\n]);\n\nawait wide.fields(\"user.\")\n// => [\n// { fieldName: \"user.email\", fieldType: \"string\", count: 3 },\n// { fieldName: \"user.id\", fieldType: \"number\", count: 3 },\n// { fieldName: \"user.name\", fieldType: \"string\", count: 3 }\n// ]\n\nawait wide.values(\"user.email\") \n// [\n// { value: \"bob@example.com\", count: 1 },\n// { value: \"charlie@example.com\", count: 1 },\n// { value: \"alice@example.com\", count: 1 }\n// ]\n\nawait wide.search({\n start: new Date(Date.now() - 1000 * 60 * 10),\n end: new Date(),\n filters: [{ fieldName: \"user.name\", operator: \"equals\", value: \"Alice\" }],\n})\n// [{ user: { name: \"Alice\", email: \"alice@example.com\", id: 1 } }];\n\n\nMigrated from folder: wide/wide",[125],"pulls","branches","forks",2,"envVars",{"_140":129,"_142":129},"connections",{"_140":129,"_141":129},"count","unfilledCount","emptyCount",{"_18":124,"_20":125,"_110":126,"_111":-5,"_112":67,"_113":127,"_114":26,"_22":149,"_64":129,"_117":95,"_119":130,"_121":63,"_122":-5,"_146":150,"_84":151},{"_18":108,"_20":109,"_110":35,"_111":-5,"_112":67,"_113":65,"_114":26,"_22":145,"_64":116,"_117":118,"_119":120,"_121":63,"_122":-5,"_146":147,"_84":148},["D",1734122922901],"children",[],[109],["D",1732383111722],[],[125],["D",1745953749515],{"_16":17,"_82":78},{"_16":17,"_76":-5,"_77":78,"_32":33,"_79":80,"_81":63},{"_64":65,"_20":66,"_18":67,"_68":19,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":21,"_75":17},"ctx",{"_56":-5,"_103":189,"_190":191,"_192":193,"_194":63,"_195":63,"_196":63,"_197":26,"_198":-5,"_199":-7,"_200":-7,"_201":129,"_202":63,"_203":63,"_204":-5,"_205":63,"_206":63,"_207":63,"_208":-5},"ENV",{"_160":161,"_162":163,"_164":66,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Search