floatfile

pig build pkg floatfile;		# build deb

pig repo add pgsql -u   # add both repo and update cache

pig install floatfile;		# install via package name, for the active PG version

pig install floatfile -v 18;   # install for PG 18
pig install floatfile -v 17;   # install for PG 17
pig install floatfile -v 16;   # install for PG 16
pig install floatfile -v 15;   # install for PG 15
pig install floatfile -v 14;   # install for PG 14

CREATE EXTENSION floatfile;

SELECT save_floatfile('my_data', ARRAY[1.0, 2.0, 3.0, 4.0]::float[]);

SELECT load_floatfile('my_data');
-- {1,2,3,4}

SELECT extend_floatfile('my_data', ARRAY[5.0, 6.0]::float[]);

SELECT drop_floatfile('my_data');

SELECT save_floatfile('my_ts', 'my_data', ARRAY[1.0, 2.0]::float[]);
SELECT load_floatfile('my_ts', 'my_data');
SELECT extend_floatfile('my_ts', 'my_data', ARRAY[3.0]::float[]);
SELECT drop_floatfile('my_ts', 'my_data');

SELECT floatfile_to_hist('my_data', 0.0, 1.0, 10);
-- Returns int[] with histogram counts

SELECT floatfile_to_hist2d('xs_file', 'ys_file', 0.0, 0.0, 1.0, 1.0, 10, 10);
-- Returns 2D int[] histogram