# Changelog

All notable changes to this project will be documented in this file.

The format is based on [Keep a Changelog](https://keepachangelog.com/en/1.1.0/),
and this project adheres to [Semantic Versioning](https://semver.org/spec/v2.0.0.html).

## [Unreleased](https://codeberg.org/kdwarn/pgtui/compare/v0.10.0...HEAD)

## [0.10.0](https://codeberg.org/kdwarn/pgtui/compare/v0.9.0...v.0.10.0) - 2026-02-01

### Added

* More Postgres data types/spellings of data types converted to Toml representations and therefore handled:
  * additional string types
  * time (by itself, rather than as part of datetime)

### Changed

* Include row count in status area when viewing data.
* Viewing records in an editor is now possible on all tables, not just those with primary keys. (Deleting and editing records still requires those tables to have a primary key.)

### Fixed

* A trailing semi-colon in where clause filtering would cause query to return no results; it is now trimmed off if it is included.
* Postgres float types are now handled correctly. Previously, `real` and `numeric` conversion would fail or be incorrect.
* Postgres `timestamp with time zone` types are now handled correctly; previously they were treated the same as `timestamp without time zone`.

## [0.9.0](https://codeberg.org/kdwarn/pgtui/compare/v0.8.3...v.0.9.0) - 2026-01-20

### Added

* View-only method of opening a record in text editor
* More data types/spellings of data types

## [0.8.3](https://codeberg.org/kdwarn/pgtui/compare/v0.8.2...v0.8.3) - 2026-01-19

### Fixed

* Screen clearing/redrawing was not being done after editor opened in some (most?) terminals, and then abandoned. (Previous fix only handled saving without abandoning edit.)

## [0.8.2](https://codeberg.org/kdwarn/pgtui/compare/v0.8.1...v0.8.2) - 2026-01-19

### Changed

* Include the relation filters in the Relation pane's title.

### Fixed

* Screen clearing/redrawing was not being done after editor opened in some (most?) terminals.
* Previously, `Esc` in the Relation pane only cleared the relation name filter, now it also clears the relation type filter.

## [0.8.1](https://codeberg.org/kdwarn/pgtui/compare/v0.8.0...v0.8.1) - 2026-01-18

### Fixed

Insert was broken if a table had no existing data or it hadn't yet been viewed. In implementing the fix for this, a number of improvements were also made to the code to make it simpler, less redundant, and more idiomatic.

## [0.8.0](https://codeberg.org/kdwarn/pgtui/compare/v0.7.0...v0.8.0) - 2026-01-17

### Added

* Ability to filter by relation name
* Control to clear filters
* Controls to go to first page and last page of results

### Changed

* Improve handling of decoding error and indicate when it occurs
* More explicit title/label of the right pane: either "Data Definition" or "Data" rather than just "Main" for both modes
* Indicate null and unparsed values with colored text

## [0.7.0](https://codeberg.org/kdwarn/pgtui/compare/v0.6.0...v0.7.0) - 2026-01-13

### Added

* Ability to use default values when inserting or updating
* Handle boolean types

### Changed

* Abandoning an insert or update is now simpler and will always result in abandonment. Previously, there was a very unlikely scenario where the insert/update could still occur. 
* Comment out unhandled data types in editor, add warning that including values for them could cause error.

## [0.6.0](https://codeberg.org/kdwarn/pgtui/compare/v0.5.0...v0.6.0) - 2026-01-10

### Added

* Filter records with a where clause.
* Ability to make arrays empty.
* Ability to change a nullable value from non-null to null.

### Fixed

* Handle additional errors - show message rather than crash.

## [0.5.0](https://codeberg.org/kdwarn/pgtui/compare/v0.4.0...v0.5.0) - 2025-12-07

### Added

* Sort in reverse order

### Changed

* Default to `vi` rather than `vim` if env var not set.

### Fixed

* Improved performance
* Improved docs
* Fixed various bugs

## [0.4.0](https://codeberg.org/kdwarn/pgtui/compare/v0.3.0...v0.4.0) - 2025-10-26

### Added

* Ability to edit records
* Ability to delete records
* Ability to sort (simple, one way) by field
* Pagination of data
* Ability to horizontally scroll data definition

### Changed

* Improved display of records
* Improved messaging to user
* Make navigation more consistent
