Re: [GENERAL] Storing jpgs
I've found bytea works better for me than large objects. As far as how to retrieve and display, that depends. What scripting language are you using? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of C G > Sent: Monday, April 05, 2004 12:20 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] Storing jpgs > > > Dear All, > > What's the best way to store jpgs in postgresql to use in a web page? > > I tried to use large objects, but how would you extract them from > a table to > be viewed in a web-page without having to write them to a scratch file > somewhere first? > > Thanks > > Colin > > _ > Stay in touch with absent friends - get MSN Messenger > http://www.msn.co.uk/messenger > > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) > > ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Data Corruption in case of abrupt failure
Does anyone know the equivalent to hdparm on FreeBSD? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of scott.marlowe > Sent: Wednesday, March 17, 2004 11:27 AM > To: Tom Lane > Cc: Keith C. Perry; Stephen Robert Norris; satish satish; > [EMAIL PROTECTED] > Subject: Re: [GENERAL] Data Corruption in case of abrupt failure > > > On Tue, 16 Mar 2004, Tom Lane wrote: > > > "Keith C. Perry" <[EMAIL PROTECTED]> writes: > > > I've read threads like this before and because I've never lost data on > > > servers with IDE drives after doing some basic torture tests > > > (e.g. pulling the plug in the middle of an update et al), I don't > > > think I've paid close enough attention. > > > > On many IDE drives it is possible to turn write caching on and off with > > some incantation involving "hdparm" (don't have the details but you can > > probably find 'em in the list archives). Possibly your system is > > already configured safely. > > hdparm -W0 /dev/hda > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: Triggers, Stored Procedures, PHP. was: Re: [GENERAL] PostgreSQL Advocacy, Thoughts and Comments
Paul Thomas wrote: > > > > On 28/11/2003 17:10 Jason Tesser wrote: > > [snip] > > > > MySQL cannot even handle > > sub-queries yet. I also use Python for standalone interfaces to > the data. > > > > Why should I not be able to use the same views and triggers etc > in there > > that I use for my web apps. PHP is quite powerful if used correctly. > > You are, of course, free to do whatever want. But if you have to use > features of the database to compensate for inadequacies in your > programming language maybe you should be using another language? This doesn't even make sense in the context of Jasons remark. > > > Java has its own issues and I am not sure it is as far supiour as you > > are claming it is. But that is not for this dscussion. > > I'm not aware of any "issues" with Java (unless you mean Swing ;)). > > MySQL may be more > > popular with (cheap) web hosting places but that doesn't mean it is the > > best > > or that Postgres wouldn't serve better even in this area. I am glad > > to see the article written for PHP mag as Postgres would help > alot of PHP > > guys that are using MySQL. > > Much of the populatity of MySQL seems to stem from PHPs out-of-the-box > support for it. With the MySQL client library license change, this > situation will probably change. There was a long thread about > this earlier > this year. Check the archives. > > This is incorrect. The embedded mysql client library was not added until PHP4.0 RC1. PHP's popularity existed long before this. The real culprit causing the popularity of MySQL was it's ubiquity among hosting providers and the virtual non-existence of PG in that arena. If PG had been more friendly to shared hosting environments, perhaps this situation wouldn't have arisen. Blaming PHP for this situation (and your other comments) show extreme prejudice. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
