Thanks Igor!
This solves a big question for me :-)
Ran
On 3/29/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
>
> Ran <[EMAIL PROTECTED]> wrote:
> > For example:
> >
> > create temp table A(col1 varchar, col2 varchar, col3 varchar, col4
> > varchar);
> >
> > insert into A values('a', 'A', '1'
Iulian Popescu wrote:
Thank you very much, but this will require to modify the library as far as I
understand. I would rather not do that, is that any other less intrusive
way?
Iulian,
I wasn't suggesting that you modify the library. It is an open source
program. I was suggesting that you
Thank you very much, but this will require to modify the library as far as I
understand. I would rather not do that, is that any other less intrusive
way?
Iulian.
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 29, 2006 6:50 PM
To: sqlite-users@sqlit
Iulian Popescu wrote:
I'm really sorry - I forgot to mention that both databases are in memory.
Iulian,
In that case you will have to copy the contents.
The easiest way to do that is probably to modify the code the sqlite
shell uses to do a database dump. Instead of writing the generate
I'm really sorry - I forgot to mention that both databases are in memory.
Iulian.
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 29, 2006 5:32 PM
To: SQLite
Subject: [sqlite] Re: Db copy
Iulian Popescu wrote:
> Does anybody have an idea what wo
I have a sqlite database with about 3 GB of data, most of which is stored
in a data table with about 75 million records, having three columns
(EntryId INTEGER, PropertyId INTEGER, Value NUMERIC) and
PRIMARY KEY(EntryId, PropertyId).
This table is not indexed, to allow faster updates.
The problem
Why not do it through the underlying OS?
If the destination is empty
-alex
On Mar 29, 2006, at 1:10 PM, Iulian Popescu wrote:
Hello,
Does anybody have an idea what would be the easiest way to
completely copy
an attached database to another empty attached database?
Thank you,
I
Iulian Popescu wrote:
Does anybody have an idea what would be the easiest way to completely copy
an attached database to another empty attached database?
Iulian,
I think it would be easiest to copy the file associated with the
attached database instead of the trying to copy the database co
Iulian Popescu wrote:
Does anybody have an idea what would be the easiest way to completely
copy an attached database to another empty attached database?
Making a copy of the underlying file.
Igor Tandetnik
Hello,
Does anybody have an idea what would be the easiest way to completely copy
an attached database to another empty attached database?
Thank you,
Iulian.
you are absolutely right on the debian version numbering, of course.
the GNU lib is 2.2.5
and brilliant idea aabout the live cd. i'll get a copy of knoppix (debian
based i recall) and get the lib from there.
thanks so much!
Justin
--
View this message in context:
http://www.nabble.com/Insta
jpadie wrote:
> 2. the linux servers are debian 2.4.28 (so they say). i read that 2.4 was
> not a stable release so i am assuming they mean 2.2.x in any event
With Debian 2.4.28 I think of a Debian release with kernel version
2.4.28. This means it is a Debian distribution with a self-compiled
Ran <[EMAIL PROTECTED]> wrote:
For example:
create temp table A(col1 varchar, col2 varchar, col3 varchar, col4
varchar);
insert into A values('a', 'A', '1', 'n');
insert into A values('a', 'a', '2', 'e');
insert into A values('b', 'B', '3', 'n');
insert into A values('a', 'A', '4', 'n
Hi all,
I would like to ask if anyone can suggest how to filter out rows of one
table by using negation over several columns of rows of other table.
For example:
create temp table A(col1 varchar, col2 varchar, col3 varchar, col4
varchar);
insert into A values('a', 'A', '1', 'n');
insert i
Thanks, guys. I knew this wasn't going to be enough, I was mostly looking
for suggestions as to how I should pursue the problem and it looks like I'll
have to resort to writing a rusty C sample given that I haven't touched
C/C++ in years. I guess I was still hoping for an "oh yea, we have a bug 123
Thanks for the reply.
I should have included this in my original post:
1. 1&1 won't turn on sqlite. they say it's a security issue (which is, of
course, nonsense). I suspect it is a pricing issue as it might cause people
who would otherwise upgrade to a multiple mysql package to remain at th
On 3/29/06, jt <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm implementing a log procedure with triggers on my tables (following
> some ideas found in http://www.sqlite.org/cvstrac/wiki?p=UndoRedo).
> As I have more than one table, I'm generating the relevant SQL to do the
> job.
> I use the quote() fu
Hi,
I found this site but unfortunately it is intended for the J2SE/J2EE but not
for the J2ME (Java 2 Mobile Edition). Me I work under J2ME with
configuration CLDC. But the latter does not comprise all APIs java which one
finds under J2EE.
From: Dennis Cote <[EMAIL PROTECTED]>
Reply-To: s
Tito Ciuro wrote:
Due to application requirements, I must rely on LIKE and GLOB in
order to match data, matching data that contains some value
(sensitive or insensitive match).
Now, it seems to me that using either LIKE or GLOB will force a row
scan anyhow, since it can't use the index,
On Wed, 29 Mar 2006, jpadie wrote:
>
>Hi there
>
>my host (1 and 1) have compiled php5 without sqlite. but I have a couple of
>php applications that would benefit from SQLite (for portability).
You could raise a ticket with 1 and 1 to install sqlite.
>
>The server is a linux box and I do not
Hi,
I'm implementing a log procedure with triggers on my tables (following
some ideas found in http://www.sqlite.org/cvstrac/wiki?p=UndoRedo).
As I have more than one table, I'm generating the relevant SQL to do the job.
I use the quote() function to quote each value of each row.
The problem is t
EL AMRANI Jalal wrote:
Hi,
I am a new developper in the J2ME technology, I want to connect to a file
SQLITE database through JDBC by using the CLDC configuration. I know that
the java.sql API does not exist but i make this question for our
programmers
for many explation.
And I shall be aware
Hi there
my host (1 and 1) have compiled php5 without sqlite. but I have a couple of
php applications that would benefit from SQLite (for portability).
The server is a linux box and I do not have root, SSH or telnet access
(although i have found using php i can eval and exec commands (eg. apt
On Wed, 29 Mar 2006 [EMAIL PROTECTED] wrote:
>"Boris Popov" <[EMAIL PROTECTED]> wrote:
>>
>> Does this help at all?
>>
>
>No. A stack trace, especially one without line number
>information, is of no help whatsoever.
I beg to differ. Any stack trace that includes malloc or free is almost
certain
Hi,
I am a new developper in the J2ME technology, I want to connect to a file
SQLITE database through JDBC by using the CLDC configuration. I know that
the java.sql API does not exist but i make this question for our programmers
for many explation.
And I shall be aware of that it dosn't exist an
"Boris Popov" <[EMAIL PROTECTED]> wrote:
>
> Does this help at all?
>
No. A stack trace, especially one without line number
information, is of no help whatsoever.
If you think the problem is in SQLite and not in your
own code, then you should do as much of the following
as you can:
(1) Exp
26 matches
Mail list logo