Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Support for Row Deletion Policy #302

Copy link
Copy link
Open
@jstlaurent

Description

@jstlaurent
Issue body actions

Is your feature request related to a problem? Please describe.
We have a use case where some entities have a life cycle where they are created, kept alive through a polling mechanism, and then destroyed. In order to handle the case where the client fails to explicitly destroy an entity (through error, network failure, etc.), we have implemented a time-to-live feature that flags entities as stale once they have not received a keep-alive request beyond a certain delay. We currently have a scheduled event that calls a process to remove these stale entities.

Describe the solution you'd like
Cloud Spanner supports Row Deletion policies that would let us set the TTL directly in Spanner, without having to manage a scheduled process to do so. This requires adding SQL statements to the table declaration. We would like to be able to add these statements through the declarative __table_args__ field of our SQLAlchemy models, much like interleaving.

Describe alternatives you've considered
We can continue to run our scheduled process, but we would prefer to leverage the full capabilities of Spanner going forward.

Additional context
None.

Metadata

Metadata

Assignees

No one assigned

    Labels

    api: spannerIssues related to the googleapis/python-spanner-sqlalchemy API.Issues related to the googleapis/python-spanner-sqlalchemy API.priority: p3Desirable enhancement or fix. May not be included in next release.Desirable enhancement or fix. May not be included in next release.type: feature request‘Nice-to-have’ improvement, new feature or different behavior or design.‘Nice-to-have’ improvement, new feature or different behavior or design.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Morty Proxy This is a proxified and sanitized view of the page, visit original site.