# AWS Lambda Layer for DuckDB Python

A pre-built AWS Lambda Layer containing DuckDB for Python, making it easy to use DuckDB in your Lambda functions without worrying about package size limits or architecture.

## Overview

This project provides ready-to-use Lambda layers containing DuckDB Python bindings, optimized for AWS Lambda runtime environments.

### Features (Preview)

- 🚀 **Pre-built and optimized** for AWS Lambda Python runtimes
- 🌍 **Multi-region support** - Available in all AWS regions
- 🏗️ **Multiple architectures** - Support for both x86_64 and ARM64
- 📦 **Easy integration** - Just add the layer ARN to your Lambda function
- 🔄 **Automated builds** - Continuously updated with latest DuckDB versions
- 🆓 **Public layers** - No AWS account restrictions

## Quick Start

1. **Add the layer to your Lambda function:**

   ```bash
   # Using AWS CLI
   aws lambda update-function-configuration \
     --function-name your-function-name \
     --layers LAYER_ARN
   ```

2. **Use DuckDB in your Lambda function:**

   ```python
   import duckdb

   def lambda_handler(event, context):
       # Create an in-memory database
       conn = duckdb.connect(':memory:')

       # Execute a query
       result = conn.execute("SELECT 'Hello DuckDB!' as message").fetchall()

       return {
           'statusCode': 200,
           'body': result[0][0]
       }
   ```

## DuckDB layers

### Usage

To use the DuckDB layer in your Lambda function, add the appropriate layer ARN to your function configuration.

You can find the complete list of layer ARNs in the [data/arns.json](data/arns.json) file.

### Compatibility

<!-- COMPATIBILITY-LIST:START -->

| DuckDB version | Python versions | Architectures |
| -------------- | --------------- | ------------- |
| 0.9.0 | 3.8, 3.9, 3.10, 3.11 | arm64, x86_64 |
| 0.9.1 | 3.8, 3.9, 3.10, 3.11 | arm64, x86_64 |
| 0.9.2 | 3.8, 3.9, 3.10, 3.11 | arm64, x86_64 |
| 0.10.0 | 3.8, 3.9, 3.10, 3.11, 3.12 | arm64, x86_64 |
| 0.10.1 | 3.8, 3.9, 3.10, 3.11, 3.12 | arm64, x86_64 |
| 0.10.2 | 3.8, 3.9, 3.10, 3.11, 3.12 | arm64, x86_64 |
| 0.10.3 | 3.8, 3.9, 3.10, 3.11, 3.12 | arm64, x86_64 |
| 1.0.0 | 3.8, 3.9, 3.10, 3.11, 3.12 | arm64, x86_64 |
| 1.1.0 | 3.8, 3.9, 3.10, 3.11, 3.12 | arm64, x86_64 |
| 1.1.1 | 3.8, 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.1.2 | 3.8, 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.1.3 | 3.8, 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.2.0 | 3.8, 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.2.1 | 3.8, 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.2.2 | 3.8, 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.3.0 | 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.3.1 | 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.3.2 | 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.4.0 | 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.4.1 | 3.9, 3.10, 3.11, 3.12, 3.13 | arm64, x86_64 |
| 1.4.2 | 3.9, 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |
| 1.4.3 | 3.9, 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |
| 1.4.4 | 3.9, 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |
| 1.4.5 | 3.9, 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |
| 1.5.0 | 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |
| 1.5.1 | 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |
| 1.5.2 | 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |
| 1.5.3 | 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |
| 1.5.4 | 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |
| 1.5.5 | 3.10, 3.11, 3.12, 3.13, 3.14 | arm64, x86_64 |

<!-- COMPATIBILITY-LIST:END -->

## Contributing

Contributions are welcome! Please feel free to submit issues and pull requests.

## License

This project is licensed under the MIT License - see the [LICENSE](LICENSE) file for details.