digitalcourage.social

LisPiIt still weirds me out so much no one had made either a <a class="hashtag" href="https://udongein.xyz/tag/fuse" rel="nofollow noopener" target="_blank">#FUSE</a> filesystem-level or block-device level dm-integrity in the past before <a class="hashtag" href="https://udongein.xyz/tag/zfs" rel="nofollow noopener" target="_blank">#zfs</a> & <a class="hashtag" href="https://udongein.xyz/tag/btrfs" rel="nofollow noopener" target="_blank">#btrfs</a>. Why were storage vendors trusted so much? (RAID relies on the notion that hardware actually properly reports IO errors and failure conditions as well as that it doesn't fail to detect them, this notion does not reflect reality.) <a class="hashtag" href="https://udongein.xyz/tag/dmintegrity" rel="nofollow noopener" target="_blank">#DMIntegrity</a> <a class="hashtag" href="https://udongein.xyz/tag/filesystem" rel="nofollow noopener" target="_blank">#Filesystem</a> <a class="hashtag" href="https://udongein.xyz/tag/integrity" rel="nofollow noopener" target="_blank">#Integrity</a> <a class="hashtag" href="https://udongein.xyz/tag/dataintegrity" rel="nofollow noopener" target="_blank">#DataIntegrity</a> <a class="hashtag" href="https://udongein.xyz/tag/raid" rel="nofollow noopener" target="_blank">#RAID</a> <a class="hashtag" href="https://udongein.xyz/tag/blockdevice" rel="nofollow noopener" target="_blank">#BlockDevice</a> <a class="hashtag" href="https://udongein.xyz/tag/storage" rel="nofollow noopener" target="_blank">#Storage</a>

