On 8/2/06, jason zhang <[EMAIL PROTECTED]> wrote:
Hi All,
I don't find the method to unsubscribe this mail list from www.sqlite.org,
could you please tell me how?
Send an email to [EMAIL PROTECTED]
--
Nemanja Corlija <[EMAIL PROTECTED]>
Hi All,
I don't find the method to unsubscribe this mail list from www.sqlite.org,
could you please tell me how?
Thanks
Jason
Cesar David Rodas Maldonado wrote:
Thanks Daniel!
Now i have another question! Is any way to serialize all the dates
given a
preference to SELECT a delay to the insert.
I am building a Small Library in C & SQLite that will be under GPL, is
something like Lucene. Please help me how to give a p
It's less filling... :-)
-Original Message-
From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 01, 2006 3:20 PM
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: Re: [sqlite] SQLite and ASP Classic
On 8/1/06, Artie Pagan <[EMAIL PROTECTED]> wrote:
> Does anyone know
On 8/1/06, Artie Pagan <[EMAIL PROTECTED]> wrote:
Does anyone know what the connection string is for SQLite using ASP classic?
Does that have fewer calories than "New ASP" or does it just taste better?
;)
Try with the ODBC or use PHP (PHP is better than ASP and multi OS)
On 8/1/06, Artie Pagan <[EMAIL PROTECTED]> wrote:
Does anyone know what the connection string is for SQLite using ASP
classic?
Does anyone know what the connection string is for SQLite using ASP classic?
Using an SQL engine to drive a relatively small database is not really
very simple, IMHO. But you will notice I am a member of the SQLite fan
club for some time now.
My largest dataset is somewhere just over 10K rows. I justify using
SQLite by noting the advantage of using a well maintained, wid
[EMAIL PROTECTED] wrote:
John Stanton <[EMAIL PROTECTED]> wrote:
Sqlite is more than one flat file. It is impossible for it to use less
resources than one flat file.
I guess this depends on the format and content of the flat file.
As an experiment, I constructed a database with 16K row
John Stanton <[EMAIL PROTECTED]> wrote:
>
> Sqlite is more than one flat file. It is impossible for it to use less
> resources than one flat file.
>
I guess this depends on the format and content of the flat file.
As an experiment, I constructed a database with 16K rows with each
row conta
Christian Smith wrote:
John Stanton uttered:
In general you must expect Sqlite to use more of all resources
compared to a flat file. After all Sqlite is a flat file with
additional logic.
Except updates and selective reads will be cheaper in general, as less
IO is required due to additio
John Stanton uttered:
In general you must expect Sqlite to use more of all resources compared to a
flat file. After all Sqlite is a flat file with additional logic.
Except updates and selective reads will be cheaper in general, as less IO
is required due to additional logic.
Storage will
Aseem Rastogi wrote:
Hi All,
I am planning to migrate to SQLite for my embedded system application.
Currently we have a flat text file which we read and write using normal
C++ routines. Whole of the configuration is written everytime some
change happens. We do it using ofstream. For reading a
On 8/1/06, Aseem Rastogi <[EMAIL PROTECTED]> wrote:
1. How does SQLite behave as compared to our current approach regarding
I/O access time ?
2. How much disk space does SQLite take as compared to flat text file ?
If somebody has some benchmarking data for these issues, it will be
really helpfu
[EMAIL PROTECTED] schrieb:
Gunnar Roth <[EMAIL PROTECTED]> wrote:
Well what happens if i write the db to a compact flash card and remove
it while writing and put it back again?
The database should recover automatically.
Actually i have tried that on our ce device while i
Mario Frasca wrote:
I'm throwing this here, I assume that it would not be too much work to
complete this patch. the aim is to support the sql92 syntax insert
into default values;
all right, a possible complete patch, maybe could be added to the
rest... don't tell me that it looks ugly, I t
Thaniks, I hope it works as expected since I'm using SQLite in my e-mail
client project (https://sourceforge.net/projects/envoy/) and I expect
millions of people to use it eventually. I fear having to answer e-mails and
complaints of hundreds of users whose e-mail databases have been corrupted.
So
Gunnar Roth <[EMAIL PROTECTED]> wrote:
> >
> Well what happens if i write the db to a compact flash card and remove
> it while writing and put it back again?
The database should recover automatically.
> Actually i have tried that on our ce device while importing cvs records
> with .read com
[EMAIL PROTECTED] schrieb:
=?utf-8?Q?Olaf_Beckman_Lapr=C3=A9?= <[EMAIL PROTECTED]> wrote:
Hi,
Is there a way to do this programmatically? I would like to recover from a
damaged database upon program startup.
If your program crashes, or your computer loses power in the
middle of a dat
Olaf Beckman Lapré schrieb:
Hi,
Is there a way to do this programmatically? I would like to recover from a
damaged database upon program startup.
1. Copy the code for dump command from shell.c
2. Try if "vacuum;" command repairs the database. with "pragma
integrity_check;" you can check i
Sarah schrieb:
> Why I can't find the implementation of functions(xClose, xRead, xWrite,
> xSeek) in IoMethod in the whole SQLite project?
>
> Are these functions implemented in OS level?
>
>
Of course, where did you expect these os specific function
implementation to be?
static const IoM
"Sarah" <[EMAIL PROTECTED]> wrote:
> Why I can't find the implementation of functions(xClose, xRead, xWrite,
> xSeek) in IoMethod in the whole SQLite project?
>
> Are these functions implemented in OS level?
>
> Can anyone help me?
Separate implementions exist in os_unix.c and os_win.c
--
Bill KING <[EMAIL PROTECTED]> wrote:
> Is there a way to move the journal to say use a temp directory? We're
> doing some stuff with dbs on SD-cards and it's dog slow. Writing to them
> is dog slow too. So is transacting to them. 3 writes on slw media.
> Is there a way to have the journal in th
=?utf-8?Q?Olaf_Beckman_Lapr=C3=A9?= <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is there a way to do this programmatically? I would like to recover from a
> damaged database upon program startup.
>
If your program crashes, or your computer loses power in the
middle of a database change, and thus leaves
Hi,
Is there a way to do this programmatically? I would like to recover from a
damaged database upon program startup.
Regards,
Olaf
- Original Message -
From: "Christian Smith" <[EMAIL PROTECTED]>
To: "SQLite Mailing List"
Sent: Monday, July 31, 2006 4:53 PM
Subject: Re: [sqlite] Read
Hello,
I am using the vb method for using the sqlite wrapper dll in my application.
But on few PC's I am getting the error as compobj.dll is too old for the
ole2.dll initialized
What could be the reason?
Thanks in advance.
Why I can't find the implementation of functions(xClose, xRead, xWrite,
xSeek) in IoMethod in the whole SQLite project?
Are these functions implemented in OS level?
Can anyone help me?
just to show that it does not crash:
sqlite> create table test2 (k integer primary key autoincrement);
sqlite> insert into test2 default values;
sqlite> insert into test2 () values ();
sqlite> select * from test2;
1
2
sqlite>
I refined the patch. it constructs a list of values with one NULL, but
I don't see how to construct an idList with just the primary key.
also added the grammar rule to recognize both:
insert into default values;
insert into () values ();
anybody completing/correcting the work?
sqlite> ins
29 matches
Mail list logo