[sqlite] XML into sqlite

How would you recommend to drop XML data into an sqlite DB? I am guessing there is more than one way. I thought of importing XML into Excel, converting to csv, for further import into sqlite, now that I know how to import csv into sqlite ... almost always! But this seems like a long haul.

Re: [sqlite] Reinstalling My Build Environment

I've run into this kind of issue with another IDE, not dealing with SQLite. The issue came down to package/code/something-or-other that was once upon a time on an old installation of the IDE that I ported in then, but now, after a fresh install of the same IDE, it wouldn't work. My only

Re: [sqlite] Reinstalling My Build Environment

Hello Paul, What programming language are you using to devel with? Using C++, I "deploy" sqlite by building the lib and static linking it into my program. No DLL's or install is needed. Sounds like you're doing something significantly more complicated than that though. C Wednesday,

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

> On Sep 10, 2014, at 4:50 PM, Simon Slavin wrote: > > Don't worry too much about this. In the last count of an OS X version I > counted seven different copies of SQLite being used in various places, > integrated into programs, or as libraries, or as the shell tool.

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

On 11 Sep 2014, at 12:35am, Jens Alfke wrote: > On Sep 10, 2014, at 4:28 PM, Simon Slavin wrote: > >> Please post a followup to your bugreport mentioning that /the SQLIte >> developers/ say that the bug is fixed in build 3.8.6. Apple's report >>

Re: [sqlite] Reinstalling My Build Environment

On 11 Sep 2014, at 12:36am, Paul Bainter wrote: > SQLite is a great database, but I've had nothing but problems deploying it > to a clean machine. Maybe I can help a little by explaining something. SQLite is C source code. It's available most conveniently as one .h file

[sqlite] Reinstalling My Build Environment

SQLite is a great database, but I've had nothing but problems deploying it to a clean machine. There is supposed to be nothing extra to do when moving the files from the bin directory to the target machine, but then I hear rumblings about an unknown missing C++ redistribution package that may need

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

> On Sep 10, 2014, at 4:28 PM, Simon Slavin wrote: > > Please post a followup to your bugreport mentioning that /the SQLIte > developers/ say that the bug is fixed in build 3.8.6. Apple's report readers > will notice it and note the easy fix. I've just done so. It's

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

On 11 Sep 2014, at 12:14am, Jens Alfke wrote: > I filed a bug report with Apple a few days ago Please post a followup to your bugreport mentioning that /the SQLIte developers/ say that the bug is fixed in build 3.8.6. Apple's report readers will notice it and note the

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

> On Sep 10, 2014, at 4:06 PM, Richard Hipp wrote: > > The problem was fixed in SQLite version 3.8.6 released on 2014-08-15. Thanks for the confirmation! I hadn't caught the notice that the bug fix is in 3.8.6; I must not have read far enough down the release notes. I filed

Re: [sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

On Wed, Sep 10, 2014 at 6:58 PM, Jens Alfke wrote: > I've run into an R-tree query regression in the latest beta of Mac OS X > 10.10. > I've got a test case in the form of a SQL file [2] that demonstrates my > problem. I'm not 100% sure this is the same as the reported

[sqlite] R-tree query regression, in SQLite library on latest Mac OS X beta

I've run into an R-tree query regression in the latest beta of Mac OS X 10.10. Looks like Apple upgraded the built-in SQLite library to version 3.8.5. (I'm not sure what version was in the previous beta, but the current released Mac OS X, 10.9.4, has version 3.7.13.) I looked at the list of

[sqlite] fts5

I was browsing the source on the fossil repository, and I noticed that there were files for fts5 in the trunk. I've been playing with fts3/4 and I'm curious about what new features/changes are incorporated into fts5. Can anyone clarify that for me? Thanks. -- Kyle

Re: [sqlite] FW: GUI INfo

Maxine Nietz writes: > > Is this the way to post a question? You are doing fine, but here is a link I send to new listserv users sometimes: http://www.catb.org/esr/faqs/smart-questions.html ___ sqlite-users mailing list

Re: [sqlite] Error with xBestIndex

I can confirm to Vendomele that implementing a xBestIndex with a 'return SQLITE_OK;' does work -- I did this myself a few weeks ago. I do second Dominique's advice about checking the use of the various 'SQLITE_EXTENSION_INITx' macros. There's three of them. If it's not already obvious, what it

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

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] GUI INfo

>From a MS Access point of view, think of SQLite as your backend, similar to a desktop version of MS SQL Server. What language you use really depends on what you are trying to do. If all you want is forms and reports, you don't have to give up MS Access, just use an ODBC driver for SQLite

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

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?

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] Use of etilqs-files

On 10 Sep 2014, at 1:26pm, Richard Hipp wrote: > The etilqs files are used (on Windows only) to store TEMP tables, > manifested views, automatic indices, and as temporary storage for sorting > operations and for VACUUM. Compile with -DSQLITE_TEMP_STORE=3 to disable > them.

Re: [sqlite] Use of etilqs-files

On Wed, Sep 10, 2014 at 4:50 AM, Dileep wrote: > Hi, > > What is the use etilqs-files. Is there any way I can disable my application > creating these temp files in the native temp directory ? Is there any issue > on disabling these temp files also ? > > See

Re: [sqlite] Error with xBestIndex

On Wed, Sep 10, 2014 at 11:53 AM, vendomele wrote: > I developed a loadable extension, but after the execution of the callback > "xBestIndex" there is a crash. > > So I made it simple for this callback by implementing only one line that > returns SQLITE_OK. > > The crash still

[sqlite] Error with xBestIndex

Hi, I developed a loadable extension, but after the execution of the callback "xBestIndex" there is a crash. So I made it simple for this callback by implementing only one line that returns SQLITE_OK. The crash still persists. With a development tool, the crash occurred in an external

[sqlite] Use of etilqs-files

Hi, What is the use etilqs-files. Is there any way I can disable my application creating these temp files in the native temp directory ? Is there any issue on disabling these temp files also ? -- Regards D.S. DIleep ___ sqlite-users mailing list

Re: [sqlite] GUI INfo

C++ or Python / Qt/PySide On 10 September 2014 02:05, jose isaias cabrera wrote: > "Warren Young" wrote... > > On 9/10/2014 14:56, Maxine Nietz wrote: >> >>> I am an experienced Access VBA programmer. I know about the SQLite >>> commands >>> to create and manipulate