Cloudflare Developers•3y ago

but why u would use json in the first time, just use columns is better 😄

but why u would use json in the first time, just use columns is better

manstfu•6/17/23, 12:24 PM

for example

manstfu•6/17/23, 12:24 PM

social media link

manstfu•6/17/23, 12:24 PM

you want me to create a column for each, facebook, instagram etc?

Rraise;but why u would use json in the first time, just use columns is better 😄

manstfu•6/17/23, 12:25 PM

Mmanstfu .

raise;OP•6/17/23, 12:32 PM

did you read the doc of sqlite functions ?

manstfu•6/17/23, 12:32 PM

https://developers.cloudflare.com/d1/learning/querying-json/

Query JSON · Cloudflare D1 docs

D1 has built-in support for querying and parsing JSON data stored within a database. This enables you to:

raise;OP•6/17/23, 12:32 PM

but did u read it carefully ? because u are trying to use the

json

json

function

manstfu•6/17/23, 12:33 PM

raise;OP•6/17/23, 12:33 PM

what does it says ?

manstfu•6/17/23, 12:33 PM

that he should return an array

manstfu•6/17/23, 12:33 PM

with json

raise;OP•6/17/23, 12:33 PM

Validates the provided string is JSON and returns a minified version of that JSON object.

manstfu•6/17/23, 12:34 PM

raise;OP•6/17/23, 12:34 PM

it 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

manstfu•6/17/23, 12:34 PM

this is with json_array

raise;OP•6/17/23, 12:35 PM

man what you are trying is called

parse/extract json

parse/extract json

, so u are using the wrong functions

raise;OP•6/17/23, 12:37 PM

Most of these json functions are designed to help you manipulate/store the data.

Mmanstfu Click to see attachment

raise;OP•6/17/23, 12:37 PM

try to use

json_extract

json_extract

manstfu•6/17/23, 12:38 PM

raise;OP•6/17/23, 12:39 PM

json_extract(${usersTable.settings}, '$')

json_extract(${usersTable.settings}, '$')

manstfu•6/17/23, 12:40 PM

null

manstfu•6/17/23, 12:40 PM

and with '$' only

settings
: 
"{\"hello\":[\"world\",\"there\"]}"

settings
: 
"{\"hello\":[\"world\",\"there\"]}"

Mmanstfu and with '$' only `settings : "{\"hello\":[\"world\",\"there\"]}"`

raise;OP•6/17/23, 12:42 PM

examples

SELECT json_extract('{"hello":["world","there"]}', '$.hello');

SELECT json_extract('{"hello":["world","there"]}', '$.hello');

'["world","there"]'

'["world","there"]'

SELECT json_extract('{"hello":["world","there"]}', '$');

SELECT json_extract('{"hello":["world","there"]}', '$');

'{"hello":["world","there"]}'

'{"hello":["world","there"]}'

raise;OP•6/17/23, 12:43 PM

So its confirmed, you need to parse(jsondecode) that data in your side.

Rraise;**So its confirmed, you need to parse(jsondecode) that data in your side.**

manstfu•6/17/23, 1:06 PM

console.log(JSON.parse(user?.settings?.hello))

console.log(JSON.parse(user?.settings?.hello))

message: "undefined" is not valid JSON

message: "undefined" is not valid JSON

manstfu•6/17/23, 1:07 PM

and with

console.log(JSON.parse(user?.settings))

console.log(JSON.parse(user?.settings))

Matt Silverlock•6/17/23, 1:20 PM

https://developers.cloudflare.com/d1/learning/querying-json/#extracting-values

specifically the “Extracting values” section - lots of examples.

Query JSON · Cloudflare D1 docs

D1 has built-in support for querying and parsing JSON data stored within a database. This enables you to:

Matt Silverlock•6/17/23, 1:23 PM

If you’re learning, using the dashboard’s console to test out functions or

wrangler d1 execute your-db —command="SELECT json_extract(…) FROM yourtable"

wrangler d1 execute your-db —command="SELECT json_extract(…) FROM yourtable"

is a good way to experiment.

Jjbonett Hi, I’m starting a new project which would like to release within around 3 month...

Matt Silverlock•6/18/23, 11:51 AM

https://blog.cloudflare.com/d1-turning-it-up-to-11/

The Cloudflare Blog

D1: We turned it up to 11

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.

SStan I was unable to connect with D1 using SvelteKit after a day of struggling due to...

Matt Silverlock•6/18/23, 11:55 AM

You 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

SStan I was unable to connect with D1 using SvelteKit after a day of struggling due to...

Matt Silverlock•6/18/23, 12:41 PM

A working example: https://github.com/elithrar/svelte-demo-d1

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";

** @type {import('@sveltejs/kit').RequestHandler} */
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));
}
```

Jjbonett Thanks, but is there a timeline for increasing the current limits?

Matt Silverlock•6/18/23, 3:05 PM

We 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.

MetalGear•6/18/23, 6:37 PM

Hey 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

Unsmart•6/18/23, 6:41 PM

D1 is in alpha and shouldnt really be used for production critical applications.

UUnsmart D1 is in alpha and shouldnt really be used for production critical applications.

MetalGear•6/18/23, 6:58 PM

I know I’m referencing to when it’s released

Unsmart•6/18/23, 6:59 PM

When D1 is released I assume it will have much much much higher limits to storage than it does now. But it is going to be in alpha for some time so you shouldnt plan on using it if you are already working on a service you want to use for critical production workloads

UUnsmart When D1 is released I assume it will have much much much higher limits to storag...

MetalGear•6/18/23, 7:00 PM

Thanks I get that and using planet scale for now but watching d1 carefully as I’d like to migrate to using only cf services in future so that’s why I’m asking

MetalGear•6/18/23, 7:00 PM

My question I guess is does cloudflare plan to auto scale for users like planet scale does

MetalGear•6/18/23, 7:01 PM

Or is that something they have settled that we have to do ourselves with sharding? How would one even handle having multiple databases due to reaching size limits

JSON•6/19/23, 3:22 AM

I just saw that new information was updated in d1 price.
The price of reading is reasonable
It may not be completed yet, but I have a few questions.

Does the UPDATE query go into Write units?
Does "Workers Paid" mean First 50 million is free? Or are you saying that up to 50 million is charged $1 per million?

Unsmart•6/19/23, 3:25 AM

Updates are writes.

For workers paid plan the first 50 million write units are free. The first 25 billion read units are free. (But pricing isn’t final and subject to change)

UUnsmart Updates are writes. For workers paid plan the first 50 million write units are...

JSON•6/19/23, 3:28 AM

Thank you for your answer!
Then I think it's much cheaper than I expected!
I will change my postgres db to sqlite sometime this week to move quickly when d1 is released!

but why u would use json in the first time, just use columns is better 😄

Similar Threads

Similar Threads

Similar Threads