Download the PHP package kafkiansky/phpclick without Composer
On this page you can find all versions of the php package kafkiansky/phpclick. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download kafkiansky/phpclick
More information about kafkiansky/phpclick
Files in kafkiansky/phpclick
Informations about the package phpclick
Installation
This package can be installed as a Composer dependency.
This package requires PHP 8.2 or later.
Usage
- From memory
- From resource
- Query builder
- Types
From Memory
This client is designed to be inserted into clickhouse in large batches. RowBinary
mode is used for insertion.
This means that you must know the types of table columns and their order.
For example, let's look at the following table DDL:
You can insert directly from memory using Row
:
From resource
Or accumulate data in a file and then paste data from it:
Query builder
You can use a simple query builder (insert-only) instead of a query string:
Types
All available clickhouse types are listed below:
ClickHouse Type | API Type |
---|---|
Bool |
\Kafkiansky\PHPClick\Column::bool |
Int8 |
\Kafkiansky\PHPClick\Column::int8 |
Uint8 |
\Kafkiansky\PHPClick\Column::uint8 |
Int16 |
\Kafkiansky\PHPClick\Column::int16 |
Uint16 |
\Kafkiansky\PHPClick\Column::uint16 |
Int32 |
\Kafkiansky\PHPClick\Column::int32 |
Uint32 |
\Kafkiansky\PHPClick\Column::uint32 |
Int64 |
\Kafkiansky\PHPClick\Column::int64 |
Uint64 |
\Kafkiansky\PHPClick\Column::uint64 |
Float32 |
\Kafkiansky\PHPClick\Column::float32 |
Float64 |
\Kafkiansky\PHPClick\Column::float64 |
String |
\Kafkiansky\PHPClick\Column::string |
DateTime |
\Kafkiansky\PHPClick\Column::dateTime |
DateTime64 |
\Kafkiansky\PHPClick\Column::dateTime64 |
Nullable |
\Kafkiansky\PHPClick\Column::nullable |
Map |
\Kafkiansky\PHPClick\Column::map |
Array |
\Kafkiansky\PHPClick\Column::array |
Testing
License
The MIT License (MIT). See License File for more information.