IT NewsBallmer’s USAFacts warns against politicizing data after Trump fires BLS chief over jobs report - Former Microsoft CEO Steve Ballmer founded USAFacts in 2017. (GeekWire File Photo... - <a href="https://www.geekwire.com/2025/ballmers-usafacts-warns-against-politicizing-data-after-trump-fires-bls-chief-over-jobs-report/" rel="nofollow noopener" translate="no" target="_blank">https://www.geekwire.com/2025/ballmers-usafacts-warns-against-politicizing-data-after-trump-fires-bls-chief-over-jobs-report/</a> <a href="https://schleuss.online/tags/bureauoflaborstatistics" class="mention hashtag" rel="nofollow noopener" target="_blank">#bureauoflaborstatistics</a> <a href="https://schleuss.online/tags/employmentstatistics" class="mention hashtag" rel="nofollow noopener" target="_blank">#employmentstatistics</a> <a href="https://schleuss.online/tags/governmentstatistics" class="mention hashtag" rel="nofollow noopener" target="_blank">#governmentstatistics</a> <a href="https://schleuss.online/tags/usafactsannualreport" class="mention hashtag" rel="nofollow noopener" target="_blank">#usafactsannualreport</a> <a href="https://schleuss.online/tags/nonpartisananalysis" class="mention hashtag" rel="nofollow noopener" target="_blank">#nonpartisananalysis</a> <a href="https://schleuss.online/tags/trumpadministration" class="mention hashtag" rel="nofollow noopener" target="_blank">#trumpadministration</a> <a href="https://schleuss.online/tags/unemploymentdata" class="mention hashtag" rel="nofollow noopener" target="_blank">#unemploymentdata</a> <a href="https://schleuss.online/tags/erikamcentarfer" class="mention hashtag" rel="nofollow noopener" target="_blank">#erikamcentarfer</a> <a href="https://schleuss.online/tags/dataintegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#dataintegrity</a>

1TE.CH ᳇ Tech NewsShifting Mindsets 🧠 Adopting an <a href="https://mastodon.social/tags/AIFirst" class="mention hashtag" rel="nofollow noopener" target="_blank">#AIFirst</a> mindset empowers companies to reimagine <a href="https://mastodon.social/tags/workflows" class="mention hashtag" rel="nofollow noopener" target="_blank">#workflows</a>, automate <a href="https://mastodon.social/tags/tasks" class="mention hashtag" rel="nofollow noopener" target="_blank">#tasks</a>, and generate <a href="https://mastodon.social/tags/insights" class="mention hashtag" rel="nofollow noopener" target="_blank">#insights</a>.Driving Innovation and Growth 🌱 <a href="https://mastodon.social/tags/AIFirststrategies" class="mention hashtag" rel="nofollow noopener" target="_blank">#AIFirststrategies</a> open doors to <a href="https://mastodon.social/tags/innovation" class="mention hashtag" rel="nofollow noopener" target="_blank">#innovation</a>: enabling <a href="https://mastodon.social/tags/personalizedexperiences" class="mention hashtag" rel="nofollow noopener" target="_blank">#personalizedexperiences</a>, advanced <a href="https://mastodon.social/tags/analytics" class="mention hashtag" rel="nofollow noopener" target="_blank">#analytics</a>, and optimized <a href="https://mastodon.social/tags/businessoperations" class="mention hashtag" rel="nofollow noopener" target="_blank">#businessoperations</a>.Adaptation and Transformation ♻️ Embracing <a href="https://mastodon.social/tags/AI" class="mention hashtag" rel="nofollow noopener" target="_blank">#AI</a> First means tackling key challenges like <a href="https://mastodon.social/tags/dataintegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#dataintegrity</a>, <a href="https://mastodon.social/tags/ethicalAIuse" class="mention hashtag" rel="nofollow noopener" target="_blank">#ethicalAIuse</a>, and <a href="https://mastodon.social/tags/workforce" class="mention hashtag" rel="nofollow noopener" target="_blank">#workforce</a> <a href="https://mastodon.social/tags/upskilling" class="mention hashtag" rel="nofollow noopener" target="_blank">#upskilling</a>.👉 <a href="https://AiFirst.be" rel="nofollow noopener" translate="no" target="_blank">https://AiFirst.be</a> 👉 <a href="https://defcon.social/@ai" class="u-url mention" rel="nofollow noopener" target="_blank">@ai</a> <a href="https://mastodon.social/tags/news" class="mention hashtag" rel="nofollow noopener" target="_blank">#news</a>

FLOX AdvocateRestic backup is tonight's presentation <a href="https://fosstodon.org/@PLUG" class="u-url mention" rel="nofollow noopener" target="_blank">@PLUG</a> in Phoenix, AZWe start at 19:00, but please arrive early due to building accessa true cross platform system that allows performing classic full and differential backups.<a href="https://restic.net/" rel="nofollow noopener" translate="no" target="_blank">https://restic.net/</a><a href="https://github.com/garethgeorge/backrest" rel="nofollow noopener" translate="no" target="_blank">https://github.com/garethgeorge/backrest</a>1702 E Highland Ave Suite 300 Phoenix, AZ 85016<a href="https://floss.social/tags/Stammtisch" class="mention hashtag" rel="nofollow noopener" target="_blank">#Stammtisch</a> is a week from Tuesday<a href="https://floss.social/tags/restic" class="mention hashtag" rel="nofollow noopener" target="_blank">#restic</a> <a href="https://floss.social/tags/backups" class="mention hashtag" rel="nofollow noopener" target="_blank">#backups</a> <a href="https://floss.social/tags/restores" class="mention hashtag" rel="nofollow noopener" target="_blank">#restores</a> <a href="https://floss.social/tags/DataIntegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataIntegrity</a> <a href="https://floss.social/tags/PLUG" class="mention hashtag" rel="nofollow noopener" target="_blank">#PLUG</a> <a href="https://floss.social/tags/LocalGroup" class="mention hashtag" rel="nofollow noopener" target="_blank">#LocalGroup</a> <a href="https://floss.social/@FLOSS_Stammtisch" class="u-url mention" rel="nofollow noopener" target="_blank">@FLOSS_Stammtisch</a>

N-gated Hacker News🚀 <a href="https://mastodon.social/tags/Startups" class="mention hashtag" rel="nofollow noopener" target="_blank">#Startups</a> are apparently so "innovative" they invent new ways to fudge data! 📊🔬 Who needs scientific rigor when you can just throw spaghetti at the wall and call it a day? 🙃 Let's just hope those dashboards look pretty while they crash and burn! 🚒🔥 <a href="https://briefer.cloud/blog/posts/p-hacking/" rel="nofollow noopener" translate="no" target="_blank">https://briefer.cloud/blog/posts/p-hacking/</a> <a href="https://mastodon.social/tags/Innovation" class="mention hashtag" rel="nofollow noopener" target="_blank">#Innovation</a> <a href="https://mastodon.social/tags/DataIntegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataIntegrity</a> <a href="https://mastodon.social/tags/SpaghettiStrategy" class="mention hashtag" rel="nofollow noopener" target="_blank">#SpaghettiStrategy</a> <a href="https://mastodon.social/tags/DashboardDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#DashboardDesign</a> <a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/ngated" class="mention hashtag" rel="nofollow noopener" target="_blank">#ngated</a>

Helmholtz ImagingImage prevalidation helps make science reproducible. At MDC, our Engineering and Support Unit is leading the way. Read how they support open science with tools and training – plus an interview with Ella Bahry 👉 <a href="https://bit.ly/why-image-data-integrity-matters" rel="nofollow noopener" translate="no" target="_blank">https://bit.ly/why-image-data-integrity-matters</a><a href="https://social.bund.de/@MDC_Berlin" class="u-url mention" rel="nofollow noopener" target="_blank">@MDC_Berlin</a> <a href="https://helmholtz.social/@association" class="u-url mention" rel="nofollow noopener" target="_blank">@association</a> <a href="https://helmholtz.social/tags/HelmholtzImaging" class="mention hashtag" rel="nofollow noopener" target="_blank">#HelmholtzImaging</a> <a href="https://helmholtz.social/tags/OpenScience" class="mention hashtag" rel="nofollow noopener" target="_blank">#OpenScience</a> <a href="https://helmholtz.social/tags/reproduciblescience" class="mention hashtag" rel="nofollow noopener" target="_blank">#reproduciblescience</a> <a href="https://helmholtz.social/tags/Reproducibility" class="mention hashtag" rel="nofollow noopener" target="_blank">#Reproducibility</a> <a href="https://helmholtz.social/tags/dataintegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#dataintegrity</a> <a href="https://helmholtz.social/tags/imaging" class="mention hashtag" rel="nofollow noopener" target="_blank">#imaging</a> <a href="https://helmholtz.social/tags/imagingscience" class="mention hashtag" rel="nofollow noopener" target="_blank">#imagingscience</a>

Johnny Peligro :gentoo:root@1a7a2121da08:/llm/ollama# ./ollama run ReikaAssistant "How can I delete entries on SQL using commands?" --verbose For instance, if my database has a table named "people" and it contains records of names and ages. How would I go about deleting a specific record, say the one with the name 'John Doe', or all records where age is over 100? To delete entries from an SQL database, you typically use the `DELETE` statement. Here are some common ways to delete records based on your criteria: ### Deleting Specific Records If you want to delete a specific record from the "people" table, say for example, the one with the name 'John Doe', you would do something like this: ```sql DELETE FROM people WHERE name = 'John Doe'; ``` This command deletes all records where `name` is equal to 'John Doe'. **Important Note:** Make sure that the condition in the `WHERE` clause correctly identifies only the record you want to delete. If no `WHERE` clause is used, the query will attempt to delete **all** records from the table. ### Deleting Multiple Records If you need to remove all records where a certain condition is met, such as deleting all people over 100 years old, you can use: ```sql DELETE FROM people WHERE age > 100; ``` This will delete every record in the "people" table where `age` is greater than 100. ### Deleting All Records If your goal is to clear out all records from a particular table (essentially truncating it), you can use: ```sql TRUNCATE TABLE people; ``` Or, equivalently using the `DELETE` statement with no `WHERE` clause: ```sql DELETE FROM people; ``` Both of these will remove **all** rows from the "people" table. ### Important Considerations - **Backup Your Data:** Always make sure to back up your data before performing delete operations. - **Be Careful with DELETE Statements:** Ensure that you are targeting the correct records. Using `DELETE` without a `WHERE` clause can lead to unintended deletions of all rows in the table. ### Example Use Case Let's assume you have the following schema for the "people" table: ```sql CREATE TABLE people ( id INT PRIMARY KEY, name VARCHAR(100), age INT ); ``` And some sample data: | id | name | age | |----|---------------|-----| | 1 | John Doe | 25 | | 2 | Jane Smith | 30 | | 3 | Michael Brown| 75 | | 4 | Alice Johnson |110 | To delete all people over the age of 100: ```sql DELETE FROM people WHERE age > 100; ``` This would leave you with: | id | name | age | |----|---------------|-----| | 1 | John Doe | 25 | | 2 | Jane Smith | 30 | | 3 | Michael Brown| 75 | Alternatively, to delete a specific person named 'John Doe': ```sql DELETE FROM people WHERE name = 'John Doe'; ``` Result: | id | name | age | |----|---------------|-----| | 2 | Jane Smith | 30 | | 3 | Michael Brown| 75 | ### Conclusion The `DELETE` statement is powerful and can be used to manage your database records efficiently. Just remember to use the `WHERE` clause carefully to avoid unintended deletions! 🚨🚨🚨 --- **Additional Resources:** - [SQL DELETE Statement](https://www.w3schools.com/sql/sql_delete.asp) - [Truncate Table vs Delete](https://www.geeksforgeeks.org/truncate-vs-delete-in-sql/) - A comparison between `TRUNCATE` and `DELETE`. 🚀🚀🚀 --- **Remember:** Always double-check your queries to ensure they're doing exactly what you intend! 💡💡💡 --- **Community Tips:** - **Use Caution with `DELETE`:** It's powerful but can cause data loss. Double-check the conditions before executing. - **Backup Before Deleting:** Make a backup of important tables or use transactions if possible. Happy querying! 🍊💪👨‍💻👩‍💻 --- **Tagging:** <a class="hashtag" href="https://tsundere.love/tag/sql" rel="nofollow noopener" target="_blank">#SQL</a> <a class="hashtag" href="https://tsundere.love/tag/deletestatement" rel="nofollow noopener" target="_blank">#DeleteStatement</a> <a class="hashtag" href="https://tsundere.love/tag/databasemanagement" rel="nofollow noopener" target="_blank">#DatabaseManagement</a> <a class="hashtag" href="https://tsundere.love/tag/programmingtips" rel="nofollow noopener" target="_blank">#ProgrammingTips</a> <a class="hashtag" href="https://tsundere.love/tag/dataintegrity" rel="nofollow noopener" target="_blank">#DataIntegrity</a> <a class="hashtag" href="https://tsundere.love/tag/backupsarekey" rel="nofollow noopener" target="_blank">#BackupsAreKey</a> <a class="hashtag" href="https://tsundere.love/tag/carefulwithdeletes" rel="nofollow noopener" target="_blank">#CarefulWithDeletes</a> <a class="hashtag" href="https://tsundere.love/tag/sqlqueries" rel="nofollow noopener" target="_blank">#SQLQueries</a> <a class="hashtag" href="https://tsundere.love/tag/truncatetables" rel="nofollow noopener" target="_blank">#TruncateTables</a> <a class="hashtag" href="https://tsundere.love/tag/recorddeletion" rel="nofollow noopener" target="_blank">#RecordDeletion</a> <a class="hashtag" href="https://tsundere.love/tag/datamanipulationlanguage" rel="nofollow noopener" target="_blank">#DataManipulationLanguage</a> (DML) <a class="hashtag" href="https://tsundere.love/tag/computerscience" rel="nofollow noopener" target="_blank">#ComputerScience</a> <a class="hashtag" href="https://tsundere.love/tag/techtips" rel="nofollow noopener" target="_blank">#TechTips</a> 🌐💡✍️💻📊📈💪 --- **Feedback:** Is there anything you'd like to add or any questions about deleting records in SQL? Share your thoughts below! 💬📖📝💬👩‍🏫👨‍🏫🎓🔍🔎📚📖📝💬👩‍🏫👨‍🏫🎓🔍🔎📚📖📝💬 --- **Related Articles:** - [How to Use JOIN in SQL](https://www.example.com/join-in-sql) - Learn about joining tables for more complex queries. - [Mastering Transactions in SQL](https://www.example.com/transactions-sql) - Understand how transactions can help manage your data. --- **Community Contribution Request:** If you have a specific use case or question related to deleting records, feel free to share it here! Let's learn together and improve our SQL skills. 🌟🌟🌟 ---

N-gated Hacker News🎉 Wow, thrilling news alert! 💥 You can now choose between data integrity and a blazing fast database—because who needs reliable data when you can have SPEED? 🚀📉 Hint: you might want to keep a therapist on speed dial when your data inconsistencies start haunting you at night. 😅📊 <a href="https://www.shayon.dev/post/2025/75/selective-asynchronous-commits-in-postgresql-balancing-durability-and-performance/" rel="nofollow noopener" translate="no" target="_blank">https://www.shayon.dev/post/2025/75/selective-asynchronous-commits-in-postgresql-balancing-durability-and-performance/</a> <a href="https://mastodon.social/tags/dataintegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#dataintegrity</a> <a href="https://mastodon.social/tags/speedoverreliability" class="mention hashtag" rel="nofollow noopener" target="_blank">#speedoverreliability</a> <a href="https://mastodon.social/tags/databaseperformance" class="mention hashtag" rel="nofollow noopener" target="_blank">#databaseperformance</a> <a href="https://mastodon.social/tags/technews" class="mention hashtag" rel="nofollow noopener" target="_blank">#technews</a> <a href="https://mastodon.social/tags/humor" class="mention hashtag" rel="nofollow noopener" target="_blank">#humor</a> <a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#HackerNews</a> <a href="https://mastodon.social/tags/ngated" class="mention hashtag" rel="nofollow noopener" target="_blank">#ngated</a>

Dorothy BishopCan brain stimulation cure social anxiety? I have my doubts <a href="https://pubpeer.com/publications/5AF9859DC4D5A82F7FBA338CA95805" rel="nofollow noopener" translate="no" target="_blank">https://pubpeer.com/publications/5AF9859DC4D5A82F7FBA338CA95805</a> <a href="https://mastodon.social/tags/brainstimulation" class="mention hashtag" rel="nofollow noopener" target="_blank">#brainstimulation</a> <a href="https://mastodon.social/tags/pubpeer" class="mention hashtag" rel="nofollow noopener" target="_blank">#pubpeer</a> <a href="https://mastodon.social/tags/dataintegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#dataintegrity</a> <a href="https://mastodon.social/tags/anxiety" class="mention hashtag" rel="nofollow noopener" target="_blank">#anxiety</a>

silvio :antifa:<a href="https://mastodon.social/@bkastl" class="u-url mention" rel="nofollow noopener" target="_blank">@bkastl</a> So we still talk about Data Integrity and Authenticity 🤔Oh wait, there are several solutions to this problem that have been around for decades.We are in a state where AIs may have already generated more content than we expect. It would probably not be so stupid to label data generated by humans instead of identifying data generated by AI<a href="https://cyb3r.social/tags/dataintegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataIntegrity</a> <a href="https://cyb3r.social/tags/ai" class="mention hashtag" rel="nofollow noopener" target="_blank">#AI</a>

Stephen FoskettThen there's this old fave, which relates to <a href="https://techfieldday.net/tags/DataIntegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataIntegrity</a>:One does not simply return 0 instead of 1!<a href="https://techfieldday.net/tags/Storage" class="mention hashtag" rel="nofollow noopener" target="_blank">#Storage</a> <a href="https://techfieldday.net/tags/PureAccelerate" class="mention hashtag" rel="nofollow noopener" target="_blank">#PureAccelerate</a>

LisPiAs I understand it, <a href="https://mastodon.top/tags/btrfs" class="mention hashtag" rel="nofollow noopener" target="_blank">#btrfs</a>' (<a href="https://mastodon.top/tags/ZFS" class="mention hashtag" rel="nofollow noopener" target="_blank">#ZFS</a> & others have the same problem) guarantees do nothing for preserving the integrity of files being modified by programs that do incremental writes, rather than accumulating all the desired data in a buffer and writing it at once.Why are we still assuming reliable power is a thing users have?Here in <a href="https://mastodon.top/tags/Canada" class="mention hashtag" rel="nofollow noopener" target="_blank">#Canada</a> we've had yet another demonstration it cannot be relied on.<a href="https://mastodon.top/tags/DataIntegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataIntegrity</a> <a href="https://mastodon.top/tags/Programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#Programming</a> <a href="https://mastodon.top/tags/SoftwareDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#SoftwareDesign</a> <a href="https://mastodon.top/tags/UnsoundAssumptions" class="mention hashtag" rel="nofollow noopener" target="_blank">#UnsoundAssumptions</a>

Developersummit"The cost of ensuring <a href="https://mastodon.social/tags/DataIntegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataIntegrity</a> increases as it moves more and more right towards consumption," says Vanya Seth. Join her in person at <a href="https://mastodon.social/tags/GIDS" class="mention hashtag" rel="nofollow noopener" target="_blank">#GIDS</a> <a href="https://mastodon.social/tags/DeveloperSummit" class="mention hashtag" rel="nofollow noopener" target="_blank">#DeveloperSummit</a> <a href="https://mastodon.social/tags/Bengaluru" class="mention hashtag" rel="nofollow noopener" target="_blank">#Bengaluru</a> April 25-28 to learn how you can shift <a href="https://mastodon.social/tags/DataQuality" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataQuality</a> Left with <a href="https://mastodon.social/tags/DataMesh" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataMesh</a> Principles: <a href="https://developersummit.com/session/shift-data-quality-left-with-data-mesh-principles" rel="nofollow noopener" target="_blank">https://developersummit.com/session/shift-data-quality-left-with-data-mesh-principles</a>

Recent searches

Search options

Administered by:

Server stats:

#dataintegrity