Wizzel Posts - Answer Overflow

Wizzel

Explore posts from servers

CDCloudflare Developers DDeno KKysely HHono DTDrizzle Team

•Created by Wizzel on 3/10/2025 in #help

Any way to work with jsonb in a sqlite db?

I have a local sqlite db that I want to sync to supabase. The supabase column is of type jsonb. This is the local table definition:

export const userProfilesTable = sqliteTable('user_profiles', {
  id: text('id').primaryKey(),
  ...
  user_info: text('user_info', { mode: 'json' }).$type<UserInfo>(),
});

export const userProfilesTable = sqliteTable('user_profiles', {
  id: text('id').primaryKey(),
  ...
  user_info: text('user_info', { mode: 'json' }).$type<UserInfo>(),
});

when I run

        try {
          const res = await tx
            .update(userProfilesTable)
            .set({
              user_info: userInfoData, //object
            })
            .execute();

          console.log('res', res);
        } catch (error) {
          console.log('error', error);
        }

        try {
          const res = await tx
            .update(userProfilesTable)
            .set({
              user_info: userInfoData, //object
            })
            .execute();

          console.log('res', res);
        } catch (error) {
          console.log('error', error);
        }

the object gets stored as string and not as jsonb.

1 replies

HHono

•Created by Wizzel on 11/13/2024 in #help

How to implement proxy connections with hono?

I am trying to connect to a proxy network from my hono server but the standard fetch request doesn't allow any proxy arguments. What should I do instead?

1 replies

DDeno

•Created by Wizzel on 10/18/2024 in #help

How to make sveltekit work with deno2?

Sorry for the dumb question but I don't quite understand how to make sveltekit work on deno2 and what the consequences would be. For example do I still write my +page.server.ts files as usual or would they change? Is there an example project to learn from?

4 replies

CDCloudflare Developers

•Created by Wizzel on 3/11/2024 in #general-help

DNS_PROBE_FINISHED_NXDOMAIN

I just deployed a sveltekit project to test the workflow. When I visit the generated url I get DNS_PROBE_FINISHED_NXDOMAIN

2 replies

Gaming

Programming