hmm I wonder whether I could format it in the sql statement directly

DDahoom also is that a CMD theme or did you take a picture with your iphone 3G and crop ...

U

UpOP•10/22/23, 1:16 AM

that's a terminal theme xD

D

Dahoom•10/22/23, 1:16 AM

could you show it to me please

U

UpOP•10/22/23, 1:16 AM

UUp hmm I wonder whether I could format it in the sql statement directly

D

Dahoom•10/22/23, 1:17 AM

I say its not worth the effort to search. The answer is right there with half a line of JS code and makes things much simpler at least for me

U

UpOP•10/22/23, 1:17 AM

(one sec for the theme settings)

D

Dahoom•10/22/23, 1:17 AM

this is windows 11?

U

UpOP•10/22/23, 1:17 AM

win10

U

UpOP•10/22/23, 1:18 AM

but using the windows terminal app

U

UpOP•10/22/23, 1:19 AM

profile settings:

            {
                "colorScheme": "Retro Orange",
                "cursorColor": "#FF7300",
                "cursorShape": "vintage",
                "experimental.retroTerminalEffect": true,
                "font": 
                {
                    "face": "PxPlus IBM VGA8"
                },
                "guid": "{574e775e-4f2a-5b96-ac1e-a2962a402336}",
                "hidden": false,
                "name": "PowerShell",
                "opacity": 75,
                "padding": "5",
                "source": "Windows.Terminal.PowershellCore",
                "useAcrylic": true
            }

            {
                "colorScheme": "Retro Orange",
                "cursorColor": "#FF7300",
                "cursorShape": "vintage",
                "experimental.retroTerminalEffect": true,
                "font": 
                {
                    "face": "PxPlus IBM VGA8"
                },
                "guid": "{574e775e-4f2a-5b96-ac1e-a2962a402336}",
                "hidden": false,
                "name": "PowerShell",
                "opacity": 75,
                "padding": "5",
                "source": "Windows.Terminal.PowershellCore",
                "useAcrylic": true
            }

            {
                "colorScheme": "Retro Orange",
                "cursorColor": "#FF7300",
                "cursorShape": "vintage",
                "experimental.retroTerminalEffect": true,
                "font": 
                {
                    "face": "PxPlus IBM VGA8"
                },
                "guid": "{574e775e-4f2a-5b96-ac1e-a2962a402336}",
                "hidden": false,
                "name": "PowerShell",
                "opacity": 75,
                "padding": "5",
                "source": "Windows.Terminal.PowershellCore",
                "useAcrylic": true
            }

            {
                "colorScheme": "Retro Orange",
                "cursorColor": "#FF7300",
                "cursorShape": "vintage",
                "experimental.retroTerminalEffect": true,
                "font": 
                {
                    "face": "PxPlus IBM VGA8"
                },
                "guid": "{574e775e-4f2a-5b96-ac1e-a2962a402336}",
                "hidden": false,
                "name": "PowerShell",
                "opacity": 75,
                "padding": "5",
                "source": "Windows.Terminal.PowershellCore",
                "useAcrylic": true
            }

