Re: [sqlite] How to contact Android Sqlite Bindings Maintainers?

On 09/19/2018 12:18 AM, David White wrote: >> I am stuck trying to use the precompiled binaries + Android bindings on >> Android 8. Does anyone know how to reach the maintainers for this stuff? >Posting here will work. >> I have posted a ticket on the wiki but no luck. >This one, correct? >

Re: [sqlite] How to contact Android Sqlite Bindings Maintainers?

On 09/19/2018 12:18 AM, David White wrote: I am stuck trying to use the precompiled binaries + Android bindings on Android 8. Does anyone know how to reach the maintainers for this stuff? Posting here will work. I have posted a ticket on the wiki but no luck. This one, correct?

Re: [sqlite] docs: application_id is signed, not unsigned

Update: drh fixed this in 3580ba4b5bd75ec6. Thanks! Best, WC ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to contact Android Sqlite Bindings Maintainers?

I am stuck trying to use the precompiled binaries + Android bindings on Android 8. Does anyone know how to reach the maintainers for this stuff? I have posted a ticket on the wiki but no luck. Thanks --- This email has been checked for viruses by Avast antivirus software.

Re: [sqlite] [EXTERNAL] shell csv import

Thank you E.Pasma, most elegant. Solves my problem. Thank you Rowan, I was trying to achieve it with /bin/sh (dash) On Tue, Sep 18, 2018 at 7:12 PM, E.Pasma wrote: > > > Rowan Worth wrote: > > > > You can also filter out specific messages at the shell level: > > > > sqlite foo.db 2> >(grep -v

Re: [sqlite] [EXTERNAL] shell csv import

> Rowan Worth wrote: > > You can also filter out specific messages at the shell level: > > sqlite foo.db 2> >(grep -v 'expected 7 columns but found 6 - filling the > rest with NULL' >&2) > > But note that the >() syntax is not a POSIX sh feature, and will not work > in a script using a shebang

Re: [sqlite] [EXTERNAL] shell csv import

> I have a script that loads csv into an existing table. > > I get this message on stderr for each row imported: > > "... expected 7 columns but found 6 - filling the rest with NULL" > > > We have the means to send stdout to /dev/null using the .once or .output > > Is there a way to send

Re: [sqlite] [EXTERNAL] shell csv import

You can also filter out specific messages at the shell level: sqlite foo.db 2> >(grep -v 'expected 7 columns but found 6 - filling the rest with NULL' >&2) But note that the >() syntax is not a POSIX sh feature, and will not work in a script using a shebang of #!/bin/sh. You need to change it to

Re: [sqlite] [EXTERNAL] shell csv import

Thanks hick. But that's not the problem. The import will always write to stderr, it's not an error Lots of other stuff in the script and I want to be able to catch any errors in the other parts of the script. On Tue, Sep 18, 2018 at 4:20 PM, Hick Gunter wrote: > When running a script from the

Re: [sqlite] [EXTERNAL] shell csv import

When running a script from the shell, you can redirect stderr tot he null device using 2>/dev/null or to the same destination as stdout using 2>&1. The latter is also very useful in crontab entries, as neglecting to handle stderr will result in an email tot he user that contains anything

[sqlite] shell csv import

I have a script that loads csv into an existing table. I get this message on stderr for each row imported: "... expected 7 columns but found 6 - filling the rest with NULL" We have the means to send stdout to /dev/null using the .once or .output Is there a way to send suppress stderr messages

Re: [sqlite] [EXTERNAL] Last_row_id

Or maybe also a SELECT ... INTO. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von David Raymond Gesendet: Montag, 17. September 2018 16:07 An: SQLite mailing list Betreff: Re: [sqlite] [EXTERNAL] Last_row_id I can't seem