Re: [sqlite] readfile() enhancement request

2019-05-18 Thread Warren Young
On May 17, 2019, at 7:49 PM, sql...@zzo38computer.org wrote: > > (For Macintosh you may need to change "xclip -o" to the proper command on > Macintosh, pbpaste > For Windows, this extension is unlikely to work There are pipes in the NT line of kernels, and there are ways to tie that to stdin

Re: [sqlite] Cell pointer array values

2019-05-18 Thread Richard Hipp
On 5/18/19, Gravis wrote: > So would this pseudocode yield the correct address for cell number > "x"? (assuming cell x exists) > > ((page_number - 1) * page_size) + cell_pointer_array[x] Yes. You seem to be thinking in terms of overall file offsets. We tend to think in terms of offsets within

Re: [sqlite] Cell pointer array values

2019-05-18 Thread Gravis
So would this pseudocode yield the correct address for cell number "x"? (assuming cell x exists) ((page_number - 1) * page_size) + cell_pointer_array[x] On Sat, May 18, 2019 at 9:10 AM Richard Hipp wrote: > > On 5/18/19, Gravis wrote: > > I've been working on making a simple DB file reader an

Re: [sqlite] Cell pointer array values

2019-05-18 Thread Richard Hipp
On 5/18/19, Gravis wrote: > I've been working on making a simple DB file reader and according to > the file format document (https://sqlite.org/fileformat.html), > immediately after a "B-tree Page Header" is the "cell pointer array". > Unfortunately, it never actually states how to use these 16-bi

[sqlite] Cell pointer array values

2019-05-18 Thread Gravis
I've been working on making a simple DB file reader and according to the file format document (https://sqlite.org/fileformat.html), immediately after a "B-tree Page Header" is the "cell pointer array". Unfortunately, it never actually states how to use these 16-bit values to compute the addresses t

Re: [sqlite] readfile() enhancement request

2019-05-18 Thread sqlite
sqlite-users@mailinglists.sqlite.org wrote: > It's quite often (for me, at least) the case I need to do something like this > from the command line: > > >sqlite3.exe my.db "insert into t values(`simple field','multi-line text > >copied > >from some other app') > > The problem is the multi-line