From here
http://download.micron.com/pdf/datasheets/flash/nand/2gb_nand_m29b.pdf you
can se what PAGE_SIZE is
Page size is smallest writeable unit. Technically you can write less
multiple times but as far as I know jffs2 does not use this technique, but
lot of other flash file systems does (jffs
I found the R-Tree idea fascinating. Conceptually, this is exactly what I need.
But indeed, my case is very simple: my dataset is not sparse, my tiles never
overlap (for a given zoom factor), the number of tiles is still rather small,
they are all rectangular and the same size (modulo edge
I found few topics on this issue but still. For instance from here
http://www.mail-archive.com/sqlite-users@sqlite.org/msg54904.html.
I have similar problem of writing multiple small data (max 100bytes per
entry), but do not think that those advices from upper link were right.
I have to tell that
I apologize if double-post, the first one didn't make it to the list.
-
Hi,
Hi all, I am interested in seeing fuzzy searching in SQLite, for
lack of a better term. This type of search would return more results
than LIKE
Good Morning Richard... thanks for the response... after making the
change you suggested and when doing the build, I get the following error:
l _sqlite3MisuseError, referenced from:
-[PointPeekViewController
imagePickerController:didFinishPickingMediaWithInfo:] in
PointPeekViewController.o
Hi all, I am interested in seeing fuzzy searching in SQLite, for
lack of a better term. This type of search would return more results
than LIKE currently does today. The search would return matches based
on expanded criteria, each one may be considered a separate RFE for
LIKE or for another
With respect to SQLite 3.7.6
Situation:
- incremental vacuum mode
- old journal mode (have not tested with WAL)
- extra tail-room using SQLITE_FCNTL_CHUNK_SIZE
- some free pages
- execute PRAGMA incremental_vacuum
Problem:
- the journal will be created for all extra tail pages
This is just a
On Tue, May 3, 2011 at 10:29 AM, Rolf Marsh ro...@pragerphoneapps.comwrote:
Good Morning Richard... thanks for the response... after making the
change you suggested and when doing the build, I get the following error:
l _sqlite3MisuseError, referenced from:
-[PointPeekViewController
I think I figured it out on my own (a good night's sleep helps!)...
thanks everybody...
R
On 5/3/11 4:14 PM, Rolf Marsh wrote:
I'm having a hard time changing my Obj-C SQLite3 code to FMDB... the
code works (after a fashion), but I need it to be a singleton (my
current SQLite3 code is
Hi Folks,
Using virtual tables the WHERE clause is broken up and sent to the best index
function to determine the best index. Then the filter function is called to
perform the actual work. I've noticed that the SQLITE engine seems to process
OR clauses outside of the virtual table process,
On 05/04/2011 08:58 PM, Schrum, Allan wrote:
Hi Folks,
Using virtual tables the WHERE clause is broken up and sent to the best
index function to determine the best index. Then the filter function is
called to perform the actual work. I've noticed that the SQLITE engine seems
to process OR
Hello.
I have two tables to join. TABLE_A (contains column 'a') and TABLE_BC (contains
columns 'b' and 'c'). There is a condition on TABLE_BC. The two tables are
joined by 'rowid'.
Something like:
SELECT a, b, c FROM main.TABLE_A INNER JOIN main.TABLE_BC WHERE (b 10.0 AND c
10.0) ON
The problem is that I would like to avoid splitting the query into two parts.
I would expect SQLite to do the same thing for me automatically (at least in
the second scenario), but it does not seem to happen... Why is that?
In short, because SQLite cannot read your mind.
To understand the
On Tue, May 3, 2011 at 4:44 PM, Sugathan, Rupesh r...@carriercomm.com wrote:
I am planning to use sqlite on a Linux system with JFFS2 file system on
NAND flash. NAND device that I am using has page size of 2048 bytes and
a erase sector size of 128K. I would like to take advantage of sqlite
this is the vb net code I was running
Dim f As New OpenFileDialog
f.Filter = SQLite 3 (*.db)|*.db|All Files|*.*
If f.ShowDialog() = DialogResult.OK Then
Dim SQLconnect As New SQLite.SQLiteConnection()
Dim SQLcommand As SQLite.SQLiteCommand
Is it possible you're trying to load a 64 bit .dll with a 32 bit .exe? Or
visa versa.
Joe Mokos
Sr. Software Engineer
OPNET Technologies, Inc.
jmo...@opnet.com
(603) 598-2582 x377
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On
Prior to getting this error, I opened the d/b and inserted one (1) very
small record...
Where do I start looking? I am using FMDB, ZBarSDK (used to read
barcodes), but I can't imagine that's using all of my memory... and I
have the d/b set to be a singleton, as indicated by the NSLog
Hi Rolf,
I am using FMDB and SQLite for more than 2 years now and have not experienced
any problems so far. Therefore, I expect that the bug is somewhere else but not
inside SQLite (3.7.2) nor FMDB (2009-10-18).
Greetings,
Hartwig
Am 04.05.2011 um 23:22 schrieb Rolf Marsh:
Prior to
Hi Hartwig... I'm looking at the FMDB code, and I don't see any open
for the d/b. Does FMDB do this for me and I'm just missing it? Also
looked at Gus Mueller's blog of examples, and I don't see it there
either
Regards,
Rolf
On 5/4/11 2:38 PM, skywind mailing lists wrote:
Hi Rolf,
I
I tried several different sqlite.dlls now it works
Thanks
kp2011 wrote:
this is the vb net code I was running
Dim f As New OpenFileDialog
f.Filter = SQLite 3 (*.db)|*.db|All Files|*.*
If f.ShowDialog() = DialogResult.OK Then
Dim SQLconnect As
20 matches
Mail list logo