-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ludvig Strigeus wrote:
> I would like to have a single table larger than 2GB...though.
FAT16 has a maximum file size of 2GB. FAT32 (the most common one in use
today) has a maximum file size of 4GB. It is impossible to have single
files larger than
On 4/13/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
"Scott Hess" <[EMAIL PROTECTED]> wrote:
> My assumption would be that you'd use 'cvs log VERSION' to find the
> datestamp where the VERSION file was updated, then check the tree out
> using -D.
>
> Right?
Not always. Better to go to the
Hamid Benhocine <[EMAIL PROTECTED]> wrote:
> Dear drh,
> We do want install the latest version of sqlite.for the production (
> 2007-Apr-09 - Version 3.3.15 )
> But, Our sytem group, found the only flaged stable version of the sqlite3 in
> the web site is this one ( 2006-Jan-31 - Version 3.3.3
My assumption would be that you'd use 'cvs log VERSION' to find the
datestamp where the VERSION file was updated, then check the tree out
using -D.
Right?
Thanks,
scott
-
To unsubscribe, send email to [EMAIL PROTECTED]
On 4/13/07, Hamid Benhocine <[EMAIL PROTECTED]> wrote:
Dear drh,
We do want install the latest version of sqlite.for the production (
2007-Apr-09 - Version 3.3.15 )
But, Our sytem group, found the only flaged stable version of the sqlite3 in
the web site is this one ( 2006-Jan-31 - Version
Dear drh,
We do want install the latest version of sqlite.for the production (
2007-Apr-09 - Version 3.3.15 )
But, Our sytem group, found the only flaged stable version of the sqlite3 in
the web site is this one ( 2006-Jan-31 - Version 3.3.3 stable )
The question?
Are all the sqlite-x.x.x
Unless things have changed recently, the following should still be valid for
Windows Mobile/Windows CE devices: Usually these devices do not power off,
but
stay in a standby state where the memory is always powered. Check if that's
the
case with your system and move as much as possible into RAM
You might find some joy in the baby disk drives such as installed in the
original ipods.
Can you substitute RAM with a battery backup if the memory card is
always in the device?
Joel Cochran wrote:
Thanks John and Dennis,
At least now I have something to look at. I will look into the CF
Thanks John and Dennis,
At least now I have something to look at. I will look into the CF problem
next.
The database itself gets generated on a PC and then transferred to the CF
Card. During testing and development, this could have been 20-30 times a
day, constantly erasing and recreating the
Use a file system with 64 bit addressing.
Ludvig Strigeus wrote:
I would like to have a single table larger than 2GB...though.
/Ludvig
On 4/13/07, John Stanton <[EMAIL PROTECTED]> wrote:
It is limited by the maximum file size on your OS. You can make a
multiple file database by ATTACHing
Flash memory is for read only access on a continuing basis but has a
certain number of write cycles to use for load it with data. For
example you might use it for backups or for loading and distributing
software or playing music but if you use it like a disk drive it will
hit its write limit
I would like to have a single table larger than 2GB...though.
/Ludvig
On 4/13/07, John Stanton <[EMAIL PROTECTED]> wrote:
It is limited by the maximum file size on your OS. You can make a
multiple file database by ATTACHing more than one database.
Ludvig Strigeus wrote:
> Does Sqlite
Joel Cochran wrote:
Or do you mean over the course of the lifetime of a CF card it can
only be
used so much? That might apply to this scenario, these cards have been
written over continuously for the last 6 months.
Joel,
Yes, that is exactly the problem. You should look at using a flash
Joel Cochran wrote:
John,
What do you mean by "general processing"? The database is on the CF card,
the application accesses the database. Other than what application
normally
do (select, update, insert, etc.), I'm not sure what else to tell you.
Or do you mean over the course of the
I think it is also the case that flash cards write pretty slowly,
and there is a finite buffer of pending writes. Your unexpected
write failure may be because you're writing too fast. Depending
on the driver and access mode, the writes might throw this
error rather than block your process.
You
John,
What do you mean by "general processing"? The database is on the CF card,
the application accesses the database. Other than what application normally
do (select, update, insert, etc.), I'm not sure what else to tell you.
Or do you mean over the course of the lifetime of a CF card it can
That's what I was implying by my question.
-Ursprüngliche Nachricht-
Von: John Stanton [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 13. April 2007 20:56
An: [EMAIL PROTECTED]
Betreff: Re: [sqlite] Still getting "Insertion failed because database is
full." errors
Regular flash memory
It is limited by the maximum file size on your OS. You can make a
multiple file database by ATTACHing more than one database.
Ludvig Strigeus wrote:
Does Sqlite support databases larger than 2GB on FAT filesystems?
If not, how hard would it be to add so it uses additional files for the
pages
Regular flash memory has a limited number of write cycles before it
fails. Are you hitting this problem by using it for general processing?
Joel Cochran wrote:
First, to answer John's question: the CF Card is a 1GB card, and the only
thing on the card is the SQLite Database (currently 509KB),
If something passes all tests but fails later then it is very likely
failing where testing was not performed, such as the hardware under
other conditions.
Michael Ruck wrote:
Hi,
Is this the only device seeing this error or are *all* devices seeing this
error? Have you checked the CF card?
You can break up the db into multiple databases and attach them to the same
connection. That would be easiest approach (as long as one individual table
is not bigger than 2gb).
Sam
---
We're Hiring! Seeking a passionate developer to join our team
I would suggest including the SQL that was being processed, including all
parameters, in the error message. Even better would be to keep a log of all
SQL messages sent--perhaps keep the last X calls in memory and when an error
occurs log all of those calls and then the offending one.
log4net
Does Sqlite support databases larger than 2GB on FAT filesystems?
If not, how hard would it be to add so it uses additional files for the
pages that don't fit in the first file?
Thanks
Ludvig
First, to answer John's question: the CF Card is a 1GB card, and the only
thing on the card is the SQLite Database (currently 509KB), so I really
don't think it is a space problem. Unless you mean something else by Flash
memory?
Michael,
Yes, I am doing Selects, and using DataAdapters to fill
Hi,
Is this the only device seeing this error or are *all* devices seeing this
error? Have you checked the CF card? May be its just the card, which is
corrupt and you're hitting these bugs at points, where the file system is
hitting a bad sector.
Is this running in a transaction?
Mike
Guessing from his call stack he's doing a select. ExecuteReader executes a
statement, which must return a resultset (aka select.)
-Ursprüngliche Nachricht-
Von: John Stanton [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 13. April 2007 17:57
An: [EMAIL PROTECTED]
Betreff: Re: [sqlite]
In the following pseudo-code which works the first time through either
Function A or Function B I get a problem when either function is
executed a second time.
I get the following error:
SQLITE_ERROR[1] - cannot start a transaction within a transaction
Program
{
Open Database
randomly call
Are you sure that you are not exceeding the capacity of the flash memory
to handle writes?
Joel Cochran wrote:
Hi folks,
I had sent this message out a couple of weeks ago, and I am still searching
for a solution. I looked at the application design and made a modest
change: I now create a
> The offending lines are
> tclsqlite.c:
> EXTERN int Sqlite3_Init(Tcl_Interp *interp){
> Tcl_InitStubs(interp, "8.4", 0);
> Tcl_CreateObjCommand(interp, "sqlite3", (Tcl_ObjCmdProc*)DbMain, 0,
> 0);
I simply removed EXTERN from source and there were no other compile errors.
But there were
Samuel R. Neff wrote:
Still, I think backwards compatibility and consistency with other databases
would be most important in this situation. I just checked MSSQL and it's
same as current sqlite which uses the first select statement's column names.
Samuel,
The following is from Oracle's
Huian Li wrote:
I have a package which uses functions like
sqlite3_get_database_file_fd() and
sqlite3_get_journal_file_fd(). Supposedly
sqlite3_fds.h has these two functions and fds.c
defines them, but I searched both sqlite-3.3.4 and
sqlite-3.3.15, and could not find anything. Does
anyone know
Hi Jef,
* Jef Driesen <[EMAIL PROTECTED]> [2007-04-11 16:10]:
> I managed to solve this problem now. I had to write my solution
> (see below) in pseudo sql code (e.g some extra non-sql code was
> required) because sqlite does not support stored procedures. It
> think it is doable to incorporate
Hi all:
Probably due to my weak knowledge of SQL techniques, I'm having some
problems using SQLite.
Consider this scenario:
sql = "SELECT a, b, c FROM someTable WHERE someCondition";
result = sqlite3_exec (dbPtr, sql, callBackFunct, ptrDest, );
if ( result != SQLITE_OK ) {
//
I need a way to automatically have the rowid for all queries issued
by our users (without modifying the original sql queries).
A lot of time for some queries (COUNT(*) for example), it is simply
not possible to obtain a valid rowid, so it could just be set to -1.
Is this a planned feature?
On 4/12/07, Brandon, Nicholas (UK) <[EMAIL PROTECTED]> wrote:
> > You used to be able to compile with -DVDBE_PROFILE=1 to enable some
> > special assembly-language instructions that would use
> hi-res timers on
> > ix586 chips to provide the cycle counts needed to execute each
> > instruction in
Dennis Cote wrote:
Jef Driesen wrote:
I can give you the example of an application using sqlite as the on-disk
file format. As mentioned on the sqlite website [1], the traditional
File/Open operation does an sqlite3_open() and executes a BEGIN
TRANSACTION. File/Save does a COMMIT followed by
dear all,
i'm are freshman in sqlite,so,firstly forgive me for simple question.
in my application ,i ported sqlite base on a flash fs writed by ourself.
so far , everything is ok but when i delete some row in my table. during do
that , i find the sqlite will free some memory that have been free
When i am trying to print the der encoded certificate subject in gdb it shows
like the following string..
Taken from nss code:=
data is unsigned char * type
(gdb) p derSubject->data
0\0261\0240\022\006\003U\004\003\023\vSamrat saha
Now how to store this kinf of info into database as binary and
samrat saha schrieb:
Dear All,
I am trying to store certificate related DER encoded data using sqlite
database??
But what kind of datatype should i use in sqlite to store and retrive DER
encoded data??
Is there anyway to store the DER encoded certificate related fileds in sqlite??
ASN.1 DER
39 matches
Mail list logo