Re: [sqlite] XML into sqlite

2014-09-11 Thread Gert Van Assche
I'm using XSLT to create CSV. gert 2014-09-11 7:04 GMT+02:00 Carlos A. Gorricho : > > 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 >

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

2014-09-11 Thread Tim Streater
On 11 Sep 2014 at 00:50, 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. And these >

Re: [sqlite] XML into sqlite

2014-09-11 Thread Simon Slavin
On 11 Sep 2014, at 6:04am, Carlos A. Gorricho wrote: > How would you recommend to drop XML data into an sqlite DB? I am guessing > there is more than one way. Is this a one-time thing or are you going to have to do it every month/week ? Do you have a favourite

Re: [sqlite] Error with xBestIndex

2014-09-11 Thread vendomele
Hi Dominique, Yes I started by creating a user defined function, I followed the example of the "half" function we can find everywhere on the Internet and it works My loadable extension manages to create a virtual table when I send the "CREATE VIRTUAL TABLE x USING ..." SQL command, I can see the

Re: [sqlite] Error with xBestIndex

2014-09-11 Thread vendomele
Hi Dominique, Yes I started by creating a user defined function, I followed the example of the "half" function we can find everywhere on the Internet and it works My loadable extension manages to create a virtual table when I send the "CREATE VIRTUAL TABLE x USING ..." SQL command, I can see the

Re: [sqlite] Error with xBestIndex

2014-09-11 Thread vendomele
Thanks a lot Dave The problem came from SQLite3_vtab's attributte: zErrMsg. It was not initialized to null. Now I have more crashes, I can continue the development of the loadable extension. For your information, I develop in Delphi, it is not too difficult to transcribe C in Delphi --

Re: [sqlite] Error with xBestIndex

2014-09-11 Thread dave
Yep, same one as me, glad the info helped. I think I may file a bug on that. Delphi, I do remember that, and have had rare occasion to use it, though I've never linked c obj in (or are you using sqlite as a dll?). Good luck on the rest of you implementation! -dave > -Original Message- >

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

2014-09-11 Thread Jens Alfke
> On Sep 11, 2014, at 1:44 AM, Tim Streater wrote: > > In OS X 10.9.4, the SQLite version in PHP is 3.7.7.1, for example. Yes, as I already said, there are some open-source components not developed by Apple that embed their own copies of sqlite. But the really important

Re: [sqlite] XML into sqlite

2014-09-11 Thread Carlos A. Gorricho
For the time being, it's a one-off thing. In the future it could become regular. I used to solve all my analytical DB needs with MS Access. Since I migrated to a Mac I decided to look for a new DB engine and am exploring sqlite. I have been running a couple of tests, based on actual data

Re: [sqlite] fts5

2014-09-11 Thread Dan Kennedy
On 09/11/2014 02:51 AM, Kyle Shannon wrote: 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?

Re: [sqlite] fts5

2014-09-11 Thread Kyle Shannon
On Thu, Sep 11, 2014 at 9:58 AM, Dan Kennedy wrote: > On 09/11/2014 02:51 AM, Kyle Shannon wrote: >> >> 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

Re: [sqlite] fts5

2014-09-11 Thread Scott Robison
On Thu, Sep 11, 2014 at 9:58 AM, Dan Kennedy wrote: > Fts5 will use less memory and be faster than fts4 (I think - initial > testing has been positive). It will also be smaller, as we can do without a > bunch of code that is used to workaround problems inherent in the >

Re: [sqlite] XML into sqlite

2014-09-11 Thread Petite Abeille
On Sep 11, 2014, at 5:45 PM, Carlos A. Gorricho wrote: > Next step is to venture into XML - sqlite integration...both ways. Considering you are on a *nix system, you may find Dan Egnor’s xml2 set of command line utilities of interest:

Re: [sqlite] Reinstalling My Build Environment

2014-09-11 Thread Joe Mistachkin
Paul Bainter wrote: > > 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++

Re: [sqlite] Reinstalling My Build Environment

2014-09-11 Thread Drago, William @ MWG - NARDAEAST
> Please help me. At this point, I'm desperate for an installation where > I can copy the compiled files from the bin directory to a clean machine > and have it run. I use VS2013, but I don't use EF6, so this may not work for you, but maybe it will help in some way anyway. Based on what you

