[{"_1":2,"_1217":-5,"_1218":-5},"loaderData",{"_3":4,"_12":13},"root",{"_5":6,"_7":8,"_9":10,"_11":10},"isProd",true,"enableStats",false,"domain","ifebitcoin.org","siteHost","routes/$",{"_14":15,"_951":952},"json",{"_16":17,"_18":19,"_20":-5,"_21":-5,"_22":-5,"_23":8,"_24":-5,"_25":26,"_137":6,"_36":138,"_149":150,"_151":152,"_926":927,"_928":6,"_11":929,"_930":929,"_931":932,"_946":947},"prefersLanguages",[],"viewTerm","collaborators","panelParam","openComment","accountUid","isInspect","inspectTab","document",{"_27":28,"_113":39,"_114":115,"_116":117,"_119":120,"_121":122,"_123":122,"_124":125,"_128":129,"_130":39,"_131":132,"_135":136},"content",[29,48,74,91,106],{"_30":31,"_32":33},"children",[],"block",{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47},"type","Paragraph","id","uOPL87My","revision","bafy2bzacecmometxom6jy3blvvtlna5fbcvnzypu6oojunl56wcyt5hjwdpds","attributes",{},"annotations",[],"text","In our backend code I've seen a bunch of places where we compare the result of an expression with an input parameter/s.","link","",{"_30":49,"_32":67},[50,60],{"_30":51,"_32":52},[],{"_34":53,"_36":54,"_38":39,"_40":55,"_42":58,"_44":59,"_46":47},"Code","n1_t6w8O",{"_56":57},"language","sql",[],"SELECT\n id\nFROM public_keys\nWHERE hex(principal) = :principal LIMIT 1;",{"_30":61,"_32":62},[],{"_34":53,"_36":63,"_38":39,"_40":64,"_42":65,"_44":66,"_46":47},"rnD8Aiar",{"_56":57},[],"SELECT DISTINCT\n multihash,\n codec\nFROM blobs\nWHERE hex(multihash) IN (\n SELECT value from json_each(:mhash_json)\n)\nAND size > 0",{"_34":35,"_36":68,"_38":39,"_40":69,"_42":72,"_44":73,"_46":47},"O4BttVFb",{"_70":71},"childrenType","Group",[],"For example:",{"_30":75,"_32":76},[],{"_34":35,"_36":77,"_38":39,"_40":78,"_42":79,"_44":90,"_46":47},"DEE-HKih",{},[80],{"_34":53,"_81":82,"_85":86,"_40":89,"_46":47},"starts",[83,84],29,150,"ends",[87,88],34,155,{},"In both of these queries the WHERE clause can't use an index, and will do a full table scan. This is because the index doesn't know the result of the hex() expression, so it can't compare the column value against the input parameter.",{"_30":92,"_32":93},[],{"_34":35,"_36":94,"_38":39,"_40":95,"_42":96,"_44":105,"_46":47},"TIHMi81A",{},[97],{"_34":53,"_81":98,"_85":101,"_40":104,"_46":47},[99,100],42,110,[102,103],77,177,{},"The solution for the first query is to do WHERE principal = unhex(:principal) and for the second one is to do WHERE multihash IN (SELECT unhex(value) FROM json_each(:mhash_json).",{"_30":107,"_32":108},[],{"_34":35,"_36":109,"_38":39,"_40":110,"_42":111,"_44":112,"_46":47},"QHFwP2nu",{},[],"So, instead of running an expression on all the rows in the table, we run the \"reverse\" expression to convert the input parameter to the same value as the column, which will let us use the index.","version","account","z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno","authors",[118],"z6MkgYR76i3w2Xc2fcvgFJWfYjsop6YwUonDhQx3AdLmQ4BQ","path","/tech-talks/sqlite-avoid-comparing-against-expressions","createTime","2025-11-24T10:18:02.090Z","updateTime","metadata",{"_126":127},"name","SQLite: Avoid Comparing Against Expressions","detachedBlocks",{},"genesis","generationInfo",{"_130":39,"_133":134},"generation","1763979482090","visibility","PUBLIC","isLatest",{"_119":139,"_113":39,"_142":8,"_143":115,"_36":144,"_145":-5,"_146":-5,"_147":-5,"_148":-5},[140,141],"tech-talks","sqlite-avoid-comparing-against-expressions","latest","uid","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sqlite-avoid-comparing-against-expressions","blockRef","blockRange","hostname","scheme","siteHomeIcon","ipfs://bafkreibbbufz2nmtqikzu4xilamfp2z77umkmlj5r7h4vqvgydf4gq57rm","dehydratedState",{"_153":154,"_155":156},"mutations",[],"queries",[157,234,353,814,820,834,912],{"_158":159,"_229":230,"_232":233},"state",{"_160":161,"_213":214,"_215":216,"_217":-5,"_218":219,"_220":219,"_221":219,"_222":-5,"_223":-5,"_224":8,"_225":226,"_227":228},"data",{"_34":25,"_25":162,"_36":211},{"_27":163,"_113":39,"_114":115,"_116":207,"_119":120,"_121":122,"_123":122,"_124":208,"_128":209,"_130":39,"_131":210,"_135":136},[164,169,184,193,202],{"_30":165,"_32":166},[],{"_34":35,"_36":37,"_38":39,"_40":167,"_42":168,"_44":45,"_46":47},{},[],{"_30":170,"_32":181},[171,176],{"_30":172,"_32":173},[],{"_34":53,"_36":54,"_38":39,"_40":174,"_42":175,"_44":59,"_46":47},{"_56":57},[],{"_30":177,"_32":178},[],{"_34":53,"_36":63,"_38":39,"_40":179,"_42":180,"_44":66,"_46":47},{"_56":57},[],{"_34":35,"_36":68,"_38":39,"_40":182,"_42":183,"_44":73,"_46":47},{"_70":71},[],{"_30":185,"_32":186},[],{"_34":35,"_36":77,"_38":39,"_40":187,"_42":188,"_44":90,"_46":47},{},[189],{"_34":53,"_81":190,"_85":191,"_40":192,"_46":47},[83,84],[87,88],{},{"_30":194,"_32":195},[],{"_34":35,"_36":94,"_38":39,"_40":196,"_42":197,"_44":105,"_46":47},{},[198],{"_34":53,"_81":199,"_85":200,"_40":201,"_46":47},[99,100],[102,103],{},{"_30":203,"_32":204},[],{"_34":35,"_36":109,"_38":39,"_40":205,"_42":206,"_44":112,"_46":47},{},[],[118],{"_126":127},{},{"_130":39,"_133":134},{"_36":144,"_143":115,"_119":212,"_113":39,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":8},[140,141],"dataUpdateCount",1,"dataUpdatedAt",1779649237930,"error","errorUpdateCount",0,"errorUpdatedAt","fetchFailureCount","fetchFailureReason","fetchMeta","isInvalidated","status","success","fetchStatus","idle","queryKey",[231,144,39,8],"ENTITY","queryHash","[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sqlite-avoid-comparing-against-expressions\",\"bafy2bzacecmometxom6jy3blvvtlna5fbcvnzypu6oojunl56wcyt5hjwdpds\",false]",{"_158":235,"_229":351,"_232":352},{"_160":236,"_213":214,"_215":350,"_217":-5,"_218":219,"_220":219,"_221":219,"_222":-5,"_223":-5,"_224":8,"_225":226,"_227":228},{"_34":25,"_25":237,"_36":347},{"_27":238,"_113":248,"_114":115,"_116":290,"_119":47,"_121":295,"_123":296,"_124":297,"_128":303,"_130":344,"_131":345,"_135":136},[239],{"_30":240,"_32":276},[241],{"_30":242,"_32":270},[243],{"_30":244,"_32":245},[],{"_34":246,"_36":247,"_38":248,"_40":249,"_42":269,"_44":47,"_46":47},"Query","j95CSEq5","bafy2bzacecztnajmr5r7luldjzb5xf7un5x6lmk3pri463l22vetxlu4qjqhs",{"_250":251,"_252":253,"_254":255,"_268":8},"columnCount",3,"style","Card","query",{"_256":257,"_262":263},"includes",[258],{"_259":115,"_119":47,"_260":261},"space","mode","Children","sort",[264],{"_265":8,"_266":267},"reverse","term","UpdateTime","banner",[],{"_34":271,"_36":272,"_38":248,"_40":273,"_42":274,"_44":275,"_46":47},"Heading","JAHqMKPr",{"_70":71},[],"Sections by Activity",{"_34":35,"_36":277,"_38":278,"_40":279,"_42":280,"_44":289,"_46":47},"ucCwKK6W","bafy2bzacea42u7e3oinbynyvr4hqdrdambwuksgydraxgmmwjwk2oe5qxaqey",{"_70":71},[281],{"_34":282,"_81":283,"_85":285,"_40":287,"_46":288},"Link",[284],310,[286],315,{},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/site-organization?l","Seed Hypermedia supports human thought and collaborative work on the web through an extremely decentralized network for storage and permissions, designed for any knowledge community — from publishers and newspapers to universities, conferences, and creators. Read the organization of this knowledge repository first.",[118,291,292,293,115,294],"z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4","z6MkkGNjfnikRkxK9EaxMPYy3HYxNGkRyXTWxxRtynB2kyeb","z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou","z6Mkvz9TgGtv9zsGsdrksfNk1ajbFancgHREJEz3Y2HsAVdk","1970-01-01T00:00:00Z","2026-02-19T15:02:20.121Z",{"_126":298,"_299":150,"_300":301,"_302":6},"Develop Seed Hypermedia","icon","siteUrl","https://seedteamtalks.hyper.media","showActivity",{"_304":305},"navigation",{"_30":306,"_32":343},[307,313,319,325,331,337],{"_30":308,"_32":309},[],{"_34":282,"_36":310,"_46":311,"_44":312},"0dneHA1iYVUB6pwR-YPMv","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/roadmap?l","Roadmap",{"_30":314,"_32":315},[],{"_34":282,"_36":316,"_46":317,"_44":318},"Os3QakPzxNB8OzZpVdpQ3","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks?l","Tech Talks",{"_30":320,"_32":321},[],{"_34":282,"_36":322,"_46":323,"_44":324},"Jh7YrFGNfT5LqzWXR9hZ-","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/human-interface-library?l","Design",{"_30":326,"_32":327},[],{"_34":282,"_36":328,"_46":329,"_44":330},"hgoxp_CZgdacfA6L4fMLf","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs?l","Specs",{"_30":332,"_32":333},[],{"_34":282,"_36":334,"_46":335,"_44":336},"7QpiCgdQDsxYY4tekQd47","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/discussions?l","Notes",{"_30":338,"_32":339},[],{"_34":282,"_36":340,"_46":341,"_44":342},"bdfz0tfzzZc0Kho3U3ZKw","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/meeting-notes?v=bafy2bzacecdujov4k6h3filkpqwm4kgrrjxj3dpnurspxw2pbbpeyewqnesry&l","Meeting Notes",{"_34":71,"_36":304},"bafy2bzacec7wxg3z4sucahp62txnbuf4k2qv3vzpwh72ivlmchvbzw5anhzku",{"_130":344,"_133":346},"0",{"_36":348,"_143":115,"_119":349,"_113":-5,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno",[],1779649238586,[231,348,-5,6],"[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno\",null,true]",{"_158":354,"_229":811,"_232":813},{"_160":355,"_213":214,"_215":810,"_217":-5,"_218":219,"_220":219,"_221":219,"_222":-5,"_223":-5,"_224":8,"_225":226,"_227":228},[356,397,430,459,488,516,543,572,597,625,649,672,700,724,752,780],{"_34":25,"_36":357,"_119":361,"_116":362,"_121":363,"_123":368,"_371":372,"_130":373,"_113":360,"_374":375,"_378":379,"_131":391,"_393":-5,"_124":394,"_135":136},{"_36":358,"_143":115,"_119":359,"_113":360,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks",[140],"bafy2bzaceb2sff4mo3nac6guf25makfqop2pizdla73ze27jksxdxtq46rjyg",[140],[293,291],{"_364":365,"_366":367},"seconds","1760379588","nanos",8000000,{"_364":369,"_366":370},"1772102928",885000000,"sortTime","2025-10-13T18:19:48.008Z","bafy2bzaceci4odwwqtrrrhrntnq46pdvkpshot2xnkm3jpatfyvpfqwjmlhnq","breadcrumbs",[376],{"_126":298,"_119":47,"_377":8},"isMissing","activitySummary",{"_380":381,"_384":385,"_386":387,"_388":389,"_390":6},"latestCommentTime",{"_364":382,"_366":383},"1771922459",920000000,"latestCommentId","zDnaeTtfA5itWshS1NQE2Aa2HU5kAv5v5XoQR3traojiiwbhX/z6FaSwjsSSjG1F","commentCount",163,"latestChangeTime",{"_364":369,"_366":370},"isUnread",{"_130":373,"_133":392},"1760379588008","redirectInfo",{"_126":318,"_395":396},"summary","Conversations about technology and enlightenment.",{"_34":25,"_36":398,"_119":403,"_116":404,"_121":407,"_123":410,"_371":413,"_130":414,"_113":402,"_374":415,"_378":417,"_131":424,"_393":-5,"_124":426,"_135":136},{"_36":399,"_143":115,"_119":400,"_113":402,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/projects",[401],"projects","bafy2bzacedlve27jcr332ey5bhvcq56fvr6pfnqi6g5gg3tv23b5xcil3szve",[401],[293,115,405,406,294,291,118],"z6Mkq9emq1yUBq4KSeiSH5yzgNBJSnidPVqFnTpzjCdLxB3R","z6MkqULds7oeqGPgtSpqpisK77FxhwP57ikVNFVfYfsMb2KZ",{"_364":408,"_366":409},"1737452534",659000000,{"_364":411,"_366":412},"1772042391",171000000,"2025-01-21T09:42:14.659Z","bafy2bzaceclwoffe3urzgxzxeuaozsyftjoswi7kymxmnbame5ruwmf665oei",[416],{"_126":298,"_119":47,"_377":8},{"_380":418,"_384":421,"_386":422,"_388":423,"_390":6},{"_364":419,"_366":420},"1772134295",723000000,"z6Mkvz9TgGtv9zsGsdrksfNk1ajbFancgHREJEz3Y2HsAVdk/z6FcZSGY7vAjBn",31,{"_364":411,"_366":412},{"_130":414,"_133":425},"1737452534659",{"_126":427,"_395":47,"_428":429},"Projects","contentWidth","L",{"_34":25,"_36":431,"_119":436,"_116":437,"_121":438,"_123":441,"_371":444,"_130":445,"_113":435,"_374":446,"_378":448,"_131":455,"_393":-5,"_124":457,"_135":136},{"_36":432,"_143":115,"_119":433,"_113":435,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/meeting-notes",[434],"meeting-notes","bafy2bzaceb3t47birzausbjryuzwdkop24jy7cxtkytzvax5lgsxmjrksm6ng",[434],[118],{"_364":439,"_366":440},"1758055379",977000000,{"_364":442,"_366":443},"1772015186",609000000,"2025-09-16T20:42:59.977Z","bafy2bzaceba7jlw74w3a6fh5yq7y7tp4hpzp4ubbqkknmuel3nogbihkthzes",[447],{"_126":298,"_119":47,"_377":8},{"_380":449,"_384":452,"_386":453,"_388":454,"_390":6},{"_364":450,"_366":451},"1763403952",567000000,"zDnaeXWXuy4pXkctJDhPze8HXMe1k6RGg7CAgQCZrzgTj737w/z6E7XCrtsjaisf",4,{"_364":442,"_366":443},{"_130":445,"_133":456},"1758055379977",{"_126":342,"_395":458},"Every time we have a meeting, it's useful to take notes. When we do, let's put them in this directory.",{"_34":25,"_36":460,"_119":465,"_116":466,"_121":468,"_123":471,"_371":474,"_130":475,"_113":464,"_374":476,"_378":478,"_131":485,"_393":-5,"_124":486,"_135":136},{"_36":461,"_143":115,"_119":462,"_113":464,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/human-interface-library",[463],"human-interface-library","bafy2bzacedyjhztusyihq67dpdl6lgyzptgjmqjvnudlpvw33a4xn7w3q7rce",[463],[293,294,291,467,292],"z6MkfnCSnmstMXTAb6MBXXCj4zdPwZedtRF6YBgYtE5Q8Sov",{"_364":469,"_366":470},"1752161904",417000000,{"_364":472,"_366":473},"1771935480",170000000,"2025-07-10T15:38:24.417Z","bafy2bzacec6hrmu6x3i4sig3v65yimreki35vksxz7rvahnhcgbn4zbnqxh4c",[477],{"_126":298,"_119":47,"_377":8},{"_380":479,"_384":482,"_386":483,"_388":484,"_390":6},{"_364":480,"_366":481},"1769678048",922000000,"zDnaevzAM7dt31eEa4ugrp1H2VwpUzProjrQ1HuC1qXjFYAEW/z6FC58uAKdHzjc",20,{"_364":472,"_366":473},{"_130":475,"_133":346},{"_126":324,"_428":487},"M",{"_34":25,"_36":489,"_119":494,"_116":495,"_121":496,"_123":499,"_371":502,"_130":503,"_113":493,"_374":504,"_378":506,"_131":513,"_393":-5,"_124":515,"_135":136},{"_36":490,"_143":115,"_119":491,"_113":493,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/roadmap",[492],"roadmap","bafy2bzacecfy7xw2zhe7oy5irrz5uirma54wic5avw26m2yasayikmi3323te",[492],[293,115,291,467,118],{"_364":497,"_366":498},"1751702529",991000000,{"_364":500,"_366":501},"1771326401",660000000,"2025-07-05T08:02:09.991Z","bafy2bzaced3t5nb4pyuu5iukdirwdsblmggv2vuq6urpnd4vftg5lnu5yjuey",[505],{"_126":298,"_119":47,"_377":8},{"_380":507,"_384":510,"_386":511,"_388":512,"_390":6},{"_364":508,"_366":509},"1771863047",262000000,"z6MkomKJd58PhVSoDZPi9RtUZ6rLrT2P8UN9ijLpb7Hj2tdn/z6FZrbATfsngbe",38,{"_364":500,"_366":501},{"_130":503,"_133":514},"1751702529991",{"_126":312},{"_34":25,"_36":517,"_119":522,"_116":523,"_121":524,"_123":527,"_371":530,"_130":531,"_113":521,"_374":532,"_378":534,"_131":541,"_393":-5,"_124":542,"_135":136},{"_36":518,"_143":115,"_119":519,"_113":521,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs",[520],"specs","bafy2bzacedfa3cmxkeswnj5eqvsuzyg3n2jrihwkrekq2u7v7p7xfdot53a4e",[520],[293,115,294,291],{"_364":525,"_366":526},"1757507072",743000000,{"_364":528,"_366":529},"1770899043",471000000,"2025-09-10T12:24:32.743Z","bafy2bzacedgzqyw4bffanmgxuxigf7w4qksk4ib5ut7mhfcggm5w4f3ud3xwm",[533],{"_126":298,"_119":47,"_377":8},{"_380":535,"_384":538,"_386":539,"_388":540,"_390":6},{"_364":536,"_366":537},"1760598695",490000000,"z6Mkvz9TgGtv9zsGsdrksfNk1ajbFancgHREJEz3Y2HsAVdk/z6DdZ6RHVmaMNX",5,{"_364":528,"_366":529},{"_130":531,"_133":346},{"_126":330},{"_34":25,"_36":544,"_119":549,"_116":550,"_121":551,"_123":554,"_371":557,"_130":558,"_113":548,"_374":559,"_378":561,"_131":568,"_393":-5,"_124":570,"_135":136},{"_36":545,"_143":115,"_119":546,"_113":548,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/user-story-map",[547],"user-story-map","bafy2bzaceduic574uietf5ds5qxo7tf42gremw6vxlzdxwsp2bkjddiizjite",[547],[293,291],{"_364":552,"_366":553},"1753177046",860000000,{"_364":555,"_366":556},"1770891926",614000000,"2025-07-22T09:37:26.860Z","bafy2bzacealtqjbqauikxnocl2so3eorgne3ggkhv7cogtf4onodqaxartg7o",[560],{"_126":298,"_119":47,"_377":8},{"_380":562,"_384":565,"_386":566,"_388":567,"_390":6},{"_364":563,"_366":564},"1770976718",280000000,"z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4/z6FR25YjTujXE6",6,{"_364":555,"_366":556},{"_130":558,"_133":569},"1753177046858",{"_126":571},"User Story Map",{"_34":25,"_36":573,"_119":578,"_116":579,"_121":580,"_123":583,"_371":586,"_130":587,"_113":577,"_374":588,"_378":590,"_131":592,"_393":-5,"_124":594,"_135":136},{"_36":574,"_143":115,"_119":575,"_113":577,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/methodologies",[576],"methodologies","bafy2bzaceaw5gsmplbwxrqlhfjqsf7t47hrslkntf6a2gxvet3qlcfsf2qxpa",[576],[293],{"_364":581,"_366":582},"1752483694",123000000,{"_364":584,"_366":585},"1766145645",486000000,"2025-07-14T09:01:34.123Z","bafy2bzacebip7pvsmdoewquvcmipekt53gcksnn7pbc7igu7u5wpsonneptvq",[589],{"_126":298,"_119":47,"_377":8},{"_380":-5,"_384":47,"_386":219,"_388":591,"_390":6},{"_364":584,"_366":585},{"_130":587,"_133":593},"1752483694123",{"_126":595,"_395":596},"Methodologies","Methodologies are a necessary element for human intellect augmentation. ",{"_34":25,"_36":598,"_119":603,"_116":604,"_121":605,"_123":608,"_371":611,"_130":612,"_113":602,"_374":613,"_378":615,"_131":621,"_393":-5,"_124":623,"_135":136},{"_36":599,"_143":115,"_119":600,"_113":602,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/stories",[601],"stories","bafy2bzacecvcpp76llpsnwrzlog2noqomez64ebx5a3jumjy4n5af6oivgni2",[601],[293,115,294],{"_364":606,"_366":607},"1756300583",462000000,{"_364":609,"_366":610},"1765813574",75000000,"2025-08-27T13:16:23.462Z","bafy2bzacecrattxfobgydg3rqsirjsquulwbxpermpxqfohwlugmidlepcqi2",[614],{"_126":298,"_119":47,"_377":8},{"_380":616,"_384":619,"_386":87,"_388":620,"_390":6},{"_364":617,"_366":618},"1757935799",194000000,"z6MkgYR76i3w2Xc2fcvgFJWfYjsop6YwUonDhQx3AdLmQ4BQ/z6DB1JTe1PDUyG",{"_364":609,"_366":610},{"_130":612,"_133":622},"1756300583462",{"_126":624},"Stories",{"_34":25,"_36":626,"_119":631,"_116":632,"_121":633,"_123":636,"_371":639,"_130":640,"_113":630,"_374":641,"_378":643,"_131":645,"_393":-5,"_124":647,"_135":136},{"_36":627,"_143":115,"_119":628,"_113":630,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/academic-papers",[629],"academic-papers","bafy2bzacecpciyww7skadu3wxqzgp6tlfslyyymp7kixspmwn74panl6l2n54",[629],[293],{"_364":634,"_366":635},"1763396740",165000000,{"_364":637,"_366":638},"1763396788",635000000,"2025-11-17T16:25:40.165Z","bafy2bzacechg2zqbfzsobwuifyzc7iprmi2qr4b4h3owejttu473kd25wbipw",[642],{"_126":298,"_119":47,"_377":8},{"_380":-5,"_384":47,"_386":219,"_388":644,"_390":6},{"_364":637,"_366":638},{"_130":640,"_133":646},"1763396740165",{"_126":648},"Academic Papers",{"_34":25,"_36":650,"_119":655,"_116":656,"_121":657,"_123":660,"_371":663,"_130":664,"_113":654,"_374":665,"_378":667,"_131":669,"_393":-5,"_124":670,"_135":136},{"_36":651,"_143":115,"_119":652,"_113":654,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/identified-pain-points",[653],"identified-pain-points","bafy2bzacebn5gompe4lz5crytfykeyi7vkbszyd4ejepwe7i2zj64el3cvjcq",[653],[293],{"_364":658,"_366":659},"1753351865",631000000,{"_364":661,"_366":662},"1758272387",548000000,"2025-07-24T10:11:05.631Z","bafy2bzacebpdextl7sosiws4oprqfldkj3lswtl3mng3lxkqagwtqgnza5rfo",[666],{"_126":298,"_119":47,"_377":8},{"_380":-5,"_384":47,"_386":219,"_388":668,"_390":6},{"_364":661,"_366":662},{"_130":664,"_133":346},{"_126":671},"Identified Pain Points",{"_34":25,"_36":673,"_119":678,"_116":679,"_121":680,"_123":683,"_371":686,"_130":687,"_113":677,"_374":688,"_378":690,"_131":697,"_393":-5,"_124":699,"_135":136},{"_36":674,"_143":115,"_119":675,"_113":677,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/discussions",[676],"discussions","bafy2bzaceafps6rwv26m26b3ndalaihxmvrlhc2zztepty2wtrbfrabiurvvi",[676],[293,115],{"_364":681,"_366":682},"1732791826",161000000,{"_364":684,"_366":685},"1758096718",948000000,"2024-11-28T11:03:46.161Z","bafy2bzacecai7zv2yssq7j6on5wnylvsdgg2ctbyrnwoknh4wwtasexjh22wm",[689],{"_126":298,"_119":47,"_377":8},{"_380":691,"_384":694,"_386":695,"_388":696,"_390":6},{"_364":692,"_366":693},"1771252490",788000000,"z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4/z6FTmYNygCS4ex",120,{"_364":684,"_366":685},{"_130":687,"_133":698},"1732791826161",{"_126":336,"_428":429},{"_34":25,"_36":701,"_119":706,"_116":707,"_121":708,"_123":711,"_371":714,"_130":715,"_113":705,"_374":716,"_378":718,"_131":720,"_393":-5,"_124":722,"_135":136},{"_36":702,"_143":115,"_119":703,"_113":705,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/site-organization",[704],"site-organization","bafy2bzacebjuo7m4ljbnnw6f3qwve3wqnu24wkmcwmv4scjsqizgfyk6ls2wm",[704],[293,115],{"_364":709,"_366":710},"1757971251",134000000,{"_364":712,"_366":713},"1758011895",764000000,"2025-09-15T21:20:51.134Z","bafy2bzacecspxqbvg4vyrgwuazy766ndx7i2aa2zfc76kt5awvr2lzz4tb65y",[717],{"_126":298,"_119":47,"_377":8},{"_380":-5,"_384":47,"_386":219,"_388":719,"_390":6},{"_364":712,"_366":713},{"_130":715,"_133":721},"1757971251133",{"_126":723},"Site Organization",{"_34":25,"_36":725,"_119":730,"_116":731,"_121":732,"_123":735,"_371":738,"_130":739,"_113":729,"_374":740,"_378":742,"_131":748,"_393":-5,"_124":750,"_135":136},{"_36":726,"_143":115,"_119":727,"_113":729,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/create-a-new-discussion",[728],"create-a-new-discussion","bafy2bzacecwyuyxhqqfwmkd4hek7yudoebwjaqt2ehun346r5vah6qnyqaau2",[728],[293,118],{"_364":733,"_366":734},"1756300679",383000000,{"_364":736,"_366":737},"1757423008",601000000,"2025-08-27T13:17:59.383Z","bafy2bzacedokt2n6ku35tovylopn76r4vbcuwf4je7v5rdomdyr35adapsdaq",[741],{"_126":298,"_119":47,"_377":8},{"_380":743,"_384":746,"_386":539,"_388":747,"_390":6},{"_364":744,"_366":745},"1756461470",757000000,"z6MkfnCSnmstMXTAb6MBXXCj4zdPwZedtRF6YBgYtE5Q8Sov/z6CvJnaJb4mMJe",{"_364":736,"_366":737},{"_130":739,"_133":749},"1756300679383",{"_126":751},"Create a new Discussion",{"_34":25,"_36":753,"_119":758,"_116":759,"_121":760,"_123":763,"_371":766,"_130":767,"_113":757,"_374":768,"_378":770,"_131":776,"_393":-5,"_124":778,"_135":136},{"_36":754,"_143":115,"_119":755,"_113":757,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/definitions",[756],"definitions","bafy2bzaceardarkdfmc7l5gko4v2zi3z5kf6y7alekquvqxzp3ioexqzabo72",[756],[293,115],{"_364":761,"_366":762},"1752232211",716000000,{"_364":764,"_366":765},"1752232556",193000000,"2025-07-11T11:10:11.716Z","bafy2bzaceaqctzadpz27ncr674vzix6jgcvuqvuix3jcqlfhpetpblxm6o2fg",[769],{"_126":298,"_119":47,"_377":8},{"_380":771,"_384":774,"_386":214,"_388":775,"_390":6},{"_364":772,"_366":773},"1761609849",219000000,"z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4/z6DodnPuv1mjF8",{"_364":764,"_366":765},{"_130":767,"_133":777},"1752232211716",{"_126":779},"Definitions",{"_34":25,"_36":781,"_119":786,"_116":787,"_121":788,"_123":791,"_371":794,"_130":795,"_113":785,"_374":796,"_378":798,"_131":805,"_393":-5,"_124":807,"_135":136},{"_36":782,"_143":115,"_119":783,"_113":785,"_145":-5,"_146":-5,"_147":-5,"_148":-5,"_142":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/updates",[784],"updates","bafy2bzacedjhk4r4tzf2bfkhd3rqbzep2o7s6ec3tzuwpn3jbqo4ipv2vrnle",[784],[405,294,291,118],{"_364":789,"_366":790},"1745330217",834000000,{"_364":792,"_366":793},"1746610473",772000000,"2025-04-22T13:56:57.834Z","bafy2bzacedajlr6y5olm3ee24vmpat7yxi7ysb35qnyu3z7fkmsd7sloxwpm6",[797],{"_126":298,"_119":47,"_377":8},{"_380":799,"_384":802,"_386":803,"_388":804,"_390":6},{"_364":800,"_366":801},"1763480049",21000000,"zDnaeUAteHX98erunHCNphgNFnXeQnAegvQjUKqxKJWQFP6Z3/z6E8HCybawN6HA",2,{"_364":792,"_366":793},{"_130":795,"_133":806},"1745330217833",{"_126":808,"_809":8,"_428":429},"Updates","showOutline",1779649238578,[812,348,261],"DOC_LIST_DIRECTORY","[\"DOC_LIST_DIRECTORY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno\",\"Children\"]",{"_158":815,"_229":818,"_232":819},{"_160":816,"_213":214,"_215":817,"_217":-5,"_218":219,"_220":219,"_221":219,"_222":-5,"_223":-5,"_224":8,"_225":226,"_227":228},[],1779649239101,[812,144,261],"[\"DOC_LIST_DIRECTORY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sqlite-avoid-comparing-against-expressions\",\"Children\"]",{"_158":821,"_229":831,"_232":833},{"_160":822,"_213":214,"_215":830,"_217":-5,"_218":219,"_220":219,"_221":219,"_222":-5,"_223":-5,"_224":8,"_225":226,"_227":228},{"_823":219,"_824":219,"_825":214,"_30":219,"_826":827,"_828":829},"citations","comments","changes","authorUids",[],"blocks",{},1779649238589,[832,144],"DOCUMENT_INTERACTION_SUMMARY","[\"DOCUMENT_INTERACTION_SUMMARY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sqlite-avoid-comparing-against-expressions\"]",{"_158":835,"_229":910,"_232":911},{"_160":836,"_213":214,"_215":909,"_217":-5,"_218":219,"_220":219,"_221":219,"_222":-5,"_223":-5,"_224":8,"_225":226,"_227":228},{"_34":25,"_25":837,"_36":907},{"_27":838,"_113":360,"_114":115,"_116":901,"_119":902,"_121":372,"_123":903,"_124":904,"_128":905,"_130":373,"_131":906,"_135":136},[839,852,862,870,878,886,894],{"_30":840,"_32":841},[],{"_34":35,"_36":842,"_38":843,"_40":844,"_42":845,"_44":851,"_46":47},"1M6vMB7T","bafy2bzaced4lqd5w4vhvqp2qthkk4xrk4fnhbafuthobu2uzxgdaqyd5qcp2e",{},[846],{"_34":282,"_81":847,"_85":848,"_40":850,"_46":851},[219],[849],59,{},"https://seedteamtalks.hyper.media/tech-talks/:discussions?l",{"_30":853,"_32":854},[],{"_34":855,"_36":856,"_38":857,"_40":858,"_42":860,"_44":47,"_46":861},"Embed","GskEMIbKXY","bafy2bzacecf3h4mlhomplwadgmyff4e2buqyladj2jjxjrdjmd6yjoojjyt4k",{"_859":253},"view",[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/proposal-new-feed-url-format?v=bafy2bzaceaqrtju2mrzqw2cq2h3dfmzpedak3o3qc4hdhcj36bacv74ynry6c",{"_30":863,"_32":864},[],{"_34":855,"_36":865,"_38":866,"_40":867,"_42":868,"_44":47,"_46":869},"rw7BGM01h9","bafy2bzaceavarxiytknm2u6lletj5c7ozerz66ximj47lxl5z4segt5rrp77g",{"_859":253},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/hypermedia-protocol-schemas?v=bafy2bzacecu2alxq25lqjcxwaq7zaxao7oqae6yejfn2ipvshwbicrkrcca2u",{"_30":871,"_32":872},[],{"_34":855,"_36":873,"_38":874,"_40":875,"_42":876,"_44":47,"_46":877},"H-l3S5necu","bafy2bzacecz4ckjcyv5wmmru4s2uoknzyh4g6zfyt5qzocc3l2jatbsimczs4",{"_859":253},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/hypermedia-onyx?v=bafy2bzaceb7tz2sp2djraj3gqhmlizfx7pfboksywc2v6ayvw7scmcr2t5qfc",{"_30":879,"_32":880},[],{"_34":855,"_36":881,"_38":882,"_40":883,"_42":884,"_44":47,"_46":885},"A0RHeYK7Q2","bafy2bzacedu572jfsh73qyj4v5ayxgm4imnbgon6nwo62qvzvabf33fs7ebzk",{"_859":253},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/interface-linage?v=bafy2bzaceclhzdlz3babhlsizutkunvo3tiwiywvxvfmbolwi46uf6sl2l2my",{"_30":887,"_32":888},[],{"_34":855,"_36":889,"_38":890,"_40":891,"_42":892,"_44":47,"_46":893},"7E_89Yu-q4","bafy2bzacebkdglo2ebuflyfhufpujy62gxuobg5nr35jnye4hbajno6c5qgli",{"_859":253},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/inheritance-was-invented-as-a-performance-hack?v=bafy2bzacebvmjwa6blv2ol2o6kinjhprlpla2hbv2l43tbvbfhxezcgtsyseo",{"_30":895,"_32":896},[],{"_34":855,"_36":897,"_38":360,"_40":898,"_42":899,"_44":47,"_46":900},"Gbhv_6MV9j",{"_859":253},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/joinsubscribefollownotify?v=bafy2bzacec3boggkxtxylhtxwaq6roa37kejjcvls6lmty44w2h3feac4f25g",[291,293],"/tech-talks","2026-02-26T10:48:48.885Z",{"_126":318,"_395":396},{},{"_130":373,"_133":392},{"_36":358,"_143":115,"_119":908,"_113":-5,"_145":-5,"_146":-5,"_147":-5,"_148":-5},[140],1779649237934,[231,358,-5,8],"[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks\",null,false]",{"_158":913,"_229":923,"_232":925},{"_160":914,"_213":214,"_215":922,"_217":-5,"_218":219,"_220":219,"_221":219,"_222":-5,"_223":-5,"_224":8,"_225":226,"_227":228},{"_34":114,"_36":915,"_124":919},{"_113":916,"_143":118,"_36":917,"_119":918,"_145":-5,"_146":-5,"_147":-5,"_148":-5},"bafy2bzacea6fd72k47wlvgd4hc33vbxbmlca6siu4tcg2p66aizpqkbfrpd2e","hm://z6MkgYR76i3w2Xc2fcvgFJWfYjsop6YwUonDhQx3AdLmQ4BQ",[],{"_126":920,"_299":921,"_395":-5},"Alex Burdiyan","ipfs://bafkreidm54rhouk5rjrzzh75kfy6de72rlefi2xdhv2plfeg2k6sau5ky4",1779649239129,[924,118],"ACCOUNT","[\"ACCOUNT\",\"z6MkgYR76i3w2Xc2fcvgFJWfYjsop6YwUonDhQx3AdLmQ4BQ\"]","ssrContentHTML","

In our backend code I've seen a bunch of places where we compare the result of an expression with an input parameter/s.

For example:

SELECT\n  id\nFROM public_keys\nWHERE hex(principal) = :principal LIMIT 1;

SELECT DISTINCT\n  multihash,\n  codec\nFROM blobs\nWHERE hex(multihash) IN (\n  SELECT value from json_each(:mhash_json)\n)\nAND size > 0

In both of these queries the WHERE clause can't use an index, and will do a full table scan. This is because the index doesn't know the result of the hex() expression, so it can't compare the column value against the input parameter.

The solution for the first query is to do WHERE principal = unhex(:principal) and for the second one is to do WHERE multihash IN (SELECT unhex(value) FROM json_each(:mhash_json).

So, instead of running an expression on all the rows in the table, we run the "reverse" expression to convert the input parameter to the same value as the column, which will let us use the index.

","enableWebSigning","https://ifebitcoin.org","origin","homeMetadata",{"_126":933,"_299":934,"_935":936,"_300":929,"_937":47,"_938":939,"_940":941,"_809":8,"_302":8,"_428":429,"_942":943},"Instituto de Filosofía y Economía Bitcoin","ipfs://bafkreidefxplum2mkfvv2uhaupvil5uvbguud5s2p7dgyp6orchw4f6jpm","cover","ipfs://bafkreifsdwjltm7dcv2a6vlnae6wy37ep2f4wgxo2hfjk4cn3sgkuvnake","layout","seedExperimentalLogo","ipfs://bafkreibpra4x7f5yuyijo7erlpbpahsmtaeoargic3dyda2ccwdxfyafle","seedExperimentalHomeOrder","CreatedFirst","theme",{"_944":945},"headerLayout","Center","originHomeId",{"_143":948,"_36":949,"_119":950,"_113":-5,"_145":-5,"_146":-5,"_147":-5,"_148":-5},"z6MkmoafLuwBs51a18PfEqjmBmXE2idHPLAdsCqm7VjQHFCs","hm://z6MkmoafLuwBs51a18PfEqjmBmXE2idHPLAdsCqm7VjQHFCs",[],"meta",{"_953":954,"_1196":1197},"values",{"_955":956,"_958":959,"_960":961,"_962":963,"_965":966,"_967":968,"_969":970,"_972":973,"_974":975,"_976":977,"_978":979,"_980":981,"_982":983,"_984":985,"_986":987,"_988":989,"_990":991,"_992":993,"_994":995,"_996":997,"_998":999,"_1000":1001,"_1002":1003,"_1004":1005,"_1006":1007,"_1008":1009,"_1010":1011,"_1012":1013,"_1014":1015,"_1016":1017,"_1018":1019,"_1020":1021,"_1022":1023,"_1024":1025,"_1026":1027,"_1028":1029,"_1030":1031,"_1032":1033,"_1034":1035,"_1036":1037,"_1038":1039,"_1040":1041,"_1042":1043,"_1044":1045,"_1046":1047,"_1048":1049,"_1050":1051,"_1052":1053,"_1054":1055,"_1056":1057,"_1058":1059,"_1060":1061,"_1062":1063,"_1064":1065,"_1066":1067,"_1068":1069,"_1070":1071,"_1072":1073,"_1074":1075,"_1076":1077,"_1078":1079,"_1080":1081,"_1082":1083,"_1084":1085,"_1086":1087,"_1088":1089,"_1090":1091,"_1092":1093,"_1094":1095,"_1096":1097,"_1098":1099,"_1100":1101,"_1102":1103,"_1104":1105,"_1106":1107,"_1108":1109,"_1110":1111,"_1112":1113,"_1114":1115,"_1116":1117,"_1118":1119,"_1120":1121,"_1122":1123,"_1124":1125,"_1126":1127,"_1128":1129,"_1130":1131,"_1132":1133,"_1134":1135,"_1136":1137,"_1138":1139,"_1140":1141,"_1142":1143,"_1144":1145,"_1146":1147,"_1148":1149,"_1150":1151,"_1152":1153,"_1154":1155,"_1156":1157,"_1158":1159,"_1160":1161,"_1162":1163,"_1164":1165,"_1166":1167,"_1168":1169,"_1170":1171,"_1172":1173,"_1174":1175,"_1176":1177,"_1178":1179,"_1180":1181,"_1182":1183,"_1184":1185,"_1186":1187,"_1188":1189,"_1190":1191,"_1192":1193,"_1194":1195},"document.generationInfo.generation",[957],"bigint","dehydratedState.queries.0.state.data.document.generationInfo.generation",[957],"dehydratedState.queries.1.state.data.document.generationInfo.generation",[957],"dehydratedState.queries.1.queryKey.2",[964],"undefined","dehydratedState.queries.2.state.data.0.createTime.seconds",[957],"dehydratedState.queries.2.state.data.0.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.0.sortTime",[971],"Date","dehydratedState.queries.2.state.data.0.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.0.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.0.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.0.redirectInfo",[964],"dehydratedState.queries.2.state.data.1.createTime.seconds",[957],"dehydratedState.queries.2.state.data.1.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.1.sortTime",[971],"dehydratedState.queries.2.state.data.1.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.1.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.1.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.1.redirectInfo",[964],"dehydratedState.queries.2.state.data.2.createTime.seconds",[957],"dehydratedState.queries.2.state.data.2.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.2.sortTime",[971],"dehydratedState.queries.2.state.data.2.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.2.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.2.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.2.redirectInfo",[964],"dehydratedState.queries.2.state.data.3.createTime.seconds",[957],"dehydratedState.queries.2.state.data.3.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.3.sortTime",[971],"dehydratedState.queries.2.state.data.3.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.3.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.3.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.3.redirectInfo",[964],"dehydratedState.queries.2.state.data.4.createTime.seconds",[957],"dehydratedState.queries.2.state.data.4.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.4.sortTime",[971],"dehydratedState.queries.2.state.data.4.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.4.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.4.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.4.redirectInfo",[964],"dehydratedState.queries.2.state.data.5.createTime.seconds",[957],"dehydratedState.queries.2.state.data.5.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.5.sortTime",[971],"dehydratedState.queries.2.state.data.5.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.5.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.5.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.5.redirectInfo",[964],"dehydratedState.queries.2.state.data.6.createTime.seconds",[957],"dehydratedState.queries.2.state.data.6.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.6.sortTime",[971],"dehydratedState.queries.2.state.data.6.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.6.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.6.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.6.redirectInfo",[964],"dehydratedState.queries.2.state.data.7.createTime.seconds",[957],"dehydratedState.queries.2.state.data.7.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.7.sortTime",[971],"dehydratedState.queries.2.state.data.7.activitySummary.latestCommentTime",[964],"dehydratedState.queries.2.state.data.7.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.7.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.7.redirectInfo",[964],"dehydratedState.queries.2.state.data.8.createTime.seconds",[957],"dehydratedState.queries.2.state.data.8.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.8.sortTime",[971],"dehydratedState.queries.2.state.data.8.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.8.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.8.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.8.redirectInfo",[964],"dehydratedState.queries.2.state.data.9.createTime.seconds",[957],"dehydratedState.queries.2.state.data.9.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.9.sortTime",[971],"dehydratedState.queries.2.state.data.9.activitySummary.latestCommentTime",[964],"dehydratedState.queries.2.state.data.9.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.9.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.9.redirectInfo",[964],"dehydratedState.queries.2.state.data.10.createTime.seconds",[957],"dehydratedState.queries.2.state.data.10.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.10.sortTime",[971],"dehydratedState.queries.2.state.data.10.activitySummary.latestCommentTime",[964],"dehydratedState.queries.2.state.data.10.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.10.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.10.redirectInfo",[964],"dehydratedState.queries.2.state.data.11.createTime.seconds",[957],"dehydratedState.queries.2.state.data.11.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.11.sortTime",[971],"dehydratedState.queries.2.state.data.11.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.11.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.11.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.11.redirectInfo",[964],"dehydratedState.queries.2.state.data.12.createTime.seconds",[957],"dehydratedState.queries.2.state.data.12.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.12.sortTime",[971],"dehydratedState.queries.2.state.data.12.activitySummary.latestCommentTime",[964],"dehydratedState.queries.2.state.data.12.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.12.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.12.redirectInfo",[964],"dehydratedState.queries.2.state.data.13.createTime.seconds",[957],"dehydratedState.queries.2.state.data.13.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.13.sortTime",[971],"dehydratedState.queries.2.state.data.13.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.13.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.13.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.13.redirectInfo",[964],"dehydratedState.queries.2.state.data.14.createTime.seconds",[957],"dehydratedState.queries.2.state.data.14.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.14.sortTime",[971],"dehydratedState.queries.2.state.data.14.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.14.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.14.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.14.redirectInfo",[964],"dehydratedState.queries.2.state.data.15.createTime.seconds",[957],"dehydratedState.queries.2.state.data.15.updateTime.seconds",[957],"dehydratedState.queries.2.state.data.15.sortTime",[971],"dehydratedState.queries.2.state.data.15.activitySummary.latestCommentTime.seconds",[957],"dehydratedState.queries.2.state.data.15.activitySummary.latestChangeTime.seconds",[957],"dehydratedState.queries.2.state.data.15.generationInfo.generation",[957],"dehydratedState.queries.2.state.data.15.redirectInfo",[964],"dehydratedState.queries.5.state.data.document.generationInfo.generation",[957],"dehydratedState.queries.5.queryKey.2",[964],"dehydratedState.queries.6.state.data.metadata.summary",[964],"referentialEqualities",{"_955":1198,"_960":1199,"_967":1200,"_976":1201,"_982":1202,"_996":1203,"_1010":1204,"_1024":1205,"_1038":1206,"_1052":1207,"_1066":1208,"_1080":1209,"_1094":1210,"_1108":1211,"_1122":1212,"_1136":1213,"_1150":1214,"_1164":1215,"_1178":1216},[958],[1018,1046,1116],[974],[1190],[988],[1002],[1016],[1030],[1044],[1058],[1072],[1086],[1100],[1114],[1128],[1142],[1156],[1170],[1184],"actionData","errors"]