Re: SQL backend for GnuCash 2

2006-10-27 Thread Jim C. Nasby
On Fri, Oct 27, 2006 at 11:51:50AM -0400, Derek Atkins wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > > You'd be better off creating a stored-procedure-based interface and > > having it enforce the semantics. > > Except not all DBs that we

Re: SQL backend for GnuCash 2

2006-10-27 Thread Jim C. Nasby
On Thu, Oct 26, 2006 at 03:33:37PM -0400, Derek Atkins wrote: > the list of requirements. Also, I dont think we can depend on stored > procedures; SQLite doesn't support them. Dumb question... why would someone want to run SQLite over the existing storage mechanism? -- Jim C. Nasb

Re: SQL backend for GnuCash 2

2006-10-27 Thread Jim C. Nasby
, 7427, 4919, 13301, 18917 and probably more). See also http://sql-info.de/mysql/gotchas.html -- Jim C. Nasby, Database Architect[EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where

Re: SQL backend for GnuCash 2

2006-10-27 Thread Jim C. Nasby
ks and > enforces certain integrity) from application tier (single point) to DB > backend tier (potentially many different implementations for different > backends). You'd be better off creating a stored-procedure-based interface and having it enforce the semantics. -- Jim

Re: Updated DDL for SQL backend

2006-10-27 Thread Jim C. Nasby
that I'm biased or anything > ;) Actually, at least in PostgreSQL, bytea is human readable when you select on it: decibel=# create table b(b bytea); CREATE TABLE decibel=# insert into b values('01234456789ABCDEF'); INSERT 0 1 decibel=# select * from b; b