so what exactly is the spec for `TIMESTAMP` columns? I've got a column defined as `created_at TIMES

UUp so what exactly is the spec for `TIMESTAMP` columns? I've got a column defined ...

D

Dahoom•10/22/23, 12:53 AM

date() time() YYYY-MM-DD HH-MM-SS

D

Dahoom•10/22/23, 12:55 AM

Interestingly I just researched this very thing 30 mins ago for my own project. D1 is basically just SQLite so you can see the info in the sqlite documentation https://www.sqlite.org/lang_datefunc.html

DDahoom Interestingly I just researched this very thing 30 mins ago for my own project. ...

U

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

heh.

except the sqlite documentation sucks and says it is iso8601, when it in fact isn't

UUp heh. except the sqlite documentation sucks and says it is iso8601, when it in f...

D

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

Might be because sqlite.org is refrencing the 8601 Steptember 1997 standarization format while what you need is 2019

D

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

If you dont mind me asking, why do you need that specific standardization?

DDahoom Might be because sqlite.org is refrencing the 8601 Steptember 1997 standarizatio...

U

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

nope its just noncompliant. iso8601 specifically does not allow space as separator, what sqlite actually uses is RFC3339

DDahoom If you dont mind me asking, why do you need that specific standardization?

U

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

because the client consuming the api is C#, and the datetime deserializer wants iso8601-1:2019

UUp because the client consuming the api is C#, and the datetime deserializer wants ...

D

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

This does mean that there is an intermediary cloudflare worker used to route the request. Maybe try to standardize it there?
Ask gippity what it knows about ISO 8601 standardization in sqlite, it might give you garbage but garbage is treasure to the right person

U

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

This does mean that there is an intermediary cloudflare worker used to route the request. Maybe try to standardize it there?

yeah that is pmuch what I'm trying to do right now

U

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

seems like I could potentially do it on the JS side

U

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

U

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

just gotta tell it that that's zulu time

D

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

yeah i'd much rather do it while its being routed in JS to reduce redundancy.

D

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

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

U

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

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]]

[[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

wrangler d1 migrations apply

wrangler d1 migrations apply not request user input ( to write y ). eg,

--yes

--yes

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

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

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\":[],

\"projectRef\":[],

\"projectRef\":[],

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

so what exactly is the spec for `TIMESTAMP` columns? I've got a column defined as `created_at TIMES

Similar Threads