surrealdb-python

Expected outcome:

• Create two users first:
• await db.create('person:alice', {'name': 'Alice'})
• await db.create('person:bob', {'name': 'Bob'})
• Create a knows relationship between them:
• await db.query("RELATE person:alice->knows->person:bob SET since = '2024-01-01'")
• Find friends of friends using multi-hop traversal:
• result = await db.query("SELECT ->knows->person->knows->person AS friends_of_friends FROM person:alice")

Expected outcome:

• First define your schema:
• await db.query("DEFINE TABLE documents SCHEMAFULL")
• Generate and store embedding with your model:
• embedding = model.encode(text).tolist()
• await db.create('documents', {'content': text, 'embedding': embedding})
• Search using KNN:
• SELECT * FROM documents WHERE embedding <|5|> $query_vector

Expected outcome:

• Start a live query on a table:
• live_id = await db.live('user')
• Subscribe to notifications:
• async for notification in db.subscribe_live(live_id):
• print(f"Change: {notification['action']} - {notification['result']}")
• Stop when done:
• await db.kill(live_id)