Re: [sqlite] Sweet 16

[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 occurred 16 years ago today.
>> https://www.sqlite.org/src/timeline?c=2000-05-29
>>
>
> Congratulations on that!  Thank you for all of that work.  Stay strong and
> keep moving on.
>
> Coincidentally, that first commit date is within a month or so of the
> first time I ever released open-source code to the public (on CPAN).
>
> -- Darren Duncan
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Noël Frankinet
Strategis sprl
0478/90.92.54
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to study the Vdbe in SQLite?

[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 vdbe part?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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:
>
>> Hi
>>
>>
>> In the R interface to SQLite [1], we observe that opening a database with
>> ":memory:" does not work anymore on Windows (both 32- and 64-bit versions),
>
>
might it be a problem with the R wrapper? If it cannot be reproduced in the
cli client then the wrapper is the most likely culprit.

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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 into foo values('test');
sqlite> select rowid from foo where foo match 'test' order by rank;
rowid
1
sqlite> select rowid from foo where foo match 'test OR foo' order by
rank;
Error: database disk image is malformed


Thanks for reporting this. As you no doubt surmised, the db is not 
corrupt but a bug in FTS5 is causing it to report so. Now fixed here:


  http://sqlite.org/src/info/64ca1a835a89fd21

Dan.

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

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

[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 keywords in the corpus (such
as ascii lf or some other acronyms).

I'm wondering if there is an option to tell the tokenizer not to stem
certain keywords and take them as it is?


No way to do that with any of the built-in tokenizers for either fts3/4 
or fts5. The only way would be to write a custom tokenizer.


  https://www.sqlite.org/fts5.html#section_7_1

Dan.




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


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

[sqlite] alter table and .schema output

[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 pratica_protocollo ADD COLUMN  cage_attribuzione_anno
   integer;
ALTER TABLE pratica_protocollo ADD COLUMN  cage_attribuzione_numero
   integer;

and the .schema on the table provides now:

CREATE TABLE pratica_protocollo(
...

note varchar( 2048 ), cage_attribuzione_anno integer,
cage_attribuzione_numero   integer, -- note per l'integrazione
)

As you can see, the columns have been added before the SQL comment on
the last column of the table.
While this does not have any implicit or functional problem, I suspect
it could avoid some tools to work on "annotated" schemas.
Am I missing something on the ALTER TABLE side or this behavior is normal?
I'm running 3.8.11.1.

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

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

[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 about how it works.  The changes between the two version are easy to 
understand if you have read this page.

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

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

[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, and I really like the nice front end
and reporting capabilities that come with that.  But it costs money to keep
Access around, and it is usable only on my PC.  I decided I could live
without the prettiness so that I would have something that is more flexible
and will remain accessible even if I don't have a Windows machine in the
future.


I agree on the user-oriented front-end that MSSQL has, both in the SMS 
and the Access application, but you'll find there are quite a few that 
makes life with SQLite a pleasure too - some of them very user oriented. 
May I suggest, if you use Windows as a vehicle, you try either:

SLite Expert from: http://www.sqliteexpert.com/
or SQLitespeed from: http://www.sqlc.rifin.co.za/

If between those you don't get most of the features you need (or you 
need it on other platforms or perhaps connectors), there are many others 
that a simple Google will find.


Best of luck,
Ryan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] alter table and .schema output

[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 .schema on the table provides now:
>
> CREATE TABLE pratica_protocollo(
> ...
>
> note varchar( 2048 ), cage_attribuzione_anno integer,
> cage_attribuzione_numero   integer, -- note per l'integrazione
> )
>
> As you can see, the columns have been added before the SQL comment on
> the last column of the table.

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 too complex; and in any case the DB cannot know whether the comment
belongs to the column or the table.


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

Re: [sqlite] alter table and .schema output

[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 too complex; and in any case the DB cannot know whether the comment
> belongs to the column or the table.

Thanks, I was suspecting it.
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.

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

Re: [sqlite] alter table and .schema output

[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 want it to look good even after an ALTER TABLE, put
the comment before the comma:

CREATE TABLE ... (
...
Col /* hi! */,
...
);

To ensure that there is a comma after the last column, always use
a table constraint (e.g., PRIMARY KEY, or a dummy CHECK(1)).


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

Re: [sqlite] alter table and .schema output

[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 column definition in the next line would
be too complex; and in any case the DB cannot know whether the comment
belongs to the column or the table.

Thanks, I was suspecting it.
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.


There is no more-correct way in SQL terms, but there is an option that 
works for most of us - simply use /* ... */ style commenting and add it 
before the comma, like so:

CREATE TABLE xxx(
...
  Col3 INT NOT NULL /* Comment here */,
  Col4 TEXT /* Comment two */ NOT NULL,
...etc.
);

Some DB managers even read these as metadata, such as this documentation 
example produced by SQLitespeed. You can see the schema SQL that 
prompted the detail in there, and if you look at the Numbers table, you 
can see the same effect achieved for other objects, like triggers and 
Indices:

http://www.sqlc.rifin.co.za/SchemaDocExample2.html

or if you prefer a more contrasting version:
http://www.sqlc.rifin.co.za/SchemaDocExample1.html

Hope that helps!
Ryan


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

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

[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 26.05.2016 14:57, Kirill Müller wrote:


Hi


In the R interface to SQLite [1], we observe that opening a database with
":memory:" does not work anymore on Windows (both 32- and 64-bit versions),



might it be a problem with the R wrapper? If it cannot be reproduced in the
cli client then the wrapper is the most likely culprit.

The R wrapper is rather thin at this point, perhaps the build 
environment is triggering this. It used to work with an older version of 
SQLite, thoujgh. I'd be happy to run a bisection against SQLite, but I'm 
having trouble finding intermediate amalgamation sources, and I'm not 
really familiar with Fossil. I'd appreciate any pointers on bisecting 
SQLite. Thanks.



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

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

[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) Install Fossil.  You can either download the precompiled
stand-alone binary from https://www.fossil-scm.org/download.html and
put that binary somewhere on your $PATH, or you can compile the
stand-alone binary yourself, from sources.
(https://www.fossil-scm.org/fossil/doc/trunk/www/build.wiki)  Either
way, installing is just a matter of putting the "fossil" or
"fossil.exe" file on your $PATH or %PATH% and uninstalling is simply
deleting the binary.

(3) Clone the SQLite repo:  fossil clone http://www.sqlite.org/src sqlite.fossil

(4) Open a check-out on the SQLite repo:  fossil open sqlite.fossil

(5) Make sure you can build:  ./configure; make sqlite3.c

(6) Start the bisect:  "fossil bisect reset; fossil bisect good
version-3.11.0; fossil bisect bad trunk".  In place of
"version-3.11.0" and "trunk", substitute whatever tags and/or SHA-1
check-in hashes and/or ISO8601 timestamps are appropriate to define
the end-points of the bisection.

(7) Rebuild and test.  Then type "fossil bisect good|bad" as
appropriate.  "fossil bisect undo" is available if you make a mistake
and need to back up.

(8) When the bisect finishes (or at any time in between) you can do
"fossil bisect ui" to see a timeline graph of the bisection.
-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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
SQLITE_ENABLE_SESSION
SQLITE_ALLOW_URI_AUTHORITY
SQLITE_ENABLE_EXPLAIN_COMMENTS
SQLITE_ENABLE_FTS3_TOKENIZER
SQLITE_ENABLE_RBU
SQLITE_ENABLE_STMT_SCANSTATUS
SQLITE_ENABLE_SQLLOG
SQLITE_USE_FCNTL_TRACE
SQLITE_DISABLE_FTS3_UNICODE
SQLITE_DISABLE_FTS4_DEFERRED
(Via a quick comparison. There may be others.)

Noticed this when "PRAGMA compile_options" did not return everything that
was anticipated.

Steps to Reproduce:
-Build SQLite with one or more of the affected compilation options defined
(ex: SQLITE_ENABLE_PREUPDATE_HOOK).
-Execute "PRAGMA compile_options" on a new database connection.

Expected Result:
-All compilation options that were defined will be returned (ex: including
ENABLE_PREUPDATE_HOOK).

Actual Result:
-The returned compilation options are missing certain entries (ex:
ENABLE_PREUPDATE_HOOK).

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

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

[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, etc.  But it seems to be a single-person
development effort, so improvements are slow in coming. SQlite Expert has
its own advantages including built-in viewers for images so that images
stored as blobs in a SQLite db can be browsed instead of having to export
them as files before looking at them. I have never tried SQLiteSpeed, and
from its description, it seems to be very similar to the other two.

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
enable event-based computations, etc.  The ability to arrange inputs and
outputs using boxes that can be moved around on a page so that you get
exactly the look and feel you are looking for instead of the straight (but
endless) scrolling between rows and columns.  The flexibility to make the
forms and reports single-record or continuous.  A multitude of charting
options to visualize data rather than just looking at numbers.  And the
parent-child nesting of forms and subforms in Access is an elegant solution
to the problem of updating the main table while simultaneously adding new
entries to a related table to keep foreign keys in the main table in sync.
Nothing like that exists in any of the front ends I have looked at for
SQLite.  And unfortunately, Access can't read SQLite files directly either.

I don't blame SQLite for not having something like that.  In fact, I know
no other db product that comes with all this built-in.  There are bolt-on
products like crystal reports that will work with other db products to
provide this kind of reporting capability, but that just increases the
complexity of what all you have to pay for and keep up to date, and you can
completely forget about platform independence.

The only other way to handle what I used to do in Access is for me to learn
PHP and use a web browser as the front end.  That is now on my to-do list.
In the meantime, sqlite studio and sqlite expert are passable.

On the android side, there is a front end similar to sqlite expert called
aSQLiteManager (
https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager).
But this also seems to be more of a 1-person development effort, so I am
not sure how feature-rich it will eventually become.

Balaji Ramanathan

>I agree on the user-oriented front-end that MSSQL has, both in the SMS and
the Access application, but you'll find there are quite a few >that makes
life with SQLite a pleasure too - some of them very user oriented. May I
suggest, if you use Windows as a vehicle, you try >either:
>SLite Expert from: http://www.sqliteexpert.com/
>or SQLitespeed from: http://www.sqlc.rifin.co.za/
>
>If between those you don't get most of the features you need (or you need
it on other platforms or perhaps connectors), there are many >others that a
simple Google will find.

>Best of luck,
>Ryan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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 are not real applications - they require Access to be 
on the target machines. Those are essentially scripted forms running on 
Access to deal with data, a complication by any standard. It's M$'s way 
of making something feel like programming your own system when your 
really you are not. Why not simply do it for real? Access is not less 
complicated than any other - It hails from the days of Mail-Merge and 
other once-great ideas that's been usurped by modern accessibility. The 
reason there are no other systems like Access, and no-one else bothers, 
is a testament to how useful it is. I am willing to venture out and say 
that the only reason Access had any survivability is that it comes 
bundled with Office[1].


If you try your hand at some programming, there are myriad platforms 
available where you can build custom applications requiring Zero 
pre-installed applications, all with arrays of custom text boxes and 
what all to make displaying/editing data a pleasure for the end user. 
And you can connect to any DB with such a system, not just SQLite. you 
could even find those that still use VB, but probably C or such would be 
better. MSVC and Lazarus (among others) are both excellent and free. 
Delphi is probably by far the best rapid development tool out there, 
faster than Access at making multi-tier data applications, and then use 
the same code over Windows, Mac, iPhone and Android, but it is also 
really expensive (though you only pay for the tool, with Access you have 
to pay per end user!).



On the other hand - if you really like Access, it can be used with 
SQLite too. Here is a quick guide:

http://sqlite.awardspace.info/syntax/sqliteodbc.htm



[1] - If the above sounds like I am strongly opposed to Access - I'm 
not, I think it's a great tool for some very specific uses - but should 
be avoided for any other uses.

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

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

[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:
https://support.office.com/en-us/article/Deploy-an-Access-2007-application-7bb4f2ba-30ee-458c-a673-102dc34bf14f
and https://www.microsoft.com/en-us/download/details.aspx?id=50040 .

Thanks for the pointers to Lazarus and MSVC.  Have to look into them.  The
first programming language I learned in college and one I still have a soft
spot for after all these years is Pascal.  As for using SQLite with Access,
once I got to that website and saw the references to Windows XP, I beat a
hasty retreat!  I am not that desperate, thank you very much!!

Balaji Ramanathan

>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 are not real applications - they require Access to be
>on the target machines.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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 can get from MS according to this website//...


It still needs access to be installed on the target computer (even if in 
runtime form), /but/, if that does not require any licensing then that 
is more than I knew or expected, and stand corrected on that point.



Thanks for the pointers to Lazarus and MSVC.  Have to look into them.  The
first programming language I learned in college and one I still have a soft
spot for after all these years is Pascal.


Lazarus and Delphi is what you need for Pascal development - it works a 
treat, plus I have very good Pascal SQLite wrapper objects you can have. 
(SQLiteExpert and SQLitespeed are both developed in it).
This thread is becoming a bit long-winded though, so any next discussion 
in this regard we should take offline.



   As for using SQLite with Access,
once I got to that website and saw the references to Windows XP, I beat a
hasty retreat!  I am not that desperate, thank you very much!!


Haha, well it's a primitive description, but the implementation is quite 
modern and works very well on Win10. (ODBC is alive and well!).


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

[sqlite] json arrays

[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
--

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

Re: [sqlite] json arrays

[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 this correctly but I'd assume it does 
until you have evidence to the contrary.  Given how SQLite works, if you've 
defined a column as numeric and feed it the string "12.34" you'll get a number 
anyway.

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