[Default] On Fri, 2 Nov 2007 19:52:21 +0530, "Babu, Lokesh" <[EMAIL PROTECTED]> wrote:
>Hi all, > >Does anyone analysed the sqlite3 database output file by opening the file in >some hex editor. >Is it possible to create one such database file without using sqlite.i.e., >is it possible to write the contents without using sqlite and later read the >contents using sqlite. > >or say if I have a text file with n records and each field seperated by >delimiter, is it possible for me to insert into the table without using >PARSER and VDBE. You might be able to do that, but you would have to duplicate quite a lot of SQLite code anyway, and it won't be easy. Much more difficult than the dBase/FoxPro format. Considering http://www.sqlite.org/php2004/page-015.html and http://www.sqlite.org/php2004/page-016.html I would estimate the code would still be about a quarter to a third of the full size. Using the API or the command line tool (.import) is much easier, and very fast, if done right (transactions). The library and the command line tool are both smaller than 400k (MS Windows, v3.4.2), so why bother? >Thanks in advance. >-Lokee HTH -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
