Delete

Jump to the Code block for a combined complete example.

Setup

The following examples will use the setup below to illustrate single record deletion in an Aerospike database.

using Aerospike.Client;

// Define host configuration
Host config = new Host("127.0.0.1", 3000);
// Establishes a connection to the server
AerospikeClient client = new AerospikeClient(null, config);

// Creates a key with the namespace "sandbox", set "ufodata", and user key 5001
Key key = new Key("sandbox", "ufodata", 5001);

Policies

Just as Create and Update, Delete utilizes write policies that can be defined per command.

The following example creates a write policy that enables durable deletes.

// Can use a previously defined write policy or create a new one
WritePolicy deletePolicy = new WritePolicy();
deletePolicy.durableDelete = true;

Delete a record

Default policy

Aerospike deletes a record efficiently by only dropping the primary index entry. The record space on device is recovered during garbage collection.

The following example shows how to delete a record using the default write policy.

// Delete record with default write policy
client.Delete(null, key);

// Close the connection to the server
client.Close();

Durable deletes

When a command results in deletion of a record and the durable delete write policy is set to true, a tombstone record is written to disk to prevent previous versions of the record from returning during a cold restart. Refer to Durable Deletes for more information.

The following example uses the write policy set above to durably delete a record.

// Durably delete a record with the write policy
client.Delete(deletePolicy, key);

// Close the connection to the server
client.Close();

Code block

Expand this section for a single code block to durably delete a record

using Aerospike.Client;

// Define host configuration
Host config = new Host("127.0.0.1", 3000);
// Establishes a connection to the server
AerospikeClient client = new AerospikeClient(null, config);

// Creates a key with the namespace "sandbox", set "ufodata", and user key 5001
Key key = new Key("sandbox", "ufodata", 5001);

// Can use a previously defined write policy or create a new one
WritePolicy deletePolicy = new WritePolicy();
deletePolicy.durableDelete = true;

// Durably delete a record with the write policy
client.Delete(deletePolicy, key);

// Close the connection to the server
client.Close();