I noticed that in a SQLite based Durable Object, any `INSERT` operation against the storage returns

I noticed that in a SQLite based Durable Object, any

INSERT

INSERT

INSERT

INSERT operation against the storage returns 2

rowsWritten

rowsWritten

rowsWritten

rowsWritten , although I only inserted one row, is this normal behavior or am I missing something?
It's also unlikely that I exceeded any 4k limit for write units, although I'm not sure if it applies to SQLite based DOs, and I don't have any index on the table I'm writing to.

Mmihaaai I noticed that in a SQLite based Durable Object, any `INSERT` operation against ...

James•1/14/25, 4:59 PM

could be the default index for rowid, or a trigger for updated ts updates

JJames could be the default index for rowid, or a trigger for updated ts updates

mihaaaiOP•1/14/25, 5:02 PM

Interesting, is there any way to disable that index on rowidrowid?
I'm trying to optimize pricing since my use case is a write heavy one.

James•1/14/25, 5:03 PM

https://www.sqlite.org/withoutrowid.html

James•1/14/25, 5:04 PM

i wonder if the write is related to updating the meta table for bumping sequences related to rowid, and perhaps rowid doesnt cost in itsself

JJames https://www.sqlite.org/withoutrowid.html

Isaac McFadyen•1/14/25, 5:05 PM

That docs page also says that even without a Row ID you still need a primary key with a unique index.

JJames https://www.sqlite.org/withoutrowid.html

mihaaaiOP•1/14/25, 5:06 PM

It seems to solve the problem, now I get the correct count for the written rows.

James•1/14/25, 5:07 PM

still could be sequence related, since every new row writes to the sqlite_sequence meta table, and if that counts, that kind of sucks

mihaaaiOP•1/14/25, 5:09 PM

Indeed, I noticed that using WITHOUT ROWIDWITHOUT ROWID the sequence of written data is not ordered as before

James•1/14/25, 5:10 PM

temps me to switch all my PKs to random guids instead of rowid

Original message was deleted

Larry•1/14/25, 11:12 PM

UUIDv7 is the standardized version of ULID so I recommend looking for that over an ULID library

dandoen•1/15/25, 1:56 PM

hi folks,

i'm leveraging DO for a websocket w/ hubernation support, but keen to understand how i can pass on context to my "webSocketMessage". i want to simply pass on the user id of the user into the webSocketMessage handler. when it gets hibernated, it seems to get lost. i'll drop my fairly basic code in a thread.

KWAC•1/15/25, 4:10 PM

Is there a guide on how I could setup durable objects with nuxt?

KKWAC Is there a guide on how I could setup durable objects with nuxt?

Blind Goose•1/15/25, 4:25 PM

What are you trying to do? My understanding is nuxt is frontend. Durable objects would be handled by your API Server.

KWAC•1/15/25, 4:26 PM

I'm trying to send notification to frontend from backend when stripe payment is successful. I want to use websocket for that

Blind Goose•1/15/25, 4:28 PM

Right but you'd use an API for that. The actual frontend doesn't have direct access to your data store for securiy reasons.

KWAC•1/15/25, 4:28 PM

that's not what im saying

KWAC•1/15/25, 4:28 PM

anyway i edited message to make it more clear

Blind Goose•1/15/25, 4:30 PM

WebSocket server: https://developers.cloudflare.com/workers/examples/websockets/

You'd just access durable objects normally through the JavaScript API for workers that way.

Cloudflare Docs

Using the WebSockets API · Cloudflare Workers docs

Use the WebSockets API to communicate in real time with your Cloudflare Workers.

KWAC•1/15/25, 4:31 PM

i need working examples for nuxt

KWAC•1/15/25, 4:31 PM

i already read the docs

Blind Goose•1/15/25, 4:31 PM

What nuxt specific detail do you need?

KWAC•1/15/25, 4:35 PM

how do I set it up in the api

Blind Goose•1/15/25, 4:38 PM

Youwrite your API and either deploy or run locally locally, and write frontend code that consumes the API. I haven't used nuxt specifically but I found https://krutiepatel.com/blog/30-real-time-with-nuxt-3-a-guide-to-websocket-integration which is pretyy much how to open, close, an receive messages from your websockets server

krutiepatel.com

Real-Time with Nuxt 3: A Guide to WebSocket Integration

Learn how to bring real-time functionality to Nuxt 3 by building a foundation for a two-player board game, illustrating WebSocket setup, message handling, and in-game player interaction.

KWAC•1/15/25, 4:39 PM

i need to use durable objects

KKWAC i need to use durable objects

Blind Goose•1/15/25, 4:40 PM

Then use them in your API, what exactly are you asking for help with?

KWAC•1/15/25, 4:41 PM

I just want to see example god damn

Blind Goose•1/15/25, 4:41 PM

An example, of what, I showed you an example of how to do websockets in Nuxts

Blind Goose•1/15/25, 4:41 PM

And how to use the web sockets for workers api

KKWAC how do I set it up in the api

KWAC•1/15/25, 4:41 PM

KWAC•1/15/25, 4:43 PM

I found this but im not sure if it's good example

