Re: [sqlite] Regarding CoC

On Oct 19, 2018 11:00 PM, "Roger Schlueter" wrote: There's no atheists/freethinkers at SQLite? There's at least one (me), but they can simply ignore all the God-related rules, easy. It gets a bit harder for Hindus though, they have to mentally add "(your favorite for this use case)" in front

Re: [sqlite] Regarding CoC

> On Oct 19, 2018, at 11:05 PM, Wout Mertens wrote: > > I can live with that. Yes, let’s get along for once. In the memorable words of President Dale: "Why can't we work out our differences? Why can't we work things out? Little forum people, why can't we all just get along?” Mars Attacks!

Re: [sqlite] Regarding CoC

Well in the preface it does say that full compliance is near impossible and not required. I wouldn't call it antagonistic, it has many rules that are very inclusive of anyone. I must say it's a bit messy though, there are quite a few rules and not all of them are nicely orthogonal. Most of them

Re: [sqlite] Regarding CoC

There's no atheists/freethinkers at SQLite? If the second half of 54 is observed, it would be a dreary world indeed. Roger On 10/19/2018 10:30, Simon Slavin wrote: On 19 Oct 2018, at 6:26pm, Andrew Brown wrote: I looked it up, wondering what it would say, and I have to say, I love it.

Re: [sqlite] geopoly data input options

There a WKB and WKT (text) representation). You can probably find everything : http://www.opengeospatial.org Spatialite is also a good source . On Fri, 19 Oct 2018 at 22:47, Richard Hipp wrote: > On 10/19/18, Thomas Kurz wrote: > >> Beginning with the next release, polygons will always be

Re: [sqlite] geopoly data input options

On 10/19/18, Thomas Kurz wrote: >> Beginning with the next release, polygons will always be stored in the >> binary format. > > Is the SQLite binary encoding identical to the Well-Known-Binary geometry > format? That might have happened, except the WKB format was not known to me... Where can I

Re: [sqlite] clarification of the .binary option of the sqlite3 command shell program.

thanks for that. I had forgotten about taking a look at the source code. All clear now. Graham On 20-10-2018 12:29 am, Jay Kreibich wrote: On Oct 19, 2018, at 3:30 AM, Graham Hardman wrote: Hi, I am curious about what this option does. It is not discussed in the documentation and my own

Re: [sqlite] Regarding CoC

How come it hadn't yet? On Fri, Oct 19, 2018, 20:30 Simon Slavin wrote: > On 19 Oct 2018, at 6:26pm, Andrew Brown > wrote: > > > I looked it up, wondering what it would say, and I have to say, I love > it. > > Yeah, that's gonna magically appear on Hacker News within the month. For > those

Re: [sqlite] geopoly data input options

Thanks very much for your prompt reply. I had seen that I could use the geopoly_blob function to copy a json-formatted entry into a new record without getting an error from sqlite, however I was disconcerted when seeing that a select _shape from newtab (using example from documentation)

Re: [sqlite] geopoly data input options

Hmm... this seems to be different from WKB format. I was hoping that the geopoly extension would be compatible to established formats such as Spatialite. - Original Message - From: Keith Medcalf To: SQLite mailing list Sent: Friday, October 19, 2018, 21:05:02 Subject: [sqlite]

Re: [sqlite] geopoly data input options

