iqlabs-solana-sdk 0.1.9

IQLabs Solana SDK for Python — on-chain data storage, database tables, and connections

IQLabs SDK (Python)

Draft: This document is in progress and will be refined.

---

Table of Contents

1. Core Concepts

   • Data Storage (Code In)
   • User State PDA
   • Connection PDA
   • Database Tables

2. Function Details

   • Data Storage and Retrieval
   • Connection Management
   • Table Management
   • Environment Settings

2.1. Advanced Functions (list only)

---

Core Concepts

These are the key concepts to know before using the IQLabs SDK.

---

Data Storage (Code In)

This is how you store any data (files, text, JSON) on-chain.

How is it stored?

Depending on data size, the SDK picks the optimal method:

• Small data (< 700 bytes): store immediately, fastest
• Medium data (< 8.5 KB): split into multiple transactions
• Large data (>= 8.5 KB): upload in parallel for speed

Key related functions

• code_in(): upload data and get a transaction ID
• read_code_in(): read data back from a transaction ID

---

User State PDA

An on-chain profile account for a user.

What gets stored?

• Profile info (name, profile picture, bio, etc.)
• Number of uploaded files
• Friend request records

Note: Friend requests are not stored as values in the PDA; they are sent as transactions.

When is it created?

It is created automatically the first time you call code_in(). No extra setup is required, but the first user may need to sign twice.

---

Connection PDA

An on-chain account that manages relationships between two users (friends, messages, etc.).

What states can it have?

• pending: a friend request was sent but not accepted yet
• approved: the request was accepted and the users are connected
• blocked: one side blocked the other

Important: A blocked connection can only be unblocked by the blocker.

Key related functions

• request_connection(): send a friend request (creates pending)
• manage_connection(): approve/reject/block/unblock a request
• read_connection(): check current relationship status
• write_connection_row(): exchange messages/data with a connected friend
• fetch_user_connections(): fetch all connections (sent & received friend requests)

---

Database Tables

Store JSON data in tables like a database.

How are tables created?

There is no dedicated "create table" function. The first write via write_row() creates the table automatically.

Note: A table is uniquely identified by the combination of db_root_id and table_seed (table name).

Key related functions

• write_row(): add a new row (creates the table if missing)
• read_table_rows(): read rows from a table
• get_tablelist_from_root(): list all tables in a database
• fetch_inventory_transactions(): list uploaded files

---

Function Details

Data Storage and Retrieval

code_in()

Parameters	connection: Solana RPC AsyncClient signer: Keypair or WalletSigner chunks: data to upload (list[str]) filename: optional filename (str or None) method: upload method (int, default: 0) filetype: file type hint (str, default: '') on_progress: optional progress callback (Callable[[int], None])
Returns	Transaction signature (str)

Example:

from iqlabs import writer
from solana.rpc.async_api import AsyncClient
from solders.keypair import Keypair

# Upload data
signature = await writer.code_in(connection, signer, ['Hello, blockchain!'])

# Upload with filename
signature = await writer.code_in(connection, signer, ['file contents here'], filename='hello.txt')

---

read_code_in()

Parameters	tx_signature: transaction signature (str) speed: rate limit profile (optional, str) on_progress: optional progress callback (Callable[[int], None])
Returns	dict with metadata (str) and data (str or None)

Example:

from iqlabs import reader

result = await reader.read_code_in('5Xg7...')
print(result['data'])      # 'Hello, blockchain!'
print(result['metadata'])  # JSON string with file metadata

---

Connection Management

request_connection()

Parameters	connection: AsyncClient signer: Keypair db_root_id: database ID (bytes or str) party_a: first user pubkey (str) party_b: second user pubkey (str) table_name: connection table name (str or bytes) columns: column list (list[str or bytes]) id_col: ID column (str or bytes) ext_keys: extension keys (list[str or bytes])
Returns	Transaction signature (str)

Example:

from iqlabs import writer

await writer.request_connection(
    connection, signer, 'my-db',
    my_wallet_address, friend_wallet_address,
    'dm_table', ['message', 'timestamp'], 'message_id', []
)

---

manage_connection()

Note: There is no high-level SDK wrapper for this function. Use the contract-level instruction builder directly.

Parameters	builder: InstructionBuilder accounts: dict with db_root, connection_table, signer args: dict with db_root_id, connection_seed, new_status
Returns	Instruction

Example:

from iqlabs import contract

# Create an instruction builder
builder = contract.create_instruction_builder(contract.PROGRAM_ID)

# Approve a friend request
approve_ix = contract.manage_connection_instruction(
    builder,
    {"db_root": db_root, "connection_table": connection_table, "signer": my_pubkey},
    {"db_root_id": db_root_id, "connection_seed": connection_seed, "new_status": contract.CONNECTION_STATUS_APPROVED}
)

# Block a user
block_ix = contract.manage_connection_instruction(
    builder,
    {"db_root": db_root, "connection_table": connection_table, "signer": my_pubkey},
    {"db_root_id": db_root_id, "connection_seed": connection_seed, "new_status": contract.CONNECTION_STATUS_BLOCKED}
)

