Re: [sqlite] library routine called out of sequence

2011-12-24 Thread Tito Ciuro
Hi Sreekumar, Do you have a db connection shared across threads? This is not advised . Try opening a db connection per thread instead. -- Tito On Dec 23, 2011, at 15:06, Sreekumar TP wrote: > Hi, > > yes, I know. I have a multithreaded app. One db conection.I will

Re: [sqlite] SELECT query first run is VERY slow

2011-07-24 Thread Tito Ciuro
Hi, It has worked fairly well with small databases, but I see the problem with medium to large files. Have you tried to run ANALYZE on your database? I'm curious to know how long it takes. -- Tito On Jul 24, 2011, at 8:26 AM, Григорий Григоренко wrote: >> >> Perhaps my post dated Aug. 19,

Re: [sqlite] SELECT query first run is VERY slow

2011-07-22 Thread Tito Ciuro
Hello all, Perhaps my post dated Aug. 19, 2009 will help a little bit: http://www.cocoabuilder.com/archive/cocoa/242954-core-data-dog-slow-when-using-first-time-after-boot.html -- Tito On Jul 22, 2011, at 10:40 AM, Simon Slavin wrote: > > On 22 Jul 2011, at 2:11pm, Григорий Григоренко wrote:

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

2011-05-16 Thread Tito Ciuro
Hi Steven. You're absolutely right. Adding the sources to a real iOS project (standard Xcode 4, View-based iOS app) results in 885 KB. Great to see the linker/stripping process remove all this symbol info. Thanks for the help, -- Tito On May 16, 2011, at 8:49 AM, Steven Parkes wrote: >

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

2011-05-16 Thread Tito Ciuro
Hi Richard, On May 16, 2011, at 8:40 AM, Richard Hipp wrote: > I took the amalgamation file (sqlite3.c) and compiled it thusly: > > gcc -Os -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -c sqlite3.c > > The resulting binary size (as reported by the "size" command) is 392,203 > bytes. That's

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

2011-05-16 Thread Tito Ciuro
Hi Simon, No, I don't need it... but someone else might. I was considering adding FTS3 to my library in case someone needs to search across several text records. Depending on the table size, LIKE or GLOB would be very expensive because doing a full table scan would not be the most optimal

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

2011-05-16 Thread Tito Ciuro
Hi Steven, OK. First of all, I messed up by compiling shell.c (which is included in the SQLite amalgamated distro.) Removing it brings the size to: GCC: - Debug: 3.1 MB - Release: 3.4 MB LLVM Compiler 2.0: - Debug: 3.7 MB - Release: 4 MB This is what I did: 1) Create a new project in Xcode,

Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

2011-05-16 Thread Tito Ciuro
p://www.sqlabs.com > > > > > > > On May 16, 2011, at 5:01 PM, Tito Ciuro wrote: > >> Hello, >> >> I have a question about SQLite running on iOS. If I'm not mistaken, SQLite >> on iOS is not compiled with R*Tree and FTS3. Compiling a static library

[sqlite] Using SQLite with R*Tree and FTS3 support in iOS

2011-05-16 Thread Tito Ciuro
Hello, I have a question about SQLite running on iOS. If I'm not mistaken, SQLite on iOS is not compiled with R*Tree and FTS3. Compiling a static library of SQLite's amalgamated version weighs at about 4.3 MB, which represents almost 25% of the 20 MB-per-app allowed on the App Store. For many,

Re: [sqlite] Question: Memory-Based Databases

2011-05-10 Thread Tito Ciuro
Thanks Pavel! -- Tito On May 10, 2011, at 11:12 AM, Pavel Ivanov wrote: > Until you reach limit set by 'pragma cache_size' memory usage would be > the same for in-memory database and on-disk database. When the size of > your database grows beyond 'pragma cache_size' in-memory database > starts

[sqlite] Question: Memory-Based Databases

