Re: [sqlite] What if OpenDocument were built atop SQLite?

On Tue, Sep 9, 2014 at 6:46 AM, Stephan Beal wrote: > On Tue, Sep 9, 2014 at 12:45 AM, Nico Williams > wrote: > >> I've played with building a JSON extension for SQLite3 using jq's >> excellent JSON C library. The biggest "problem" with that work

Re: [sqlite] What if OpenDocument were built atop SQLite?

On Tue, Sep 9, 2014 at 12:45 AM, Nico Williams wrote: > I've played with building a JSON extension for SQLite3 using jq's > excellent JSON C library. The biggest "problem" with that work is that the extension has to serialize values to JSON (and, of course, > parse) in

Re: [sqlite] What if OpenDocument were built atop SQLite?

On Mon, Sep 8, 2014 at 9:44 PM, Keith Medcalf wrote: > > Not really very difficult, and it does not require another type. You just > need a scalar function to process the URI passed to the function and return > the result -- just like the readfile() (in the fileio.c

Re: [sqlite] What if OpenDocument were built atop SQLite?

Not really very difficult, and it does not require another type. You just need a scalar function to process the URI passed to the function and return the result -- just like the readfile() (in the fileio.c extension, or included in the shell) function does for a "file-specifier" which can be

Re: [sqlite] What if OpenDocument were built atop SQLite?

On Mon, Sep 8, 2014 at 8:05 PM, John McKown wrote: > Hum, why not a URI data type instead? ref: Because we're talking about a purely internal type, with internal linkage. Externally it would appear as TEXT or BLOB. You'd use the TEXT type to store JSON, XML, ...,

Re: [sqlite] What if OpenDocument were built atop SQLite?

On Mon, Sep 8, 2014 at 6:32 PM, Nico Williams wrote: > On Mon, Sep 8, 2014 at 6:16 PM, Simon Slavin wrote: >> On 8 Sep 2014, at 11:45pm, Nico Williams wrote: >>> It'd also be good to have JSON and XML support, possibly as an

Re: [sqlite] What if OpenDocument were built atop SQLite?

On Mon, Sep 8, 2014 at 6:16 PM, Simon Slavin wrote: > On 8 Sep 2014, at 11:45pm, Nico Williams wrote: >> It'd also be good to have JSON and XML support, possibly as an >> loadable extension. That way XPath and similar expressions matching >> document

Re: [sqlite] What if OpenDocument were built atop SQLite?

On 8 Sep 2014, at 11:45pm, Nico Williams wrote: > It'd also be good to have JSON and XML support, possibly as an > loadable extension. That way XPath and similar expressions matching > document snippets in SQL string values could be used in SQL queries. Not so sure

Re: [sqlite] What if OpenDocument were built atop SQLite?

It'd also be good to have JSON and XML support, possibly as an loadable extension. That way XPath and similar expressions matching document snippets in SQL string values could be used in SQL queries. I've played with building a JSON extension for SQLite3 using jq's excellent JSON C library. The

Re: [sqlite] Final preparations for the release of System.Data.SQLite v1.0.94.0 have begun...

Hi, The issue I found about indexes on another column than the primary key is now corrected, I obtain the desired results. Thank you for your efficiency and your quickness. Eric DAVID -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De

Re: [sqlite] What if OpenDocument were built atop SQLite?

And now that SQLite3 has recursive queries, building a mapping of XML->SQL is relatively easy, which might make it even easier to switch to SQLite3. (Speaking of which, a XPath to SQL compiler would be really nice. I haven't sat down to think about whether that'd be feasible, but my impression

Re: [sqlite] What if OpenDocument were built atop SQLite?

On 08/09/14 05:35, Richard Hipp wrote: > See the essay at: > >http://www.sqlite.org/affcase1.html > > Comments, criticism, and feedback are welcomed. BTW historically Microsoft used a "file system" for Office files before the XML stuff (ie even in the first versions from over 20 years ago).

Re: [sqlite] Final preparations for the release of System.Data.SQLite v1.0.94.0 have begun...

Pre-release packages are now available at: https://system.data.sqlite.org/index.html/doc/preRelease/www/downloads.wiki If you have any issues with these packages, please report them via this mailing list (and/or by creating a ticket on "https://system.data.sqlite.org/;) prior to Friday,

Re: [sqlite] Python - database disk image is malformed

On Mon, Sep 8, 2014 at 1:56 PM, Andres Riancho wrote: > On Mon, Sep 8, 2014 at 2:27 PM, Roger Binns wrote: > > > > It sounds like what you could use temporary tables and let SQLite do the > > work for you. > > > Hmmm. How about this. Stop

Re: [sqlite] Python - database disk image is malformed

On Mon, Sep 8, 2014 at 2:37 PM, Roger Binns wrote: > On 08/09/14 03:49, Andres Riancho wrote: >> Off-list some guys contacted me and mentioned APSW [0], another >> wrapper around sqlite for python, and said that it might be worth >> giving it a try. Do you guys believe that

Re: [sqlite] Python - database disk image is malformed

On Mon, Sep 8, 2014 at 2:27 PM, Roger Binns wrote: > On 08/09/14 03:29, Andres Riancho wrote: >> In my project we use the database to store data during the process >> life, and then remove it when the process finishes. > > It sounds like what you could use temporary tables

Re: [sqlite] Python - database disk image is malformed

On 08/09/14 03:49, Andres Riancho wrote: > Off-list some guys contacted me and mentioned APSW [0], another > wrapper around sqlite for python, and said that it might be worth > giving it a try. Do you guys believe that a change in wrapper could > improve my situation? Thanks! (Disclosure: I am

Re: [sqlite] System.Data.SQLite - issues

Chris Abbott wrote: > > I've also noticed a drastic degradation in speed with this release over > 1.0.86. > This issue should be fixed in 1.0.94.0. Please try with the pre-release bits available at: https://system.data.sqlite.org/index.html/doc/preRelease/www/downloads.wiki -- Joe

Re: [sqlite] Python - database disk image is malformed

On 8 Sep 2014, at 6:27pm, Roger Binns wrote: > The problem with synchronous off is that all your code has to be perfect, Hmmm. How about this. Stop turning synchronous off for a month or two and see if people stop reporting the fault. Simon.

Re: [sqlite] Python - database disk image is malformed

On 08/09/14 03:29, Andres Riancho wrote: > In my project we use the database to store data during the process > life, and then remove it when the process finishes. It sounds like what you could use temporary tables and let SQLite do the work for you. > With this in mind, sync=OFF still looks

Re: [sqlite] What if OpenDocument were built atop SQLite?

On 8 Sep 2014, at 1:35pm, Richard Hipp wrote: > See the essay at: > > http://www.sqlite.org/affcase1.html You would need to provide some short and simple 'viewer' code which can be used to extract a 'Quick View' or 'Thumbnail' file from the database, so the GUI Shell can

[sqlite] A weird issue in android c++ app that uses sqlite3

Hi Everyone We have been working on an android app which uses cocos2dx. We use sqlite3 for storing data locally on the device. We use c++ code to connect and use the database. Recently we used transactions, it runs fine on iOS platform (cocos2dx apps are cross platform) but it fails on android.

Re: [sqlite] Query help

> There are two ways to rewrite this query, with a correlated subquery: > > SELECT * > FROM table_a AS x > WHERE NOT EXISTS (SELECT 1 >FROM table_b AS y >WHERE x.id = y.id > AND x.col = y.col) > > or with an outer join: > >

Re: [sqlite] Request to change int parameter to size_t parameter / potential bug on iOS (64 bit)

> Roger Binns wrote on Sunday, September 07, 2014 2:30 PM > On 07/09/14 11:19, Richard Hipp wrote: > > Please use a cast to silence the compiler warnings. > "(int)sizeof(...)" > > instead of just "sizeof(...)". > > That isn't safe for correctly written 64 bit apps. For example they > could end

Re: [sqlite] Query help

Joseph L. Casale wrote: > SELECT x.id, x.col > FROM table_a x > EXCEPT > SELECT y.id, y.col > FROM table_b y > JOIN table_a . This query is not complete, but as far as I can tell, it is intended to return table_a rows that do not have a matching table_b row. Is this correct? > now

Re: [sqlite] What if OpenDocument were built atop SQLite?

Hello Richard, Monday, September 8, 2014, 8:35:30 AM, you wrote: RH> See the essay at: RH>http://www.sqlite.org/affcase1.html RH> Comments, criticism, and feedback are welcomed. I use Sqlite as a container for images because it's superior to CBR/CBZ files (which are rar and zip

Re: [sqlite] What if OpenDocument were built atop SQLite?

On Mon, Sep 8, 2014 at 7:35 AM, Richard Hipp wrote: > See the essay at: > >http://www.sqlite.org/affcase1.html > > Comments, criticism, and feedback are welcomed. > -- > D. Richard Hipp > d...@sqlite.org A very good presentation of an good idea. Although I am not a developer

Re: [sqlite] Python - database disk image is malformed

On 8 Sep 2014, at 11:47am, Andres Riancho wrote: > On Sun, Sep 7, 2014 at 11:39 PM, Simon Slavin wrote: > >> There are two possibilities: >> >> A) The database really is malformed >> B) The client's copy of SQLite is returning that code by

Re: [sqlite] Does the Connection string support UNC paths?

a...@zator.com wrote... Mensaje original De: "Chris" Para: Fecha: Sat, 6 Sep 2014 23:46:19 -0500 Asunto: [sqlite] Does the Connection string support UNC paths? I am old database programmer that just came across SQLite and

[sqlite] What if OpenDocument were built atop SQLite?

See the essay at: http://www.sqlite.org/affcase1.html Comments, criticism, and feedback are welcomed. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Whats the SQLite Encryption Algo?

On 8 Sep 2014, at 9:16am, Tom Ashley wrote: > I noticed that in C# I can set a password using SetPassword. Does this > encrypt the entire database? If so, What algorithm precisely does it use? See this and get back to us if

Re: [sqlite] System.Data.SQLite - issues

writes: > > Hi, > Below are the two issues I would like to report for SQLite .Net client. > 1. SQLiteDataReader.GetString() method: > The method fails with "Invalid cast exception" when you try to retrieve a number stored in a text field. > > 2. SQLiteDataReader.GetValue

[sqlite] Whats the SQLite Encryption Algo?

I noticed that in C# I can set a password using SetPassword. Does this encrypt the entire database? If so, What algorithm precisely does it use? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite and Windows 95

Hi. http://blog.livedoor.jp/blackwingcat/archives/1813730.html I compiled SQLite 3.7.17 and 3.8.0.2 for Windows 95 before. If you want to know the reason why it would not work on Win95, see the following article. http://blog.livedoor.jp/blackwingcat/archives/1804729.html -- View this message

Re: [sqlite] Python - database disk image is malformed

Off-list some guys contacted me and mentioned APSW [0], another wrapper around sqlite for python, and said that it might be worth giving it a try. Do you guys believe that a change in wrapper could improve my situation? Thanks! [0] https://github.com/rogerbinns/apsw On Sun, Sep 7, 2014 at 11:11

Re: [sqlite] Python - database disk image is malformed

Simon, On Sun, Sep 7, 2014 at 11:39 PM, Simon Slavin wrote: > > On 8 Sep 2014, at 3:11am, Andres Riancho wrote: > >>I'm using sqlite as the database backend for an open source >> project and it works perfectly 99% of the time; however some

Re: [sqlite] Python - database disk image is malformed

Roger, On Mon, Sep 8, 2014 at 12:26 AM, Roger Binns wrote: > On 07/09/14 19:11, Andres Riancho wrote: >> * I'm setting [4] "PRAGMA synchronous=OFF" for increased >> performance. Can this trigger malformed errors? > > Read the doc: > >