Simple PHP RocksDB extension. No guarantees of anything. WORKS in 8.x.

1h file, 1c file, 1 config. easily audited (in case you're worried about a supply-chain attack).

Build instructions:

git clone git@github.com:lirenz/php-rocksdb.git
cd php-rocksdb
phpize
./configure --with-rocksdb=YOUR_ROCKSDB_SO_DIRECTORY
make
sudo make install

Sample usage:

// - create_if_missing: create the database if it does not exist
// - error_if_exists: error out if the database already exists
// - paranoid_checks: perform extra checks for data integrity
// - write_buffer_size: buffer size for writes (in bytes)
// - max_open_files: maximum number of open files
// - block_restart_interval: interval for block restarts
// - compression: compression type (e.g., RocksDB::SNAPPY_COMPRESSION)
$options = [
  'read_only' => true,
  'create_if_missing'      => true,
  'error_if_exists'        => false,
  'paranoid_checks'        => true,
  'write_buffer_size'      => 67108864,    // 64 MB
  'max_open_files'         => 500,
  'block_restart_interval' => 16,
  'compression'            => RocksDB::SNAPPY_COMPRESSION,
];

// Create a new RocksDB instance at the given path with the specified options.
$db = new RocksDB('/your/path', $options);

// Basic put and get operations.
if ($db->put('example_key', 'example_value')) {
  echo "Stored 'example_key' successfully.\n";
} else {
  echo "Failed to store key.\n";
}

$value = $db->get('example_key');
if ($value !== false) {
  echo "Retrieved 'example_key': $value\n";
} else {
  echo "'example_key' not found.\n";
}

// Demonstrate batch writing.
$batch = new RocksDBWriteBatch();
$batch->put('batch_key1', 'batch_value1');
$batch->put('batch_key2', 'batch_value2');
$batch->delete('example_key');
if ($db->write($batch)) {
  echo "Batch operation completed successfully.\n";
} else {
  echo "Batch operation failed.\n";
}

// Demonstrate prefix search.
// Assume keys with the prefix "batch_" are of interest.
$iterator = $db->prefixSearch('batch_');
for ($iterator->rewind(); $iterator->valid(); $iterator->next()) {
  echo $iterator->key() . " => " . $iterator->current() . "\n";
}

$iterator = $db->getIterator($readOptions); // Correct method name

// Statistics
$count = 0;
$batch_count = 0;
$report_every = 5000000; // Report progress every 5 million records

// Track execution time
$start_time = microtime(true);

for ($iterator->seekToFirst(); $iterator->valid(); $iterator->next()) {
    $count++;

    // Get the key and value
    $key = $iterator->key();
    $value = $iterator->current(); // Correct method for retrieving value

    // Print key-value pair (adjust as needed)
    echo "Key: $key, Value: $value\n";

    // Periodically report progress
    if ($count % $report_every === 0) {
        $batch_count++;
        $elapsed = microtime(true) - $start_time;
        $rate = $count / $elapsed;

        echo "Processed $count keys in " . number_format($elapsed, 2) . " seconds ";
        echo "(" . number_format($rate, 2) . " keys/sec)\n";

        // Garbage collection every 10 reports
        if ($batch_count % 10 === 0) {
            gc_collect_cycles();
        }
    }
}