Add with-edgedb example

[colinhacks]

Documentation / Examples

• Make sure the linting passes by running yarn lint

[colinhacks]

@ijjk Just addressed the reviews 👍

[steven-tey]

Hey I'm just reviewing this example – while everything works fine in localhost, I'm having issues deploying it to prod.

I'm going with the DigitalOcean example and I'm stuck on the One-Click Deploy step:

As a result, I'm not able to get the EDGEDB_DSN connection string – do I get it from the CLI? From Digital Ocean?

When I deploy it to Vercel, there's also an issue where I can't generate edgeql-js in prod since we added it to .gitignore

I tried adding predev and prebuild in package.json:

"scripts": {
    "predev": "npx edgeql-js",
    "dev": "next",
    "prebuild": "npx edgeql-js",
    "build": "next build",
    "start": "next start",
    "seed": "ts-node dbschema/seed.ts"
  },

But it still doesn't work.

[1st1]

One of the other errors Steve had with his app, not sure if this is related to this repo or not

Regarding the second screenshot -- it appears the problem was that the DB (and the schema) were empty. Maybe we add a script to check that condition and error out with a clearer build-time error suggesting that the DB is empty?

Checking if a db is empty or not is relatively easy:

        SELECT
            count(
                schema::Module
                FILTER NOT .builtin AND NOT .name = "default"
            ) + count(
                schema::Object
                FILTER .name LIKE "default::%"
            )

should return 0

[colinhacks]

@steven-tey I updated this with all the fixes we found yesterday, addressed the issues Yury mentioned, and added more detailed deployment instructions as well.

[leerob]

Thank you so much!

[1st1]

Thanks @leerob @steven-tey and @ijjk! 🎉