2011-05-10 Thread Tito Ciuro
Hello, I have been using memory-based databases (opened via :memory:) and performance is great. However, one of the things I assumed with memory-based databases was that memory usage would be higher than the temporary or persistent databases stored on disk. Is this true, or is the memory usage

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-02-01 Thread Tito Ciuro
Hello Marian, On Feb 1, 2011, at 1:28 PM, Marian Cascaval wrote: > Since this topic has lead to different sub-topic I dare ask a question (I'm a > beginner both in C++ and, Oh boy, in SQLite too). > > Tito, do you really need the 5th argument in sqlite3_prepare_v2() i.e. > ""? > From what I

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-02-01 Thread Tito Ciuro
Hi Drake, On Feb 1, 2011, at 9:33 AM, Drake Wilson wrote: > Quoth Tito Ciuro <tci...@mac.com>, on 2011-02-01 09:01:09 -0200: >> I don't think so. The fileSystemRepresentation method should we used >> when dealing with file-based paths. > > But not when dealing wi

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-02-01 Thread Tito Ciuro
Hi Afriza, On Feb 1, 2011, at 4:16 AM, Afriza N. Arief wrote: > On Tue, Feb 1, 2011 at 3:38 AM, Tito Ciuro <tci...@mac.com> wrote: > >> Hello, >> >> The following code snippet runs fine on Mac OS X, but fails on the iOS >> simulator: >> >>

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-01-31 Thread Tito Ciuro
Hello Simon, On Jan 31, 2011, at 8:29 PM, Simon Slavin wrote: > > On 31 Jan 2011, at 7:55pm, Tito Ciuro wrote: > >> What do you mean by "no further"? In my app, I use both statements. I have >> trimmed down the code in this email thread to show the err

Re: [sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-01-31 Thread Tito Ciuro
Hi Simon, On Jan 31, 2011, at 5:49 PM, Simon Slavin wrote: > > On 31 Jan 2011, at 7:38pm, Tito Ciuro wrote: > >> So my question I have is, why would the second sqlite3_prepare_v2 statement >> fail only on path-based iOS apps? :-/ > > The other question is: Is

[sqlite] Second sqlite3_prepare_v2() call fails on iOS path-based databases

2011-01-31 Thread Tito Ciuro
Hello, The following code snippet runs fine on Mac OS X, but fails on the iOS simulator: // Obtain a path for the database NSString *docs = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject]; NSString *path = [[docs

Re: [sqlite] Using Bulk Insert in SQLite

2011-01-10 Thread Tito Ciuro
Sunil, Google is your friend: http://www.google.com/search?client=safari=en=bulk+insert+sqlite=UTF-8=UTF-8 Regards, -- Tito On Jan 10, 2011, at 11:25 AM, Sunil Bhardwaj wrote: > Hi > > Please suggest, how can we implement Bulk Insert in SQLite. > > Thanks > Sunil Bhardwaj > Ext. 1125

Re: [sqlite] SQLite Documentation v2

2010-12-10 Thread Tito Ciuro
Thank you Simon! On Dec 10, 2010, at 10:08 AM, Simon Slavin wrote: > > On 10 Dec 2010, at 6:02pm, Tito Ciuro wrote: > >> Does it only work for Explorer? No Linux or Mac support? > > The web site has copies of itself for download. See the fourth item on >

Re: [sqlite] SQLite Documentation v2

2010-12-10 Thread Tito Ciuro
Hello Dagdamor, Does it only work for Explorer? No Linux or Mac support? -- Tito On Dec 10, 2010, at 7:55 AM, Dagdamor wrote: > SQLite Documentation (unofficial, HTML Help version) has been updated. > > Changes: > > - keywords list (index) extended with many new terms > - one missing link

Re: [sqlite] sqlite3_open on non-DB files / corrupt DBs - Found word(s) list error in the Text body

2010-11-25 Thread Tito Ciuro
Hi Nick, On Nov 25, 2010, at 2:09 PM, Nick Shaw wrote: > As Igor points out, that may not fail if the corruption is in a table > you don't query. > > In this case, the databases I'm working with are either small enough for > the speed of an integrity check not to be an issue, or the integrity

Re: [sqlite] sqlite3_open on non-DB files / corrupt DBs

2010-11-25 Thread Tito Ciuro
On 25 Nov 2010, at 12:51, Igor Tandetnik wrote: > Run "PRAGMA integrity_check" right after opening. That could be a potentially slow operation if the database is valid and contains lots of records. Wouldn't be better to issue a SELECT statement and let SQLite come back

Re: [sqlite] sqlite3_get_table() vs sqlite3_step

2010-11-21 Thread Tito Ciuro
to me that sqlite3_get_table() is not faster than sqlite3_step(). -- Tito On 21 Nov 2010, at 14:14, Igor Tandetnik <itandet...@mvps.org> wrote: > Tito Ciuro <tci...@mac.com> wrote: >> Let me start by saying that I'm aware that sqlite3_get_table() should not be >> use

Re: [sqlite] sqlite3_get_table() vs sqlite3_step

2010-11-21 Thread Tito Ciuro
Thanks a lot Max! -- Tito On 21 Nov 2010, at 14:04, Max Vlasov <max.vla...@gmail.com> wrote: > On Sun, Nov 21, 2010 at 6:31 PM, Tito Ciuro <tci...@mac.com> wrote: > >> Hello, >> >> Sounds like sqlite3_get_table() would take less time to access

[sqlite] sqlite3_get_table() vs sqlite3_step

2010-11-21 Thread Tito Ciuro
Hello, Let me start by saying that I'm aware that sqlite3_get_table() should not be used (as per the documentation). I'm curious about one thing though: if the computer/device has sufficient memory to hold the result set returned by sqlite3_get_table(), wouldn't it be more optimized

Re: [sqlite] Question about manifest typing/data affinity

2010-11-07 Thread Tito Ciuro
responded. It's definitely more clear to me how this works... excellent. Best regards, -- Tito On 06/11/2010, at 21:28, Jay A. Kreibich wrote: > On Sat, Nov 06, 2010 at 08:35:10PM -0300, Tito Ciuro scratched on the wall: >> Hello, >> >> I have a question about manifest

Re: [sqlite] Question about manifest typing/data affinity

2010-11-07 Thread Tito Ciuro
On 06/11/2010, at 21:28, Jay A. Kreibich wrote: > On Sat, Nov 06, 2010 at 08:35:10PM -0300, Tito Ciuro scratched on the wall: >> Hello, >> >> I have a question about manifest typing/data affinity. Assume I have >> created this table: >> >> CREATE TABLE f

[sqlite] Question about manifest typing/data affinity

2010-11-06 Thread Tito Ciuro
Hello, I have a question about manifest typing/data affinity. Assume I have created this table: CREATE TABLE foo (ROWID INTEGER PRIMARY KEY, key TEXT, attr TEXT, value NONE); I was reading the Using SQLite book and came across page #38 (#60 on the PDF version) where it states: "None: A

[sqlite] NanoStore has moved to Google Code

2010-10-06 Thread Tito Ciuro
Hello everyone, Based on feedback from other developers, I have decided to move NanoStore, a Cocoa wrapper for SQLite, to Google Code: http://code.google.com/p/nanostore/ The Sourceforge repository is now considered obsolete and will be removed shortly. Regards, -- Tito

[sqlite] [ANN] Release: NanoStore 1.0 for Mac and iOS

2010-09-22 Thread Tito Ciuro
?) In addition, the NanoStore project includes: - Unit tests - An iOS plain-vanilla app to demonstrate how easy it is to embed NanoStore in your project Enjoy! -- Tito * Tito Ciuro R Group, Webbo, L.L.C. ___ sqlite-users mailing list

Re: [sqlite] Books which cover C API

2010-07-07 Thread Tito Ciuro
On 08/07/2010, at 02:11, Mohit Sindhwani wrote: > On 8/7/2010 8:06 AM, Tito Ciuro wrote: >> On 8 Jul 2010, at 01:58, Mohit Sindhwani<m...@onghu.com> wrote: >> >> >>> On 8/7/2010 2:55 AM, Jay A. Kreibich wrote: >>> >>>> On Wed

Re: [sqlite] Books which cover C API

2010-07-07 Thread Tito Ciuro
On 8 Jul 2010, at 01:58, Mohit Sindhwani wrote: > On 8/7/2010 2:55 AM, Jay A. Kreibich wrote: >> On Wed, Jul 07, 2010 at 07:45:02PM +0100, Andrew Wood scratched on the wall: >> >>> Which of the books on the market is the best for covering the C API? >>> >>

Re: [sqlite] When to close a db?

2010-06-21 Thread Tito Ciuro
Sam, Could it be that you have prepared statements still active when you're trying to close the db? (not finalized, that is) -- Tito Sent from my iPhone On 20 Jun 2010, at 23:17, Sam Carleton wrote: > I am getting some strange behavior out of my app, which

Re: [sqlite] A question about how to interpret pragma integrity_check

2009-09-15 Thread Tito Ciuro
On Sep 15, 2009, at 6:59 PM, P Kishor wrote: > On Tue, Sep 15, 2009 at 8:50 PM, Tito Ciuro <tci...@mac.com> wrote: >> On Sep 15, 2009, at 6:42 PM, P Kishor wrote: >> >>> Could it be that those seemingly identical multiple rows actually >>> have >&g

Re: [sqlite] A question about how to interpret pragma integrity_check

2009-09-15 Thread Tito Ciuro
On Sep 15, 2009, at 6:42 PM, P Kishor wrote: > Could it be that those seemingly identical multiple rows actually have > trailing spaces or some other non-visible character? Check for their > length. Here we go: > sqlite> SELECT clientName, entityName, length(entityName) FROM > MyDBState ORDER

Re: [sqlite] A question about how to interpret pragma integrity_check

2009-09-15 Thread Tito Ciuro
Hello, On Sep 15, 2009, at 6:15 PM, P Kishor wrote: > well, your clientName, entityName combo is not unique in the list > above, and it should be given it is a PK. I have no idea how you > managed to insert these rows while the PK constraint was active. Precisely. I cannot reproduce this

Re: [sqlite] A question about how to interpret pragma integrity_check

2009-09-15 Thread Tito Ciuro
Hello, On Sep 15, 2009, at 12:55 PM, D. Richard Hipp wrote: > > On Sep 15, 2009, at 3:33 PM, Tito Ciuro wrote: > >> Hello, >> >> Given the following pragma integrity_check output: >> >>> sqlite> pragma integrity_check; >>> rowid 106931 mis

[sqlite] A question about how to interpret pragma integrity_check

2009-09-15 Thread Tito Ciuro
Hello, Given the following pragma integrity_check output: > sqlite> pragma integrity_check; > rowid 106931 missing from index sqlite_autoindex_MyDBState_1 > rowid 106933 missing from index sqlite_autoindex_MyDBState_1 > rowid 106935 missing from index sqlite_autoindex_MyDBState_1 > wrong # of

Re: [sqlite] about journal file

2009-08-29 Thread Tito Ciuro
On 29/08/2009, at 06:25, Zhanjun You wrote: > I finally understand do not need to deal with journal file. > But I do not know what circumstances led to the journal file, this > time to > read the database file will fail.What may cause such a thing happen? Google is your friend: typing 'sqlite

Re: [sqlite] Optimizing 'ends with' queries

2009-08-23 Thread Tito Ciuro
Hi Simon, On Aug 23, 2009, at 8:52 PM, Simon Slavin wrote: > > On 24 Aug 2009, at 4:22am, Tito Ciuro wrote: > >> But that would introduce the overhead of doubling the space required >> for every string + an additional column index. > > One of the options I mentione

Re: [sqlite] Optimizing 'ends with' queries

2009-08-23 Thread Tito Ciuro
, -- Tito On Aug 23, 2009, at 8:15 PM, Simon Slavin wrote: > > On 24 Aug 2009, at 3:44am, Tito Ciuro wrote: > >> Is there a way to optimize this type of queries? (column Value is >> indexed): >> >> SELECT Value FROM MyValues WHERE Value LIKE '%crashed.' >>

[sqlite] Optimizing 'ends with' queries

2009-08-23 Thread Tito Ciuro
Hello, Is there a way to optimize this type of queries? (column Value is indexed): SELECT Value FROM MyValues WHERE Value LIKE '%crashed.' I've seen the document where 'begins with' queries can be optimized using >= and < (end of the '4.0 The LIKE optimization' section):

[sqlite] Question about sqlite3_extended_result_codes()

2009-06-27 Thread Tito Ciuro
Hello, I have a couple questions about sqlite3_extended_result_codes(): 1) Once I enable it, is it possible to determine whether extended result codes is enabled for a given a sqlite3* handle? 2) Do I have to process each result code in order to obtain the "regular" SQLite code, or can I

