Re: [sqlite] question on creating/populating table with varchar/clob data types

2009-02-24 Thread Jay A. Kreibich
> Richard, > > This is fascinating. To quote a bit from "The Definitive Guide to SQLite" by Michael Owens: SQLite was conceived on a battleship... well, sort of. SQLite's author, D. Richard Hipp, was working for General Dynamics on a program for the U.S. Navy developing sof

Re: [sqlite] question on creating/populating table with varchar/clob data types

2009-02-23 Thread python
Dr. Hipp, > The story goes like this: ... Great story! Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] question on creating/populating table with varchar/clob data types

2009-02-23 Thread P Kishor
On Mon, Feb 23, 2009 at 8:01 PM, D. Richard Hipp wrote: > > On Feb 23, 2009, at 3:54 PM, P Kishor wrote: > >> On Mon, Feb 23, 2009 at 2:46 PM, D. Richard Hipp >> wrote: >>> >> .. >>> >>> SQLite is, in fact, a TCL extension that escaped into the wild. It >>> is >>> specifically designed to integr

Re: [sqlite] question on creating/populating table with varchar/clob data types

2009-02-23 Thread D. Richard Hipp
On Feb 23, 2009, at 3:54 PM, P Kishor wrote: > On Mon, Feb 23, 2009 at 2:46 PM, D. Richard Hipp > wrote: >> > .. >> >> SQLite is, in fact, a TCL extension that escaped into the wild. It >> is >> specifically designed to integrate well with Tcl/Tk. >> > .. > > Did you ever tell that story an

Re: [sqlite] question on creating/populating table with varchar/clob data types

2009-02-23 Thread P Kishor
On Mon, Feb 23, 2009 at 2:46 PM, D. Richard Hipp wrote: > .. > > SQLite is, in fact, a TCL extension that escaped into the wild. It is > specifically designed to integrate well with Tcl/Tk. > .. Did you ever tell that story anywhere? Would be fun to read it. -- Puneet Kishor http://www.punkish

Re: [sqlite] question on creating/populating table with varchar/clob data types

2009-02-23 Thread D. Richard Hipp
On Feb 23, 2009, at 3:29 PM, anjela patnaik wrote: > Hello all, > > I have a TCL application that writes database records to an Oracle > db. This database has grown to contain 8000 records. There are 2 > columns of varchar with 4k chars and 1 column of clob which contains > 1Mg max. The dat

[sqlite] question on creating/populating table with varchar/clob data types

2009-02-23 Thread anjela patnaik
Hello all,   I have a TCL application that writes database records to an Oracle db. This database has grown to contain 8000 records. There are 2 columns of varchar with 4k chars and 1 column of clob which contains 1Mg max. The data in this database are scripts.   Now, I need to write another app