[sqlite] test for bounce detection

This is a test message. I just sent another message to the list and it got bounced with the message "Relay access denied" so I want to see if this one made it. If it does, can the listadmin see if there's anything wrong ? Sorry to occupy your Friday night or weekend. Simon.

[sqlite] test for bounce detection

We are in the process of moving mailman from sqlite.org:8080 to mailinglists.sqlite.org. The reason for this is that sqlite.org runs on a different web server (althttpd) than the mailman management (Apache) and so we originally used port 8080 for mailman. Well, port 8080 does not work for some peop

[sqlite] sqlite journal file question

Thanks all for the responses. Just want to clarify the scenario one more time:- -by syncing, I mean taking the modifications on the active machine and sending over wire to another machine(in some proprietary format) , where there is a similar sqlite application which receives the records and the

[sqlite] sqlite journal file question

On 2/13/15, Mayank Kumar (mayankum) wrote: > when we > do a rsync, does it make sense to copy the journal file Yes, yes. Emphatically, Yes. -- D. Richard Hipp drh at sqlite.org

[sqlite] test for bounce detection

gt; http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 801 bytes Desc: Message signed with OpenPGP using GPGMail URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150213/32ff3150/attachment.pgp>

[sqlite] test for bounce detection

qlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 801 bytes Desc: Message signed with OpenPGP using GPGMail URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150213/2679ab20/attachment.pgp>

Re: [sqlite] BLOB type not showing in table description after using create table as

Tiemogo, Idrissa wrote: > When I derive a table from another table containing blob type. > The describing the new table doesn’t show “blob". > > sqlite> create table t1 (p_id int, geometry blob); > sqlite> pragma table_info(t1); > 0|p_id|int|0||0 > 1|geometry|blob|0||0 > sqlite> create table t2 as

Re: [sqlite] sqlite3_analyzer code download?

this is an old post, but still top hit in google regarding to this topic. just for reference of others, one need to install tcl and tcl-dev first in order to compile sqlite3analyzer from source code, the error message from ./configure is not that clear. -- View this message in context: htt

[sqlite] BLOB type not showing in table description after using create table as

I am using sqlite 3.8.6 on MacOSX Yosemite 10.10.2. When I derive a table from another table containing blob type. The describing the new table doesn’t show “blob". See below: sqlite> select sqlite_version(); 3.8.6 sqlite> create table t1 (p_id int, geometry blob); sqlite> pragma table_info

[sqlite] Problem on sqlite3 backup_init

Dear all, I am facing a problem while using the sqlite3_backup_init, the error code returned by the loadOrSaveDb function is 21. Here below the code, the function "loadOrSaveDb" was taken as is from your web site. Any hint? Kind Regards. Vincenzo. sqlite3 *conn; CHAR dbPath[]="/mnt/sd/NEX33A

Re: [sqlite] sqlite3 mailing list broken

Follow up, eventually I got it working by using the following; http://fabianpeter.de/cloud/owncloud-migrating-from-sqlite-to-mysql/ Pretty dirty, but it got the job done... took me 6 *hours* to discover this fix, it's untested/alpha as hell and I didn't even write the code. Hopefully this helps o

Re: [sqlite] unreached code in sqlite3.c?

On 2/13/2015 9:57 AM, Dominique Devienne wrote: Warnings are always a tradeoff between pointing out what could be mistakes/oversights versus senseless noise. Most times I get the unreachable warning in my code is when I'm actively coding, experimenting, moving things around, then when I'm done

Re: [sqlite] sqlite journal file question

This was my initial reading too Paul, but reading the OP post again it could be either - who knows what is meant by "syncing". I also think this is the main point for the OP - If by syncing he really means "copying the file" then Richard's advice, else if he means "adding via normal DB connect

Re: [sqlite] sqlite journal file question

Richard I read that the db on the standby machine is being updated at a record by record level, i.e. not copied in its entirety. In this scenario I can't see the two db files being guaranteed binary compatible. Copying the journal across in this scenario would imo be a mistake. Paul www.sandersonf