id
type
5 (blog/news article)
status
21 (imported old-v2, waiting for another import)
review version
0
cleanup version
0
pending deletion
0 (-)
created at
2025-11-15 08:48:36
updated at
2025-11-15 08:48:37
url
https://www.fishdan.com/2024/05/preventing-accidental-large-deletes.html
url length
72
url crc
34379
url crc32
2283570763
location type
1 (url matches target location, page_location is empty)
canonical status
10 (verified canonical url)
canonical page id
domain id
domain tld
2211
domain parts
0
originating warc id
-
originating url
https://data.commoncrawl.org/crawl-data/CC-MAIN-2025-33/segments/1754151279985.36/warc/CC-MAIN-20250808003938-20250808033938-00992.warc.gz
source type
11 (CommonCrawl)
server ip
Publication date
2025-08-08 01:33:43
Fetch attempts
0
Original html size
122289
Normalized and saved size
28550
title
Preventing accidental large deletes.
excerpt
content
Instructions for Developers on Using the safe_delete Stored Procedure To enhance safety and auditability of delete operations within our databases, we have implemented a controlled deletion process using a stored procedure named safe_delete. This procedure relies on a temporary table (temp_delete_table) that lists complete records intended for deletion, not just their IDs. This approach helps prevent accidental deletions and provides a traceable audit log of delete actions. Why We Are Doing This Controlled Deletions: Centralizing delete operations through a stored procedure reduces the risk of erroneous or unauthorized deletions. Auditability: Using a temporary table to store complete records before deletion allows for an in-depth review and verification process, enhancing our ability to confirm and audit delete operations accurately. Security: Restricting direct delete permissions and channeling deletions through a specific procedure aligns ...
author
updated
1768233436
block type
0
extracted fields
104
extracted bits
title
full content
content was extracted heuristically
detected location
0
detected language
1 (English)
category id
-
index version
1
paywall score
0
spam phrases
0
text nonlatin
0
text cyrillic
0
text characters
3280
text words
591
text unique words
241
text lines
1
text sentences
26
text paragraphs
1
text words per sentence
22
text matched phrases
0
text matched dictionaries
0
links self subdomains
0
links other subdomains
0
links other domains
0
links spam adult
0
links spam random
0
links spam expired
0
links ext activities
0
links ext ecommerce
0
links ext finance
0
links ext crypto
0
links ext booking
0
links ext news
0
links ext leaks
0
links ext ugc
25
links ext klim
0
links ext generic
0
image author
featured image