[sqlite] seeking database design advice

2012-03-01 Thread Rich Rattanni
All: I wanted to solicit some opinions about how best to layout a database table for a project I am working on. I have a distributed application that reports run time information back to a central machine. Included in the report are the parameters used during runtime... approx 25 or so.

Re: [sqlite] vacuum and rowids

2011-04-28 Thread Rich Rattanni
> "You can access the ROWID of an SQLite table using one the special column > names ROWID, _ROWID_, or OID. Except if you declare an ordinary table column > to use one of those special names, then the use of that name will refer to > the declared column not to the internal ROWID." > > which

Re: [sqlite] SQLite handling of EINTR

2011-04-21 Thread Rich Rattanni
That would be it. Thanks Roger. Next time I will update first and ask questions later. -- Rich On Thu, Apr 21, 2011 at 5:55 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 04/21/2011 02:24 PM, Rich Rattanni wrote: >&

[sqlite] SQLite handling of EINTR

2011-04-21 Thread Rich Rattanni
I have been tracing the source of a low-occurrence anomaly in my C# application, running on Linux 2.6 under Mono. My application is using Robert Simpson's SQLite .NET adapter + SQLite 3.7.5. After I resolved my own bug, which prevented me from seeing the exception thrown by System.Data.SQLite, I

Re: [sqlite] Building managed only System.Data.SQLite

2011-04-20 Thread Rich Rattanni
at 5:36 PM, Rich Rattanni <ratta...@gmail.com> wrote: > Daniel: > > I have not tried Csharp-sqlite, it looks interesting but I do not know > if that is right for me at this moment. > > Shane: > > I will try what you recommend tomorrow, thank you. > > -- > R

Re: [sqlite] Building managed only System.Data.SQLite

2011-04-19 Thread Rich Rattanni
he > settings changes there. > This should work with VS2008 and VS2010. > > HTH. > -Shane > > > On Tue, Apr 19, 2011 at 3:09 PM, Rich Rattanni <ratta...@gmail.com> wrote: > >> I was wondering if anyone has had any luck building the Managed-Only >> S

[sqlite] Building managed only System.Data.SQLite

2011-04-19 Thread Rich Rattanni
I was wondering if anyone has had any luck building the Managed-Only System.Data.SQLite .NET adapter for SQLite from the source provided at system.data.sqlite.org? I downloaded the pre-built binaries but they appear to rely on the InterOp assembly. My current project is running under Linux 2.6

Re: [sqlite] Insert while select

2011-01-26 Thread Rich Rattanni
<itandet...@mvps.org> wrote: > >> On 1/26/2011 11:09 AM, Rich Rattanni wrote: >> > I am helping someone write an application that utilizes SQLite.  The >> > following code is giving us grief (sqlite lib version 3.5.ish - >> > Windows XP): >> > >&

[sqlite] Insert while select

