Re: [sqlite] json arrays

2016-05-30 Thread Simon Slavin
On 31 May 2016, at 12:49am, Scott Doctor wrote: > Should numbers in a json array have quotes around the numbers? If you want an answer strictly about JSON, no quotes. This is a number: 12.34 and this is a string: "12.34" . I don't know whether SQLite implements

[sqlite] json arrays

2016-05-30 Thread Scott Doctor
Regarding json format, assume a list of numbers as a json array. Should numbers in a json array have quotes around the numbers? For example: {"result":["1.23","2.34","3.45"]} or {"result":[1.23,2.34,3.45]} -- Scott Doctor sc...@scottdoctor.com --

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-30 Thread R Smith
On 2016/05/30 11:39 PM, Balaji Ramanathan wrote: Nope, not true. You can make standalone applications using Access that don't require Access to be installed on the target machine. Not sure how the licensing works, but it is definitely possible. It just requires the Access run-time which you

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-30 Thread Balaji Ramanathan
Nope, not true. You can make standalone applications using Access that don't require Access to be installed on the target machine. Not sure how the licensing works, but it is definitely possible. It just requires the Access run-time which you can get from MS according to this website:

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-30 Thread R Smith
On 2016/05/30 7:09 PM, Balaji Ramanathan wrote: The strength of Access is not in having a good built-in front end, but in giving the user the ability to build a good custom front-end. Forms and reports with a visual basic based programming language (VBA) behind it to...// Ah ok, but those

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-30 Thread Balaji Ramanathan
Thank you for those suggestions, Ryan. I have used SQLiteExpert as well as SQLiteStudio. I actually like the latter. It has some interesting features such as cell-by-cell rollback and commit, the ability to add new rows to the bottom of a table regardless of where your cursor is at currently,

[sqlite] BUG: PRAGMA compile_options does not return all anticipated values (entries missing from azCompileOpt)

2016-05-30 Thread S
Quick Summary: "PRAGMA compile_options" does not return certain compilation options, despite them being defined for the build. (ex: SQLITE_ENABLE_PREUPDATE_HOOK) Details: azCompileOpt[] in ctime.c is missing an entry for several compilation options, including: SQLITE_ENABLE_PREUPDATE_HOOK

Re: [sqlite] ":memory:" path does not seem to work on Windows anymore

2016-05-30 Thread Richard Hipp
On 5/30/16, Kirill Müller wrote: > I'd appreciate any pointers on bisecting > SQLite. Thanks. (1) Make sure you have tclsh 8.5 or later installed on your system, as there are various TCL scripts that SQLite makefile needs to run in order to build the amalgamation. (2)

Re: [sqlite] ":memory:" path does not seem to work on Windows anymore

2016-05-30 Thread Kirill Müller
On 30.05.2016 09:57, Stephan Beal wrote: On Mon, May 30, 2016 at 8:35 AM, Kirill Müller wrote: I can't reproduce the issue on Windows with the current command-line client, but it is real in our environment. How can I help you replicate it? Thanks. -Kirill On

Re: [sqlite] alter table and .schema output

2016-05-30 Thread R Smith
On 2016/05/30 12:39 PM, Luca Ferrari wrote: On Mon, May 30, 2016 at 12:24 PM, Clemens Ladisch wrote: This is normal. The ALTER TABLE adds the new column(s) immediately behind the actual column definition. Inserting a comma before the comment and the rest of the new

Re: [sqlite] alter table and .schema output

2016-05-30 Thread Clemens Ladisch
Luca Ferrari wrote: > Is there a "correct" way to annotate SQL schema? Other databases > provides special commands (e.g., PostgreSQL ADD COMMENT), but I don't > see nothing in SQLIte3 syntax except the SQL '--' one. If those annotations are to be queried, put them into a table. Otherwise, if you

Re: [sqlite] alter table and .schema output

2016-05-30 Thread Luca Ferrari
On Mon, May 30, 2016 at 12:24 PM, Clemens Ladisch wrote: > This is normal. The ALTER TABLE adds the new column(s) immediately > behind the actual column definition. Inserting a comma before the > comment and the rest of the new column definition in the next line would > be

