Try Opteryx

Quick Start

This guide will help you get started with Opteryx quickly.

Your First Query

Here's a simple example to get you started with Opteryx:

import opteryx

# Execute a simple query
result = opteryx.query("SELECT 'Hello, Opteryx!' AS greeting")

# Display the results
for row in result:
    print(row)

Working with Data

Querying In-Memory Data

You can query data from Python data structures:

import opteryx

# Create sample data
data = [
    {"name": "Alice", "age": 30},
    {"name": "Bob", "age": 25},
    {"name": "Charlie", "age": 35}
]

# Query the data
result = opteryx.query("""
    SELECT name, age 
    FROM $data 
    WHERE age > 25
""", variables={"data": data})

# Print results
for row in result:
    print(f"{row['name']} is {row['age']} years old")

Basic SQL Operations

SELECT Queries

import opteryx

# Simple SELECT
result = opteryx.query("SELECT 1 AS number, 'test' AS text")

Filtering Data

import opteryx

# Using WHERE clause
result = opteryx.query("""
    SELECT * 
    FROM my_data 
    WHERE column_name = 'value'
""")

Next Steps

Now that you've learned the basics, you can:

  • Explore more complex SQL queries
  • Learn about connecting to different data sources
  • Check out advanced features and optimizations

Need Help?

If you encounter any issues, please visit our GitHub repository or check the documentation for more detailed information.