People can choose "paragon" skills: - Cloudflare Developers

R

RabidOP•11/11/23, 3:02 PM

many many possibilities

R

RabidOP•11/11/23, 3:02 PM

58 choices for skills to allocate

R

RabidOP•11/11/23, 3:02 PM

Plus gear choices etc

I

itsmatteomanf•11/11/23, 3:03 PM

I see...

RRabid People can choose "paragon" skills:

I

itsmatteomanf•11/11/23, 3:03 PM

Do you know how many one can select and how many are there?

RRabid 58 choices for skills to allocate

I

itsmatteomanf•11/11/23, 3:03 PM

Same here?

RRabid Plus gear choices etc

I

itsmatteomanf•11/11/23, 3:03 PM

And here?

Iitsmatteomanf Do you know how many one can select and how many are there?

I

itsmatteomanf•11/11/23, 3:04 PM

(Ignoring the fact some can only be chosen if the adjacent is, like total skill points given vs. total possible options)

R

RabidOP•11/11/23, 3:04 PM

225 max selections for the paragon boards, 6 boards, up to 441 tiles per board

R

RabidOP•11/11/23, 3:04 PM

Boards can be rotated

R

RabidOP•11/11/23, 3:04 PM

Positioned differently lol

R

RabidOP•11/11/23, 3:04 PM

they have slots where you can socket "glyphs" there are like 50 of those

I

itsmatteomanf•11/11/23, 3:04 PM

Oh, ok. It's gonna get too involed OMEGALUL

R

RabidOP•11/11/23, 3:05 PM

Most classes have about 12 gear choices, plus gems per gear slot haha

I

itsmatteomanf•11/11/23, 3:05 PM

If the tables were fixed positions, it might be done easily ahah

R

RabidOP•11/11/23, 3:22 PM

Yeah hah. Well I was mostly worried about collisions if I was generating a shortened version of it that was only like 10 characters long

R

RabidOP•11/11/23, 3:22 PM

But the full MD5 should be fine, going to make that change, thanks for the suggestion! Should help keep my table much smaller

Ɇ

Ɇ₦ĐɆⱤV₳₥₱łⱤɆ•11/12/23, 12:21 AM

Hey, I currently use D1 via the API. Where can I request a limit increase for my key? Starting to get 429s :P

W

wadefletch•11/12/23, 12:57 AM

Is there a slick way in D1 (generated columns, maybe?) to support updatedAt columns? Currently, I'm using the following.

CREATE TABLE IF NOT EXISTS project (
    id                      INTEGER     NOT NULL    PRIMARY KEY,
    name                    TEXT        NOT NULL,
    slug                    TEXT        NOT NULL    UNIQUE,
    ownerId                 TEXT        NOT NULL,
    createdAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP,
    updatedAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP);

CREATE TRIGGER IF NOT EXISTS project_updatedAt
    AFTER UPDATE ON project
    FOR EACH ROW
    BEGIN
        UPDATE project SET updatedAt = CURRENT_TIMESTAMP WHERE id = OLD.id;
    END;

CREATE TABLE IF NOT EXISTS project (
    id                      INTEGER     NOT NULL    PRIMARY KEY,
    name                    TEXT        NOT NULL,
    slug                    TEXT        NOT NULL    UNIQUE,
    ownerId                 TEXT        NOT NULL,
    createdAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP,
    updatedAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP);

CREATE TRIGGER IF NOT EXISTS project_updatedAt
    AFTER UPDATE ON project
    FOR EACH ROW
    BEGIN
        UPDATE project SET updatedAt = CURRENT_TIMESTAMP WHERE id = OLD.id;
    END;

CREATE TABLE IF NOT EXISTS project (
    id                      INTEGER     NOT NULL    PRIMARY KEY,
    name                    TEXT        NOT NULL,
    slug                    TEXT        NOT NULL    UNIQUE,
    ownerId                 TEXT        NOT NULL,
    createdAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP,
    updatedAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP);