Re: [sqlite] [OT] How to implement paging

2009-05-25 Thread Tito Ciuro
Hi Sam, On May 25, 2009, at 10:58 AM, Sam Carleton wrote: > Example: Following the logic of the ScrollingCursor page, lets assume > a total result set of 88 titles. If the lasttitle happens to be the > 29th title, so the set that is returned is 30 through 34, how do I > determine that this is

Re: [sqlite] corrupt database recovery

2009-04-26 Thread Tito Ciuro
Hi Gene, On Apr 25, 2009, at 3:47 PM, Gene wrote: > Every now and again, we have a database that gets corrupt in the > field (bad > coding on our end, not sqlite). How do you corrupt a database with bad coding? Just curious... -- Tito ___

Re: [sqlite] Heuristics of when to vacuum

2009-04-12 Thread Tito Ciuro
Hi Eugene, On 12 Apr 2009, at 9:53 AM, Eugene Wee wrote: > Hi, > > On Mon, Apr 13, 2009 at 12:40 AM, Tito Ciuro <tci...@mac.com> wrote: >> One question, when I run the command I see that the fragmentation in >> "All tables" is greater than "All tables

Re: [sqlite] Heuristics of when to vacuum

2009-04-12 Thread Tito Ciuro
Hi Kees, On Apr 12, 2009, at 5:27 AM, Kees Nuyt wrote: > PRAGMA freelist_count; tells you how many pages are free. > If there are many free pages, you may have a reason to > vacuum. It doesn't tell anything about the average > percentage of payload in database pages, which would be > another