2011-01-26 Thread Rich Rattanni
I am helping someone write an application that utilizes SQLite. The following code is giving us grief (sqlite lib version 3.5.ish - Windows XP): sqlite3_prepare("select some rows") while (sqlite3_step() == SQLITE_ROW) { // Do some calc on multiple rows, and occasinally

[sqlite] Database unreadable after WAL conversion on system w/o shared mem support

2010-08-02 Thread Rich Rattanni
I recently tried out SQLite 3.7.0 on an ARM project board running linux 2.6. I did not realize that jffs2 lacked shared memory support, so when I opened my database file using the sqlite3 utility and typed 'pragma journal_mode=wal' it appeared as though the conversion worked (response: wal) but

Re: [sqlite] notify all processes of database modification

2010-06-16 Thread Rich Rattanni
> That is, other than polling, . Yep, that trick. (Why does everyone dismiss polling...don't we have any embedded programmers here? Hey Windows CE guy, don't raise your hand...) Roger summed it up, and labeled it correctly (crappy). But if it works sufficiently for him, why not

Re: [sqlite] notify all processes of database modification

2010-06-15 Thread Rich Rattanni
The creator of SQLite actually gave a talk about using an SQLite database as a means for IPC (it was available on youtube, maybe you can find it). If you want an 'sqlit-ish' way, why not use that trick? One advantage of using SQLite is that debugging / backtracing becomes easier. Since your

Re: [sqlite] [lcc32] "sqlite3.c:6597 Character constant taken as not signed"

2010-05-21 Thread Rich Rattanni
BloodShed Dev-C++ and ming? My choice for windows development. On Fri, May 21, 2010 at 11:01 AM, Richard Hipp wrote: > On Fri, May 21, 2010 at 7:43 AM, Gilles Ganault wrote: > >> >> But when hitting "Compiler > Make" in the Wedit IDE, I get the >>

[sqlite] journaling across multiple databases on read only filesystems

2010-02-03 Thread Rich Rattanni
I got a quick question. I have two databases, one resides on a read only file system, the other is on a writable file system. I routinely copy from the read only copy to the other. I did not realize, until today, that I do not have the protection of transaction support since one database is

Re: [sqlite] Selecting unique entries from one table with multiple columns forming a unique key

2009-12-03 Thread Rich Rattanni
e index on (col2, > col3) in biggest of the tables foo or bar then my query will work an > order of magnitude faster than yours. > > > Pavel > > On Thu, Dec 3, 2009 at 4:54 PM, Rich Rattanni <ratta...@gmail.com> wrote: >> Awesome!  Thank you.  Can I ask a follow u

Re: [sqlite] Selecting unique entries from one table with multiple columns forming a unique key

2009-12-03 Thread Rich Rattanni
> where foo.col2 = bar.col2 and foo.col3 = bar.col3 > > It's not clear from your requirements written below whether you need > 'distinct' here or not but I've added it just in case... > > > Pavel > > On Thu, Dec 3, 2009 at 4:34 PM, Rich Rattanni <ratta...@gmail.com>

[sqlite] Selecting unique entries from one table with multiple columns forming a unique key

2009-12-03 Thread Rich Rattanni
Suppose I have the following two tables foo: 10 | A | A 20 | B | B 30 | C | C and bar: 1 | A | X 2 | B | C 3 | A | A 4 | C | A 5 | B | B I want to select all the rows in table bar where the second and third column match an entry found in foo (that is to say, I want my result to be 3 | A |

[sqlite] accessing bound variables in trigger

2009-09-14 Thread Rich Rattanni
I have an application that performs the following SQL action: UPDATE table SET value = date('now', ?1, 'localtime') WHERE id = ?2 In my code I bind an integer to ?1. This results in null. I never intended to code it that way, it is an honest to goodness bug. I wanted to bind '+1 days' or

Re: [sqlite] Interrupting sqlite

2009-06-23 Thread Rich Rattanni
Would forking another process as a worker process be acceptable, then in your main message loop wait for some IPC signal saying it is done? Unless you are doing this on some extremely lightweight OS / monitor that doesn't implement the concept of time-sharing, I can't see how this would be hard to

Re: [sqlite] Simple example for dummy user writing C code

2009-04-02 Thread Rich Rattanni
pr 2, 2009 at 8:54 AM, Rich Rattanni <ratta...@gmail.com> wrote: > Igor, be careful your not solving someone's homework > > On Thu, Apr 2, 2009 at 7:39 AM, Igor Tandetnik <itandet...@mvps.org> wrote: >> "My Name"

Re: [sqlite] Simple example for dummy user writing C code

2009-04-02 Thread Rich Rattanni
Igor, be careful your not solving someone's homework On Thu, Apr 2, 2009 at 7:39 AM, Igor Tandetnik wrote: > "My Name" > wrote in message > news:ee8102080904012149h3b8d64d9u8b972b1e6fbbf...@mail.gmail.com >> I'm having hard time to store and

Re: [sqlite] How to size and position a scrollbar within a virtual listview

2009-02-25 Thread Rich Rattanni
I thought Puneet's reply was good. When you make statements like query the internal btree table to request at least the internal pagenr w... I think you are asking too much of sqlite, right? The purpose of a database engine is to abstract the gory details and make your life easier, just as

[sqlite] Google Chrome and SQLite3

2008-09-08 Thread Rich Rattanni
So after playing around in my application data directory for google chrome, I noticed file called something-journal. Of course, I knew what that was. So I began opening all kinds of SQLite databases in use by Chrome (had to close chrome due to locks on a few of them). Interesting the things

Re: [sqlite] validate SQL Statement

2008-07-05 Thread Rich Rattanni
>From the manual, doesnt sqlite3_prepare do the following: "To execute an SQL query, it must first be compiled into a byte-code program using one of these routines." If you are really paranoid, what about taking the input SQL statement x and then verifying it by issuing: sqlite3_prepare("EXPLAIN

Re: [sqlite] A question about the use of localtime

2008-06-19 Thread Rich Rattanni
Matthew: I simply called tzset() after I extract the timezone file. It worked like a charm. Thank you very much! I was having a heck of a time information online. On Thu, Jun 19, 2008 at 4:53 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote: > On Thu, Jun 19, 2008 at 4:35 PM, Matthew L. Creech

[sqlite] A question about the use of localtime

2008-06-19 Thread Rich Rattanni
All: I noticed the following when using sqlite to timestamp flags in an embedded system. I will lay out the tests performed and the results I got. First, an overview. I am working with a linux 2.6.26 kernel and sqlite v3.5.0. For the handling of timezones, I use the zoneinfo files.

Re: [sqlite] integrity_check: Beating the system

2008-06-16 Thread Rich Rattanni
> Couldn't you go ahead and do your quick check on startup and then do the > integrity check later when the database is otherwise unoccupied? I was thinking of doing a hybrid as you suggested. > If your database is smaller than system memory then there is also value > in just reading the entire

[sqlite] integrity_check: Beating the system

2008-06-16 Thread Rich Rattanni
All: I need to check a database for readability before my application starts. I was originally going to keep an MD5 on the database and check it each time at powerup. This seems to take a great deal of time so instead I thought abou having the database do an integrity check at powerup, however

Re: [sqlite] Implementing fast database rotation

2008-06-15 Thread Rich Rattanni
1 4 a 2 5 b 2 Just thinking out of my finger tips. On Sun, Jun 15, 2008 at 10:20 PM, Rich Rattanni <[EMAIL PROTECTED]> wrote: > I am working with SQLite in an embedded environment. With synchronous > = full, I can say large inserts are abysmal (of course I

Re: [sqlite] Implementing fast database rotation

2008-06-15 Thread Rich Rattanni
I am working with SQLite in an embedded environment. With synchronous = full, I can say large inserts are abysmal (of course I need the protection that full synchronous offers). Of course, as always what I call large may not be what you call large. Keep in mind that sqlite will make a journal

Re: [sqlite] design question / discussion

2008-05-21 Thread Rich Rattanni
Adolfo: I can't tell you how many times I felt a flat file approach would be better. However, 2 years ago when the design began there was a thought of 'Having the ability to mine data on the device would be an invaluable tool'. SQLite has proven superb for some aspects of the system, but not for

Re: [sqlite] design question / discussion

2008-05-21 Thread Rich Rattanni
> It seems unclear to me what your requirements are trying to attempt. > > Do you need to keep any of this data, if so for how long? I have to keep all data until a download. Downloads can fail too so I cannot delete data until a download succeeds. > Do you need to be able to read the older

Re: [sqlite] design question / discussion

2008-05-21 Thread Rich Rattanni
> Perhaps i've missed something or don't understand it well. Your > databases is all on the same file or do you have 2 separate sqlite > sessions to 2 different databases files? In the first scenario you > must be very fast and in the second you can switch from one database > to the other, unbind

Re: [sqlite] design question / discussion

2008-05-20 Thread Rich Rattanni
shared cache and read_uncommitted > isolation. It might be a bit tricky in that you'll probably have to get the > "committed" data in a txn, then set the uncomitted mode to read to avoid > waiting for locks. > > Ken > > Rich Rattanni <[EMAIL PROTECTED]> w

Re: [sqlite] design question / discussion

2008-05-18 Thread Rich Rattanni
Thanks for your reply. I have done some quick timing tests on my system; a vacuum can take 5 or more minutes (synchronous full), and a delete and recreate is rougly 3 seconds. I think I did such a test with a 30MB database. The database resides on a jffs2 file system (compression off), which

[sqlite] design question / discussion

2008-05-17 Thread Rich Rattanni
Hi I have a general design question. I have the following senario... In an embedded system running linux 2.6.2x I have a sqlite database constantly being updated with data acquired by the system. I cant lose data (hence why I am using sqlite in the first place). However periodically I have

[sqlite] Meaning of the following code

2008-03-17 Thread Rich Rattanni
a integrity check? -- Thanks in advance, Rich Rattanni ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Does or will Sqlite provide a DUMP mechanism?

2008-03-03 Thread Rich Rattanni
It should be easy to write your own dump feature. The table create statements are saved in sqlite_master, and likewise for the schema. Without looking at the code for sqlite3 (the command line utility) or tksqlite, I would bet that is how they implement their dump feature. On Mon, Mar 3, 2008

[sqlite] Use of SUM() causes Alignment Traps on ARM arch

2008-02-26 Thread Rich Rattanni
and recover), it does slow the execution of any SQL statements with SUM() considerably. Just I thought I would just throw it out there. -- Rich Rattanni ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

[sqlite] Reducing size of timestamps

2008-02-22 Thread Rich Rattanni
All: I was wondering if there was any way to reduce the 'cost' of storing a timestamp on entries in a SQLite database. I performed a hexdump of the file and it showed me the timestamp is stored as a 19-byte ASCII string. One quick thing I thought of was to store the unix timestamp in each

[sqlite] Storing / Archiving of SQLite database in vcs

2008-01-15 Thread Rich Rattanni
is deterministic such that for a given sequence of SQL input each time I wind up with the same database (of course, using sqlite3 to dump the sql may not guarantee me the same sequence of SQL as was used to create the database, huh?). Feedback? (please be nice) -- Rich Rattanni

[sqlite] Help with an unusual query

2007-10-24 Thread Rich Rattanni
' Version 4 Version 5' Basically I want a row returned for each unique key, but i want the data column for each key (string data) concatenated together (and seperated with spaces if possible :) ). Thanks, Rich Rattanni

Re: [sqlite] Compact statement for table to table copy

2007-10-17 Thread Rich Rattanni
gt; ordering. > > INSERT INTO table1 SELECT * FROM table2; > > Rich Rattanni wrote: > > I have two tables in a database with exactly the same schema > > (idNum PRIMARY KEY, data1, data2) > > > > I want to copy all the records in table 2 to table 1, currently I am > >

[sqlite] Compact statement for table to table copy

2007-10-16 Thread Rich Rattanni
I have two tables in a database with exactly the same schema (idNum PRIMARY KEY, data1, data2) I want to copy all the records in table 2 to table 1, currently I am using the following statement: INSERT INTO table1 (data1, data2) SELECT data1, data2 FROM table2. Now this is just a simplified

Re: [sqlite] SQLite, pthread and daemon

2007-10-03 Thread Rich Rattanni
Just read this today, after doing some other research. Does this help any? http://www.sqlite.org/faq.html#q6 It says, in a nutshell, don't use a database across forks. On 10/3/07, John Stanton <[EMAIL PROTECTED]> wrote: > How do you know that when your process forks that you are looking at the

[sqlite] malloc failure in sqlite3_prepare

2007-07-17 Thread Rich Rattanni
All: I am writing a program that reads large blob data (~15 MB) from a sqlite database, then writes the data out to the sound card. After this time, some results are calculated and inserted into the same database. In my code, I have 1 database handle from which I do a prepare to extract the

Re: [sqlite] Seg Fault when using sqlite3_bind_blob

2007-07-02 Thread Rich Rattanni
I wish I could run valgrind, but this project is running on an ARM chip and there is no port for the ARM last I checked. Thanks for checking my code. -- Rich Rattanni On 7/2/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Rich Rattanni" <[EMAIL PROTECTED]> wrote: >

Re: [sqlite] Seg Fault when using sqlite3_bind_blob

2007-07-02 Thread Rich Rattanni
copy of the blob data sqlite made during the call to sqlite3_bind_blob(). -- Rich Rattanni On 7/1/07, Rich Rattanni <[EMAIL PROTECTED]> wrote: I stand corrected, thank you Andrew. I seriuosly doubt it is a bug in SQlite, but I have had a hell of a time with sqlite and binding dynamically

Re: [sqlite] Seg Fault when using sqlite3_bind_blob

2007-07-01 Thread Rich Rattanni
I stand corrected, thank you Andrew. I seriuosly doubt it is a bug in SQlite, but I have had a hell of a time with sqlite and binding dynamically allocated text and binary data. On 7/1/07, Andrew Finkenstadt <[EMAIL PROTECTED]> wrote: On 7/1/07, Rich Rattanni <[EMAIL PROTECTED]>

Re: [sqlite] Seg Fault when using sqlite3_bind_blob

2007-07-01 Thread Rich Rattanni
On 7/1/07, Rich Rattanni <[EMAIL PROTECTED]> wrote: On 7/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > "Rich Rattanni" <[EMAIL PROTECTED]> wrote: > > All: > > I am using SQlite to store several rows of binary data into a > > databa

Re: [sqlite] Seg Fault when using sqlite3_bind_blob

2007-07-01 Thread Rich Rattanni
On 7/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Rich Rattanni" <[EMAIL PROTECTED]> wrote: > All: > I am using SQlite to store several rows of binary data into a > database. In my code I have a several character arrays containing > data. I th

[sqlite] Question about triggers

2007-06-27 Thread Rich Rattanni
her reasons for or against using triggers for automatic timestamping. -- Thanks, Rich Rattanni - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Rich Rattanni
Thank you Igor and Christian. I appreciate your help. On 6/18/07, Christian Smith <[EMAIL PROTECTED]> wrote: Rich Rattanni uttered: > The databases will be in flux, and I didnt necessairly want to suspend > the application that is performs reads and writes into the database. >

Re: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Rich Rattanni
wrote: It would most likely be much quicker (and simpler) just to utilize the OS's file coping feature to copy the table. What would be gained with the attaching databases approach over just a straight file copy? Fred > -Original Message- > From: Rich Rattanni [mailto:[EMAIL PROTE

[sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Rich Rattanni
close the cloned version and offload that to the server. The standard questions now follow... Is this an acceptable way? Is there a better/best way? Thanks for any input, Rich Rattanni - To unsubscribe, send email to [EMAIL

Re: [sqlite] Re: Re: One statement column to column copy

2007-04-19 Thread Rich Rattanni
What you tried made no sense. You can only use a table name in a statement if it's the "primary" table of the statement (for UPDATE and DELETE) or was explicitly introduced into the statement by FROM clause (for SELECT). You can't just throw in any odd table, because you can't then specify which

Re: [sqlite] Re: One statement column to column copy

2007-04-19 Thread Rich Rattanni
update Parameters set value = (select value from WorkingParameters wp where wp.id = Parameters.id); Hi Igor, That worked fine. I am curious why it does work? According to the sqlite syntax guide, it says that... "When a SELECT appears within an expression but is not the right operand

[sqlite] Re: One statement column to column copy

2007-04-19 Thread Rich Rattanni
On 4/19/07, Rich Rattanni <[EMAIL PROTECTED]> wrote: All: I have a main table (Parameters) which contains system parameters to which I clone the table to a temporary database... CREATE TEMPORARY TABLE WorkingParameters AS SELECT * from Parameters; I modify the parameters in the tem

[sqlite] One statement column to column copy

2007-04-19 Thread Rich Rattanni
misunderstanding something. sql-statement ::= UPDATE table-name SET assignment assignment ::= column-name = expr expr ::= database-name . table-name . column-name Could someone please help me with my query? Thanks, Rich Rattanni

[sqlite] sqlite database on a read only media

2007-04-19 Thread Rich Rattanni
All: Is it possible to have an sqlite database on a read only media? I will only be issuing SELECT queries on this database. Are there any pragma's you need to issue to let SQLITE know it is not acceptable to write to the database file. -- Rich Rattanni

Re: [sqlite] Default sqlite memory management policy

2007-04-05 Thread Rich Rattanni
On 4/5/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Rich Rattanni" <[EMAIL PROTECTED]> wrote: > > I am just wondering should I take matters into my own hands, > and compile and make use of sqlite3_soft_heap_limit(), or can I trust > SQLITE to ma

Re: [sqlite] Default sqlite memory management policy

2007-04-05 Thread Rich Rattanni
On 4/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Rich Rattanni" <[EMAIL PROTECTED]> wrote: > On 4/3/07, Rich Rattanni <[EMAIL PROTECTED]> wrote: > > All: > >I was wondering exactly how SQLite handles freeing memory u

[sqlite] Re: Default sqlite memory management policy

2007-04-04 Thread Rich Rattanni
On 4/3/07, Rich Rattanni <[EMAIL PROTECTED]> wrote: All: I was wondering exactly how SQLite handles freeing memory used from the heap when compiled without SQLITE_ENABLE_MEMORY_MANAGEMENT? Will absolutely no memory be freed, or is there some default memory management scheme used?

[sqlite] Default sqlite memory management policy

2007-04-03 Thread Rich Rattanni
All: I was wondering exactly how SQLite handles freeing memory used from the heap when compiled without SQLITE_ENABLE_MEMORY_MANAGEMENT? Will absolutely no memory be freed, or is there some default memory management scheme used?

Re: [sqlite] using SQLite with flash file systems

2007-03-25 Thread Rich Rattanni
On 3/25/07, John Fisher <[EMAIL PROTECTED]> wrote: I note from the home page that "Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures". Is this still the case if the database is stored on a flash file system, say JFFS2 with the linux

Re: [sqlite] sqlite segfault using libc library

2007-03-24 Thread Rich Rattanni
On 3/24/07, John Stanton <[EMAIL PROTECTED]> wrote: Andrew Finkenstadt wrote: > On 3/24/07, John Stanton <[EMAIL PROTECTED]> wrote: > >> >> Compilers do not terminate strings, library functions do. > > > > You are guaranteed by the C standard that the string referred to by > >>> const char

Re: [sqlite] sqlite segfault using libc library

2007-03-24 Thread Rich Rattanni
Just because you have a pointer assigned to the string does not ensure that it is terminated. It only finds the start of the string. You need a null character at the end. I understand that John, but these strings I am writing to the database are declared as follows... const char message[] =

Re: [sqlite] sqlite segfault using libc library

2007-03-24 Thread Rich Rattanni
Maybe using an invalid UTF-8 string as input to SQLite? Maybe your wrapper uses strlen to find the end of the string and that is different from the SQL string length function of SQLite, which may be diferent on UTF-8 strings? My wrapper class never uses strlen(). Instead I bind the string to

Re: [sqlite] sqlite segfault using libc library

2007-03-24 Thread Rich Rattanni
I agree, but all my strings are const char *, and I do not modify them during program execution. On 3/24/07, John Stanton <[EMAIL PROTECTED]> wrote: It looks like you might have an unterminated string. Rich Rattanni wrote: > All: >I am writing an application that heavily logs

[sqlite] sqlite segfault using libc library

2007-03-24 Thread Rich Rattanni
All: I am writing an application that heavily logs all activity to a sqlite3 database. Last night, while running some extended testing, I caught a segmentation fault. The core dump isnt of much help... (gdb) bt #0 0x403d2934 in strlen () from /lib/libc.so.6 #1 0x401add60 in ?? () from

Re: [sqlite] Re: Re: Re: Question about multithreading

2007-03-22 Thread Rich Rattanni
On 3/22/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Voxen <[EMAIL PROTECTED]> wrote: >> There's no "like" - you do use connection pointer directly from >> thread B. The fact that the piece of code thread B currently >> executes is a method of an object that happened to be created by >> thread

Re: [sqlite] Re: Question about multithreading

2007-03-22 Thread Rich Rattanni
On 3/22/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Gil Delavous <[EMAIL PROTECTED]> wrote: > However, what happens when a thread calls a method from the main > thread, this one using its own sqlite connection? The question doesn't make any sense to me, sorry. Methods don't belong to threads.

Re: [sqlite] Re: multithread problem

2007-03-20 Thread Rich Rattanni
On 3/20/07, Jakub Ladman <[EMAIL PROTECTED]> wrote: Dne úterý 20 březen 2007 12:42 Igor Tandetnik napsal(a): > Rafi Cohen <[EMAIL PROTECTED]> wrote: > > 1. Should I open the database explicitly in the amin part and also in > > the thread? > > In my experience, SQLite works best when every thread

Re: [sqlite] Avoiding use of temporary files

2007-03-19 Thread Rich Rattanni
On 3/19/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Siebe Warners <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm using sqlite on an embedded system with flash EEPROM as the medium. > Performance of the flash is not too good, so i'm trying to avoid file > system access where possible without

[sqlite] Segmentation fault using sqlite

2007-03-12 Thread Rich Rattanni
I am wondering why my program crashes with a segmentation fault. This has only occured once, but it seems to be something with sqlite. Is this a known issue or is there anything I can do to further track this down? Program terminated with signal 11, Segmentation fault. #0 0x403cdcb4 in

[sqlite] Difference between DATETIME datatype and TIMESTAMP

2007-03-02 Thread Rich Rattanni
I was wondering what the differences were (storage, efficiency, usefulness) between the DATETIME field and TIMESTAMP field in sqlite?

Re: [sqlite] SQLite on ARM9 running Linux

2007-03-02 Thread Rich Rattanni
My co-worker did a lot of work on OpenEmbedded, I know he just pushed the latest patch for the latest SQLite snapshot into OE. If you hardware is supported by OE I would suggest you take a look. I am writing an application to run on this platform and everything is working wonderfully. On

Re: [sqlite] use of sqlite in a multithread C application

2007-03-02 Thread Rich Rattanni
Rafi, Do not forget that if you do prepare and perform an execute in different threads, that you should not attempt to execute multiple statements compiled against the same sqlite3 database pointer concurrently. Trust me, I made this mistake. If you are preparing multiple statements, make