Re: [sqlite] how into insert row into middle of table with integer primary key

Shane. Below is a simple benchmark you can play with to decide if that trigger is fast enough for your application. On the time scale of human thinking and reaction time, I've found SQLite code quite responsive and magnitudes easier to maintain than the equivalent application code. FYI, that

Re: [sqlite] how into insert row into middle of table with integer primary key

Shane Dev wrote: > Why do I want store ID numbers whose values may change? Why not. Because the name "ID" implies that its value _identifies_ the row. If it changes, it is not an ID. > Obviously, this would be bad idea if the ID column was referenced by > other column / table. In that case, I

Re: [sqlite] how into insert row into middle of table with integer primary key

On 2017/11/22 2:29 AM, Jens Alfke wrote: On Nov 21, 2017, at 2:48 PM, Simon Slavin wrote: But that just brings us back to the question of why OP wants to store ID numbers which might change. When I’ve run into this before, the requirement has been to support lists

Re: [sqlite] how into insert row into middle of table with integer primary key

Hi Igor, Homework exercise? No, this is purely a hobby project in my free time. My goal is see how much logic can moved from application code to the database. Why do I want store ID numbers whose values may change? Why not. Obviously, this would be bad idea if the ID column was referenced by

Re: [sqlite] how into insert row into middle of table with integer primary key

On Tue, Nov 21, 2017, 11:10 PM Jens Alfke, wrote: > > It’s a lot better to use strings, and just increase the length of the > string as necessary. So to insert in between “A” and “C” you add “B”, then > to insert between “A” and “B” you add “AM”, etc. > Except that you can't

Re: [sqlite] Many ML emails going to GMail's SPAM

I have been having the same problem for a while. But, this is using Windows Live Mail client. I would love to keep the list email driven, if possible. But, whatever it is, I will be part of the next phase of communication. Thanks. -Original Message- From: Keith Medcalf Sent:

Re: [sqlite] how into insert row into middle of table with integer primary key

Am 22.11.2017 um 01:29 schrieb Jens Alfke: When I’ve run into this before, the requirement has been to support lists with customizable ordering, like an outliner where the user can freely drag the rows up and down. Yep. And therefore such cases should be handled at the App-Level IMO...

Re: [sqlite] how into insert row into middle of table with integer primary key

> On Nov 21, 2017, at 2:48 PM, Simon Slavin wrote: > > But that just brings us back to the question of why OP wants to store ID > numbers which might change. When I’ve run into this before, the requirement has been to support lists with customizable ordering, like an

Re: [sqlite] Many ML emails going to GMail's SPAM

On 11/21/2017 08:20 PM, Keith Medcalf wrote: > Strict RFC compliance is very simple: Which explains why virtually every email client on mobile devices is unable to send email that complies with the relevant RFCs. Using RFC-compliance as a spam detection tool is useful, because it eliminates

Re: [sqlite] Many ML emails going to GMail's SPAM

On 21 November 2017 at 11:42, Warren Young wrote: > On Nov 21, 2017, at 10:24 AM, Peter Da Silva > wrote: >> >> But the mailers I use (Gmail’s web interface, Apple Mail and (yuck) Outlook) >> all do basic threading. > > I’d describe what Apple

Re: [sqlite] Many ML emails going to GMail's SPAM

On 21 November 2017 at 06:30, Richard Hipp wrote: > On 11/21/17, Paul Sanderson wrote: >> Coincidence! I have just been in my gmail folder marking a load of SQLite >> email as 'not spam' > > I've been seeing mailing list emails go to spam for a

Re: [sqlite] Many ML emails going to GMail's SPAM

Sqlite had a forum in the past on Nabble. Seems nice to me, I still get several hits to nabble when googling for sqlite issues. What didn't work there? -SK On Tue, Nov 21, 2017 at 9:30 AM, Richard Hipp wrote: > On 11/21/17, Paul Sanderson wrote:

Re: [sqlite] how into insert row into middle of table with integer primary key