CREATE TRIGGER IF NOT EXISTS project_updatedAt
    AFTER UPDATE ON project
    FOR EACH ROW
    BEGIN
        UPDATE project SET updatedAt = CURRENT_TIMESTAMP WHERE id = OLD.id;
    END;

CREATE TABLE IF NOT EXISTS project (
    id                      INTEGER     NOT NULL    PRIMARY KEY,
    name                    TEXT        NOT NULL,
    slug                    TEXT        NOT NULL    UNIQUE,
    ownerId                 TEXT        NOT NULL,
    createdAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP,
    updatedAt               TIMESTAMP   NOT NULL    DEFAULT CURRENT_TIMESTAMP);

CREATE TRIGGER IF NOT EXISTS project_updatedAt
    AFTER UPDATE ON project
    FOR EACH ROW
    BEGIN
        UPDATE project SET updatedAt = CURRENT_TIMESTAMP WHERE id = OLD.id;
    END;

ɆɆ₦ĐɆⱤV₳₥₱łⱤɆ Hey, I currently use D1 via the API. Where can I request a limit increase for my...

C

Cyb3r-Jak3•11/12/23, 2:14 AM

Only if you are enterprise. The recommended way would be to run an HTTP proxy worker so you don’t have a rate limit

C

Cyb3r-Jak3•11/12/23, 2:15 AM

Something like https://github.com/elithrar/http-api-d1-example

GitHub

GitHub - elithrar/http-api-d1-example: An example HTTP API for Clou...

An example HTTP API for Cloudflare's D1 database: https://developers.cloudflare.com/d1/

GitHub - elithrar/http-api-d1-example: An example HTTP API for Cloudflare's D1 database: ht...

Wwadefletch Is there a slick way in D1 (generated columns, maybe?) to support updatedAt colu...

I

Isaac McFadyen•11/12/23, 2:35 AM

Generated columns are done at SELECT time not INSERT time, so there's not really a way aside from what you've done, no.

I

Isaac McFadyen•11/12/23, 2:36 AM

D1 is just SQLite so most things that work with SQLite will work with D1, FYI.

IIsaac McFadyen Generated columns are done at SELECT time not INSERT time, so there's not really...

M

Matt Silverlock•11/12/23, 12:55 PM

There are two types of generated column: https://developers.cloudflare.com/d1/learning/generated-columns/#types-of-generated-columns

Generated columns · Cloudflare D1 docs

D1 allows you to define generated columns based on the values of one or more other columns, SQL functions, or even extracted JSON values.

MMatt Silverlock There are two types of generated column: https://developers.cloudflare.com/d1/le...

I

Isaac McFadyen•11/12/23, 1:12 PM

Oh - interesting! TIL, thank you.

J

jiangok•11/12/23, 1:57 PM

How do I use d1 with a different env? could anyone help a remix related question? thanks.

Jjiangok https://discord.com/channels/595317990191398933/1172999291451736164/117310614809...

M

Matt Silverlock•11/12/23, 2:54 PM

You’re better off responding/creating a new thread, but I’ve linked https://developers.cloudflare.com/d1/examples/d1-and-remix/ for you

Query D1 from Remix · Cloudflare D1 docs

Remix is a full-stack web framework that operates on both client and server. You can query your D1 database(s) easily from Remix with Remix’s data …

FFerry While we are wainting for transactions is it possible to nest statement methods ...

G

GuillaumeLakano•11/12/23, 4:36 PM

db.prepare is not interactive, it's similar to a parser that format correctly your SQL statement.
Fetch your statements from your table, and push them inside an array to db.batch.

Something like:

