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 is > > that the extension has to serialize value

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 many cases where it could

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 extension, or > included in

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 o

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, ..., BLOB to store binary encodings.

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 >>> loadable extension. That way XPath and similar expressions matchin

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 snippets in SQL string values could be used i

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 about that. There are JSON

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 is

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, Septem

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 turning synchronous off for a month or two > and see if

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 a change in wrapper cou

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 and let SQLite do the >

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 the

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. ___ s

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 like

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 show it to the use

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

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: > > SELECT

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 up

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 I

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 fil

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 or historian of O

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 mistake. >> >> Can you have one of these clients sen

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 am working on a small project for a PVR that uses

[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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-use

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 you have questions. The ba

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 performance in versio

[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 http://sqlite.org:8080/cgi-bin/mailman/listinfo/

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 P

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 users >> have reported "database disk image is malfo

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: > > https://sqlite.org/pragma.html#pragma_synchronous >