Simple Database for Shell Scripts

[Michael42]

Hello,

On a Sun Solaris 8 system I write many Bourne shell scripts. I am at the point where I need a simple database (like dBase etc.) for various tasks.

I think I have exhausted the "almost" databases with the help of awk,nawk,sed,grep and other UNIX string processing tools. I am trying to avoid syntax like:

MYSTRING=*&)(*&SDASDJS cut 0909 Dgrepas(SD*SDF {print $1} )D(DS)F(ODLKMFD)_FIDS<DSF DF)DS(grep=0DF_)(S+D_)grep|S()DF*)(SDJJ sed )SD(FS(

I am ideally looking for a script library that uses all the native Sun UNIX OS binaries (grep/sed/awk) in a more abstracted and easy to use syntax.

Can anyone make any recommendations on a simple database for shell script usage?


Thanks,

Michael42

 

[ericbrunson]

Mysql. You can write your sql commands, pipe them to mysql and read the output from standard out. Or you can be clever, start a mysql shell with stdin and out on file descriptors and read and write to them as you need.