Re: [sqlite] alter table and .schema output

2016-05-30 Thread Clemens Ladisch
Luca Ferrari wrote: > CREATE TABLE pratica_protocollo( > ... > note varchar( 2048 ) -- note per l'integrazione > ); > > ALTER TABLE pratica_protocollo ADD COLUMN cage_attribuzione_anno >integer; > ALTER TABLE pratica_protocollo ADD COLUMN cage_attribuzione_numero >integer; > > and the

Re: [sqlite] Messages posted on Nabble not getting to list

2016-05-30 Thread R Smith
On 2016/05/30 1:17 AM, Balaji Ramanathan wrote: It was too much database for my purposes as far as this project was concerned. Same with PostgreSQL. Also, I wanted something that would be easily accessible from my android phone/tablet as well as my PC. I have been using MS Access all along,

Re: [sqlite] How to study the Vdbe in SQLite?

2016-05-30 Thread Simon Slavin
On 30 May 2016, at 8:28am, sanhua.zh wrote: > I find that sqlite.org only explains the reference and a > fewobsoletetutorialabout vdbe. The page Is about an earlier version of the VDBE, but it is a long page which explains a lot

[sqlite] alter table and .schema output

2016-05-30 Thread Luca Ferrari
Hi all, I've a doubt about the SQL that .schema provides regarding a single table. I've a table that has been created (and reported back by .schema) as follows: CREATE TABLE pratica_protocollo( ... note varchar( 2048 ) -- note per l'integrazione ); The I ran the following: ALTER TABLE

Re: [sqlite] Preventing certain query keywords from getting stemmed

2016-05-30 Thread Dan Kennedy
On 05/30/2016 12:00 AM, Abhinav Upadhyay wrote: Hi, While running queries, sometimes there are technical keywords which shouldn't be stemmed by the tokenizer. For example, if I query for "lfs" (which is a file system), the porter stemmer, converts it to "lf", which matches many other unrelated

Re: [sqlite] BUG: FTS5 query containing OR + order by rank

2016-05-30 Thread Dan Kennedy
On 05/29/2016 04:22 AM, Jan Berkel wrote: I'm getting "database disk image is malformed" errors when running a query containing OR and ordering by rank against a FTS5 index: $ sqlite3 SQLite version 3.13.0 2016-05-18 10:57:30 sqlite> create virtual table foo using fts5(bar); sqlite> insert

Re: [sqlite] ":memory:" path does not seem to work on Windows anymore

2016-05-30 Thread Stephan Beal
On Mon, May 30, 2016 at 8:35 AM, Kirill Müller wrote: > I can't reproduce the issue on Windows with the current command-line > client, but it is real in our environment. How can I help you replicate it? > Thanks. > > > -Kirill > > On 26.05.2016 14:57, Kirill Müller wrote:

[sqlite] How to study the Vdbe in SQLite?

2016-05-30 Thread sanhua.zh
I find that sqlite.org only explains the reference and a fewobsoletetutorialabout vdbe. Without a“Getting Started” tutorial, I feel a little hard to trace the source code in this part, although I have already read the btree part. Is there any suggestion for theinitiate like me to start up the

Re: [sqlite] Sweet 16

2016-05-30 Thread Noel Frankinet
I ported sqlite to windowsCe in 2003, I didn't know I was so soon ! Congratulation to an incredible piece of code ! Best wishes. Noël On 30 May 2016 at 05:47, Darren Duncan wrote: > On 2016-05-29 10:28 AM, Richard Hipp wrote: > >> The first check-in of SQLite code

Re: [sqlite] ":memory:" path does not seem to work on Windows anymore

2016-05-30 Thread Kirill Müller
I can't reproduce the issue on Windows with the current command-line client, but it is real in our environment. How can I help you replicate it? Thanks. -Kirill On 26.05.2016 14:57, Kirill Müller wrote: Hi In the R interface to SQLite [1], we observe that opening a database with