https://github.com/nicgene/nuxt-durable-object

GitHub

GitHub - nicgene/nuxt-durable-object

Contribute to nicgene/nuxt-durable-object development by creating an account on GitHub.

Blind Goose•1/15/25, 4:44 PM

I would start there.

KWAC•1/15/25, 4:59 PM

thank you sir for your help, i really appreciate it

Chris Jayden•1/15/25, 5:23 PM

Some methods on my stub are being returned as nevernever. Anyone had this before?

Gagan Suie•1/15/25, 6:44 PM

hi, is there a way to do text search in DO storage?

GGagan Suie hi, is there a way to do text search in DO storage?

Hard@Work•1/15/25, 6:48 PM

Via FTS5: https://developers.cloudflare.com/d1/sql-api/sql-statements/#supported-sqlite-extensions

Cloudflare Docs

SQL statements · Cloudflare D1 docs

D1 is compatible with most SQLite's SQL convention since it leverages SQLite's query engine. D1 supports a number of database-level statements that allow you to list tables, indexes, and inspect the schema for a given table or index.

Hard@Work•1/15/25, 6:48 PM

That's the D1 docs, but it should

work with DOSQLite too

HHard@Work That's the D1 docs, but it should™️ work with DOSQLite too

Gagan Suie•1/15/25, 6:49 PM

even in the do chat sample? https://github.com/cloudflare/workers-chat-demo

GitHub

GitHub - cloudflare/workers-chat-demo

Contribute to cloudflare/workers-chat-demo development by creating an account on GitHub.

Gagan Suie•1/15/25, 6:50 PM

i dont think its using DOSQLite

GGagan Suie even in the do chat sample? https://github.com/cloudflare/workers-chat-demo

Hard@Work•1/15/25, 6:51 PM

No, you would probably have to migrate it to SQLite

jd•1/15/25, 7:54 PM

Hi! Question: I'm looking for a place to store 2-10T of our model training image / video data that doesn't incur crazy monthly or egress fees, flexible with multiple cloudproviders.

Most importantly, great with large file download performance like .tar file / webdataset or large # of small files if needed.

How cloudflare storage performs in terms of benchmark?

Datapoint: Our model weights live on huggingface and with their cli + hf_transfer we can get 1.2G/s download speed on EC2.

Thanks!

Jjd Hi! Question: I'm looking for a place to store 2-10T of our model training image...

lambrospetrou•1/15/25, 8:18 PM

Check Cloudflare R2, which is S3-compatible object storage and has zero egress fees.

jd•1/15/25, 10:19 PM

Yep i was just curious about R2's performance on large file IO. Let me run some benchmarks on my own then

jd•1/15/25, 10:24 PM

:insane: sorry i didn't see there's a r2 channel and thought this one was

1984 Ford Laser•1/16/25, 2:23 AM

Anyone else having issues with websockets not hibernating? Some code that was working fine a few weeks ago is now no longer hibernating the connections

1984 Ford Laser•1/16/25, 2:28 AM

Hmm seems to be localized to a specific namespace, tried a different DO and that one is fine

1984 Ford Laser•1/16/25, 3:36 AM

Okay this is a dumb one, I think I fixed it. On top of the normal

message

message

and closeclose WS handlers, I also had a

error

error

one set up, which was supposed to remove the current connection from the list of connections, but wasn't necessarily closing the connection, such as if the client experienced an error, but not one that caused the socket to close. Somewhere, this was causing the socket to stay open or something. You can see a comparison in the screenshots

HHard@Work That's the D1 docs, but it should™️ work with DOSQLite too

Gagan Suie•1/16/25, 7:53 AM

does DOSQLite create a new table for every DO session? or do all connections share the same DB table?

GGagan Suie does DOSQLite create a new table for every DO session? or do all connections sha...

1984 Ford Laser•1/16/25, 8:52 AM

Tables per instance

KWAC•1/16/25, 12:49 PM

Property 'idFromName' does not exist on type 'DurableObject'.
Property 'get' does not exist on type 'DurableObject'.

Property 'idFromName' does not exist on type 'DurableObject'.
Property 'get' does not exist on type 'DurableObject'.

export default defineEventHandler(async (event) => {
    try {
        const env = event.context.cloudflare?.env.DUMMY_OBJECT;
        const id = env.idFromName('counter');
        const stub = env.get(id);
        const response = await stub.fetch(event.context.cloudflare.request);
        const data = await response.json() as { value: number };
        return data;
    }
    catch (error) {
        console.error(error);
        return { error: 'Failed to fetch from Durable Object' };
    }
});

export default defineEventHandler(async (event) => {
    try {
        const env = event.context.cloudflare?.env.DUMMY_OBJECT;
        const id = env.idFromName('counter');
        const stub = env.get(id);
        const response = await stub.fetch(event.context.cloudflare.request);
        const data = await response.json() as { value: number };
        return data;
    }
    catch (error) {
        console.error(error);
        return { error: 'Failed to fetch from Durable Object' };
    }
});

I noticed that in a SQLite based Durable Object, any `INSERT` operation against the storage returns

Similar Threads

Similar Threads

Similar Threads