Cloudflare DevelopersCD
Cloudflare Developers•3y ago
Greg

Also unrelated, I'm created a table with this query: ```sql CREATE TABLE Casts ( id int8 NOT NU

Also unrelated, I'm created a table with this query:

CREATE TABLE Casts (
    id int8 NOT NULL PRIMARY KEY,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    deleted_at timestamp,
    timestamp timestamp NOT NULL,
    fid int8 NOT NULL,
    hash bytea NOT NULL,
    parent_hash bytea,
    parent_fid int8,
    parent_url text,
    text text NOT NULL,
    embeds text NOT NULL DEFAULT '{}',
    mentions int8 NOT NULL DEFAULT '{}',
    mentions_positions int2 NOT NULL DEFAULT '{}'
);


I know it has some less common data types but the table seems to create just fine and I can add data from the Cloudflare dashboard.

Only problem is when I try to read it from a worker, I always gets D1_ERROR: SqliteError: no such table: Casts
Was this page helpful?