I'm using XSLT to create CSV.
gert
2014-09-11 7:04 GMT+02:00 Carlos A. Gorricho cgorri...@heptagongroup.co:
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
On 11 Sep 2014 at 00:50, Simon Slavin slav...@bigfraud.org 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
are
On 11 Sep 2014, at 6:04am, Carlos A. Gorricho cgorri...@heptagongroup.co
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
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
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
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
--
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-
On Sep 11, 2014, at 1:44 AM, Tim Streater t...@clothears.org.uk 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 copy
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
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?
On Thu, Sep 11, 2014 at 9:58 AM, Dan Kennedy danielk1...@gmail.com 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 what new
On Thu, Sep 11, 2014 at 9:58 AM, Dan Kennedy danielk1...@gmail.com 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
On Sep 11, 2014, at 5:45 PM, Carlos A. Gorricho cgorri...@heptagongroup.co
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:
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++
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
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
On Thu, 11 Sep 2014 23:49:22 +0200, Kees Nuyt k.n...@zonnet.nl
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
On Wed, 27 Aug 2014 18:25:28 -0600
Keith Medcalf kmedc...@dessus.com 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 (or did do) the same
On Thu, Sep 11, 2014 at 4:09 PM, Kees Nuyt k.n...@zonnet.nl wrote:
On Thu, 11 Sep 2014 23:49:22 +0200, Kees Nuyt k.n...@zonnet.nl
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
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
On 12 Sep 2014, at 3:18am, Scott Robison sc...@casaderobison.com 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 system
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 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
On Thu, Sep 11, 2014 at 5:49 PM, Kees Nuyt k.n...@zonnet.nl 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 Years, We're
On Thu, Sep 11, 2014 at 11:58 PM, Keith Medcalf kmedc...@dessus.com 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 memory
Should
On Thursday, 11 September, 2014, at 22:29, Richard Hipp d...@sqlite.org wrote:
Error: out of memory
Should be fixed in the latest trunk.
Confirmed fixed.
Regards,
Keith
___
sqlite-users mailing list
sqlite-users@sqlite.org
26 matches
Mail list logo
