The Picodata development team is pleased to announce the release of Picodata 24.4, our core software product.
Key feature — Pgproto module that allows connecting to the Picodata cluster via PostgreSQL protocol:
picodata run --pg-listen localhost:5432
psql "user=postgres host=localhost port=5432 password=P@ssw0rd sslmode=disable"
CREATE TABLE ...
INSERT ...
SELECT ...New features of distributed Picodata SQL:
- CREATE INDEX and DROP INDEX commands
- CASE expression
- TRIM, TO_CHAR, TO_DATE functions
- common table expressions (CTE)
Configuration file in YAML format — a new way to configure instances and clusters in addition to environment variables and command-line arguments. Relevant features:
picodata config defaultcommand generates the contents of a configuration file with default parameter valuespicodata run --configoption provides a path to the configuration filepicodata run -coption selectively overrides configuration file parameters
See the full list of changes in the CHANGELOG for this release.
Get a hand on Picodata 24.4 by downloading the pre-built packages for supported Linux distributions in the download section at our site.
You can find installation advisory as well as documentation for installing software, creating instances, cluster configuration and deployment at our dedicated documentation site.
Send your feedback and get in touch with Picodata developers in our Telegram chat at @picodataen or @picodataru.
