Re: [sqlite] Is there a way to select using cid?

On Sat, 23 Mar 2019 12:57:55 +0100 (CET) Eric wrote: > On Fri, 22 Mar 2019 16:34:20 -0500, Peng Yu > wrote: > > There are cid's for each table. Is there a way to use "select" with > > cid's instead of their names? Thanks. > > > > $ sqlite3 dbfile < > create table test (id integer primary key, v

Re: [sqlite] sqlar: makeDirectory called with permission bits of file

Please try the latest trunk check-in and let use know whether or not it fixes your issue. On 3/25/19, Winter, Martin wrote: > Hi all, > > since I have received no reaction to my contribution, would like to draw > your attention to it again. > > It is annoying that you get an error message when ex

Re: [sqlite] sqlar: makeDirectory called with permission bits of file

Hi all, since I have received no reaction to my contribution, would like to draw your attention to it again. It is annoying that you get an error message when extracting files from an sqlar archive using sqlite3 -Ax when this archive contains files with permission bits 0664 in subdirectories,

[sqlite] Documentation error: USE_ZLIB versus HAVE_ZLIB

Good morning! Both https://sqlite.org/cli.html#_do_it_yourself_builds_ and https://sqlite.org/compile.html#use_zlib mention option SQLITE_USE_ZLIB to enable _zipfile and _sqlar. However, shell.c.in uses SQLITE_HAVE_ZLIB for this. I think this is a documentation error. checkout: 7a0a26ed3

Re: [sqlite] Get SQLite Database from React Native mobile app

On 25 Mar 2019, at 6:45am, Ashu Thakkar wrote: > How to get Database created from react native mobile app. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://ma

Re: [sqlite] [EXTERNAL] Get SQLite Database from React Native mobile app

Copy it from the directory where it is located. Details differ and should be asked of the phone manufacturer and the app developer. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Ashu Thakkar Gesendet: Montag, 25. März 201

[sqlite] Get SQLite Database from React Native mobile app

Hello, How to get Database created from react native mobile app. Thank You ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Diagnosing stale readers

On 24 Mar 2019, at 12:45pm, Gerlando Falauto wrote: > if there's a way > of getting a list of the current transactions or locks. You can iterate through all the current statements for a connection: However many wrappers do not implement this function s

Re: [sqlite] proposal: make the archive option -Au to update only newer files. /Patch included/

Hello, again. I would like to know is there a way to see if this proposal rejected or something? Is this a write ML to propose with patch? And yes I saw suggested to use checksums, but this means we read all the files in a source directory, that is huge. This is a reason for relying on timestamp