Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #123

Re: In need of advise abo

Show all headers | View raw

  To: comp.lang.java.databases
On Sat, 17 May 2008 00:13:32 -0700, BoBi wrote:

> 
> Thanks a lot all of you. I was struggling with the same question.
> Since most of my blobs are well below 2 MB I'll use my mysql db.
>
Another datapoint: I'm doing the same (CLOBs in the database) but with
Postgres. It is fast and has been easy to program and use. I have only one
caveat: I'm storing e-mails and have found that some characters found in
mail headers don't play nicely with the backup/restore utility.

The bug has been reported, but I'm working on a custom approach too. I'll
back up the address index tables, which can be modified and carry
additional information such as 'never archive' flags, to a CSV file and
copy the messages to an mbox file. Quite apart from solving the Postgres
restore problem this makes me independent of the database implementation
in case I want to move to Derby. Recovery then consists of using the
normal loader to restore the messages before updating the addresses from
the CSV file.


-- 
martin@   | Martin Gregorie
gregorie. | 
org       | Zappa fan & glider pilot

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

Re: In need of advise abo "Martin Gregorie" <martin.gregorie@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000

csiph-web