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
rollback for the safety of my database files during power-fail.
As per http://www
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 currently a singleton)... my problem is I don't
know what has to be changed from my existing code, since FMDB has it's
own initializatio
On May 3, 2011, at 6:04 PM, Rolf Marsh wrote:
> Hello.. I just joined today and can't seem to figure out how to start a
> new thread... Can someone please enlighten me?
You just did.
Just post a question with the subject line indicating clearly what is bothering
you and take a seat. The doct
Hello.. I just joined today and can't seem to figure out how to start a
new thread... Can someone please enlighten me?
Regards,
Rolf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/03/2011 10:25 AM, Dotan Cohen wrote:
> I have seen this issue brought up on all types of software, from Anki
> to Kontact to Yum:
The way this is generally solved is to use a full text search engine. The
various techniques are named things like
On Tue, May 3, 2011 at 10:25 AM, Dotan Cohen wrote:
> 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 m
On Tue, May 3, 2011 at 3:31 PM, jeff archer wrote:
> >I believe any compilation options that require changes in SQL parser
> >require compiling from original sources as well. They cannot be used
> >with amalgamation file which has already generated SQL parser's code.
> >
> >Pavel
>
> OK. But thi
On Tue, May 3, 2011 at 9:15 PM, Pavel Ivanov wrote:
> I believe any compilation options that require changes in SQL parser
> require compiling from original sources as well. They cannot be used
> with amalgamation file which has already generated SQL parser's code.
>
That's correct. See:
http:/
>I believe any compilation options that require changes in SQL parser
>require compiling from original sources as well. They cannot be used
>with amalgamation file which has already generated SQL parser's code.
>
>Pavel
OK. But this call in the parser source...
sqlite3FinishTrigger
(pParse, y
I believe any compilation options that require changes in SQL parser
require compiling from original sources as well. They cannot be used
with amalgamation file which has already generated SQL parser's code.
Pavel
On Tue, May 3, 2011 at 3:05 PM, jeff archer wrote:
> I am attempting to compile
I am attempting to compile SQLite on windows with SQLITE_OMIT_TRIGGER defined
and I get the following errors.
Sure enought the code in yy_...() is not exclosed in ifndef SQLITE_OMIT_TRIGGER
1> Creating library ..\..\Bin\x64\Debug\SqlUtils.lib and object
..\..\Bin\x64\Debug\SqlUtils.exp
1>sqlite
I bought the hard copy several months ago... I use it all the time...
On 5/3/11 9:20 AM, Simon Slavin wrote:
> O'Reilly
> >Media
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I learned a lot from it, too.
Gerry Snyder
On 5/3/11, Nico Williams wrote:
> On Tue, May 3, 2011 at 11:20 AM, Simon Slavin wrote:
>> On 3 May 2011, at 5:09pm, Jay A. Kreibich wrote:
>>
>>> "Using SQLite" is today's "Ebook Deal of the Day" over at O'Reilly
>>> Media. Today only (Tuesday, May
Actually, for what he wants, you don't need anything fancy. A simple
multi-column index is enough.
The R-Tree is to allow queries of a sparse dataset, that might also
have overlaps.
So: A simple index for your background imagery. An R-Tree index for
the features added on top of your background
On 3 May 2011, at 6:25pm, Dotan Cohen wrote:
> 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
Sounds like soundex might work for you. Not sure how it handles diacritics
though.
http://www.mail-archive.com/sqlite-users@sqlite.org/msg35316.html
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
From: sqlite-us
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 speci
On 3 May 2011, at 5:56pm, Paul Shaffer wrote:
> This is a mapping table or descriptor table or whatever you want to call
> it, between 2 tables (about 120,000 rows). I'm finding that operations are
> very slow (delete, select, etc.) even within transactions. [snip]
>
> CREATE TABLE [Item_attribu
This is a mapping table or descriptor table or whatever you want to call
it, between 2 tables (about 120,000 rows). I'm finding that operations are
very slow (delete, select, etc.) even within transactions. Foreign keys =
ON. I tried a different design with an integer primary key (which in this
cas
On Tue, May 3, 2011 at 11:20 AM, Simon Slavin wrote:
> On 3 May 2011, at 5:09pm, Jay A. Kreibich wrote:
>
>> "Using SQLite" is today's "Ebook Deal of the Day" over at O'Reilly
>> Media. Today only (Tuesday, May 3rd) the ebook is 50% off, at
>> $15.99.
>
> Well I don't know, Jay. Have you read
On 3 May 2011, at 5:09pm, Jay A. Kreibich wrote:
> "Using SQLite" is today's "Ebook Deal of the Day" over at O'Reilly
> Media. Today only (Tuesday, May 3rd) the ebook is 50% off, at
> $15.99.
Well I don't know, Jay. Have you read it ? Is it any good ?
For those who don't know, Jay A. Krei
"Using SQLite" is today's "Ebook Deal of the Day" over at O'Reilly
Media. Today only (Tuesday, May 3rd) the ebook is 50% off, at
$15.99. Use the discount code "DDSQT".
O'Reilly ebooks are available in several DRM-free formats including
PDF, ePub, and Mobi.
http://oreilly.com/
ht
On Tue, May 3, 2011 at 9:46 AM, Rolf Marsh wrote:
> Here is my code, written in Obj-C. I can't figure out what I'm doing
> wrong... can someone enlighten me? Please?
>
Set a breakpoint on sqlite3MisuseError() and see where it is being hit.
>
> NSString * errmsg = nil;
> SQLiteDB* db =
Here is my code, written in Obj-C. I can't figure out what I'm doing
wrong... can someone enlighten me? Please?
NSString * errmsg = nil;
SQLiteDB* db = [SQLiteDB sharedSQLiteDB]; // create the d/b
NSString *insertCommand = [NSString stringWithFormat:@"INSERT FAIL
INTO CardDat
Hi Simon,
Thanks for the quick reply!
Haven't started the PyGTK step as I wanted to get the SQLite working first. Now
I know to skip it. Thanks again!
Cheers,
===
Brian
On 03/05/2011, at 23:14 PM, Simon Slavin wrote:
>
>> I'm Brian and very much a rookie on this topic. A
On 3 May 2011, at 1:51pm, Brian wrote:
> I'm Brian and very much a rookie on this topic. After several hours trying to
> determine how to install/compile SQLite for OS X, I'm getting no where;
> SQLite is required for KeepNote (http://rasm.ods.org/keepnote/) app.
The current version of OS X al
Hello group,
I'm Brian and very much a rookie on this topic. After several hours trying to
determine how to install/compile SQLite for OS X, I'm getting no where; SQLite
is required for KeepNote (http://rasm.ods.org/keepnote/) app.
I've downloaded and unzipped three sets of files, the shell, th
Hi,
I think an R Tree is what you are after.
http://www.sqlite.org/rtree.html
/eno
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
mykonica wrote:
> If I execute a query like 'select col_1 from tbl_1', how to get the count of
> query result before step it ?
You can't. You'll have to step through to the end while counting rows, or else
run a statement like 'select count(*) from tbl_1'
--
Igor Tandetnik
___
If I execute a query like 'select col_1 from tbl_1', how to get the count of
query result before step it ?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
My application displays very large images at different zoom factors. I have
tiled my images into individual tiles of a much smaller size. Each image has
hundreds of tiles. The tiles will be used to interactively display the image
and the speed of the zooming and panning is very important.
31 matches
Mail list logo