const { results: myviewStatements } = await db.prepare('select statetement from myview where tb=?1").bind(t1).all()
await db.batch([ db.prepare("create table.."), ...myviewStatements.map(s => db.prepare(s.statement)) ]

G

GuillaumeLakano•11/12/23, 4:57 PM

I have a request, and it's may be a bug in the pricing calculation.

The goal of « partial indexes » ( https://www.sqlite.org/partialindex.html ) is to attach a WHERE condition to reduce the required writes / storage. So the additional write for the index is not always done.

I've done a test, and this is always counted as an extra written row, even when the WHERE condition is not true.
It's a bug ?

FFerry But how if one of the statements fails?How to rollback?

G

GuillaumeLakano•11/12/23, 5:11 PM

the rollback is automatic in the batch, so if one of your statement fail, all the batch is rolled back

J

jiangok•11/13/23, 4:14 AM

hi, I am using CF pages + d1 + remix + drizzle orm + vitest. is there any example for adding a unit test for remix loader loading d1 data from a local sqlite? Thanks.

R

rostero•11/13/23, 5:38 PM

Hey. I'm also here from d1 + remix (but updated to the latest libs). I'm getting this when clicking on some of the avengers:

Failed to get worker definitions TypeError: fetch failed

Failed to get worker definitions TypeError: fetch failed

Failed to get worker definitions TypeError: fetch failed

Failed to get worker definitions TypeError: fetch failed and underneath it:

UND_ERR_HEADERS_TIMEOUT.

UND_ERR_HEADERS_TIMEOUT.

UND_ERR_HEADERS_TIMEOUT.

UND_ERR_HEADERS_TIMEOUT.

R

rostero•11/13/23, 5:45 PM

this is all local w/ wrangler

R

rostero•11/13/23, 5:52 PM

also, are there any docs on the read/write behaviors of D1, similar to https://docs.turso.tech/reference/data-consistency?

S

SmallShen•11/14/23, 9:07 AM

does delete rows count how many rows read?

SSmallShen does delete rows count how many rows read?

G

GuillaumeLakano•11/14/23, 9:44 AM

You can check the rows_read / rows_written in your response, but I guess this will be the same number of reads from the same WHERE condition on a SELECT + the 1x write of delete per row deleted

M

meow•11/14/23, 10:06 AM

Is it dangerous to commit the database name and id in

wrangler.toml

wrangler.toml

? Should that be a secret?

Mmeow Is it dangerous to commit the database name and id in `wrangler.toml`? Should th...

H

Hello, I’m Allie!•11/14/23, 10:07 AM

No, they are not a secret

Rrostero Hey. I'm also here from d1 + remix (but updated to the latest libs). I'm getti...

M

Max (@rozenmd)•11/14/23, 10:48 AM

errrr that wouldn't happen to be https://github.com/rozenmd/d1-drizzle-remix-example would it?

M

Max (@rozenmd)•11/14/23, 10:49 AM

I've just updated this

to work on Remix v2

MMax (@rozenmd)errrr that wouldn't happen to be https://github.com/rozenmd/d1-drizzle-remix-exa...

R

rostero•11/14/23, 12:56 PM

Yep! Thanks for updating. This was very helpful. Also, I think

{ mode: "timestamp" } is broken

{ mode: "timestamp" } is broken

{ mode: "timestamp" } is broken

{ mode: "timestamp" } is broken could be

{ mode: "timestamp_ms" }

{ mode: "timestamp_ms" }

{ mode: "timestamp_ms" }

{ mode: "timestamp_ms" }, but I'm new to drizzle.

Rrostero Yep! Thanks for updating. This was very helpful. Also, I think `{ mode: "time...

M

Max (@rozenmd)•11/14/23, 12:59 PM

looks like they've removed

mode: "timestamp"

mode: "timestamp"

mode: "timestamp"

mode: "timestamp" entirely from drizzle

M

Max (@rozenmd)•11/14/23, 12:59 PM

used to be in their docs

R

rostero•11/14/23, 12:59 PM

ahh. ok.

R

rostero•11/14/23, 1:04 PM

Another D1 question. Can a JS stored procedure use drizzle/prisma?