Re: [sqlite] Regarding CoC

I'm guessing this is an appropriately satirical response to a ridiculous request from corporates. If not, then: - ditch all the religious mumbo-jumbo: 1, 10, 21, 41, 42, 44, 45, 46, 49, 50, 58, 60, 61, 62, 63, 70, 72 - and probably the masochism: 11 - and probably "Do not swear, for fear of

Re: [sqlite] Regarding CoC

If my opinion has any value, even though being atheist, I prefer this CoC 100 times over the CoC that is being currently pushed onto the many open-source communities, that was created by some purple-headed feminist with political motives. This one does not have any hidden intentions (at least,

Re: [sqlite] Regarding CoC

I think Donald Knuth would approve. On Mon, Oct 22, 2018 at 8:01 PM D Burgess wrote: > > The CoC is fine. Don't change it. > +1 > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org >

Re: [sqlite] Regarding CoC

> The CoC is fine. Don't change it. +1 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Help!

On 22 Oct 2018, at 10:43pm, Petite Abeille wrote: > You could try the following perhaps: > > Import a CSV File Into an SQLite Table > http://www.sqlitetutorial.net/sqlite-import-csv/ That is a good page. Documentation for the CLI tool it refers to can be found in chapter 8 of

Re: [sqlite] Regarding CoC

> On Oct 22, 2018, at 11:31 PM, Simon Slavin wrote: > > And now has reached the summit of Slashdot's front page: Slow news day. Good night, and good luck. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Help!

> On Oct 22, 2018, at 11:35 PM, am...@juno.com wrote: > > October 22, 2018 Hello Good People: I need to import a large bunch of names > (first and last), and id numbers into SQ Lite. How do I do en-mas--as opposed > to copying and pasting each individual name, clock number, etc? I would be >

Re: [sqlite] Regarding CoC

> On Oct 22, 2018, at 10:32 PM, Donald Shepherd > wrote: > > It's disappointing Why so serious? Plus, really, what have the romans ever done for us? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] Help!

October 22, 2018 Hello Good People: I need to import a large bunch of names (first and last), and id numbers into SQ Lite. How do I do en-mas--as opposed to copying and pasting each individual name, clock number, etc? I would be most appreciative if you would give me very explicit directions.

Re: [sqlite] Regarding CoC

On 22 Oct 2018, at 10:05pm, Richard Hipp wrote: > It even made TheRegister: > https://www.theregister.co.uk/2018/10/22/sqlite_code_of_conduct/ And now has reached the summit of Slashdot's front page:

Re: [sqlite] Regarding CoC

On 10/19/18, Simon Slavin wrote: > > Yeah, that's gonna magically appear on Hacker News within the month. For > those curious ... It even made TheRegister: https://www.theregister.co.uk/2018/10/22/sqlite_code_of_conduct/ -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Regarding CoC

On 2018-10-22 10:29 AM, Richard Hipp wrote: In summary: The values expressed by the current CoC have been unchanged for decades and will not be changing as we move forward. If some people are uncomfortable with those values, then I am very sorry for them, but that does not change the fact.

Re: [sqlite] Regarding CoC

It's disappointing that some are using discussion on a (perfectly acceptable) CoC to turn it into an excuse to post "jokes" about other people's beliefs, but whatever floats your boat. Regards, Donald Shepherd. On Tue, 23 Oct 2018 at 07:05, Charles Leifer wrote: > I dig the new CoC (not that

Re: [sqlite] Regarding CoC

I dig the new CoC (not that anyone's counting). I'll share my comment from HN: If the code of conduct angers you, stop and think -- how did you feel one minute before you read the CoC? Is the problem really the CoC, or is it your collection of beliefs that is causing the problem? Furthermore,

Re: [sqlite] Regarding CoC

> On Oct 22, 2018, at 9:43 PM, Rob Dixon wrote: > > weird and antagonistic Thank you for the kind words of support. Your wisdom and insights will be missed. Farewell Rob Dixon. Godspeed. ___ sqlite-users mailing list

Re: [sqlite] Regarding CoC

Thank you Simon, I will. SQL compact will do just fine for me. Funny, I used to advocate for using SQLite. Now that I know more about the people involved with it, I want nothing do to with it. Best of luck being weird and antagonistic. On Mon, Oct 22, 2018 at 1:22 PM R Smith wrote: > > On

Re: [sqlite] Regarding CoC

On Mon, Oct 22, 2018 at 12:22 PM R Smith wrote: > > On 2018/10/22 7:09 PM, Simon Slavin wrote: > > > > If you're not going to accept those rules, in exactly the translation > used, you might as well pick something entirely different. > > > > Simon. > > Indeed. Further to this, as I understand a

Re: [sqlite] Regarding CoC

On 2018/10/22 7:09 PM, Simon Slavin wrote: If you're not going to accept those rules, in exactly the translation used, you might as well pick something entirely different. Simon. Indeed. Further to this, as I understand a CoC, it's basically the core entity informing whomever be so

[sqlite] unsubscribe

___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regarding CoC

You would have had more luck with "Be excellent to each other". ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Custom serialization/deserialization of in-memory DB

On 22 Oct 2018, at 7:30pm, Zoltan Demeter wrote: > Or if I could tell SQLite to use custom file I/O routines ... I could mock > fwrite() to just write to memory and then grab the data. You can tell indeed SQLite to use custom file I/O routines ... by writing your own virtual filesystem (VFS):

Re: [sqlite] Custom serialization/deserialization of in-memory DB

https://www.sqlite.org/c3ref/serialize.html might help. On Mon, Oct 22, 2018, 11:31 AM Zoltan Demeter wrote: > Hello there, > > I am working on a small plugin for a bigger application. I am bound by > the in-house app framework, for example I cannot create arbitrary > files or use anything

Re: [sqlite] Regarding CoC

I really feel for you, DRH. You tried covering all the bases, unfortunately, you going to get tagged out at everyone because everybody is referee and they all follow their own rules.This goes straight to your first point, "What is professional to some might be unprofessional to others." This akin

[sqlite] Custom serialization/deserialization of in-memory DB

Hello there, I am working on a small plugin for a bigger application. I am bound by the in-house app framework, for example I cannot create arbitrary files or use anything OS-specific directly. I am using SQLite with an in-memory DB to obtain sorted, filtered lists of items. I am happy with the

Re: [sqlite] Regarding CoC

Funny world that one needs a code of contact to be considered civilized. No need to defend your CoC. I see it as a non-exhaustive list of values important to the developers. That they are Christian-based gives some context for their interpretation. Can't see any fault in that. I may or may

Re: [sqlite] R*Tree performance

Hello there, thanks for the responses. Indeed, I don't have anything to compare the performance to. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regarding CoC

For feedback from one more random person on the internet: I'll let you know that the CoC as it currently stands, along with your reasoning below, brings a smile to my face and restores a small bit of faith in humanity to my heart. -Original Message- From: sqlite-users

Re: [sqlite] Regarding CoC

SQLite lost a lot of credibility with a lot of people over this stunt. I know you think it doesn’t matter, but SQLite is a brand- this tarnishes that brand and makes life more difficult for those of us who need to justify using it to project stakeholders. If it is a serious CoC, stakeholders see a

Re: [sqlite] Regarding CoC

> On Oct 22, 2018, at 5:29 PM, Richard Hipp wrote: > > In summary Leave it as it is, no one is going to loose sleep over it. Now, about that MERGE command... :) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Regarding CoC

On 22 Oct 2018, at 5:32pm, someone wrote: > I would vote for a major simplification There's no point. The point of the code a posted is that it is a direct copy of the code of St. Benedict, the rules (allowing for translation from the Latin) which have been accepted by Benedictine monks for

Re: [sqlite] Regarding CoC

I would vote for a major simplification, down to something like "love thy neighbor", "do unto others as ...", or "don't do unto others as ..." For reference: * https://www.simpletoremember.com/jewish/blog/loving-thy-neighbor-judaism/ *

Re: [sqlite] Regarding CoC

On 22 Oct 2018, at 1:19pm, Richard Hipp wrote: > Looks like that happened this morning. > https://news.ycombinator.com/item?id=18273530 It also hit Reddit, in /r/programming. Currently 239 comments:

Re: [sqlite] Regarding CoC

On 10/22/18, Chris Brody wrote: >> Looks like that happened this morning. >> https://news.ycombinator.com/item?id=18273530 > > I saw it coming, tried to warn you guys in private. There is indeed a reactionary hate mob forming on twitter. But most of the thoughtful commentators have been

Re: [sqlite] Regarding CoC

> Looks like that happened this morning. > https://news.ycombinator.com/item?id=18273530 I saw it coming, tried to warn you guys in private. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Regarding CoC

To be fair, internet is considered to be series of reposts. On Mon, Oct 22, 2018, 15:20 Richard Hipp On 10/19/18, Simon Slavin wrote: > > > > Yeah, that's gonna magically appear on Hacker News within the month. For > > those curious ... > > > > Looks like that happened this morning. >

Re: [sqlite] R*Tree performance

On Mon, Oct 22, 2018 at 2:03 PM Richard Hipp wrote: > On 10/22/18, Zoltan Demeter wrote: > > I have a rather poor performance of 50 k inserts per second. The data > > to be inserted is precalculated and passed to the loop. I am using the > > same logic as above, so the loop is wrapped in a

Re: [sqlite] Regarding CoC

On 10/19/18, Simon Slavin wrote: > > Yeah, that's gonna magically appear on Hacker News within the month. For > those curious ... > Looks like that happened this morning. https://news.ycombinator.com/item?id=18273530 -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] R*Tree performance

On 10/22/18, Zoltan Demeter wrote: > > I have a rather poor performance of 50 k inserts per second. The data > to be inserted is precalculated and passed to the loop. I am using the > same logic as above, so the loop is wrapped in a transaction and I use > a parametrized statement. > Inserting

Re: [sqlite] help, sqlite3_get_table return 21，

On 10/22/18, W J wrote: > Hello , > > I'm using sqlite3_get_table() to query some information from sqlite. but > sometimes( not every time), I got error return value: 21. > #define SQLITE_MISUSE 21 /* Library used incorrectly */ > > What is the real meaning of this error? How to correct

Re: [sqlite] SQLITE_ENABLE_DBSTAT_VTAB

On 10/22/18, Olivier Mascia wrote: > > Does compiling SQLite with SQLITE_ENABLE_DBSTAT_VTAB has a performance > impact of any sort? No. Not that is measurable. Anytime you change a library in any way, there is always some performance impact (which might be positive or negative) due to changes

[sqlite] help, sqlite3_get_table return 21，

Hello , I'm using sqlite3_get_table() to query some information from sqlite. but sometimes( not every time), I got error return value: 21. #define SQLITE_MISUSE 21 /* Library used incorrectly */ the version information is follow: #define SQLITE_VERSION"3.8.4.3" #define

[sqlite] SQLITE_ENABLE_DBSTAT_VTAB

Hello, Does compiling SQLite with SQLITE_ENABLE_DBSTAT_VTAB has a performance impact of any sort? -- Best Regards, Meilleures salutations, Met vriendelijke groeten, Olivier Mascia, http://integral.software ___ sqlite-users mailing list

[sqlite] R*Tree performance

Hello there, I would like to get an idea, what (insert) performance I could expect when building a 3-dimensional (float) R*Tree. I am using SQLite as a static lib, compiled with the following defines: "SQLITE_ENABLE_RTREE" "SQLITE_OMIT_DEPRECATED" "SQLITE_THREADSAFE=2" "SQLITE_MAX_EXPR_DEPTH=0"

Re: [sqlite] segmentation fault in sqlite api call

Your query string is ~ 61 characters (did not count precisely), not including the key length not the value length. Are you sure the real tests you run do not overflow the fixed buffer char query[200] which can hold no more than 199 characters? You would have huge problems as soon as