Data

Tools

Indexes

Applications

Experiments

Open Source Science

postgres-delete-restore-as-table-property

Using triggers, key generators and a second table for delete & restore functionality

https://github.com/the-aeydr/postgres-delete-restore-as-table-property

Science Score: 44.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ✓
    CITATION.cff file
    Found CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Committers with academic emails
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (8.0%) to scientific vocabulary

Keywords

postgres
Last synced: 6 months ago · JSON representation ·

Repository

Using triggers, key generators and a second table for delete & restore functionality

Basic Info
Statistics
  • Stars: 0
  • Watchers: 0
  • Forks: 0
  • Open Issues: 0
  • Releases: 0
Topics
postgres
Created 9 months ago · Last pushed 6 months ago
Metadata Files
Readme Contributing Funding License Code of conduct Citation Codeowners Security Notice

README.md

Soft Deletes as the responsibility of the Database

Using triggers, key generators and a second table for delete & restore functionality

This is a companion repository for the written article: Soft Deletes as the responsibility of the Database.

This repository provides supporting examples, scripts, and sample code to help illustrate the concepts and ideas discussed in the article. It is intended as a reference or demonstration only and not as a standalone library, framework, or reusable package. The contents of this repository are tightly scoped to the article's subject matter. Each resource is designed to show a specific point or concept in a simple and direct way.

For an overview of working with the contents of the repository, refer to the overview that will explain working with the repository resources, or the article, Soft Deletes as the responsibility of the Database.

You are welcome to experiment with the resources in this repository for your own study or experimentation. However, please note that:

  • There is no support or ongoing maintenance.
  • Code may be minimal and focus solely on clarity, not completeness or robustness.
  • Dependencies, if any, are listed in the article or in the script headers.

Advisory

All content in this repository is All Rights Reserved. You are welcome to read and study the contents for personal understanding or educational purposes, but be aware that this repository should be considered equivalent to written blog content: available for reading, but not licensed for derivative use.

Owner

  • Name: aeydr
  • Login: the-aeydr
  • Kind: organization

Designs, notes, writings and thoughts around building with software.

Citation (CITATION.cff) 

cff-version: 1.2.0
message: "If you refer to this article, please cite it as below."

version: 1.0.0
date-released: 2023-08-11
title: "Soft Deletes as the responsibility of the Database"
url: "https://writing.aeydr.dev/notes/postgres-delete-restore-as-table-property"
authors:
- given-names: "aeydr"

preferred-citation:
  type: article
  journal: "The Architectural Decision Record"
  authors:
  - given-names: "aeydr"

  title: "Soft Deletes as the responsibility of the Database"
  month: 08
  year: 2023

GitHub Events

Total
  • Push event: 51
  • Public event: 1
Last Year
  • Push event: 51
  • Public event: 1

Committers

Last synced: 8 months ago

All Time
  • Total Commits: 1
  • Total Committers: 1
  • Avg Commits per committer: 1.0
  • Development Distribution Score (DDS): 0.0
Past Year
  • Commits: 1
  • Committers: 1
  • Avg Commits per committer: 1.0
  • Development Distribution Score (DDS): 0.0
Top Committers
Name Email Commits
the-aeydr-repository-manager[bot] 2****] 1

Issues and Pull Requests

Last synced: 7 months ago

All Time
  • Total issues: 0
  • Total pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Total issue authors: 0
  • Total pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 0
  • Pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Issue authors: 0
  • Pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
View more stats
Top Authors
Issue Authors
Pull Request Authors
Top Labels
Issue Labels
Pull Request Labels

Dependencies

.devcontainer/Dockerfile docker
  • mcr.microsoft.com/devcontainers/base bullseye build
.gitpod/Dockerfile docker
  • gitpod/workspace-full latest build
LICENSE.spdx swiftpm