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
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,
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:
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:
>
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
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
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,
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
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,
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
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
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
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
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:
>>
>>
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
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
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
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
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
>
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
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
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
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
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
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
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
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
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
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
?)
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
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
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?
>>>
>>
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
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
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
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
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
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
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
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
,
-- 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.'
>>
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):
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
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
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
___
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
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
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
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
... 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,
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
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
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
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
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
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 ... ;
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.
>>>
>&
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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,
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
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
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
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:
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
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
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
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
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
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
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
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
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);
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
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
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
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
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
:
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
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.
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
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
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
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
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
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
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
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 - 100 of 173 matches
Mail list logo