Maybe you would want to check this file to get an idea what I am doing, and where am I at this point and how the script can be pretty reliably updated.

There is also the same page, but with expanded reasoning, so you could inspect what is actually happening "behind the scene".

What do you think once you read them?

Of course there is so much more to do. I have many functionalites on my mind in addition to that too, hahaha.

I will be away for sometime from updating the scripts.

Namely I am currently training my own LLM so I could ingest and store all the scripts (and other useful resources such as manuals etc) into my knowledge base, so I could later easier maintain scripts.

Other then http://mailmirdoch.net/index.php?topic=57.0 if you have other help resources saved somehow from the old forum NOT in pdf, please upload them here so I could import them to my LLM.

Thank you in advance.

Wow. This is way out of my league, and I admit I jsut have to wait for the final dll and how it applies on the outcome, preferably through some example.

Thanks for your commitment, though!

And now I have successfuly compilered a 64bit dll as UDF module which does the resize action automaticly

the function it self requieres
IMAGE_RESIZE("imgdata", 500, "imgformat", 78)
where
1. "imgdata" = our Blob field
2. 500 = max. desired size here: 500px (on the bigger side height or width)
3. "imgformat" = ('.jpg' or '.png') this makes diffrence
            (to find out the images format makes via the function makes it much slower so, as we got it allready, we send it as parameter)
4. 78 = compresion ratio (.jpg  only)

this dll has a view exceptions which satisfy my needs
... so do nothing if ...
1. ... the height = 700 px (this is the height of back covers to be readable)
2. ... the width = 970 px & height = 231 px (this is the width of banners)
   with on exepetion here (970:231 = an aspect ratio to approximately 4.2:1, so if width > 970 or <= 930 with equal aspect, then change it to width = 970 px)
3. ... the width = 500 px & height < 500 px
4. ... the height = 500 px & width < 500 px

currently i not made a Trigger for this resizing, in cause of testing with GET_IMAGE_WIDTH & GET_IMAGE_HEIGHT functions
may i have to put all together in 1 single UDF module

I will see

if every thing works as expected I will publish the moduls here

sty tuned meriator

hey afrocuban
I think you miss understood me
"connecting to a fbserver" makes the cominication between PVD an the DB faster. AT this point it has nothing to do with the images. fbserver (64 bit) runs faster then the embebed fb (32 bit) dill's.

the image problem is solved (in my case) in an other way

first i gave them names by setting the "imgpath"
with
SQL

UPDATE IMAGES i
SET "imgpath" = (
    SELECT m."title"
    FROM MOVIES m
    WHERE m."mid" = i."mid"
) || '_' || i."mid" || '_' || i."imgid" || i."imgformat"
WHERE EXISTS (
    SELECT 1
    FROM MOVIES m
    WHERE m."mid" = i."mid"
      AND i."imgpath" IS DISTINCT FROM (m."title" || '_' || i."mid" || '_' || i."imgid" || i."imgformat")
)
ROWS 10;

(you can set the ROWS 10 to ROWS 1000 or more)

I made a (64 bit) dll-file named 'image_udf.dll'
which is an UDF module and has to be placed in the
Firebird-Server->UDF(folder)
the two function of the module GET_IMAGE_WIDTH & GET_IMAGE_HEIGHT has to be declared via a Statement so that the FB-server gets aware of them

The task of the module is to read image-height and image-width from the blob-field "imgdata"

this is realized via a Trigger withhin the FB-server
on Inserts or Updates
so i have changed the old Trigger which only affected imgsize via OCTET_LENGTH (r. "Imgdata")
to also get "imgwidth"= GET_IMAGE_WIDTH(r."imgdata") & "imgheight" = GET_IMAGE_HEIGHT(r."imgdata")

a simple SQL-Statement like

Update IMAGES i set i."caption" = i."caption"
where i."imgheight" is NULL;

will update all data rows

and now i can easy find all images which are to big
except Back-Covers which are 700px in height
and banners  which are 970px in width
all my images should not exceed 500 px in height or  width


SELECT  m."mid", m."title", m."year",m."size", m."series",m."epid",m."wish",m."visible",
       i."imgid", i."imgformat",i."imgheight", i."imgwidth", i."imgsize", i."imgpath"
FROM IMAGES i
left join MOVIES m on (m."mid" = i."mid")
where  (i."imgheight" > 500 or i."imgwidth" > 500) and NOT (i."imgheight" = 700 or i."imgwidth" = 970)
ROWS 1000;


but still the image must be resized manualy

curently this is done automaticly (for new images) by php, as all my script run via a local proxy to my local server an back
the local server resizes each image to size configered in it's config file.
the local server and it's local proxy helps me a lot in managing the PVD-DB.

by the way a little schematic view on whats going on my PC using PVD-scripts

Quote from: meriator on  6 18 July, 2021, 06:46:17 PMso stay tunned

Hello meriator.

Just to let you know we are still tuned in waiting for your amazing work.

Quote from: meriator on 12 09 August, 2026, 12:17:18 AMhey afrocuban
you are right and you are wrong
PVD = 32 bit right
but
i use firebird as 64 bit version
and connecting PVD via Connect to Server (MainMenu-Option) (ConnectionString)
  ConnectionString = "localhost:C:\\YourFolder\YourDB.pvd"
and this makes it much faster
beside this many other Apps like a local webserver or FlameRobin can connect to the DB at the same time
Using the PVD embebed Firebird dlls blocks the DB-access for all other Apps

but u need Firebird 2.5 installed and runing
(hint: don't use any other/newer version it won't work with PVD)
give it a try

your welcome meriator 

Unfortunately this will not help with storing images out of or in PVD itself, since when connecting via fbserver, that option is not available - it is greyed out.

Quote from: meriator on 11 08 August, 2026, 11:51:28 PM@ Ivek
your are also admin now

sorry that i do not be here so much

but now you can act as your likes need it

by the way i have updated this forum from v2.1.4 to v 2.1.7
the curently up to date version

greetings meriator 

Thanks.

hey afrocuban
you are right and you are wrong
PVD = 32 bit right
but
i use firebird as 64 bit version
and connecting PVD via Connect to Server (MainMenu-Option) (ConnectionString)
  ConnectionString = "localhost:C:\\YourFolder\YourDB.pvd"
and this makes it much faster
beside this many other Apps like a local webserver or FlameRobin can connect to the DB at the same time
Using the PVD embebed Firebird dlls blocks the DB-access for all other Apps

but u need Firebird 2.5 installed and runing
(hint: don't use any other/newer version it won't work with PVD)
give it a try

your welcome meriator 

@ Ivek
your are also admin now

sorry that i do not be here so much

but now you can act as your likes need it

by the way i have updated this forum from v2.1.4 to v 2.1.7
the curently up to date version

greetings meriator