[SLUG] Handling Berkeley databases

[Howard Lowndes]

What sort of utilities are there for handling Berkeley databases other
than the db_* range.

db_dump -p gives me printable output but I still get the \0d\0a coming
out as such rather than as a new line, and I can't seem to get a pipe
into sed to fix it.

-- 
Howard.
LANNet Computing Associates;
Your Linux people 
--
"When you just want a system that works, you choose Linux;
when you want a system that just works, you choose Microsoft."
--
"Flatter government, not fatter government;
Get rid of the Australian states."


-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html

Re: [SLUG] Handling Berkeley databases

[Grant Parnell]

On Mon, 21 Mar 2005, Howard Lowndes wrote:

> What sort of utilities are there for handling Berkeley databases other
> than the db_* range.
> 
> db_dump -p gives me printable output but I still get the \0d\0a coming
> out as such rather than as a new line, and I can't seem to get a pipe
> into sed to fix it.

Well there's interfaces to various programming languages - such as 
perl-DBI (we use for MySQL but works for BDB + others). 

I wonder if you've tried something like
db_dump -p dbname | tr -d "\r"
db_dump -p dbname | dos2unix
I guess it depends on exactly how often you get , every line, 
mid-row, some lines etc.

Another thought is you might find you can convert to something like a TAB 
delimited file which may or may not help. It certainly won't if your line 
breaks are mid-row.

-- 
--
** ROOM FOR RENT $120pw (neg) near Newington Shops 525/401 buses **
Electronic Hobbyist, Former Arcadia BBS nut, Occasional nudist, 
Linux Guru, SLUG Secretary, AUUG and Linux Australia member, Sydney 
Flashmobber, Tenpin Bowler, BMX rider, Walker, Raver & rave music 
lover, Big kid that refuses to grow up. I'd make a good family pet, 
take me home today!
Some people actually read these things it seems.

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html