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 data in this database are scripts. > > Now, I need to write another application in TK that works offline, > but retrieves the data in this database and presents it to the user. > I am not going to be able to access this Oracle db so I was > wondering if I could export all the data to a SQLite db and then > access it from TCL/TK. > > Does SQLite handle 4k Varchar fields and clobs? Is there a limit on > # of rows? Can I create a db on the fly as part of a TCL/TK > application ?
SQLite is, in fact, a TCL extension that escaped into the wild. It is specifically designed to integrate well with Tcl/Tk. SQLite accepts VARCHAR and BLOB and CLOB fields up to 1GiB in size. The database can be up to 64 Tebibytes in size. There is no limit on the number of rows (you will hit the file size limit first.) SQLite is way faster than Oracle in a single-user applications. > > > My other alternative was to offload the Oracle data to a XML/Xcel > file and then write TCL code to parse it. > That would be a silly thing to do. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