From the source: /* ** Internal representation of a polygon. ** ** The polygon consists of a sequence of vertexes. There is a line ** segment between each pair of vertexes, and one final segment from ** the last vertex back to the first. (This differs from the GeoJSON ** standard in which the

Re: [sqlite] Regarding CoC

As if I needed another reason for SQLite to be my favorite database. Well done. On Fri, Oct 19, 2018 at 10:11 AM Richard Hipp wrote: > On 10/19/18, Mantas Gridinas wrote: > > > > I found code of conduct in documentation and I was wondering if it were > > true. Checking the version history it

Re: [sqlite] Regarding CoC

I have to admit I was a lot more excited about the concept of SQLite having a Code of Conduct until I actually read it. Regardless of the fact that I seem to fail a great many of its provisions, it seems fairly deaf—if not antagonistic—to the issues of our times that have created demand for

Re: [sqlite] Regarding CoC

On 19 Oct 2018, at 6:26pm, Andrew Brown wrote: > I looked it up, wondering what it would say, and I have to say, I love it. Yeah, that's gonna magically appear on Hacker News within the month. For those curious ... Simon.

Re: [sqlite] Regarding CoC

I looked it up, wondering what it would say, and I have to say, I love it. On Fri, Oct 19, 2018 at 7:11 AM Richard Hipp wrote: > On 10/19/18, Mantas Gridinas wrote: > > > > I found code of conduct in documentation and I was wondering if it were > > true. Checking the version history it appears

Re: [sqlite] A couple of questions about prepared statements

On 19 Oct 2018, at 17:33, Simon Slavin wrote: > On 19 Oct 2018, at 3:43pm, Tim Streater wrote: > >> is it OK to generate the myid and goodtext parts using the usual string >> methods from my host language, leaving only badtext as a bound variable, so >> that my prepared statement looks like

Re: [sqlite] Upsert syntax question

But isn't that the whole point of the whole UPSERT thing? https://www.sqlite.org/lang_UPSERT.html ... Ok, found my problem though https://www.sqlite.org/lang_insert.html To avoid a parsing ambiguity, the SELECT statement should always contain a WHERE clause, even if that clause is simply

Re: [sqlite] Upsert syntax question

On 19 Oct 2018, at 5:24pm, David Raymond wrote: > sqlite> insert into ids (id, in_new) select distinct id, 1 from gc_new on > conflict (id) do update set in_new = 1; You can't supply a statement for ON CONFLICT. It can only trigger IGNORE / FAIL / ABORT / ROLLBACK / REPLACE.

Re: [sqlite] A couple of questions about prepared statements

On 19 Oct 2018, at 3:43pm, Tim Streater wrote: > is it OK to generate the myid and goodtext parts using the usual string > methods from my host language, leaving only badtext as a bound variable, so > that my prepared statement looks like this: > > select somecol from mytable where myid=3 and

[sqlite] Upsert syntax question

Maybe it's just Friday, but I can't figure out what I'm messing up here. Would some kind soul point me to where I'm messing up? Version 3.25.2 sqlite> create table ids (id int primary key, in_old bool, in_new bool); QUERY PLAN `--SEARCH TABLE sqlite_master USING INTEGER PRIMARY KEY (rowid=?)

Re: [sqlite] A couple of questions about prepared statements

On 2018-10-19 10:43:21, "Tim Streater" wrote: Suppose I have an SQL statement like this: select somecol from mytable where myid=3 and badtext="usertext" and goodtext="somegoodtext" Suppose further that the values of myid and goodtext are generated by reliably me whereas badtext is

Re: [sqlite] geopoly data input options

> Beginning with the next release, polygons will always be stored in the > binary format. Is the SQLite binary encoding identical to the Well-Known-Binary geometry format? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

I suppose you COULD get rid of the \n in the query Its a Linux thing. *sigh* On Fri, Oct 19, 2018 at 10:50 AM Stephen Chrzanowski wrote: > This would be something you'd need to write something quick for. There's > no application in the world that knows how to use your specific schema and

Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

This would be something you'd need to write something quick for. There's no application in the world that knows how to use your specific schema and react to it. There may be apps that will read the values and automatically 'understand' that http:// and https:// are addresses, but, these probably

[sqlite] A couple of questions about prepared statements

Suppose I have an SQL statement like this: select somecol from mytable where myid=3 and badtext="usertext" and goodtext="somegoodtext" Suppose further that the values of myid and goodtext are generated by reliably me whereas badtext is supplied externally. If I want to use a prepared

Re: [sqlite] geopoly data input options

On 10/19/18, Graham Hardman wrote: > > My question now is : must I always format my list of vertices as text ( > in json format ) as shown in the documentation. No. Polygons can be either in the GeoJSON format as text, or in a binary format

Re: [sqlite] Regarding CoC

On 10/19/18, Mantas Gridinas wrote: > > I found code of conduct in documentation and I was wondering if it were > true. Checking the version history it appears to have been added on > 2018-02-22. > Yes. Clients were encouraging me to have a code of conduct. (Having a CoC seems to be a trendy

[sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

Hello, I have a bunch of hyperlinks in an SQLite database, and need to read each page for validation before deleting the record. To make it easier, the DB manager should launch the default web browser when I double click on a column that contains a hyperlink. Before I build a GUI, is there a

[sqlite] Regarding CoC

Hi! I found code of conduct in documentation and I was wondering if it were true. Checking the version history it appears to have been added on 2018-02-22. Cheers ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] clarification of the .binary option of the sqlite3 command shell program.

> On Oct 19, 2018, at 3:30 AM, Graham Hardman wrote: > > Hi, > > I am curious about what this option does. It is not discussed in the > documentation and my own testing with the shell program has not aided my > understanding. A simple example would be nice. It controls how data is output

Re: [sqlite] How to round to an Integer

I don't think the cast rounds, though. It just truncates. Am I wrong? RobR On Thu, Oct 18, 2018 at 4:13 PM Richard Hipp wrote: > On 10/18/18, John Harney wrote: > > Recently figured this out. Seems to work fine > > > > trim(trim(round(1.111,0),'0'),'.') = 1 > > > > CAST(1.111 AS integer)

[sqlite] clarification of the .binary option of the sqlite3 command shell program.

Hi, I am curious about what this option does. It is not discussed in the documentation and my own testing with the shell program has not aided my understanding. A simple example would be nice. regards, Graham ___ sqlite-users mailing list

[sqlite] geopoly data input options

Hi, this is my first post to this group so firstly: thanks for the oportunity to be here. I have long been in awe of sqlite's power and thankful of its open source nature. I see great possibilities for me to use the shape matching functions of the geopoly module to extend an autocad vba

Re: [sqlite] Why operations with in-memory DB are much faster than with on-disk DB?

Yuri wrote: > I noticed that my DB import process is much slower when run on the DB on > disk, vs. in memory. It's possible that you forgot to wrap a single transaction around all changes. Otherwise, you get an automatic transaction for every command, which requires disk synchronization every