Simon, On Tue, Nov 21, 2017 at 4:48 PM, Simon Slavin wrote: > > > On 21 Nov 2017, at 10:09pm, Jens Alfke wrote: > >>> On Nov 21, 2017, at 1:56 AM, R Smith wrote: >>> >>> That assumes you are not starting from an integer part (like

Re: [sqlite] Callback for sqlite3_finalize()

That should read sqlite3_create_function_v2 Am 22.11.17, 00:03 schrieb "sqlite-users im Auftrag von Stadin, Benjamin" : dms_create_function_v2 ___

[sqlite] Callback for sqlite3_finalize()

Hi, I register a custom SQL function using dms_create_function_v2, and in the C callback I create a rather heavy C++ helper class which I need to prepare the result. I currently use sqlite3_get_auxdata and sqlite3_set_auxdata, but my problem is that the finalization callback of

Re: [sqlite] Many ML emails going to GMail's SPAM

On Nov 21, 2017, at 1:20 PM, Keith Medcalf wrote: > > Strict RFC compliance is very simple: We await your patch, then. :) > And checking SPF is pretty useful as well. But not DKIM, which solves the same problem as SPF, but with strong crypto so it can’t be MITM’d? DKIM

Re: [sqlite] how into insert row into middle of table with integer primary key

On 21 Nov 2017, at 10:09pm, Jens Alfke wrote: >> On Nov 21, 2017, at 1:56 AM, R Smith wrote: >> >> That assumes you are not starting from an integer part (like 4000) and >> hitting the exact same relative insert spot every time, which /can/ happen,

Re: [sqlite] Energy consumption of SQLite queries

Dear Ali, A couple of comments. Indeed lots of energy is transferred into heat, but not all. Therefore, using temperature (after calibrating specific heat coefficient of the device ) is not a good method. Some energy is radiated as visible and invisible light and hard to catch it all. Some as

Re: [sqlite] how into insert row into middle of table with integer primary key

> On Nov 21, 2017, at 1:56 AM, R Smith wrote: > > That assumes you are not starting from an integer part (like 4000) and > hitting the exact same relative insert spot every time, which /can/ happen, > but is hugely unlikely. Not to beat this into the ground, but: it’s

Re: [sqlite] Many ML emails going to GMail's SPAM

On 22/11/2017 01:30, Richard Hipp wrote: On 11/21/17, Paul Sanderson wrote: Coincidence! I have just been in my gmail folder marking a load of SQLite email as 'not spam' I've been seeing mailing list emails go to spam for a while now. Nothing has changed with

Re: [sqlite] Energy consumption of SQLite queries

Dear All, Thanks for your comments. That was really helpful. Regards Ali On Tue, Nov 21, 2017 at 11:41 PM, Robert Oeffner wrote: > This is an interesting topic more belonging to the realms of information > theory and statistical physics. > > I am not an expert in this area

Re: [sqlite] Many ML emails going to GMail's SPAM

> On Nov 21, 2017, at 6:23 PM, Warren Young wrote: > > This is what drh does. We’re fans because he does it well. drh + djb = bliss? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Many ML emails going to GMail's SPAM

> On Nov 21, 2017, at 3:30 PM, Richard Hipp wrote: > > I think what we are seeing is the beginning of the end of email as a viable > communication medium. Nonsense. Email is one of these cockroach technologies: it will survive us all. > I really need to come up with an

Re: [sqlite] Many ML emails going to GMail's SPAM

And checking SPF is pretty useful as well. Once you have enforced strict compliance, however, the effect of SPF is negligible (less than 1/1000%). DKIM/DMARC generally causes more trouble than it solves (it was designed by a committee of idiots after all) and should be mostly ignored other

Re: [sqlite] Many ML emails going to GMail's SPAM

Strict RFC compliance is very simple: (1) When a remote MTA connects it MUST NOT speak until spoken to. (2) A remote MTA MUST NOT violate the command/response protocol. (3) The IP Address of the remote host MUST resolve (in the in-addr.arpa domain) to a name that forward resolves to a set of IP

Re: [sqlite] Many ML emails going to GMail's SPAM

I vote to keep mailing list. It works great for me with GMail (accessible from all my devices instantly) Reasons: 1. GMail has a threaded view built-in which works great. You might need to enable it in settings. 2. I doubt if any spam filter can ever be better than Gmail's. Spam fighting is not

Re: [sqlite] Many ML emails going to GMail's SPAM

