github-starred/better-auth
2
0
Fork 0
mirror of https://github.com/better-auth/better-auth.git synced 2026-08-23 17:58:47 -05:00
Code Issues 2.5k Packages Projects Releases 112 Wiki Activity

[GH-ISSUE #6605] Amazon DSQL support #10567

New Issue
Closed
opened 2026-04-13 06:47:42 -05:00 by GiteaMirror · 5 comments
GiteaMirror commented 2026-04-13 06:47:42 -05:00
Owner
Copy Link
Copy Source

Originally created by @wbrijesh on GitHub (Dec 8, 2025).
Original GitHub issue: https://github.com/better-auth/better-auth/issues/6605

Is this suited for github?

  • Yes, this is suited for github

Is your feature request related to a problem? Please describe.

Amazon DSQL is a postgres compatible database, it seems like a good fit for auth where data is relational only issue will be lack of support for foreign keys but joins should still work

Describe the solution you'd like

support for DSQL

Describe alternatives you've considered

libsql

Additional context

No response

Originally created by @wbrijesh on GitHub (Dec 8, 2025). Original GitHub issue: https://github.com/better-auth/better-auth/issues/6605 ### Is this suited for github? - [x] Yes, this is suited for github ### Is your feature request related to a problem? Please describe. Amazon DSQL is a postgres compatible database, it seems like a good fit for auth where data is relational only issue will be lack of support for foreign keys but joins should still work ### Describe the solution you'd like support for DSQL ### Describe alternatives you've considered libsql ### Additional context _No response_
GiteaMirror added the lockeddatabase labels 2026-04-13 06:47:42 -05:00
GiteaMirror commented 2026-04-13 06:47:44 -05:00
Author
Owner
Copy Link
Copy Source

@better-auth-agent[bot] commented on GitHub (Dec 8, 2025):

Thanks for opening an issue regarding support for Amazon DSQL. Better Auth currently targets databases that fully support the required relational features, so while DSQL’s PostgreSQL compatibility is promising, its lack of foreign key support may require some adaptations. Next steps would be to further test Better Auth with DSQL in your environment—particularly verifying that joins and transactional behavior meet your needs—and share any specific challenges you encounter. Your feedback would be very helpful in determining if we can offer either official support or documentation on configuring Better Auth for DSQL.

Tag @better-auth-agent if you would like an answer from the Agent. Could you share a bit more about any issues you've run into during your testing?

If you need more help, tag @better-auth-agent in a comment so I can respond.

Diagram • Discord • GitHub

Diagram Join Star

<!-- gh-comment-id:3625419640 --> @better-auth-agent[bot] commented on GitHub (Dec 8, 2025): Thanks for opening an issue regarding support for Amazon DSQL. Better Auth currently targets databases that fully support the required relational features, so while DSQL’s PostgreSQL compatibility is promising, its lack of foreign key support may require some adaptations. Next steps would be to further test Better Auth with DSQL in your environment—particularly verifying that joins and transactional behavior meet your needs—and share any specific challenges you encounter. Your feedback would be very helpful in determining if we can offer either official support or documentation on configuring Better Auth for DSQL. Tag @better-auth-agent if you would like an answer from the Agent. Could you share a bit more about any issues you've run into during your testing? _If you need more help, tag @better-auth-agent in a comment so I can respond._ <!-- bot:webhook reply v1 --> [Diagram](https://repodiagrams.s3.eu-north-1.amazonaws.com/skyvern_ultra_detailed_interactive.html) • [Discord](https://discord.gg/fG2XXEuQX3) • [GitHub](https://github.com/Skyvern-AI/Skyvern) [![Diagram](https://img.shields.io/badge/Diagram-2b3137?style=flat-square)](https://repodiagrams.s3.eu-north-1.amazonaws.com/skyvern_ultra_detailed_interactive.html) [![Join](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&style=flat-square)](https://discord.gg/fG2XXEuQX3) [![Star](https://img.shields.io/badge/star-181717?logo=github&logoColor=white&style=flat-square)](https://github.com/Skyvern-AI/Skyvern)
GiteaMirror commented 2026-04-13 06:47:45 -05:00
Author
Owner
Copy Link
Copy Source

@adsc commented on GitHub (Dec 22, 2025):

@better-auth-agent Like other serverless relational databases, Amazon DSQL does not support foreign key CONSTRAINTS. You can absolutely treat fields as foreign keys and make JOINS with them. Does better-auth really need foreign key constraints, and if so, why?

What other "relational features" does Amazon DSQL not support that better-auth needs?

<!-- gh-comment-id:3684282508 --> @adsc commented on GitHub (Dec 22, 2025): @better-auth-agent Like other serverless relational databases, Amazon DSQL does not support foreign key CONSTRAINTS. You can absolutely treat fields as foreign keys and make JOINS with them. Does better-auth really need foreign key constraints, and if so, why? What other "relational features" does Amazon DSQL not support that better-auth needs?
GiteaMirror commented 2026-04-13 06:47:45 -05:00
Author
Owner
Copy Link
Copy Source

@better-auth-agent[bot] commented on GitHub (Dec 22, 2025):

It's great to hear you're exploring Amazon DSQL for Better Auth! While DSQL being a Postgres-compatible database means it supports basic relational features, its lack of support for foreign key constraints is something to consider.

For your question, Better Auth can function without foreign key constraints, as it allows you to treat fields as foreign keys and perform joins with them. Joins are supported out of the box with Better Auth as well, which can enhance performance when fetching related data across multiple tables, depending on your use case.

If you need foreign key constraints specifically for your application logic, it might be useful to share why they are necessary in your context. Are there specific relational features or functionalities that you feel are lacking with Amazon DSQL?

Feel free to discuss this further, and if you have more questions or need additional assistance, don’t hesitate to ask!

Diagram • Discord • GitHub

Diagram Join Star

<!-- gh-comment-id:3684282926 --> @better-auth-agent[bot] commented on GitHub (Dec 22, 2025): It's great to hear you're exploring Amazon DSQL for Better Auth! While DSQL being a Postgres-compatible database means it supports basic relational features, its lack of support for foreign key constraints is something to consider. For your question, Better Auth can function without foreign key constraints, as it allows you to treat fields as foreign keys and perform joins with them. Joins are supported out of the box with Better Auth as well, which can enhance performance when fetching related data across multiple tables, depending on your use case. If you need foreign key constraints specifically for your application logic, it might be useful to share why they are necessary in your context. Are there specific relational features or functionalities that you feel are lacking with Amazon DSQL? Feel free to discuss this further, and if you have more questions or need additional assistance, don’t hesitate to ask! <!-- bot:webhook reply v1 --> [Diagram](https://repodiagrams.s3.eu-north-1.amazonaws.com/skyvern_ultra_detailed_interactive.html) • [Discord](https://discord.gg/fG2XXEuQX3) • [GitHub](https://github.com/Skyvern-AI/Skyvern) [![Diagram](https://img.shields.io/badge/Diagram-2b3137?style=flat-square)](https://repodiagrams.s3.eu-north-1.amazonaws.com/skyvern_ultra_detailed_interactive.html) [![Join](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&style=flat-square)](https://discord.gg/fG2XXEuQX3) [![Star](https://img.shields.io/badge/star-181717?logo=github&logoColor=white&style=flat-square)](https://github.com/Skyvern-AI/Skyvern)
GiteaMirror commented 2026-04-13 06:47:46 -05:00
Author
Owner
Copy Link
Copy Source

@dosubot[bot] commented on GitHub (Mar 23, 2026):

Hi, @wbrijesh. I'm Dosu, and I'm helping the better-auth team manage their backlog and am marking this issue as stale.

Issue Summary:

  • You requested support for Amazon DSQL, a Postgres-compatible database without foreign key constraints.
  • Maintainers noted Better Auth can work without foreign key constraints by treating fields as foreign keys and performing joins.
  • Clarification was sought on which relational features are critical for your use case.
  • The discussion focused on testing Better Auth with DSQL and understanding the impact of missing foreign key constraints.
  • Further feedback from you on specific challenges or requirements would help decide on official support or documentation updates.

Next Steps:

  • Please let me know if this issue is still relevant with the latest version of better-auth by commenting here.
  • If I don’t hear back within 7 days, this issue will be automatically closed.

Thanks for your understanding and contribution!

<!-- gh-comment-id:4111774608 --> @dosubot[bot] commented on GitHub (Mar 23, 2026): Hi, @wbrijesh. I'm [Dosu](https://dosu.dev), and I'm helping the better-auth team manage their backlog and am marking this issue as stale. **Issue Summary:** - You requested support for Amazon DSQL, a Postgres-compatible database without foreign key constraints. - Maintainers noted Better Auth can work without foreign key constraints by treating fields as foreign keys and performing joins. - Clarification was sought on which relational features are critical for your use case. - The discussion focused on testing Better Auth with DSQL and understanding the impact of missing foreign key constraints. - Further feedback from you on specific challenges or requirements would help decide on official support or documentation updates. **Next Steps:** - Please let me know if this issue is still relevant with the latest version of better-auth by commenting here. - If I don’t hear back within 7 days, this issue will be automatically closed. Thanks for your understanding and contribution!
GiteaMirror commented 2026-04-13 06:47:47 -05:00
Author
Owner
Copy Link
Copy Source

@github-actions[bot] commented on GitHub (Apr 7, 2026):

This issue has been locked as it was closed more than 7 days ago. If you're experiencing a similar problem or you have additional context, please open a new issue and reference this one.

<!-- gh-comment-id:4195714888 --> @github-actions[bot] commented on GitHub (Apr 7, 2026): This issue has been locked as it was closed more than 7 days ago. If you're experiencing a similar problem or you have additional context, please open a new issue and reference this one.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
adapter
astro
awaiting external contributor
blocked
breaking
breaking change
bug
c-devops
core
credentials
database
dependencies
devops
devtools
docs
documentation
duplicate
elysia
enhancement
enterprise
expo
express
fastify
good first issue
help wanted
hono
identity
infra
integration
invalid
javascript
locked
maintenance
need-more-information
needs: info
needs: repro
nextjs
nuxt
oauth
organization
P0
payments
perf
platform
plugin
pull-request
Mirrored from GitHub Pull Request
 question
ready
regression
remix
security
social-provider
solid
stale
svelte
tanstack-start
tracking
version-bump
vue
wontfix
No labels database locked
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
GiteaMirror ninjasurge (Kaehlen Rog)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/better-auth#10567