Kurdakov Alexander authored 1 year ago and Yaroslav Dynnikov committed 1 year ago

pico.whoami() returns new field tier

Transferred replication factor from Properties table to new Tier table

Instance and Replicaset belongs to tier via new field tier in _pico_instance and _pico_replicaset

New cli option init-cfg with path to configuration file in yaml format. For now contains only info about tiers.

BREAKING CHANGE!:
- pico.trace() function was removed. Use pico.sql() for tracing;
- opentelemetry tables __SBROAD_STAT and __SBROAD_QUERY were renamed
  into _SQL_STAT and _SQL_QUERY tables.

Introduce enrypoints for extended PG protocol:

- pg_bind: bind parameters to portal (IR) by descriptor;
- pg_close: remove portal from the storage by descriptor;
- pg_describe: get the portal metadata and type by descriptor;
- pg_execute: execute portal by descriptor;
- pg_parse: parse an SQL pattern into IR (reusing LRU),
  save IR into portal storage and return the descriptor;
- pg_portals: get a list of portal descriptors visible
  to the current user;

Co-authored-by: Kaitmazian Maksim <m.kaitmazian@picodata.io>

feat: add tests for tables format and parameters len, fix bucket_id calculation, add support of is_nullable sql metadata

Дмитрий Кольцов authored 1 year ago and Yaroslav Dynnikov committed 1 year ago

This commit introduces the first iteration of Picodata Web UI.
It lacks a lot of features and also indulges a lot of technically
imperfect decisions. Those are supposed to be addressed later.

Allow connecting interactive console over a unix socket `picodata run
--console-sock`. Use `picodata connect --unix` to connect.

Now it is possible to drop sharded tables with pico.sql() Lua
function.

Adds support for creation of the sharded memtx spaces via pico.sql().

Dmitry Travyan authored 1 year ago and Yaroslav Dynnikov committed 1 year ago

The following commands are affected:

- `picodata connect [user@][host][:port]`
- `picodata run --peer`
- `picodata run --listen`
- `picodata run --http-listen`
- `picodata run --advertise`
- `picodata expel --peer`

Only `picodata connect` respects the username. Other options just ignore
it.

- Provide new `struct Address`
- Replace `try_parse_address` function with `impl FromStr for Address`.
- Provide both unit and pytests