Is there any example with Vercel Edge Runtime? about drizzle-orm HOT 9 CLOSED

@ysm-dev we have released support for proxy requests in 0.17.4.
Here is small code snippet for SQLite Proxy Driver

const db = drizzle(async (sql, params, method) => {
  try {
    const rows = await axios.post('http://localhost:3000/query', {
      sql,
      params,
      method,
    });

    return { rows: rows.data };
  } catch (e: any) {
    console.error('Error from sqlite proxy server: ', e.response.data);
    return { rows: [] };
  }
});

You can read release notes and also here is a link for full usage example

Using this example you can make any driver on server side to execute raw queries

Fell free to ping me, if something won't work for you

from drizzle-orm.

@ysm-dev hey!
can you please share a raw example of what you're trying to achieve?
we have examples with FlyIO LiteFS, yet they have a fs layer
I'm not sure how that works in Vercel

ps: we've discussed mocked db to use as query builder, we'll implement soon

from drizzle-orm.

@ysm-dev we'll provide you an interface for that one of these days

from drizzle-orm.

@AlexBlokh thank you for quick reply!
I'm trying to build SQL Query inside Vercel Edge Runtime and
send that SQL Statement to Cloudflare Workers (D1) over http.

1 more question:

I'm using SQLite + Cloudflare D1,
and when I insert with undefined or null values, it saved as string it self:

is it bug? or feature?

Thank you for great library!

from drizzle-orm.

@ysm-dev so you're sending http request to Cloudflare worker, propagate it to D1 and send D1 response back?

if you can provide us an example project or a code snippet for that - would be very helpful

from drizzle-orm.

@ysm-dev btw if you're using Cloudflare, why would you need Vercel?

from drizzle-orm.

@ysm-dev so you're sending http request to Cloudflare worker, propagate it to D1 and send D1 response back?

if you can provide us an example project or a code snippet for that - would be very helpful

Yea I want to build SQL statements (with drizzle) outside of Cloudflare workers and send the Query object over HTTP,

// ex) Query object
{
  sql: 'select * from user',
  params: []
}

and run this Query in Cloudflare Workers with DrizzleORM + D1, and return it.

So Cloudflare Workers is like just SQL Runner.

And wants to use all type-safety outside of Worker.

How can I achieve this?

from drizzle-orm.

@AlexBlokh Thank you!

from drizzle-orm.

@AndriiSherman Thank you for the quick feedback and update!
I tried a Proxy driver with CF D1 Database, but there is no prepare type in D1 drizzle instance.

from drizzle-orm.