`DatabaseName must begin with a letter and contain only alphanumeric characters.` error in Function + Posgres + Drizzle ORM setup about ion

[frixaco]

Maybe it's a linking issue? Running pnpm db:gen gives following error:

❯ pnpm db:gen --verbose

> test-sst-ion@ db:gen /Users/frixaco/personal/test-sst-ion
> AWS_PROFILE=default sst shell drizzle-kit generate:pg "--verbose"

time=2024-03-24T19:41:43.422+05:00 level=INFO msg="checking for bun" path="/Users/frixaco/Library/Application Support/sst/bin/bun"
time=2024-03-24T19:41:43.422+05:00 level=INFO msg="initializing project" version=0.0.197
time=2024-03-24T19:41:43.423+05:00 level=INFO msg="esbuild building"
time=2024-03-24T19:41:43.425+05:00 level=INFO msg="esbuild built" outfile=/Users/frixaco/personal/test-sst-ion/.sst/eval/eval-1711291303423.mjs
time=2024-03-24T19:41:43.425+05:00 level=INFO msg="evaluating config"
time=2024-03-24T19:41:43.451+05:00 level=INFO msg="config evaluated"
time=2024-03-24T19:41:43.451+05:00 level=INFO msg="checking platform"
time=2024-03-24T19:41:43.452+05:00 level=INFO msg="credentials found"
time=2024-03-24T19:41:43.452+05:00 level=INFO msg="fetching bootstrap"
time=2024-03-24T19:41:45.026+05:00 level=INFO msg="found existing bootstrap" data="{\"version\":1,\"asset\":\"sst-asset-runmwdcehbtz\",\"state\":\"sst-state-runmwdcehbtz\"}"
time=2024-03-24T19:41:45.027+05:00 level=INFO msg="loaded config" app=test-sst-ion stage=frixaco
time=2024-03-24T19:41:45.027+05:00 level=INFO msg="INFO getting data key=link app=test-sst-ion stage=frixaco"
drizzle-kit: v0.20.14
drizzle-orm: v0.30.4

No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/frixaco/personal/test-sst-ion/drizzle.config.ts'
Error: "TestSSTDatabase" is not linked
    at Object.get (/Users/frixaco/personal/test-sst-ion/node_modules/.pnpm/[email protected]/node_modules/sst/dist/resource.js:15:15)
    at Object.<anonymous> (/Users/frixaco/personal/test-sst-ion/database.ts:19:22)
    at Module._compile (node:internal/modules/cjs/loader:1376:14)
    at Module._compile (/Users/frixaco/personal/test-sst-ion/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:8644:30)
    at Module._extensions..js (node:internal/modules/cjs/loader:1435:10)
    at Object.newLoader [as .ts] (/Users/frixaco/personal/test-sst-ion/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:8648:13)
    at Module.load (node:internal/modules/cjs/loader:1207:32)
    at Module._load (node:internal/modules/cjs/loader:1023:12)
    at Module.require (node:internal/modules/cjs/loader:1235:19)
    at require (node:internal/modules/helpers:176:18)

[fwang]

@frixaco what's the name of the app defined in sst.config.ts?

[frixaco]

@fwang Thanks for a response. I'm not sure I understand what do you mean by "app". If you are asking about whether it's a Next.js/Remix app, then no. It's just a Function linked to a database (wanted to make bundling migration files with lambda handler work in a Function).

Let me know if you need more details.

[thdxr]

we mean what's at the top of your sst.config.ts, the part you cut out

when you don't specify a default database name to the postgres component we use the app name as the database name, seems like yours is not valid

[frixaco]

@thdxr Thanks for clarifying.
It is test-sst-ion 🤦‍♂️ , it is using the name of root project directory. Sorry, that's my bad for being a bit careless, didn't realize that.
Maybe Ion can auto "fix" the app name when running sst init? (I'm down to implement it, though I haven't looked at the source code yet)

[thdxr]

oh can database names not have hyphens? @fwang should we strip them?

[jayair]

Gonna assign to Frank

[fwang]

Fixed in 0.0.226

Hyphens will be replaced by underscores, which are allowed for Postgres database names.