---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there
title: lastra
excerpt: |
  DuckDB Community Extensions
  Reader for the Lastra columnar time-series format

extension:
  name: lastra
  description: Reader for the Lastra columnar time-series format
  version: 0.2.0
  language: C++
  build: cmake
  license: Apache-2.0
  maintainers:
    - mrmx

repo:
  github: QTSurfer/duckdb-lastra
  ref: 984d6be30ecf91135a5377da904695ed66f55cf3

docs:
  hello_world: |
    SELECT * FROM read_lastra('data.lastra') LIMIT 10;
  extended_description: |
    Reads Lastra (.lastra) columnar time-series files with per-column codec
    selection. Designed for financial tick data (OHLCV), IoT sensor readings,etc.
    
    Supported codecs: ALP (adaptive lossless floating-point), Gorilla (XOR),
    Pongo (decimal-aware), delta-varint (timestamps), ZSTD (binary).

    Features row groups with per-group timestamp statistics for efficient
    temporal range queries — only row groups overlapping the WHERE clause
    are decoded.

extension_star_count: 0
extension_star_count_pretty: 0
extension_download_count: 772
extension_download_count_pretty: 772
image: '/images/community_extensions/social_preview/preview_community_extension_lastra.png'
layout: community_extension_doc
---

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}

### Added Functions

<div class="extension_functions_table"></div>

| function_name  | function_type | description | comment | examples |
|----------------|---------------|-------------|---------|----------|
| lastra_version | scalar        | NULL        | NULL    |          |
| read_lastra    | table         | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

This extension does not add any settings.