cloudflare/d1 have no export named json_array
cloudflare/d1 have no export named json_array
MIt’s not an exported function and it probably wouldn’t make sense for them to create exports for 20+ JSON functions. You should be able to use
.where(sql…)Drizzle ORM | %s
M
Mim already there, but there is no active people
R
It's not a js function. you need to include it within your raw sql query , like sql'select json_array_length(colname) as x from table'.M@0b1111
M
M
Rwhat is
userTable.settings ?M
Mi want to hold a json with user settings
Mlike avatar, description etc
Rbut why u would use json in the first time, just use columns is better 
Mfor example
Msocial media link
Myou want me to create a column for each, facebook, instagram etc?
M.
MD1 has built-in support for querying and parsing JSON data stored within a database. This enables you to:
Rbut did u read it carefully ? because u are trying to use the
json
Rwhat does it says ?
Mthat he should return an array
Mwith json
RValidates the provided string is JSON and returns a minified version of that JSON object.
M
Rit does not convert and return your json string into object json, its just validate & clean the json and return the minified result of it but at string format
M
Mthis is with json_array
Rman what you are trying is called
parse/extract jsonMost of these json functions are designed to help you manipulate/store the data.
Rtry to use
json_extract
Rjson_extract(${usersTable.settings}, '$')null
Mand with '$' only
settings
:
"{\"hello\":[\"world\",\"there\"]}"examples
->
->
SELECT json_extract('{"hello":["world","there"]}', '$.hello');->
'["world","there"]'SELECT json_extract('{"hello":["world","there"]}', '$');->
'{"hello":["world","there"]}'So its confirmed, you need to parse(jsondecode) that data in your side.
Mconsole.log(JSON.parse(user?.settings?.hello))message: "undefined" is not valid JSONand with
console.log(JSON.parse(user?.settings))
Mhttps://developers.cloudflare.com/d1/learning/querying-json/#extracting-values
- specifically the “Extracting values” section - lots of examples.
D1 has built-in support for querying and parsing JSON data stored within a database. This enables you to:
MIf you’re learning, using the dashboard’s console to test out functions or
wrangler d1 execute your-db —command="SELECT json_extract(…) FROM yourtable"
MThe Cloudflare Blog
We've been heads down iterating on D1, and we've just shipped a major new version that's substantially faster, more reliable, and introduces Time Travel: the ability to restore a D1 database to any point in time.
MYou don’t need to use that library. Use the Cloudflare adapter - follow these steps: https://developers.cloudflare.com/pages/framework-guides/deploy-a-svelte-site/#sveltekit-cloudflare-configuration
MA working example: https://github.com/elithrar/svelte-demo-d1
export async function GET({ request, platform }) {
let result = await platform.env.DB.prepare(
"SELECT * FROM users LIMIT 5"
).run();
return new Response(JSON.stringify(result));
}
```
- I just ran through the SvelteKit tutorial. Let it be known that I am not a big fan of SvelteKit and find the TypeScript support very janky.
```ts
// file: routes/api/users/+server.ts
import type { RequestHandler } from "@sveltejs/kit";
export async function GET({ request, platform }) {
let result = await platform.env.DB.prepare(
"SELECT * FROM users LIMIT 5"
).run();
return new Response(JSON.stringify(result));
}
```
MWe don’t publish exact timelines (see my pinned messages for a longer explanation). It’s soon, but you’re just going to be frustrated if I give you a date and we don’t hit it because there’s a bug or edge case that breaks things.
MHey guys,
I’m trying to decide between planet scale and d1 for my saas. The only thing holding me back from d1 is having to worry about database storage limit. Like planet scale Im under the impression you just create a database and never have to worry about a single thing and it grows in size as you need it to
I’m trying to decide between planet scale and d1 for my saas. The only thing holding me back from d1 is having to worry about database storage limit. Like planet scale Im under the impression you just create a database and never have to worry about a single thing and it grows in size as you need it to
UD1 is in alpha and shouldnt really be used for production critical applications.