color scheme:

        {
            "background": "#3F2C1B",
            "black": "#FF7300",
            "blue": "#FF7300",
            "brightBlack": "#FF7300",
            "brightBlue": "#FF7300",
            "brightCyan": "#FF7300",
            "brightGreen": "#FF7300",
            "brightPurple": "#FF7300",
            "brightRed": "#FF7300",
            "brightWhite": "#FF7300",
            "brightYellow": "#FF7300",
            "cursorColor": "#FFFFFF",
            "cyan": "#FF7300",
            "foreground": "#FF7300",
            "green": "#FF7300",
            "name": "Retro Orange",
            "purple": "#FF7300",
            "red": "#FF7300",
            "selectionBackground": "#5a5a5a",
            "white": "#FF7300",
            "yellow": "#FF7300"
        }

        {
            "background": "#3F2C1B",
            "black": "#FF7300",
            "blue": "#FF7300",
            "brightBlack": "#FF7300",
            "brightBlue": "#FF7300",
            "brightCyan": "#FF7300",
            "brightGreen": "#FF7300",
            "brightPurple": "#FF7300",
            "brightRed": "#FF7300",
            "brightWhite": "#FF7300",
            "brightYellow": "#FF7300",
            "cursorColor": "#FFFFFF",
            "cyan": "#FF7300",
            "foreground": "#FF7300",
            "green": "#FF7300",
            "name": "Retro Orange",
            "purple": "#FF7300",
            "red": "#FF7300",
            "selectionBackground": "#5a5a5a",
            "white": "#FF7300",
            "yellow": "#FF7300"
        }

        {
            "background": "#3F2C1B",
            "black": "#FF7300",
            "blue": "#FF7300",
            "brightBlack": "#FF7300",
            "brightBlue": "#FF7300",
            "brightCyan": "#FF7300",
            "brightGreen": "#FF7300",
            "brightPurple": "#FF7300",
            "brightRed": "#FF7300",
            "brightWhite": "#FF7300",
            "brightYellow": "#FF7300",
            "cursorColor": "#FFFFFF",
            "cyan": "#FF7300",
            "foreground": "#FF7300",
            "green": "#FF7300",
            "name": "Retro Orange",
            "purple": "#FF7300",
            "red": "#FF7300",
            "selectionBackground": "#5a5a5a",
            "white": "#FF7300",
            "yellow": "#FF7300"
        }

        {
            "background": "#3F2C1B",
            "black": "#FF7300",
            "blue": "#FF7300",
            "brightBlack": "#FF7300",
            "brightBlue": "#FF7300",
            "brightCyan": "#FF7300",
            "brightGreen": "#FF7300",
            "brightPurple": "#FF7300",
            "brightRed": "#FF7300",
            "brightWhite": "#FF7300",
            "brightYellow": "#FF7300",
            "cursorColor": "#FFFFFF",
            "cyan": "#FF7300",
            "foreground": "#FF7300",
            "green": "#FF7300",
            "name": "Retro Orange",
            "purple": "#FF7300",
            "red": "#FF7300",
            "selectionBackground": "#5a5a5a",
            "white": "#FF7300",
            "yellow": "#FF7300"
        }

DDahoom I say its not worth the effort to search. The answer is right there with half a ...

U

UpOP•10/22/23, 1:20 AM

yeah I suppose.
means I gotta post process a bunch of endpoints tho..

U

UpOP•10/22/23, 1:22 AM

then again I'm doing that anyway because I have to parse some json

D

Dahoom•10/22/23, 1:22 AM

its the easiest way I can think of

D

Dahoom•10/22/23, 1:22 AM

but ask gippity

U

UpOP•10/22/23, 1:22 AM

nah this is fine

D

Dahoom•10/22/23, 1:22 AM

it might give you some golden garbage

U

UpOP•10/22/23, 1:23 AM

nice and simple

UUp nice and simple

D

Dahoom•10/22/23, 1:24 AM

nice

S

sdan•10/22/23, 3:59 AM

Can we add custom extensions to D1?

K

kian•10/22/23, 4:03 AM

Stuff like https://www.sqlite.org/loadext.html? No

K

kian•10/22/23, 4:04 AM

It would likely follow the proposal of transactions being JavaScript, in the form of a Worker - d1-database

Kkian Stuff like <https://www.sqlite.org/loadext.html>? No

S

sdan•10/22/23, 4:26 AM

understood -- we're looking to add/adapt a postgres extension for d1 for our enterprise case but seems like gcp cloudsql might be better suited for this

K

kian•10/22/23, 4:29 AM

D1's limits and enabled extensions (like FTS5 or mathematical functions) are set at build-time and the same for everyone, so I'd probably agree that it's best to stick with a traditional offering if you want that sort of flexibility or customisation.

Lots of the limits are based on recommendations for untrusted inputs from https://www.sqlite.org/security.html.

K

kian•10/22/23, 9:09 AM

[[env.staging.d1_databases]]

[[env.staging.d1_databases]]

K

kian•10/22/23, 10:09 AM

toml

Kkian `[[env.staging.d1_databases]]`

J

Jonathan•10/22/23, 3:32 PM

Is this normal to nest D1 under the env? I didn't see this in other projects

JJonathan Is this normal to nest D1 under the env? I didn't see this in other projects

