-- Open lua wrapper library
local lib = require("libtidesdb_lua")
-- Open a TidesDB database
local code, message, db = lib.open("my_db")
--assert error codes for failures
assert(code == 0, message)
-- Create a column family
code, message = db:create_column_family(
    "my_column_family", 
    1024*1024*64,    -- Flush threshold (64MB)
    12,              -- Max level skip list, if using hash table is irrelevant
    0.24,            -- Probability skip list, if using hash table is irrelevant
    true,            -- Enable compression
    db.COMPRESS_SNAPPY, -- Compression algorithm can be NO_COMPRESSION, COMPRESS_SNAPPY, COMPRESS_LZ4, COMPRESS_ZSTD
    true,               -- Enable bloom filter
)
-- Put key-value pair into the database
code, message = db:put("my_column_family", "key", "value", 3600)
-- Get the value for the key
code, message, value = db:get("my_column_family", "key")
-- Delete the key-value pair
db:delete("my_column_family", "key")
-- Create a cursor for iterating over key-value pairs
code, message, cursor = db:cursor_init("my_column_family")
assert(code == 0, message)
-- Move cursor to next key-value pair
code, message = cursor:next()
assert(code == 0, message)
-- Get current key-value pair
code, message, value = cursor:get()
assert(code == 0, message)
-- Move cursor to previous key-value pair
code, message = cursor:prev()
assert(code == 0, message)
-- Free cursor when done
code, message = cursor:free()
assert(code == 0, message)
--- Close the database
lib.close(db)