Re: [sqlite] Heuristics of when to vacuum

2009-04-11 Thread Tito Ciuro
Hi Lawrence, On Apr 11, 2009, at 7:51 PM, Lawrence Gold wrote: > I can't offer a formula, but I suggest making it an option for the > users of the software, with sufficient warning that it could take some > time, as well as a Cancel button. Another thing you could do is to > schedule the vacuum

[sqlite] Heuristics of when to vacuum

2009-04-11 Thread Tito Ciuro
Hello, I'm sure this question has been asked before, but I haven't been able to find it in the archives: when does it make sense to vacuum? If an application which deals with a large database vacuums say, on termination, it may take a long time to process them and not gain much from that

Re: [sqlite] httpd server ???

2009-03-17 Thread Tito Ciuro
... or you can try Cherokee: http://www.cherokee-project.com/ -- Tito On 17 mars 2009, at 16:39, Nuno Magalhães wrote: >> Does anyone know of an embedded http server that can serve and/or >> create pages from a sqlite database? > > What do you mean embedded? If you mean fast and lightweight,

[sqlite] [OFF] Re: sqlite3 datbase disk image malformed

2009-03-05 Thread Tito Ciuro
Hi donnied, On Mar 5, 2009, at 4:30 AM, donnied wrote: > > rsync was corrupting the database. I'll have to exclude the > database from > rsync backup. > > > D. Richard Hipp wrote: >> >> >> See http://www.sqlite.org/atomiccommit.html and especially section >> 9.0 >> "Things That Can Go