[sqlite] presentation about ordering and atomicity of filesystems

2014-09-11 Thread Kees Nuyt
Hi all, Today I bumped into a presentation about ordering and atomicity of filesystems that might interest you. https://www.youtube.com/watch?v=YvchhB1-Aws The Application/Storage Interface: After All These Years, We're Still Doing It Wrong Remzi Arpaci-Dusseau, University of Wisconsin—Madison

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-11 Thread Kees Nuyt
On Thu, 11 Sep 2014 23:49:22 +0200, Kees Nuyt wrote: > Today I bumped into a presentation about ordering and atomicity > of filesystems that might interest you. > > https://www.youtube.com/watch?v=YvchhB1-Aws Compliments for sqlite at 43:20 .. 43:59

Re: [sqlite] Window functions?

2014-09-11 Thread James K. Lowden
On Wed, 27 Aug 2014 18:25:28 -0600 "Keith Medcalf" wrote: > >> select id, category_id, name, min(price) as minprice > >>from cat_pictures > >> group by category_id; > > >This peculiar behavior is very unique to SQLite. > > Not really. Sybase, SQL Server and DB2 do

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-11 Thread Scott Robison
On Thu, Sep 11, 2014 at 4:09 PM, Kees Nuyt wrote: > On Thu, 11 Sep 2014 23:49:22 +0200, Kees Nuyt > wrote: > > > Today I bumped into a presentation about ordering and atomicity > > of filesystems that might interest you. > > > >

[sqlite] Reinstalling My Build Environment

2014-09-11 Thread Paul Bainter
I appreciate the information that SQLite is not the same as other vendors that possibly supply packages that enable the use of SQLite for environments such as .NET. This is good information to know. Up to this point the only package that I've used and the one that I referenced in my previous

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-11 Thread Simon Slavin
On 12 Sep 2014, at 3:18am, Scott Robison wrote: > That was an interesting 90 minutes. Indeed. Thanks to Kees for posting it. Though I was surprised he didn't mention the term 'ACID' explicitly. I'm still of the opinion that we need an actual transactional file

Re: [sqlite] Reinstalling My Build Environment

2014-09-11 Thread Joe Mistachkin
I assume that you did not see the response I sent earlier? http://www.mail-archive.com/sqlite-users%40sqlite.org/msg85999.html -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] MINGW GCC 4.8.1 or MSVC 9.0 at/after 7e4978c003867d1b532b69221013dda75ca61953 Fails with out of memory when trying to initialize database

2014-09-11 Thread Keith Medcalf
SQLite version 3.8.7 2014-09-11 23:34:55 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .schema Error: out of memory sqlite> .quit This is with a "bare" amalgamation compile using either compiler and no

Re: [sqlite] presentation about ordering and atomicity of filesystems

2014-09-11 Thread Richard Hipp
On Thu, Sep 11, 2014 at 5:49 PM, Kees Nuyt wrote: > > Hi all, > > Today I bumped into a presentation about ordering and atomicity > of filesystems that might interest you. > > https://www.youtube.com/watch?v=YvchhB1-Aws > > The Application/Storage Interface: After All These

Re: [sqlite] MINGW GCC 4.8.1 or MSVC 9.0 at/after 7e4978c003867d1b532b69221013dda75ca61953 Fails with out of memory when trying to initialize database

2014-09-11 Thread Richard Hipp
On Thu, Sep 11, 2014 at 11:58 PM, Keith Medcalf wrote: > > SQLite version 3.8.7 2014-09-11 23:34:55 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> .schema > Error: out of

Re: [sqlite] MINGW GCC 4.8.1 or MSVC 9.0 at/after 7e4978c003867d1b532b69221013dda75ca61953 Fails with out of memory when trying to initialize database

2014-09-11 Thread Keith Medcalf
On Thursday, 11 September, 2014, at 22:29, Richard Hipp wrote: >> Error: out of memory >Should be fixed in the latest trunk. Confirmed fixed. Regards, Keith ___ sqlite-users mailing list sqlite-users@sqlite.org