postgres operation + progressbar + wav file
lazarus / 16-Databases

----------------------------------------------------------------------
nicolas_lazarus · 2012-03-16 00:05

Hi all ,

Is it possible to show the progress of a insert/update operation in a
progressbar ?  The data type is bytea for a wav file.
Maybe someway to read the number of bytes transferred to the database?

Thanks in advance,

Nicolás

----------------------------------------------------------------------
ludob · 2012-03-16 07:40

The only possible solution I see is to transfer your bytea in chuncks.
Split your file in say 64k block and transfer them to the database
with:
Code: [Select]insert into wavs (data,id) values (xyz,chunk1)
repeat
update wavs set data = data || chunkn where id=xyz
until finished
If you want to do the same for reading the wav's back from the
database, change your table layout to store the numbered chuncks
instead of the complete wavs.