Re: [sqlite] sqlite3 datbase disk image malformed

2009-03-04 Thread Tito Ciuro
Hi Dan, On Mar 4, 2009, at 9:21 AM, Dan wrote: > > On Mar 5, 2009, at 12:10 AM, Tito Ciuro wrote: > >> Hello, >> >> On Mar 4, 2009, at 6:06 AM, D. Richard Hipp wrote: >> >>> See http://www.sqlite.org/atomiccommit.html and especially section >>&g

Re: [sqlite] sqlite3 datbase disk image malformed

2009-03-04 Thread Tito Ciuro
Hello, On Mar 4, 2009, at 6:06 AM, D. Richard Hipp wrote: > See http://www.sqlite.org/atomiccommit.html and especially section 9.0 > "Things That Can Go Wrong" Reading the above link, I'm curious about a specific case: 4.2 Hot Rollback Journals. It states that: [...] The first time that any

Re: [sqlite] Transactions and attached databases

2009-02-26 Thread Tito Ciuro
Hi Donald, On Feb 25, 2009, at 3:39 PM, Griggs, Donald wrote: > Greetings, Tito, > > Did you see page: >http://www.sqlite.org/lang_attach.html > > > Transactions involving multiple attached databases are atomic, > assuming > that the main database is not ":memory:". > > It then goes on to

Re: [sqlite] Transactions and attached databases

2009-02-25 Thread Tito Ciuro
Hi Donald, On Feb 25, 2009, at 3:39 PM, Griggs, Donald wrote: > Greetings, Tito, > > Did you see page: >http://www.sqlite.org/lang_attach.html > > > Transactions involving multiple attached databases are atomic, > assuming > that the main database is not ":memory:". > > It then goes on to

[sqlite] Transactions and attached databases

2009-02-25 Thread Tito Ciuro
Hello, If I attach one or more databases and wrap a series of operations which affect some/all of them, would ROLLBACK or COMMIT treat these operations atomically? For example: Open database 'foo'; Attach database 'bar' as a1; BEGIN TRANSACTION; INSERT INTO main.some_table ... ;

Re: [sqlite] Question about sqlite3_clear_bindings

2008-12-08 Thread Tito Ciuro
On 8 Dec 2008, at 11:54 AM, Igor Tandetnik wrote: > Tito Ciuro <[EMAIL PROTECTED]> wrote: >> On 8 Dec 2008, at 11:29 AM, Igor Tandetnik wrote: >> >>>> I'd like to know why sqlite3_clear_bindings >>>> () exists in the first place. >>> >&

Re: [sqlite] Question about sqlite3_clear_bindings

2008-12-08 Thread Tito Ciuro
Hi Igor, On 8 Dec 2008, at 11:29 AM, Igor Tandetnik wrote: >> I'd like to know why sqlite3_clear_bindings >> () exists in the first place. > > I don't know. It doesn't look particularly useful to me, either. Looking through the docs, it seems that sqlite3_clear_bindings() is a convenience

Re: [sqlite] Question about sqlite3_clear_bindings

2008-12-08 Thread Tito Ciuro
Hi Igor, On 7 Dec 2008, at 10:49 PM, Igor Tandetnik wrote: > You might want to if most of your parameters are NULL, and you just > bind > a some of them. I didn't read your reply carefully enough. It makes sense, thank you. -- Tito ___ sqlite-users

Re: [sqlite] Question about sqlite3_clear_bindings

2008-12-08 Thread Tito Ciuro
Hello Igor, On 7 Dec 2008, at 10:49 PM, Igor Tandetnik wrote: > "Tito Ciuro" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> 1 • Create the object using sqlite3_prepare_v2() or a related >> function. 2 • Bind values to host parameters using

[sqlite] Question about sqlite3_clear_bindings

2008-12-07 Thread Tito Ciuro
Hello, I was reading the following pages: http://www.sqlite.org/c3ref/stmt.html http://www.sqlite.org/c3ref/clear_bindings.html I was wondering why sqlite3_clear_bindings() is not mentioned in the SQL Statement Object page. Would the following be incorrect?: 1 • Create the object using

Re: [sqlite] Saving a memory-based SQLite database to disk

