Hello Nathan,
Depends on how you access them. Most RISC CPU's can't do unaligned access
to multi-byte values like int's and long, they'll segfault. Intel
CPU's don't have this problem. If you memcpy the values into place,
this is a non-issue. You see it alot with embedded CPU's.
Without knowing h
On Wed, Dec 07, 2005 at 08:34:46PM -0800, Dan Kennedy wrote:
> > To make it work in more than a superficial manner, you probably will
> > need a good understanding of how structures are internally represented
> > in C++ or C. You pass sqlite a pointer to the struct and tell it how
> > long it is (
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've created a class that generates the necessary sql statements to
describe the primary-foreign key relationship between two tables. This
code is fairly rudimentary so far...
Q: Is this interesting to anyone on this list?
Q: If so, where should I pos
--- Nathan Kurz <[EMAIL PROTECTED]> wrote:
> On Wed, Dec 07, 2005 at 08:49:42PM +0100, [EMAIL PROTECTED] wrote:
> > Hello,
> > I have a following problem.
> > In my program I have a vector of elements let say defined as follow:
> >
> > struct intDouble {
> > int x;
> > int y;
> > };
>
> I
"Nathan Kurz" wrote
Is there any way to sort according to the order of a value-list that
is specified with 'IN' according to the list? I've got something
like:
SELECT iid, title FROM titles WHERE iid IN (1168,80,2934,581,1631);
Is it possible to get the results back in the order specified i
Nathan Kurz <[EMAIL PROTECTED]> writes:
> Is there any way to sort according to the order of a value-list that
> is specified with 'IN' according to the list? I've got something like:
>
> SELECT iid, title FROM titles WHERE iid IN (1168,80,2934,581,1631);
>
> Is it possible to get the results bac
Is there any way to sort according to the order of a value-list that
is specified with 'IN' according to the list? I've got something like:
SELECT iid, title FROM titles WHERE iid IN (1168,80,2934,581,1631);
Is it possible to get the results back in the order specified in the
value list: 1168,80
On Wed, Dec 07, 2005 at 08:49:42PM +0100, [EMAIL PROTECTED] wrote:
> Hello,
> I have a following problem.
> In my program I have a vector of elements let say defined as follow:
>
> struct intDouble {
> int x;
> int y;
> };
It's pretty straightforward, presuming you've already figured out the
Hi,
If you are looking for ADO.Net data provider for .net framework you can
check out the following links.
ADO.Net SQLite - "http://sqlite.phxsoftware.com/"; for .net 2.0
Finisar.SQLite - "http://adodotnetsqlite.sourceforge.net/"; for .net 1.x
--
Veysel Harun Sahin
On 12/7/05, Richard Boyd <[
Hi,
I managed to find a dll for sqlite2 that will work with C#. Has anyone any
idea where I can find a dll for sqlite3?
Thanks,
R.
I recommend using CppSQLite, see http://www.codeproject.com/database/
CppSQLite.asp for examples.
Austin
On Dec 7, 2005, at 1:49 PM, [EMAIL PROTECTED] wrote:
Hello,
I have a following problem.
In my program I have a vector of elements let say defined as follow:
struct intDouble {
int x;
Hello,
I have a following problem.
In my program I have a vector of elements let say defined as follow:
struct intDouble {
int x;
int y;
};
Now, I would like to put the contents of this vector into sqlite table, to
be able than read it back. Mayby someone can suggest some solution how to do
Arjen Markus wrote:
Hm, there is a CSV reading module in Tcllib, so one could contemplate
using Tcl instead of Perl for this. That ought to take care of the
quotes
and other nastiness...
Perl's Text::CSV module available from CPAN also handles these issues.
Jay Sprenkle wrote:
On 12/6/05, ronggui wong <[EMAIL PROTECTED]> wrote:
I have a very large CSV file with 1 rows and 100 columns.and the
file looks like the following:
"a","b","c","d",
"1","2","1","3" ,
"3","2","2","1",
..
If I use .import,It seems I have to set the variable names manu
Christian Smith wrote:
On Tue, 6 Dec 2005, John Stanton wrote:
Christian Smith wrote:
On Fri, 2 Dec 2005, C C wrote:
Basically, it'd be too complex (IMHO) to implement in a 'lite' database
engine.
The virtue of MVCC is that it does not use locking, instead it maintains
serialized versio
On 12/6/05, ronggui wong <[EMAIL PROTECTED]> wrote:
> I have a very large CSV file with 1 rows and 100 columns.and the
> file looks like the following:
> "a","b","c","d",
> "1","2","1","3" ,
> "3","2","2","1",
> ..
>
> If I use .import,It seems I have to set the variable names manually .
>
Arjen Markus wrote:
>
> >
>
> Hm, there is a CSV reading module in Tcllib, so one could contemplate
> using Tcl instead of Perl for this. That ought to take care of the
> quotes
> and other nastiness...
>
>
Come to think it, my Fortran library to interface with SQLite has
an example of readin
Aaron Peterson wrote:
>
> On 12/7/05, Teg <[EMAIL PROTECTED]> wrote:
> > Hello All,
> >
> > Wouldn't it make sense to write a program that reads it in, one line
> > at a time, splits and inserts the data into the proper tables? Even
> > creating the table on the fly? That's what I'd do, a little c
On 12/7/05, Teg <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> Wouldn't it make sense to write a program that reads it in, one line
> at a time, splits and inserts the data into the proper tables? Even
> creating the table on the fly? That's what I'd do, a little command
> line utility.
One could pro
On Tue, 6 Dec 2005, John Stanton wrote:
>Christian Smith wrote:
>> On Fri, 2 Dec 2005, C C wrote:
>>
>> Basically, it'd be too complex (IMHO) to implement in a 'lite' database
>> engine.
>>
>>
>The virtue of MVCC is that it does not use locking, instead it maintains
>serialized versions of the dat
PBDBMS on www.hellobasic.com
All through ADO..
- Original Message -
From: "Cariotoglou Mike" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 07, 2005 9:23 AM
Subject: RE: [sqlite] how can I import CSV file into SQLite quickly
sqlite3Explorer does that
___
sqlite3Explorer does that
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Wed 07-Dec-05 8:00 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] how can I import CSV file into SQLite quickly
Someone somwhere must have a simple Perl script which does what yo
22 matches
Mail list logo