> On Nov 21, 2017, at 8:42 PM, Warren Young wrote: > > As far as I can tell, the only really hard part is the email gatewaying > problem, evidenced by the fact that Fossil still doesn’t have a feature to > echo commits, ticket changes, etc. via email. “Every program

Re: [sqlite] Many ML emails going to GMail's SPAM

On Nov 21, 2017, at 10:24 AM, Peter Da Silva wrote: > > But the mailers I use (Gmail’s web interface, Apple Mail and (yuck) Outlook) > all do basic threading. I’d describe what Apple Mail and Gmail do as “clumping” rather than “threading.” I think we can all

Re: [sqlite] Many ML emails going to GMail's SPAM

In the UK we’ve still got a threaded conferencing service called CIX must be over 30 years old now (it was based on BIX / Cosy). The joke is it’s the UKs oldest online social network :) Another vote for a threaded forum here. I do try and keep up with the ML but if it was threaded it would be a

Re: [sqlite] Many ML emails going to GMail's SPAM

Haven't you read the FAQ? http://www.sqlite.org/faq.html#q6 "Threads are evil. Avoid them." (Sorry, couldn't resist) -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Peter Da Silva Sent: Tuesday, November 21, 2017 12:24 PM To:

Re: [sqlite] Many ML emails going to GMail's SPAM

On 2017-11-21 6:30 AM, Richard Hipp wrote: On 11/21/17, Paul Sanderson wrote: Coincidence! I have just been in my gmail folder marking a load of SQLite email as 'not spam' I've been seeing mailing list emails go to spam for a while now. Nothing has changed with

Re: [sqlite] Many ML emails going to GMail's SPAM

IMO, the additional functionality provided doesn't outweigh yet another niche and individual forum I need to log into that can potentially end up being hacked. Its another thing Richard (et all) has to maintain and update. On Tue, Nov 21, 2017 at 12:20 PM, Paul Sanderson <

Re: [sqlite] Many ML emails going to GMail's SPAM

On 11/21/17, 11:21 AM, "sqlite-users on behalf of Warren Young" wrote: > You don’t get proper threading with the current ticket comment system, but > both mailers I use these days lack that feature, as do most forum

Re: [sqlite] Many ML emails going to GMail's SPAM

On Nov 21, 2017, at 7:52 AM, Dominique Devienne wrote: > > On Tue, Nov 21, 2017 at 3:30 PM, Richard Hipp wrote: > >> I really need to come up with an alternative to the mailing list. Perhaps >> some kind of forum system. Suggestions are welcomed. > >

Re: [sqlite] Many ML emails going to GMail's SPAM

On Nov 21, 2017, at 7:30 AM, Richard Hipp wrote: > > On 11/21/17, Paul Sanderson wrote: >> Coincidence! I have just been in my gmail folder marking a load of SQLite >> email as 'not spam' > > I've been seeing mailing list emails go to spam for a

Re: [sqlite] Many ML emails going to GMail's SPAM

What about some sort of poll. Mail lists might work but the additonal functionality offered by a forum (I am a member of many) makes them my choice. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786

Re: [sqlite] Many ML emails going to GMail's SPAM

I’m a mailing list fan, too. Reddit I use for yucks only. On 11/21/17, 10:48 AM, "sqlite-users on behalf of Stephen Chrzanowski" wrote: All in all, just please, oh PLEASE stay away from redit I will not

Re: [sqlite] Many ML emails going to GMail's SPAM

All in all, just please, oh PLEASE stay away from redit I will not ever go there. I got BANNED for a first post question that included an example to clarify what I was looking for. Nothing nasty, nothing ignorant, it was a technical question about something or other, and out to the curb I

Re: [sqlite] Many ML emails going to GMail's SPAM

On 21.11.2017 17:30 John McKown wrote: > On Tue, Nov 21, 2017 at 10:27 AM, Drago, William @ CSG - NARDA-MITEQ < > william.dr...@l3t.com> wrote: > >>> I really need to come up with an alternative to the mailing list. >>> Perhaps some kind of forum system. Suggestions are welcomed. >>> -- >>> D.

Re: [sqlite] Many ML emails going to GMail's SPAM

