On 8/21/06, John Salerno <[EMAIL PROTECTED]> wrote:
Hi guys. Is it possible to load a sql file that is for a MySQL
database into a SQLite database? Does it just work normally, or would
some tweaking be needed? Or does this just not work?
Usually you will need some tweaking. One particularly
Hi guys. Is it possible to load a sql file that is for a MySQL
database into a SQLite database? Does it just work normally, or would
some tweaking be needed? Or does this just not work?
Thanks,
John
-
To unsubscribe,
Dragging a database onto the sqlite.exe in explorer works.
> I downloaded the command line utility, and it is an exe file
> that automatically opens the sqlite prompt. Given this, how
> am I supposed to open or create databases? The only way I'm
> aware so far is that you have to specify the
Yeah, I just moved the exe file elsewhere on my hard drive and put
it's destination in my PATH. So now I can type 'sqlite3 ' and
open a database.
On 8/21/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"John Salerno" <[EMAIL PROTECTED]> wrote:
> I downloaded the command line utility, and it
"John Salerno" <[EMAIL PROTECTED]> wrote:
> I downloaded the command line utility, and it is an exe file that
> automatically opens the sqlite prompt. Given this, how am I supposed
> to open or create databases? The only way I'm aware so far is that you
> have to specify the db after the sqlite3
Hi all
If you use shared libraries not compiled by your own, you can't be sure which
flags were set during compilation. This is especially true for the THREADSAFE
option, which is rather important for applications/libraries to decide to
enable or disable some features.
I didn't saw any way to
You may want to download the SQL Lite Database project from sourceforge.
On 8/21/06, John Salerno <[EMAIL PROTECTED]> wrote:
I downloaded the command line utility, and it is an exe file that
automatically opens the sqlite prompt. Given this, how am I supposed
to open or create databases? The
I downloaded the command line utility, and it is an exe file that
automatically opens the sqlite prompt. Given this, how am I supposed
to open or create databases? The only way I'm aware so far is that you
have to specify the db after the sqlite3 command which opens the
prompt, but in this case
So far the btree project went well but I hit a lot of memory problems when I
open btree in with flag 1 BTREE_OMIT_JOURNAL so I just open it with
BTREE_NO_READLOCK for my purpose. So far so good.
I also made a code change which is probably not necessary. I did it just to
make sure nothing
> On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote:
>> I've tried also executing the query "begine exclusive" before the
>> "update",
>> and "commit" to end the entire routine, and the query that now returns
>> the
>> exit code 5 (database locked) is "begin exclusive", I don't know if
>> this
On Mon, 21 Aug 2006, Laura Longo wrote:
> Date: Mon, 21 Aug 2006 20:01:24 +0200
> From: Laura Longo <[EMAIL PROTECTED]>
> Reply-To: sqlite-users@sqlite.org
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Re: database locked
>
>
>
> > On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote:
> >>
On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote:
I've tried also executing the query "begine exclusive" before the
"update",
and "commit" to end the entire routine, and the query that now returns
the
exit code 5 (database locked) is "begin exclusive", I don't know if this
can be
On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote:
I've tried also executing the query "begine exclusive" before the "update",
and "commit" to end the entire routine, and the query that now returns the
exit code 5 (database locked) is "begin exclusive", I don't know if this
can be meaningful...
This looks like it should work fine.
The only thing that concerns me is this could be a very long loop
if something locks the table or there's an error that's not recoverable.
It would sit there forever retrying something that will never be fixed.
Some operations will cause the database to be
On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote:
Yes, I use a wrapper around the function sqlite3_get_table which, if the
return code if different from 0, retries to execute the query calling again
sqlite3_get_table doing a 'while'. Besides, each query is written in a file
for debugging
On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote:
Hi all,
I'm a software developer and I'm using sqlite3 for my application in c++.
This is the problem I've found:
two processes do queries (about 1 query per second) on one database; the
'select' queries don't have any problem, while 'update'
On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote:
Hi all,
I'm a software developer and I'm using sqlite3 for my application in c++. This
is the problem I've found:
two processes do queries (about 1 query per second) on one database; the
'select' queries don't have any problem, while 'update'
Hi all,
I'm a software developer and I'm using sqlite3 for my application in c++. This
is the problem I've found:
two processes do queries (about 1 query per second) on one database; the
'select' queries don't have any problem, while 'update' queries find problems
after 1 or 2 days that the
The linux version of the importer is available for download now (see
the link below).
I've also received an OS-X version from a very helpful gentleman that
I'll post later.
Kudos to Carlo for the help with it.
Thanks to DRH for a wonderful package.
--
SqliteImporter and SqliteReplicator:
Hi,everyone,
I have ported SQLite to an embedded platform. When I debugged on this platform,
I met following problems:
1. in process_input(), part of codes are like this:
..
open_db(p);
rc = sqlite3_exec(p->db, zSql, NULL, p, );
..
it's strange that, after
20 matches
Mail list logo