libdbi for postgresql

[David Reiser]

On Aug 24, 2011, at 5:55 PM, James Wilde wrote:

> Thanks Derek:  Rest inline.
> 
> On Aug 24, 2011, at 23:12 , Derek Atkins wrote:
> 
>> 
>> On Wed, August 24, 2011 4:30 pm, James Wilde wrote:
>>> Thanks for your reply, Bunk3m.  Rest inline.
>>> 
>>> Maybe you have a
>>> url or two?
>> 
>> www.sqlite.org?
> 
> Thanks.  I'll take a look.
>> 
>> Honestly, there's nothing you need to do for SQLite.  It's a SQL backend
>> that, from the user point of view, acts sorta like a file.  It's a
>> single-file solution, but you get the benfits of SQL without having to run
>> an RDBMS.
>> 
>>> Not apparently on my Mac Mini running Lion.  I did a search of the
>>> entire hard disk for sqlite3, earlier today, and the only thing it found
>>> was a couple of files in a download I made from (I think) source forge
>>> yesterday.
>> 
>> Try a search for '*sqlite*'
> 
> Just did.  Only the same files I d/ld from Source Forge yesterday.

Neither Spotlight nor the find function in a finder window searches much of the system structure.

In a terminal window:

which sqlite3

has the response:

/usr/bin/sqlite3

And

sqlite3 --version

responds

3.7.5

in my copy of Lion. Snow Leopard came with version 3.6.12, so I know that Lion upgraded it.

My tests in Snow Leopard indicated that postgres is faster than sqlite3 for gnucash, but it sure is a mess to have to take care of for a single application use.

Dave
> 
> Regards,
> 
> //James