2008-11-09 Thread Tito Ciuro
Hi Jay, Definitely worth investigating. Thanks for the tip! -- Tito On 9 Nov 2008, at 8:44 AM, Jay A. Kreibich wrote: > On Sat, Nov 08, 2008 at 03:34:29PM -0800, Tito Ciuro scratched on > the wall: >> Hello, >> >> If I open a SQLite database in memory

Re: [sqlite] Saving a memory-based SQLite database to disk

2008-11-09 Thread Tito Ciuro
Thank you for the pointer Joshua. -- Tito On 8 Nov 2008, at 3:46 PM, Joshua Paine wrote: > Tito Ciuro wrote: >> If I open a SQLite database in memory (using :memory:), would it be >> possible to save it on disk? > > Open a disk db and use the ATTACH sql command to add a mem

[sqlite] Saving a memory-based SQLite database to disk

2008-11-08 Thread Tito Ciuro
Hello, If I open a SQLite database in memory (using :memory:), would it be possible to save it on disk? Here's the reason: Using a file-based SQLite database: 2008-11-08 15:15:44.180 XML2Plist[5554:10b] Number of XML documents converted successfully: 2861 2008-11-08 15:15:53.053

[sqlite] How can I count the number of times a word present in text indexed with FTS 3?

2008-06-10 Thread Tito Ciuro
Hello, I was reading the document 'http://www.sqlite.org/cvstrac/wiki?p=FtsUsage' and I was wondering whether there is a way to count the number of times a word is present in text indexed with FTS 3. For example: CREATE VIRTUAL TABLE recipe USING fts3(name, instructions); INSERT INTO

Re: [sqlite] Best way to optimize this query?

2007-05-02 Thread Tito Ciuro
Hi Donald, On May 2, 2007, at 11:25 AM, Griggs, Donald wrote: The ROWID is indexed implicitly I believe, so it may be slowing things slightly if you index it explicitly. Yes, I was aware of that, thanks for the heads up. Regarding: "What if I have, say, 500 to retrieve?" You can create a

Re: [sqlite] Best way to optimize this query?

2007-05-02 Thread Tito Ciuro
Hello, On May 2, 2007, at 11:11 AM, P Kishor wrote: On 5/2/07, Tito Ciuro <[EMAIL PROTECTED]> wrote: When you say "speed things up," is it not fast enough yet? Numbers would be helpful. I've just tested it and the query is *very* fast. I was just wondering whether this type

[sqlite] Best way to optimize this query?

2007-05-02 Thread Tito Ciuro
Hello, Assume the following scenario: I store people in a table, like this: People ROWID, idx GUID, idx First, idx Last, idx Email ... In the app, the user can select People GUIDs from different sources and then retrieve the info from the

Re: [sqlite] sqlite Performance

2007-03-15 Thread Tito Ciuro
Hello, IIRC (it was a while ago), one way to speed up insertion for large data sets is to drop the indexes, do the inserts (wrapped around a transaction) and then rebuild the indexes. For smaller data sets, the drop/rebuild indexes solution doesn't make sense because the time it takes to

Re: [sqlite] multi threats parallel reading db

2006-08-18 Thread Tito Ciuro
On Aug 18, 2006, at 6:45 AM, [EMAIL PROTECTED] wrote: Please double-check your code. The error message "library routine called out of sequence" is what you get when you try to use the the same database connection from more than one thread at one time. If I remember correctly, there are two

Re: [sqlite] Intermittent crash in sqlite3_prepare()

