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

2014-09-10 Thread Richard Hipp
On Wed, Sep 10, 2014 at 9:02 AM, Gabor Grothendieck wrote: > > There is also a breakdown of libre office code here with graphs and a > table: > https://www.openhub.net/p/libreoffice/analyses/latest/languages_summary > > The corresponding page for sqlite is: >

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

2014-09-10 Thread Gabor Grothendieck
On Wed, Sep 10, 2014 at 8:36 AM, John McKown wrote: > Well, I did a git clone to fetch the LibreOffice source. It appears to > be a mixture of Java, C, and C++. Just some stats: > > $find . -name '*.c' | wc > 108 1083908 >

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

2014-09-10 Thread John McKown
Well, I did a git clone to fetch the LibreOffice source. It appears to be a mixture of Java, C, and C++. Just some stats: $find . -name '*.c' | wc 108 1083908 ~/source-oem/libreoffice-core$find . -name '*.cpp' | wc 26 261360 ~/source-oem/libreoffice-core$find . -name

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

2014-09-09 Thread justin
On 2014-09-08 13:07, John McKown wrote: Open/Libre Office is Java based. Are you 100% about that? When I used to be involved with OpenOffice (years ago, prior to LibreOffice split), the main code was C++, with Java used for some things. OpenOffice Base was written in Java for example. I

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

2014-09-09 Thread Nico Williams
On Mon, Sep 8, 2014 at 11:46 PM, Stephan Beal wrote: > FWIW: > > http://fossil.wanderinghorse.net/wikis/cson/?page=cson_sqlite3 Yup, I've written that sort of wrapper in Python too. Of course, in the preceding sub-thread I'm talking about something rather different, but

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

2014-09-08 Thread Stephan Beal
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?

2014-09-08 Thread Stephan Beal
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?

2014-09-08 Thread Nico Williams
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?

2014-09-08 Thread Keith Medcalf
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?

2014-09-08 Thread Nico Williams
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?

2014-09-08 Thread John McKown
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?

2014-09-08 Thread Nico Williams
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?

2014-09-08 Thread Simon Slavin
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?

2014-09-08 Thread Nico Williams
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] What if OpenDocument were built atop SQLite?

2014-09-08 Thread Nico Williams
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?

2014-09-08 Thread Roger Binns
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] What if OpenDocument were built atop SQLite?

2014-09-08 Thread Simon Slavin
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

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

2014-09-08 Thread Teg
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?

2014-09-08 Thread John McKown
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

[sqlite] What if OpenDocument were built atop SQLite?

2014-09-08 Thread Richard Hipp
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