---

read_connection()

Parameters	db_root_id: database ID (bytes or str) party_a: first wallet (str) party_b: second wallet (str)
Returns	dict with status, requester, blocker

Example:

from iqlabs import reader

conn_info = await reader.read_connection('my-db', party_a, party_b)
print(conn_info['status'])  # 'pending' | 'approved' | 'blocked'

---

write_connection_row()

Parameters	connection: AsyncClient signer: Keypair db_root_id: database ID (bytes or str) connection_seed: connection seed (bytes or str) row_json: JSON data (str)
Returns	Transaction signature (str)

Example:

from iqlabs import writer
import json

await writer.write_connection_row(
    connection, signer, 'my-db', connection_seed,
    json.dumps({"message_id": "123", "message": "Hello friend!", "timestamp": 1234567890})
)

---

fetch_user_connections()

Fetch all connections (friend requests) for a user by analyzing their UserState PDA transaction history. Each connection includes its db_root_id, identifying which app the connection belongs to.

Parameters	user_pubkey: user public key (str or Pubkey) limit: max number of transactions to fetch (optional) before: signature to paginate from (optional) speed: rate limit profile (optional)
Returns	List of connection dicts with db_root_id, connection_pda, party_a, party_b, status, requester, blocker, timestamp

Example:

from iqlabs import reader

connections = await reader.fetch_user_connections(
    my_pubkey,
    speed="light",
    limit=100
)

# Filter by status
pending_requests = [c for c in connections if c['status'] == 'pending']
friends = [c for c in connections if c['status'] == 'approved']
blocked = [c for c in connections if c['status'] == 'blocked']

# Check connection details
for conn in connections:
    print(f"Party A: {conn['party_a']} <-> Party B: {conn['party_b']}, status: {conn['status']}")

---

update_user_metadata()

Parameters	connection: AsyncClient signer: Keypair db_root_id: database ID (bytes or str) meta: metadata to store (bytes or str)
Returns	Transaction signature (str)

Example:

from iqlabs import writer

# Store a codeIn tx signature as user metadata
tx_sig = await writer.update_user_metadata(
    connection, signer, 'my-db', meta_tx_signature
)

---

Table Management

write_row()

Parameters	connection: AsyncClient signer: Keypair db_root_id: database ID (bytes or str) table_seed: table name (bytes or str) row_json: JSON row data (str) skip_confirmation: skip tx confirmation (default: False)
Returns	Transaction signature (str)

Example:

from iqlabs import writer
import json

# Write the first row to create the table
await writer.write_row(connection, signer, 'my-db', 'users', json.dumps({
    "id": 1, "name": "Alice", "email": "[e-mail]"
}))

# Add another row to the same table
await writer.write_row(connection, signer, 'my-db', 'users', json.dumps({
    "id": 2, "name": "Bob", "email": "[e-mail]"
}))

---

read_table_rows()

Parameters	account: table PDA (Pubkey or str) before: signature cursor for pagination (optional) limit: max number of rows to fetch (optional) speed: rate limit profile (optional)
Returns	list[dict]

Example:

from iqlabs import reader

# Basic usage
rows = await reader.read_table_rows(table_pda, limit=50)

# Cursor-based pagination
older_rows = await reader.read_table_rows(table_pda, limit=50, before="sig...")

---

get_tablelist_from_root()

Parameters	connection: AsyncClient db_root_id: database ID (bytes or str)
Returns	dict with root_pda, creator, table_seeds, global_table_seeds

Example:

from iqlabs import reader

result = await reader.get_tablelist_from_root(connection, 'my-db')
print('Creator:', result['creator'])
print('Table seeds:', result['table_seeds'])

---

fetch_inventory_transactions()

Parameters	public_key: user public key (Pubkey) limit: max count (int) before: pagination cursor (optional, str)
Returns	Transaction list

Example:

from iqlabs import reader
import json

my_files = await reader.fetch_inventory_transactions(my_pubkey, 20)
for tx in my_files:
    metadata = None
    try:
        metadata = json.loads(tx['metadata'])
    except:
        metadata = None

    if metadata and 'data' in metadata:
        inline_data = metadata['data'] if isinstance(metadata['data'], str) else json.dumps(metadata['data'])
        print(f"Inline data: {inline_data}")
    else:
        print(f"Signature: {tx['signature']}")

---

Environment Settings

set_rpc_url()

Parameters	url: Solana RPC URL (str)
Returns	None

Example:

from iqlabs import set_rpc_url

set_rpc_url('https://your-rpc.example.com')

---

Advanced Functions

These functions are advanced/internal, so this doc lists them only. For details, please see our developer docs.

• manage_row_data() (writer)
• read_user_state() (reader)
• read_inventory_metadata() (reader)
• get_session_pda_list() (reader)
• derive_dm_seed() (utils)
• to_seed_bytes() (utils)

---

Additional Resources

• IQLabs Official X
• IQLabs Official Website