FlareStart
HomeNewsHow ToSources
FlareStart

Where developers start their day. All the tech news & tutorials that matter, in one place.

Quick Links

  • Home
  • News
  • Tutorials
  • Sources
  • Privacy Policy

Connect

© 2026 FlareStart. All rights reserved.

Back to articles
Durability in Wallet Transfer System
How-ToMachine Learning

Durability in Wallet Transfer System

via Dev.toSandhya Steffy M2h ago

In this task, I understood the Durability property of ACID using a wallet system. Durability means that once a transaction is committed, the data will be permanently stored in the database and will not be lost even if the system crashes or restarts. First, I created the accounts table. CREATE TABLE accounts ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, balance INT NOT NULL CHECK (balance >= 0), last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); Then I inserted sample data. INSERT INTO accounts (name, balance) VALUES ('Alice', 1000), ('Bob', 500); To check the initial data: SELECT * FROM accounts; Alice had 1000 and Bob had 500. Next, I performed a successful transaction to transfer 300 from Alice to Bob. BEGIN; UPDATE accounts SET balance = balance - 300 WHERE id = 1; UPDATE accounts SET balance = balance + 300 WHERE id = 2; COMMIT; After committing, I checked the data again. SELECT * FROM accounts; Now Alice had 700 and Bob had 800. Then I simulated a system restart by reconnecting to

Continue reading on Dev.to

Opens in a new tab

Read Full Article
0 views

Related Articles

How to delete your personal info from the internet (while saving money)
How-To

How to delete your personal info from the internet (while saving money)

ZDNet • 16m ago

Here Is What Programming Taught Me About Growth
How-To

Here Is What Programming Taught Me About Growth

Medium Programming • 1h ago

I Did Everything “Right” in Programming — Here Is What Actually Mattered
How-To

I Did Everything “Right” in Programming — Here Is What Actually Mattered

Medium Programming • 1h ago

Should You Still Learn DSA in 2026? (A Real Answer)
How-To

Should You Still Learn DSA in 2026? (A Real Answer)

Medium Programming • 1h ago

Apple begins age checks in the UK with latest iOS update
How-To

Apple begins age checks in the UK with latest iOS update

Ars Technica • 1h ago

Discover More Articles