Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts

Run BASIC - Zero Configuration Web Application Server

I found a blog post today that compared PHP with Ruby on Rails in terms of how much easier PHP is to install and configure than Ruby on Rails. Both of these systems are composed of at a minimum:
  • A web server (usually Apache)
  • A language interpreter for PHP or Ruby
  • And usually a database server

And this is a simplification. The user needs to install and configure these things which requires knowing about a lot of esoteric stuff. If you've never done this before, you can lose some of your hair. Unless you like pain, why put yourself through this?

If you want to create your own web applications, Run BASIC will install everything ready to run in one shot. http://www.runbasic.com/

Why do people put up with complex programming systems? Because for more than a decade they had much harder tools, so now they think PHP and RoR are easy.

What is ACID?

In database world, ACID is an acronym. It stands for; Atomicity, Consistency, Isolation and Durability. Databases should have these four features for them to become a reliable databases. All of these four features relate with transactions.

  • Atomicity:
    A transaction has to be completely commited or roll-backed, a portion of the transaction should not be committed to the database due to any issue even on a hardware failure.
  • Consistancy:
    After any transaction the data in the database should be correct and vailid according to the requirements. Database should not be having any illegal data after a transaction.
  • Isolation:
    When two or more transactions exists, one's behaviour should not give invalid data for the other transaction. That is, when one transaction is in progress, the data alterations made by that transaction should not be visible to any other transactions.
  • Durability:
    After the commit operation is aknowledged by the database, the data inside that transaction should not be lost. The updating of those data into the database has to be guaranteed.

Related Posts:
What is CRUD?

What is CRUD?


The word 'CRUD' is a acronym in the computer world. It stands for Create, Read, Update and Delete. Sometimes R in 'CRUD' is used for the word Retrieve and D for Destroy.

Most of the time 'CRUD' is related to SQL database operations as follows.
  • C: INSERT
  • R: SELECT
  • U: UPDATE
  • D: DELETE

Check out this stream