Re: SQL in the base system (Was: New FreeBSD package system (a.k.a. Daemon Package System (dps)))

2007-05-13 Thread Garrett Cooper
Jos Backus wrote: On Fri, May 11, 2007 at 11:23:00AM -0400, Mike Meyer wrote: [snip] How robust is it - can a corrupt block fry the entire database? Dunno, but "Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.". So it appears to t

Re: SQL in the base system

2007-05-13 Thread Garrett Cooper
Ivan Voras wrote: Mike Meyer wrote: Yes, they are present no matter what representation you use. The question is - how do the answers change if you change the format. These days, cross-platform means you deal with length as well as endian issues. Or maybe you don't, depending on the db. I know

Re: SQL in the base system (Was: New FreeBSD package system (a.k.a. Daemon Package System (dps)))

2007-05-11 Thread Jos Backus
On Fri, May 11, 2007 at 12:16:12PM -0700, Jos Backus wrote: > On Fri, May 11, 2007 at 01:34:07PM -0400, Mike Meyer wrote: [snip] > > > > How about portability - can I move the file to a completely > > > > different architecture and still get the data from it? [snip] The answer ("Yes") can be found

Re: SQL in the base system (Was: New FreeBSD package system (a.k.a. Daemon Package System (dps)))

2007-05-11 Thread Jos Backus
On Fri, May 11, 2007 at 01:34:07PM -0400, Mike Meyer wrote: > In <[EMAIL PROTECTED]>, Jos Backus <[EMAIL PROTECTED]> typed: > > On Fri, May 11, 2007 at 11:23:00AM -0400, Mike Meyer wrote: > > [snip] > > > How robust is it - can a corrupt block fry the entire database? > > > > Dunno, but "Transact

Re: SQL in the base system (Was: New FreeBSD package system (a.k.a. Daemon Package System (dps)))

2007-05-11 Thread Mike Meyer
In <[EMAIL PROTECTED]>, Jos Backus <[EMAIL PROTECTED]> typed: > On Fri, May 11, 2007 at 11:23:00AM -0400, Mike Meyer wrote: > [snip] > > How robust is it - can a corrupt block fry the entire database? > > Dunno, but "Transactions are atomic, consistent, isolated, and durable (ACID) > even after s

Re: SQL in the base system

2007-05-11 Thread Mike Meyer
In <[EMAIL PROTECTED]>, Ivan Voras <[EMAIL PROTECTED]> typed: > Mike Meyer wrote: > > > Yes, they are present no matter what representation you use. The > > question is - how do the answers change if you change the > > format. These days, cross-platform means you deal with length as well > > as en

Re: SQL in the base system (Was: New FreeBSD package system (a.k.a. Daemon Package System (dps)))

2007-05-11 Thread Jos Backus
On Fri, May 11, 2007 at 11:23:00AM -0400, Mike Meyer wrote: [snip] > How robust is it - can a corrupt block fry the entire database? Dunno, but "Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.". So it appears to try hard to minimize

Re: SQL in the base system

2007-05-11 Thread Ivan Voras
Mike Meyer wrote: Yes, they are present no matter what representation you use. The question is - how do the answers change if you change the format. These days, cross-platform means you deal with length as well as endian issues. Or maybe you don't, depending on the db. I know the answers for te

Re: SQL in the base system

2007-05-11 Thread Mike Meyer
In <[EMAIL PROTECTED]>, Ivan Voras <[EMAIL PROTECTED]> typed: > Mike Meyer wrote: > >> Perhaps this is a good time I should mention that I think sqlite would > >> also be good for the password and login databases? :) > > > > Someone has already pointed out the horror that is the Windows > > regist

Re: SQL in the base system

2007-05-11 Thread Ivan Voras
Mike Meyer wrote: Perhaps this is a good time I should mention that I think sqlite would also be good for the password and login databases? :) Someone has already pointed out the horror that is the Windows registry. IIUC, even MS has figured out this is a bad idea, and gotten away from it with

SQL in the base system (Was: New FreeBSD package system (a.k.a. Daemon Package System (dps)))

2007-05-11 Thread Mike Meyer
> Perhaps this is a good time I should mention that I think sqlite would > also be good for the password and login databases? :) Someone has already pointed out the horror that is the Windows registry. IIUC, even MS has figured out this is a bad idea, and gotten away from it with Vista. But it's b