Skip to content

RFC: Thoughts on databases. #2972

Description

@marciocadev

Feature Spec

I was thinking about what @ekeren said about DB, and I agree with what he said.
the wise words of Eyal

At first, using abstractions to work in the cloud is exciting, but when it comes to databases, trying to "improve" access with new abstractions tends to make it more difficult to use. I believe that the typical cloud resource user already has prior knowledge of using databases, and our current resource (Table) seems counterintuitive to me.

If you have worked with relational databases, the Table object alone doesn't mean much. If you have worked with non-relational databases like DynamoDB, our current implementation of the Table is counterintuitive (the primary key brings to mind associations with relational databases, not the partition key of DynamoDB).

I believe that the best way to create persistence resources for the language is to focus on abstractions such as permissioning and reflect the current implementations of each database.

When creating a relational database like PostgreSQL or MySQL, allow the creation of schemas, not individual tables.

Meanwhile, for non-relational databases, reflect the particularities of each one.

Use Cases

Make the use of DB in Wing simpler.

Implementation Notes

No response

Component

SDK

Community Notes

  • Please vote by adding a 👍 reaction to the issue to help us prioritize.
  • If you are interested to work on this issue, please leave a comment.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    Status
    ✅ Done

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions