Posted by: Anonymous Coward
on October 31, 2006 11:40 PM
I use PostgreSQL to manage addresses and export the DB nightly to an LDAP server for my email clients. I can access the DB at the commandline using either psql or by using ldapsearch to query the nightly exported data. The exported data is in LDIF format, so if I wanted to, I could use grep, awk, or even vi, in a manner similar to the OP (limited to searching).
I learned basic SQL a long time ago, so I don't have to learn the quirks of any particular data storage format.
The PostgreSQL DB is typically updated using a wizard-created OpenOffice.org form for single records, or using psql for updates that involve making the same change to lots of records.
I also created a quick-n-dirty perl/CGI web interface and added a searchplugin to Firefox to make it easy to search from within my browser. The results page includes both MAILTO links and a link that displays a map of the street address using Google Maps.
Learn about Linux
Download Linux
Get Linux help
Re:CLI and Thunderbird addressbook
Posted by: Anonymous Coward on October 31, 2006 11:40 PMI learned basic SQL a long time ago, so I don't have to learn the quirks of any particular data storage format.
The PostgreSQL DB is typically updated using a wizard-created OpenOffice.org form for single records, or using psql for updates that involve making the same change to lots of records.
I also created a quick-n-dirty perl/CGI web interface and added a searchplugin to Firefox to make it easy to search from within my browser. The results page includes both MAILTO links and a link that displays a map of the street address using Google Maps.
--Tony Greene
#