beanz Magazine

CRUD

W_Minshuli on Flickr

CRUD is a powerful concept used everywhere in software programming that uses a database.

CRUD is not a a league of super heroes or super villains. Instead, CRUD is an acronym for the four basic database-related functions programmers encounter as they create software.

Each letter in CRUD refers to tasks performed with databases:

  • Create or add data
  • Retrieve data
  • Update data
  • Delete data

This acronym likely was created in the 1980s to describe database functionality used by SQL (structured query language) databases. Each letter maps to an SQL operation: INSERT (create), SELECT (retrieve), UPDATE (update), and DELETE (delete). However, these operations also apply to non-SQL databases, for example, MongoDB and BigTable.

How CRUD Works

In practical terms, you likely would have functions or methods to create a data record in the database, retrieve the data record, update a specific data record (usually with the unique ID of the record), and delete a data record (also using the unique ID of the record).

 

Become a subscriber and get access to the rest of this article. Plus all our magazine articles.

Stories also include numerous links to help parents, kids, and teachers learn more. Get access today at just $15 per year!

Subscribe Today!

Also In The August 2015 Issue

In his classroom, he and his students learn together as a community.

These fifth grade students use their genius hours and Trello software to answer tough questions.

Visual storytelling apps are a great way for kids to document and explore their lives.

Raspberry Pi, Arduino, BeagleBone, Micro Bit, Edison, CHIP, and other handheld computers trace their history to board computers used by engineers.

Random Hacks of Kindness, Jr. helps schools and groups host one day hacking events for kids to work with local non-profit groups.

Resources based on teacher recommendations and other sources.

The new Sphero SPRK Edition makes it even easier for teachers, parents, and kids to learn math, robotics, and programming.

Facts, programs, and groups can help girls succeed at STEM careers.

She was in her 30s when she led the team that developed mission critical software used guide the Apollo moon landings.

Learn about and explore the code used to guide Apollo missions.

CRUD is a powerful concept used everywhere in software programming that uses a database.

Links from the bottom of all the August 2015 articles, collected in one place for you to print, share, or bookmark.

Interesting stories about computer science, software programming, and technology for August 2015.

Some thoughts on starting the third year of publishing this magazine and what's new this month.