Not free, but keep in mind $5/mo gets you 25 billion rows read: a lot.

MMatt Silverlock Not free, but keep in mind $5/mo gets you 25 billion rows read: a lot.

P

Paul•10/21/23, 3:17 PM

sweet, when can we expect read replicas to be enabled?

PPaul sweet, when can we expect read replicas to be enabled?

M

Matt SilverlockOP•10/21/23, 3:18 PM

By GA per https://blog.cloudflare.com/d1-open-beta-is-here/

The Cloudflare Blog

D1: open beta is here

D1 is now in open beta, and the theme is “scale”: with higher per-database storage limits and the ability to create more databases, we’re unlocking the ability for developers to build production-scale applications on D1

U

Up•10/22/23, 12:43 AM

so what exactly is the spec for

TIMESTAMP

TIMESTAMP

TIMESTAMP

TIMESTAMP columns?

I've got a column defined as

created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, and that produces values like

2023-10-16 15:56:51

2023-10-16 15:56:51

2023-10-16 15:56:51

2023-10-16 15:56:51, but what actual format is that so I can convert to ISO 8601-1:2019 properly?

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

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

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

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

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

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

seems like I could potentially do it on the JS side

U

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

U

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

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

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

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

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

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

win10

U

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

but using the windows terminal app

U

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

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

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

U

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

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

Up•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.

Not free, but keep in mind $5/mo gets you 25 billion rows read: a lot.

Similar Threads