On 2017/11/21 6:30 PM, Keith Medcalf wrote: //... I consider that there is no such thing as a "false positive". Either the sending MTA is a properly configured RFC compliant Internet host with a properly configured MTA, or I do not want to accept communications from it. If it is properly

Re: [sqlite] Many ML emails going to GMail's SPAM

On 11/21/17, 10:30 AM, "sqlite-users on behalf of Keith Medcalf" wrote: > I simply tell those people that they either (a) fix their systems or (b) use > snail-mail. Takes care of the problem entirely. I am

Re: [sqlite] Many ML emails going to GMail's SPAM

On Tue, Nov 21, 2017 at 10:27 AM, Drago, William @ CSG - NARDA-MITEQ < william.dr...@l3t.com> wrote: > > I really need to come up with an alternative to the mailing list. > > Perhaps some kind of forum system. Suggestions are welcomed. > > -- > > D. Richard Hipp > > d...@sqlite.org > > Please,

Re: [sqlite] Many ML emails going to GMail's SPAM

--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. On Tuesday, 21 November, 2017 09:06, Peter Da Silva wrote: >On 11/21/17, 9:59 AM, "sqlite-users on behalf of Keith Medcalf"

Re: [sqlite] Many ML emails going to GMail's SPAM

> I really need to come up with an alternative to the mailing list. > Perhaps some kind of forum system. Suggestions are welcomed. > -- > D. Richard Hipp > d...@sqlite.org Please, not a forum. The email list is instant, dynamic, and convenient. I don't think checking into a forum to stay

Re: [sqlite] Many ML emails going to GMail's SPAM

On 11/21/17, 9:59 AM, "sqlite-users on behalf of Keith Medcalf" wrote: > If you run an RFC complaint MTA then there is really very little problem with > SPAM at all -- I have many connections per second rejected for

Re: [sqlite] Many ML emails going to GMail's SPAM

Il giorno 21 novembre 2017, alle ore 15:30, Richard Hipp ha scritto: >On 11/21/17, Paul Sanderson wrote: >> Coincidence!  I have just been in my gmail folder marking a load of SQLite >> email as 'not spam' >I've been seeing mailing list emails

Re: [sqlite] Many ML emails going to GMail's SPAM

If by JS you mean JavaScript, then this is a non-starter. Many people (myself included) do not permit remote code to be executed on our computers. --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original

Re: [sqlite] Many ML emails going to GMail's SPAM

In my opinion it is the beginning of the end of crappy freemail providers and their overzealous spam filtering. And it is about time. If you run an RFC complaint MTA then there is really very little problem with SPAM at all -- I have many connections per second rejected for RFC

Re: [sqlite] Many ML emails going to GMail's SPAM

I greatly prefer e-mail, too. It's a shame mailing lists run afoul of SPF and usually DKIM, and doubly so that ARC is unlikely to be of much help. I abhor Discourse, so it's depressing for me that it's so popular. Alas... On November 21, 2017 10:16:24 AM EST, Stephen Chrzanowski

Re: [sqlite] Many ML emails going to GMail's SPAM

Discourse has a mailing-list mode you can enable, which will send you all posts (I presume, I never tried it) The default setup sends you interesting new topics at an interval of your choosing. What I like very much about Discourse: - great engagement - easy following of only those topics

Re: [sqlite] Many ML emails going to GMail's SPAM

I love the email methodology, and I'd honestly be sad to see it go. But if GMail is causing the mischaracterization of the mail, maybe just a note on the sqlite.org home page that directs people on how to whitelist the mailing list? I'm indifferent to the forum idea, but, so long the forum

Re: [sqlite] Many ML emails going to GMail's SPAM

On 11/21/17, 8:52 AM, "sqlite-users on behalf of Dominique Devienne" wrote: > After re-inventing database and source-control, forum software next? :) I > have no doubt it would be lean, fast, SQLite-based, in C

Re: [sqlite] Many ML emails going to GMail's SPAM

On Tue, Nov 21, 2017 at 3:30 PM, Richard Hipp wrote: > On 11/21/17, Paul Sanderson wrote: > > Coincidence! I have just been in my gmail folder marking a load of > SQLite > > email as 'not spam' > > I've been seeing mailing list emails go to spam

