[sqlite] Sqlite write ( HELP )

Hi all When I use INSERT INTO stmt how fast sqlite writes it in to the database. Is it depends up on the OS. Will the record be written to the database on returning from the exec of INSERT stmt? I am inserting some records in to DB using some threads and in a perticular condition the threads will

Re: [sqlite] manual with sample C programs

there are many errors in the codes. but still worthwhile to go through them carefully. liubin liu wrote: > > This's very good! > > I just download the codes from here: > http://www.apress.com/book/downloadfile/2847 > > > dcharno wrote: >> >>> Could you tell me where can I find such docume

Re: [sqlite] Is this possible?

On Sun, Mar 1, 2009 at 4:43 PM, Mike Yenco wrote: > > On Mar 1, 2009, at 5:18 PM, P Kishor wrote: > >> It is going to get even more complicated and soon approach Igor-level >> of complexity. So, for sanity's sake, it would probably be done better >> in your application. > > Thanks for the explanat

Re: [sqlite] Vacuum corruption

On Mar 1, 2009, at 4:03 PM, Dair Grant wrote: > > Hi, > > Are there any circumstances in which a vacuum could corrupt a > database? > VACUUM should never corrupt a database under any circumstances. If you have a reproducible corruption scenario, please contact me or one of the other SQLite

Re: [sqlite] Is this possible?

On Mar 1, 2009, at 5:18 PM, P Kishor wrote: > It is going to get even more complicated and soon approach Igor-level > of complexity. So, for sanity's sake, it would probably be done better > in your application. Thanks for the explanation. Yeah, as I said in one of my previous emails, my first

Re: [sqlite] Is this possible?

On Sun, Mar 1, 2009 at 4:04 PM, Mike Yenco wrote: > > On Mar 1, 2009, at 2:15 PM, Martin Engelschalk wrote: > >> Hi Mike, >> >> Yes, this is possible, however, it is complicated. > > Hi Martin, > > Thanks for the reply.  It usually is complicated :-) > > >> select Name, case OrderValue when 0 then

Re: [sqlite] Is this possible?

On Mar 1, 2009, at 2:15 PM, Martin Engelschalk wrote: > Hi Mike, > > Yes, this is possible, however, it is complicated. Hi Martin, Thanks for the reply. It usually is complicated :-) > select Name, case OrderValue when 0 then NULL else ContainerId end as > ContainerId > from > ( > select dis

[sqlite] Sqlite database syncronization gui tool?

Does anybody know of a sync tool for sqlite like what red gate offers for SQL Server? specific, the schema compare and db data compare capabilities? Thanks, -A- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailm

[sqlite] Vacuum corruption

Hi, Are there any circumstances in which a vacuum could corrupt a database? I am storing about 30 images in an SQLite database, where each row contains a couple of integers and a BLOB of data (average size 80Kb). There are a some indices on the integer columns, and the final database is aro

Re: [sqlite] Is this possible?

Hi Mike, Yes, this is possible, however, it is complicated. Lets first create the tables an populate them: create table Container (ContainerName text, ContainerId text primary key) create table Contents (ContentName text, ContainerId text) insert into Container values ('Fruit', 'ABC-0001'); ins

Re: [sqlite] Is this possible?

OK, let's see if I can clarify this. I'm using "blank", "Group", and "Code" as placeholders here. Blank is a column that contains nothing (An empty placeholder I need for display purposes). Group could be any text. Code is some ID text. Table B is being written to by some third-party code

Re: [sqlite] Is this possible?

On Sun, Mar 1, 2009 at 11:14 AM, Mike Yenco wrote: > Ok, I guess this list doesn't support image attachments.  Let's see if > I can sort of illustrate what I'm looking to do in text without > requiring 1000 words. > > Table A > blank | Group 1 | Code 1 > blank | Group 2 | Code 2 > blank | Group 3

Re: [sqlite] Is this possible?

Hi Mike, sorry, i don't fully get it. However, a single SQL statement can not return data rows of different structure as you indicated in your example. Especially, I am confused about "blank". It seems to come from Table A, same as "Group *". Do you want to put "Group *" as a sort of headline,

Re: [sqlite] Is this possible?

Ok, I guess this list doesn't support image attachments. Let's see if I can sort of illustrate what I'm looking to do in text without requiring 1000 words. Table A blank | Group 1 | Code 1 blank | Group 2 | Code 2 blank | Group 3 | Code 3 Table B Item 1 | Code 1 Item 2 | Code 1 Item 3 | Code

Re: [sqlite] Is this possible?

Hi Mike, you can't use attachments in this mailing list. Best post your data model, some data and the desired result. Martin Mike Yenco wrote: > Is there a way that SQLite can return all matching items to a search > string in Table B, but return a group name from Table A before each > set of m

[sqlite] Is this possible?

Is there a way that SQLite can return all matching items to a search string in Table B, but return a group name from Table A before each set of matching items within the result? (see attached image). ___ sqlite-users mailing list sqlite-users@sqli

Re: [sqlite] DateTime Objects

On Sat, 28 Feb 2009 17:30:24 -0800 (PST), jonwood wrote: >Thanks, but I'm not sure what this means. "SQLite date storage format and >support" doesn't appear to be a specific term (at least, it didn't turn up >anything specific on Google). I'm almost sure John Stanton had this in mind: The numb