I

Isaac McFadyen•10/22/23, 4:19 PM

That's because nesting it under env allows configuring different D1 databases per environment (where an environment is actually a separate worker suffixed with the environment name)

P

Ponmo•10/23/23, 12:38 AM

Hey is there a way to connect to D1 with Django now?

S

sandtrooper•10/23/23, 2:47 AM

is there a way to make

wrangler d1 migrations apply

wrangler d1 migrations apply

not request user input ( to write y ). eg,

--yes

--yes

flag is used on some other wrangler commands to auto accept but does not work for migrations command.

Ssandtrooper is there a way to make `wrangler d1 migrations apply` not request user input ( t...

C

Cyb3r-Jak3•10/23/23, 2:53 AM

It should skip user input if wrangle detects it’s a non-interactive environment or a CI environment. Try setting an environment variable of

CI-1

CI-1

CCyb3r-Jak3 It should skip user input if wrangle detects it’s a non-interactive environment ...

S

sandtrooper•10/23/23, 2:55 AM

thanks.

CI=1 npx wrangler d1 migrations apply

CI=1 npx wrangler d1 migrations apply

works.

O

Old Man Maker•10/23/23, 4:23 AM

anyone understand this error?

"message": [
        {
          "message": "D1_TYPE_ERROR: Type 'undefined' not supported for value 'undefined'",
          "cause": "Type 'undefined' not supported for value 'undefined'"
        }
      ],

"message": [
        {
          "message": "D1_TYPE_ERROR: Type 'undefined' not supported for value 'undefined'",
          "cause": "Type 'undefined' not supported for value 'undefined'"
        }
      ],

"message": [
        {
          "message": "D1_TYPE_ERROR: Type 'undefined' not supported for value 'undefined'",
          "cause": "Type 'undefined' not supported for value 'undefined'"
        }
      ],

"message": [
        {
          "message": "D1_TYPE_ERROR: Type 'undefined' not supported for value 'undefined'",
          "cause": "Type 'undefined' not supported for value 'undefined'"
        }
      ],

This is on an update - on logging the values being batched into the row, I dont see any values that are undefined.

The area where I am not sure is a field type of Blob, and I am trying to update it with an empty array - i.e.:

\"projectRef\":[],

\"projectRef\":[],

Does the blob type need to be a string or does it accept a pure array?

O

Old Man Maker•10/23/23, 5:01 AM

Actually, think I answered my own question... not sure what I was thinking

the error message is a challenge though

N

Nikolas•10/23/23, 12:06 PM

Hey, quick question. When I do a simple select in a table with 100 rows using some constraints (let's say some column is > than a number) which satisfy only 5 rows, why does it say

rows_read: 100

rows_read: 100

rows_read: 100

rows_read: 100 (aka I get 100 billed rows)? Is it intended or is it a bug? Thanks

NNikolas Hey, quick question. When I do a simple select in a table with 100 rows using so...

M

Matt Silverlock•10/23/23, 12:09 PM

Your query has to read the whole table to find those rows.

NNikolas Hey, quick question. When I do a simple select in a table with 100 rows using so...

M

Matt Silverlock•10/23/23, 12:09 PM

See https://developers.cloudflare.com/d1/learning/using-indexes/ for how you can optimize.

Use indexes · Cloudflare D1 docs

Indexes enable D1 to improve query performance over the indexed columns for common (popular) queries by reducing the amount of data (number of rows) …

M

Matt Silverlock•10/23/23, 12:10 PM

(Noting that at 25 billion rows read per month included, you can make that query 250 million times. Don’t worry about optimizing small queries too quickly)

N

Nikolas•10/23/23, 12:12 PM

Thanks I'll look into it. This was an example, the table has 15k rows and it reads only 50 each time..

NNikolas Thanks I'll look into it. This was an example, the table has 15k rows and it rea...

M

Matt Silverlock•10/23/23, 12:17 PM

Note that this is the same for any row-based relational database: you have to scan the table to find the rows that match the condition.

F

forslunds•10/23/23, 2:31 PM

Hmm, might save som rows when doing one db per user then

F

forslunds•10/23/23, 2:31 PM