`SQLite` as input/output format. · Issue #33763 · ClickHouse/ClickHouse · GitHub
Skip to content

SQLite as input/output format. #33763

Description

@alexey-milovidov

Use case

One random guy asked it on the internet.

Describe the solution you'd like

On output it will create SQLite database with a single table named table.
On input it will read SQLite database and pick the first table from it.

Most likely it has to be read from seekable file.
Most likely it will require to substitute some wrapper around ReadBuffer/WriteBuffer to make SQLite work.
Alternatively it can work by slurping it into memory.

Additional notes

Do you know that we alrady have SQLite as table and database engines?

Metadata

Metadata

Assignees

No one assigned

    Labels

    comp-formatsInput/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).featureminorPriority: minor

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions