Re: [Pan-users] Making Multiple Servers Happen In Your Lifetime

[Carl Wilhelm Soderstrom]

> Chris and I have talked about replacing Pan's current data file format with
> SQLite <http://www.hwaci.com/sw/sqlite/>, which is small, fast, and portable
> enough to to not scuttle the Windows port.   

someone tell me if this is a silly idea or not...

if you use something SQL-ish for your data store; suppose you could make it
generalized enough that people could attach it to an existing MySQL
(Postgres, DB/2) dbase, rather than use this SQLite tool?

if SQLite really is as lightweight as it claims to be, this may be silly and
overkill; and reliability may be better served by using something other than
one's existing SQL store.

it just occured to me that if you're going to speak fairly-portable SQL to
something; why not re-use your currently-running dbase process, rather than
something else. 
then again, the overhead of communicating via sockets to MySQL or whatever,
probably would make it somewhat slower than SQLite; and I don't really see
much of a need for it, other than the novelty value of it. (tho perhaps if
you're on a diskless thin client with the newsreader running locally, a
socket I/O is more efficient than a filesystem I/O).
that and most non-geeks (and few enough geeks) will have a handy MySQL
server running. :)

Carl Soderstrom.
-- 
Systems Administrator
Real-Time Enterprises
www.real-time.com