Database Naming Process · Issue #432 · c...
Interesting, well unless I am missing something the amazon docs don't actually give any information regarding naming constraints, opting to only tell you at creation. I just wanted to spin a local instance up using a random database I had handy that happened to be on a server using CloudPanel. They seem to be under the assumption underscores are not supported on RDS https://github.com/cloudpanel-io/cloudpanel-ce/issues/432
Regardless though, I do think having an option to set a custom database name that is not intrinsically tied to the instance name would be preferred.
GitHub
Database Naming Process · Issue #432 · cloudpanel-io/cloudpanel-ce
CloudPanel version(s) affected 2.4.1 Description this again not a bug but a better improvements when creating databases. It seems like we can't use _. for exampe, dev_domain or staging_domain. ...
7 Replies
I think you can make both the instance name and the database whatever you want when self hosting.
https://github.com/get-convex/convex-backend/blob/main/self-hosted/docker/docker-compose.yml#L12
and
https://github.com/get-convex/convex-backend/blob/main/self-hosted/docker/docker-compose.yml#L22
GitHub
convex-backend/self-hosted/docker/docker-compose.yml at main · get...
The open-source reactive database for app developers - get-convex/convex-backend
what makes it seem like you're limited?
there's a lot of customizability to the self hosting offering.
My understanding is that the database url for both postgres and mysql don't support adding a database name. Can you clarify how you are supposed to unlink the instance and database name?
the database url seems to only be database user/pass, host and port
For example, the current implementation seems to work like this:
Will try and connect to a database called
example_instance_nameah I am mistaken. They are linked in this way. From looking at
persistence_args_from_cluster_url in the codebaseGitHub
convex-backend/crates/clusters/src/lib.rs at c6918e5d971430b8fdd4cd...
The open-source reactive database for app developers - get-convex/convex-backend
Ah okay, well personally this feels both unintuitive and unnecessarily limiting. Having an additional env var for a preferred db name would be a great addition. 👍
yep seems sensible to have more control.
Feel free to fork and/or send a PR with the behavior you desire here.