Make `ArrayParser` internal and prevent multiple create instance of it

[vjik]

1) Suggest make ArrayParser as internal. Users don't must use this class directly, it'sright? (#297 (comment))

2. For each type casting of string values created new instance of ArrayParser.

db-pgsql/src/ColumnSchema.php

Lines 107 to 112 in 56df5ac

	public function phpTypecast(mixed $value): mixed
	{
	if ($this->dimension > 0) {
	if (is_string($value)) {
	$value = $this->getArrayParser()->parse($value);
	}

It would be good prevent this behavior and create instance of ArrayParser once or make ArrayParser methods static.

Similar case: #303 (comment)

[terabytesoftw]

1. Suggest make ArrayParser as internal. Users don't must use this class directly, it'sright?
2. For each type casting of string values created new instance of ArrayParser.

db-pgsql/src/ColumnSchema.php

Lines 107 to 112 in 56df5ac

	public function phpTypecast(mixed $value): mixed
	{
	if ($this->dimension > 0) {
	if (is_string($value)) {
	$value = $this->getArrayParser()->parse($value);
	}

It would be good prevent this behavior and create instance of ArrayParser once or make ArrayParser methods static.

getArrayParser() return new ArrayParser().

Always returns a new instance.

db-pgsql/src/ColumnSchema.php

Line 155 in 56df5ac

protected function getArrayParser(): ArrayParser

[vjik]

getArrayParser() return new ArrayParser().

And creates new instance every time.

[terabytesoftw]

getArrayParser() return new ArrayParser().

And creates new instance every time.

yes, that's not a problem, it just resolves the value, it's not saved anywhere.

[vjik]

yes, that's not a problem, it just resolves the value, it's not saved anywhere.

Why create instance every time?
Many times - for each type casting.

[terabytesoftw]

yes, that's not a problem, it just resolves the value, it's not saved anywhere.

Why create instance every time? Many times - for each type casting.

But that's not a problem, as i tell you the object is not saved, it only resolves the value.

[terabytesoftw]

yes, that's not a problem, it just resolves the value, it's not saved anywhere.

Why create instance every time? Many times - for each type casting.

But that's not a problem, as i tell you the object is not saved, it only resolves the value.

It's like widgets, they always create an object, and resolve its value to a string.

[samdark]

Should be a good optimization. Worth benchmarking.

[terabytesoftw]

Btw array parser cannot be internal, Db is an abstraction and you may need it for an extension.

[vjik]

Btw array parser cannot be internal, Db is an abstraction and you may need it for an extension.

ArrayParser used in specific implementation for PostgreSQL. When might it be needed somewhere else?

[terabytesoftw]

Simple, if I create my own db-pgsql implementation, or just create the PGSQL NON-PDO implementation, for example.

Everything cannot be within the framework, there will be extensions.

[vjik]

Simple, if I create my own db-pgsql implementation, or just create the PGSQL NON-PDO implementation, for example.

Everything cannot be within the framework, there will be extensions.

It's will be extension of yiisoft/db, not yiisoft/db-pgsql. Array parser is not goal of this package, I don't think that yiisoft/db-pgsql should provide it.

[Tigrov]

The parser can potentially be used for in-project optimization.

For example:

$intArray = $command->setSql('SELECT int_array FROM some_table')->queryScalar();
$parsedArray = (new ArrayParser())->parse($intArray);
$castArray = array_map('intval', $parsedArray);

instead of $castArray = $column->phpTypecast($intArray).

[vjik]

The parser can potentially be used for in-project optimization.

Agree. This is good case.

[smirnov-e]

can potentially be used for in-project optimization.

It's not optimisation, but the only way to get array from raw responses :(