- Postgres – Transactions, Isolation and Locking
BEGIN, COMMIT, ROLLBACK, and what Postgres promises in between. Read Committed versus Repeatable Read versus Serializable, shown with two real psql sessions rather than described. SELECT FOR UPDATE, the lost update it prevents, deadlocks and the ordering rule that avoids them, advisory locks, and the idle-in-transaction connection that blocks your next deploy.
- Linux Search/Filters
Grep Grep command stands for “global regular expression print”. grep command filters the content of a file which makes our search easy. grep {search-key-word} {filename} // search for word lisa in test.txt file grep ‘lisa’ test.txt grep -n The -n option display the line number grep -n ‘lisa’…
- Iterating
This is the final post in our series on how software engineering works. We have covered understanding the problem, finding and validating a solution, planning, designing, implementing, testing, and shipping an MVP. Now comes the part that separates amateur projects from professional products:…
- How It Works: MVP (Minimum Viable Product)
This is post #10 in our How It Works series. Our running example is building a task management app — a simplified Trello for small dev teams. We have gone through understanding the problem, planning, wireframing, designing, implementing, and testing. Now it is time to ship something real. What Is…
- Testing
You have written the code. Features are implemented. The task management app has endpoints, services, and a database schema. Now comes the phase that separates professional software from hobby projects: testing. This is post #9 in the How It Works series. We are not doing a deep dive into testing…