Re: [sqlite] Many ML emails going to GMail's SPAM

On 21 Nov 2017, at 2:30pm, Richard Hipp wrote: > I really need to come up with an alternative to the mailing list. > Perhaps some kind of forum system. Suggestions are welcomed. If we’re to end up with a chat-based system then I’d prefer Discord. I can’t recommend a

Re: [sqlite] SELECT result different after ANALYZE

On 21.11.2017 15:36, Richard Hipp wrote: I'll be working on some other solution for you. Many thanks, but this is not necessary. I can rebuild from Fossil. Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] SELECT result different after ANALYZE

On 11/21/17, Richard Hipp wrote: > > To work around this problem, please DROP all indexes on the INTEGER > PRIMARY KEY columns. Except, you don't have any indexes on INTEGER PRIMARY KEY columns. I misread the schema. I'll be working on some other solution for you. -- D.

Re: [sqlite] Many ML emails going to GMail's SPAM

I know it can't be expected of users, but, I've setup GMail to whitelist anything coming from the mail list. GMail tells me that the message should have gone to spam, but because of a rule, yadda yadda. On Tue, Nov 21, 2017 at 9:30 AM, Richard Hipp wrote: > On 11/21/17, Paul

Re: [sqlite] Many ML emails going to GMail's SPAM

On 11/21/17, Paul Sanderson wrote: > Coincidence! I have just been in my gmail folder marking a load of SQLite > email as 'not spam' I've been seeing mailing list emails go to spam for a while now. Nothing has changed with MailMan. I think what we are seeing is

Re: [sqlite] SELECT result different after ANALYZE

On 11/20/17, David Raymond wrote: > > To reproduce, download this database file (5.6MB, SHA1 > 12d1295d06327ee19ed2453517b0dd83233c6829, available for two days from now): > >https://expirebox.com/download/328baafe26688579fccd55debfc54ad3.html > > This SQL returns a

Re: [sqlite] Energy consumption of SQLite queries

This is an interesting topic more belonging to the realms of information theory and statistical physics. I am not an expert in this area but from what I recall from undergraduate physics the moment you create order in one corner of the universe entropy rises in another place of the universe.

Re: [sqlite] Energy consumption of SQLite queries

A pretty much impossible task I would think. The power usage of SQLite compared to the power usage of different hardware components would be miniscule. But, there are so many other tasks running on a system, many in the background, that isolating SQLite from the rest would be next to impossible.

Re: [sqlite] [OT] Updating sqlite in PHP windows

On 21 Nov 2017, at 10:30am, Eduardo wrote: > Thanks Simon. It seems that php 5.6 it's EOL and all updates (except > security) are on 7.1 and 7.2 branchs. > > See the answers I get from php staff, 7.2 will have 3.21 version plus FTS and > JSON extensions on

Re: [sqlite] Many ML emails going to GMail's SPAM

Coincidence! I have just been in my gmail folder marking a load of SQLite email as 'not spam' Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite

[sqlite] Many ML emails going to GMail's SPAM

Just FYI. Not sure if something changed on the mailer's settings. Possibly/likely linked to GMail changing it's SPAM heuristics I guess. --DD ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] [OT] Updating sqlite in PHP windows

On Mon, 20 Nov 2017 14:33:53 + Simon Slavin escribió: > On 20 Nov 2017, at 11:06am, Eduardo wrote: > > > Or better, a recipe that works to compile sqlite3 on php5.6.x? > > This is the best-looking page I’ve found, but I have never

Re: [sqlite] how into insert row into middle of table with integer primary key

On 2017/11/21 7:35 AM, Jens Alfke wrote: On Nov 20, 2017, at 2:05 PM, Simon Slavin wrote: INSERT INTO fruit VALUES ((1 + 2) / 2), 'banana') This gives you a value of 1.5, and puts the new entry in the right place. This solution (which comes up every time this

Re: [sqlite] read/write binary data via tcl

-readonly is it. Sorry for the noise. -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] read/write binary data via tcl

Getting binary data back with incrblob is only possible with a writeable database connection. Is there a way to do this with a readonly database connection? Thank you rene -- Sent from: http://sqlite.1065341.n5.nabble.com/ ___ sqlite-users mailing