2006-04-24 Thread Tito Ciuro
Hi Doug, This is what I see in the console: (gdb) print *db $2 = { nDb = 2, aDb = 0x177a750c, flags = 32, errCode = 5, autoCommit = 1 '\001', temp_store = 0 '\0', nTable = 1, pDfltColl = 0x1770f300, lastRowid = 0, priorNewRowid = 0, magic = -1607883113, nChange = 0,

[sqlite] Intermittent crash in sqlite3_prepare()

2006-04-24 Thread Tito Ciuro
Hello, When I'm running several threads at the same, I sometimes get a crash in sqlite3_prepare() in the marked statement below: int sqlite3_prepare( sqlite3 *db, /* Database handle. */ const char *zSql, /* UTF-8 encoded SQL statement. */ int nBytes,

Re: [sqlite] Is it safe to read or write a table while being indexed?

2006-04-18 Thread Tito Ciuro
Hi Christian, On 18/04/2006, at 8:22, Christian Smith wrote: SQLite will make possible whatever is safe. Just be prepared to handle SQLITE_BUSY and SQLite will take care of the rest. Great. This is what I do now. No worries here then... If the indexing process uses a large SQLite cache

[sqlite] Acquiring a PENDING lock

2006-04-16 Thread Tito Ciuro
Hello, As stated in the documentation I see that: A deferred transaction starts without a lock and obtains a SHARED lock on the first read and the first write operation creates a RESERVED lock. An immediate acquires a RESERVED lock as soon as the BEGIN command is executed, without

Re: [sqlite] Is it safe to read or write a table while being indexed?

2006-04-16 Thread Tito Ciuro
On 16/04/2006, at 3:52, [EMAIL PROTECTED] wrote: Tito Ciuro <[EMAIL PROTECTED]> wrote: - Does SQLite acquire an EXCLUSIVE lock when indexing? Yes - If I'm not mistaken, an EXCLUSIVE lock does not stop other readers from accessing the database. You are mistaken. An EXCLUSIVE lock

[sqlite] Is it safe to read or write a table while being indexed?

2006-04-15 Thread Tito Ciuro
Hello, I was wondering whether it is safe to read or write a table while being indexed. Here's a scenario: for batch imports, it's sometimes better to DROP the indexes, do the INSERTs and then recreate the relevant indexes. Indexing may take a little bit of time, so I was wondering if:

Re: [sqlite] [SOLVED] Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-28 Thread Tito Ciuro
Hi Denis, I've been reading your email carefully and I'd like to comment it. On 28/03/2006, at 14:24, Dennis Cote wrote: With these tables you will have 25K rows in the File table, one per file, and 250K rows in the Attribute table assuming an average of 10 attributes per file (your

Re: [sqlite] [SOLVED] Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-28 Thread Tito Ciuro
John, Did you read my replies at all? If not, please take 15 seconds to do so. I thanked *all of you* in all three emails. Just in case, if that wasn't enough, allow me to do that for the fourth time: I most sincerely appreciate the time and effort that you guys have taken to answer my

Re: [sqlite] [SOLVED] Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-28 Thread Tito Ciuro
MGC, I have no idea why you're so angry. Anyway, there are so many things I can think of saying, I'll just make it brief and to the point. 1) Regarding your statement: This thing won't scale. I'd like to see it when you have the 4.5 million records my database contains, and that is still

[sqlite] [SOLVED] Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-28 Thread Tito Ciuro
0800,\ntciuro,\n384,\n2006-03-26 08:46:55 -0800,\n 502,\n20\n)'),) ] Could you try reducing your search strings and see if there's a point at which they start working? HTH, Martin Jenkins XQP Ltd Ascot, UK - Original Message - From: "Tito Ciuro" <[EMAIL P

Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-26 Thread Tito Ciuro
Hello everybody, On 26/03/2006, at 10:08, John Stanton wrote: LIKE and GLOB do a row scan, and give you none of the advantages of an RDBMS. Why not use a flat file and grep and get simplicity and greater speed? I'm very well aware that LIKE and GLOB perform a row scan. I do appreciate

Re: [sqlite] LIKE and GLOB bug with numbers?

2006-03-26 Thread Tito Ciuro
On 26/03/2006, at 10:51, MGC wrote: Your design is fundamentaly wrong. I don't know what your intended use is for this data, but I am logging identical fstat file info along with an MD5 sums. Well... if you don't know what is the intended use for the data, how can you say that my design

[sqlite] LIKE and GLOB bug with numbers?

2006-03-26 Thread Tito Ciuro
Hello, I've populated a datafile with 40.176 records which contain file attributes and file paths. I have two columns, CMKey and CMValues. The column CMKey contains the path to the file and the column CMValues contains the attribute values. For example: CMKey: Application

[sqlite] "Safe" maximum numbers of tables?

2006-03-23 Thread Tito Ciuro
Hello, I was reading the FAQ and I came across this statement: In practice, SQLite must read and parse the original SQL of all table and index declarations everytime a new database file is opened, so for the best performance of sqlite3_open() it is best to keep down the number of

Re: [sqlite] INSERT multiple times using sqlite_bind_text()

2006-03-20 Thread Tito Ciuro
Perfect! It works fine now... :-) Many thanks, -- Tito On 20/03/2006, at 12:23, [EMAIL PROTECTED] wrote: Tito Ciuro <[EMAIL PROTECTED]> wrote: Hello, I'm trying to INSERT many records using sqlite3_bind_text(). This is what I do: // Finish... result = sqlite3_finalize(statement);

[sqlite] INSERT multiple times using sqlite_bind_text()

2006-03-20 Thread Tito Ciuro
Hello, I'm trying to INSERT many records using sqlite3_bind_text(). This is what I do: sqlite3_stmt *statement = NULL; const char *sql = "INSERT INTO mytable(foo, bar) VALUES (?,?);" int result = sqlite3_prepare(sqliteDatabase, sql, -1, , NULL); // Do a bunch of binds and execute... for (i

Re: [sqlite] Unrecognized token error

2006-03-19 Thread Tito Ciuro
Hi John, On 19/03/2006, at 18:23, John Stanton wrote: Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string? If I escape single quotes

[sqlite] [LONG]Re: [sqlite] Unrecognized token error

