Database download doesn't work

[simonw]

I'm trying to download your SQLite database from https://my-database.now.sh/commissioniComunePalermo.db but my request is hanging. Eventually I get this error:

An error occurred with this application.

NO_STATUS_CODE_FROM_FUNCTION

That's another datasette-publish-now bug. I'm going to move this issue to that repo.

Originally posted by @simonw in https://github.com/simonw/datasette-publish-now/issues/22#issuecomment-620207580

[simonw]

Since there's a hard upper limit on the response from a Vercel function it may be that this can't be supported.

Or... maybe I need to publish the actual database file as a static resource somehow?

If I can't get it to work then deploys should go live with allow_download set to False.

[falkben]

I'm just wondering if there's an update of the status on this issue.

I am having a similar issue with a datasette deployment to vercel, with a relatively small database (~40 MB).

https://steam-to-sqlite.vercel.app/database.db

If seems like the lambda function ideally wouldn't be involved in serving the database file at all but perhaps there's no way around that?

I'm not really too familiar with Vercel's offerings, but wondering: would including the database file in a static directory with the static option yield a URL to the database that doesn't involve the lambda function or is the lambda function involved in serving static assets regardless?