Ulozenie obrazkov do Postgress-databazy

Vladimir Rengevic vlado na grafon.sk
Pondělí Duben 16 09:18:38 CEST 2001


Dobry den,

potrebujem vytvorit databazu obrazkov. Vybral som si Postgress. A narazil
som an problem.
Aky typ je vhodny na ulozenie binarnych dat-obrazku (povedzme od 10 do 100
kB?).
V knihe p. Koska o PHP je zmienka, ze sa na to pouziva blob alebo image,
ale zavisi to od konkretneho servera (no a jasne, ze mne to hlasi chybu,
inak by som sa nepytal :-(
Hrabal som intenzivne v dokumentacii, ale nasiel som lem toto:
--------------------
Large Objects
The types discussed to this point are all "small" objects -- that is, they
are smaller than 8KB in size.

Note: 1024 longwords == 8192 bytes. In fact, the type must be considerably
smaller than 8192 bytes, since the Postgres tuple and page overhead must
also fit into this 8KB limitation. The actual value that fits depends on the
machine architecture.

If you require a larger type for something like a document retrieval system
or for storing bitmaps, you will need to use the Postgres large object
interface, or will need to recompile the Postgres backend to use internal
storage blocks greater than 8kbytes..
-------------------

Mam to brat ako holu skutocnost, alebo som nieco prehliadol. Pripadne ak by
to postgress neumoznoval jednoducho ulozit
da sa to v MySQL?

Vopred vdaka za kopnutie spravnym smerom. A este jedna prospa. Aka je adresa
na prihlasenie do konferencie o databazach?
Dnes nemam svoj den, ani toto sa mi nepodarilo najst, inac by tato otazka
bola tam ;-)

Vlado
----------------------------------------------------------
Ing. Vladimir Rengevic
GRAFON dtp studio
Tranovskoho 19, Liptovsky Mikulas, SLOVAKIA
tel.: +421/849/5526153, fax: +421/849/5621454



Další informace o konferenci Linux