2006-03-19 Thread Tito Ciuro
Hi John, On 19/03/2006, at 18:23, John Stanton wrote: Tito Ciuro wrote: Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito What is the string? Here's the string (it's a p

[sqlite] Unrecognized token error

2006-03-19 Thread Tito Ciuro
Hello, I'm trying to store a string and I get the following error: unrecognized token: \"!\"\" This happens with SQLite 3.2.7 Any ideas? Thanks, -- Tito

Re: [sqlite] Problems compiling SQLite 3.3.4 on Mac OS X

2006-03-06 Thread Tito Ciuro
Hi James! Even though I dragged the entire directory, os.c and shell.c were the only two files no included in the project. Weird... Thanks so much! -- Tito On 06/03/2006, at 17:11, James W. Walker wrote: Tito Ciuro <[EMAIL PROTECTED]> wrote: When I create an Xcode project in Ma

Re: [sqlite] Problems compiling SQLite 3.3.4 on Mac OS X

2006-03-06 Thread Tito Ciuro
: Tito Ciuro <[EMAIL PROTECTED]> writes: Hello, SQLite 3.3.4 Mac OS X Tiger 10.4.5 After ./configure and make SQLite 3.3.4, I see that some files have disappeared: os_test.c os_test.h os_unix.h os_win.h This results in a few undefined symbols: sqlite3OsClose sqlite3FileSize sqlite3

Re: [sqlite] Problems compiling SQLite 3.3.4 on Mac OS X

2006-03-06 Thread Tito Ciuro
Hello, On 06/03/2006, at 12:44, [EMAIL PROTECTED] wrote: I build the OS-X version for the website on Tiger using the ./configure script in the TEA version of SQLite. You might try it as a work-around. http://www.sqlite.org/sqlite-3.3.4-tea.tar.gz I get a "document not found" error.

Re: [sqlite] Problems compiling SQLite 3.3.4 on Mac OS X

2006-03-06 Thread Tito Ciuro
Hello Manfred, On 06/03/2006, at 12:43, Manfred Bergmann wrote: What source package did you download? http://www.sqlite.org/sqlite-3.3.4.tar.gz Were these files missing bevor configure and make, too? Yes. Thanks, -- Tito

Re: [sqlite] Problems compiling SQLite 3.3.4 on Mac OS X

2006-03-06 Thread Tito Ciuro
Hi Derrell, On 06/03/2006, at 12:11, [EMAIL PROTECTED] wrote: First guess would be that 'configure' isn't detecting that OS X is Unix-like. I suspect you might get a hint of what's going on if you carefully inspect the output from 'configure' to see what supported OS it's detecting (if

[sqlite] Problems compiling SQLite 3.3.4 on Mac OS X

2006-03-06 Thread Tito Ciuro
Hello, SQLite 3.3.4 Mac OS X Tiger 10.4.5 After ./configure and make SQLite 3.3.4, I see that some files have disappeared: os_test.c os_test.h os_unix.h os_win.h This results in a few undefined symbols: sqlite3OsClose sqlite3FileSize sqlite3OsLock ... Any ideas? Thanks, -- Tito

Re: [sqlite] Where are temporary tables/indices stored?

2005-09-01 Thread Tito Ciuro
Of course!! Thanks Dennis :-) -- Tito On 01/09/2005, at 23:05, Dennis Cote wrote: Tito Ciuro wrote: If I execute a statement such as 'CREATE TEMP TABLE...' without specifying the database name, where is the SQL statement stored? I've tried using 'temp' as the database name

Re: [sqlite] How to retrieve sqlite version

2005-09-01 Thread Tito Ciuro
Hi Jeff, Just call sqlite3_libversion() Regards, -- Tito On 01/09/2005, at 19:55, Dinsmore, Jeff wrote: I can't seem to come up with how to get the version from sqlite. The frustrating thing is that I've done it before... As I recall, it's a select, but for the life of me, I can't

[sqlite] Where are temporary tables/indices stored?

2005-09-01 Thread Tito Ciuro
Hello, Regarding the TEMP keyword, the documentation states: If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "TABLE" then the table that is created is only visible within that same database connection and is automatically deleted when the database connection is

Re: [sqlite] Richard Hipp Awarded Google-O'Reilly Open Source Award at OSCON 2005

2005-08-05 Thread Tito Ciuro
Without SQLite I couldn't have done some of my projects. It's amazing at what it does. Thanks a lot and congratulations! -- Tito --- Tito Ciuro Webbo, L.L.C. http://www.webbo.com

Re: [sqlite] ALTER TABLE: Confusing documentation

2005-07-27 Thread Tito Ciuro
On 27/07/2005, at 13:04, Kurt Welgehausen wrote: The docs are correct; you just have to read carefully. I have :-) They say that you can "rename, or add a new column to, an existing table". No, it doesn't. It states that you can "rename or add a new column to an existing table."

  1   2   >