[sqlite] sqlite:Deletion in Joins method

Hi, I have created database using the joins method. My database caontains 4 tables with the Artist(1),Album(2),Genre(or) BGM(3),Combination of all these and Track names in one table. I am having 4 tables as follows. * "create table ALBUM(AlbumId integer primary key,Album

Re: [sqlite] quickstart

On Nov 29, 2007 12:03 PM, Wilson, Ron <[EMAIL PROTECTED]> wrote: > > http://www.sqlite.org/quickstart.html > > This page still shows the old callback method for usign sqlite3_exec(). > I actually haven't used SQlite in quite a long time, but judging from > recent list topics, this is no longer

[sqlite] Re[4]: rollback fails incomprehencibly

But I use v2 interface. In particular I called sqlite3_prepare_v2, not sqlite3_prepare(). So, something is still wrong? (remind that I use sqlite 3.5.1 (windows)) >> Ok, I tried to do reset for my statement >> and ... got SQLITE_BUSY too! >> I.e. sqlite_reset() (and sqlite_finalize() too)

Re: [sqlite] Segmentation fault in syncJournal (pPager=0x102028) at src/pager.c:2417

Sorry, I use SQLite 3.4.2, NOT SQLite 3.5.2. The code in pager.c:2417 (SQLite 3.4.2) is for(pPg=pPager->pAll; pPg; pPg=pPg->pNextAll){ pPg->needSync = 0;// <= line 2417 } Is there something wrong to pPg ? why ?? And in general, pPager=0x102028 when segmentation fault was occured.

Re: [sqlite] version 3.3.12 -- malformed schema after using "limit 0" ??

"Griggs, Donald" <[EMAIL PROTECTED]> wrote: > I don't know if the following might be a problem with the new release, > or just something odd on my system. > > > In sqlite 3.3.12, I try to create an empty table copying the schema of > an existing table by using a command such as the following: >

RE: [sqlite] version 3.3.12 -- malformed schema after using "limit 0" ??

[EMAIL PROTECTED] wrote: > > I don't know if the following might be a problem with the new release, > or just something odd on my system. > > > In sqlite 3.3.12, I try to create an empty table copying the schema of > an existing table by using a command such as the following: > CREATE

[sqlite] version 3.3.12 -- malformed schema after using "limit 0" ??

I don't know if the following might be a problem with the new release, or just something odd on my system. In sqlite 3.3.12, I try to create an empty table copying the schema of an existing table by using a command such as the following: CREATE TABLE newtable AS SELECT * FROM oldtable LIMIT

Re: [sqlite] What is the preferred way to create SQLite databases?

At the command line prompt: sqlite3 name_of_database_to_be_created SQLite version 3.5.2 Enter ".help" for instructions sqlite>.read database_definition_text_file_name sqlite>.quit On Thu, 2007-11-29 at 15:43 -0600, Mark Brown wrote: > Hi- > > What is the preferred way to create SQLite

Re: [sqlite] commit and rollback

You can use the SQLITE_BUSY returned by sqlite3_step to synchronize. Just pause and resubmit the call when you get it. arbalest06 wrote: about this synchronization of multiple writers, can you please explain on how to make this possible? or your just saying that i need to make a daemon that

[sqlite] What is the preferred way to create SQLite databases?

Hi- What is the preferred way to create SQLite databases? Ideally, I would like to have the entire schema in a file, and then generate the DB from that, as we make changes to the schema often. We're currently using something called SQLite Database Browser, but I am becoming concerned that the

Re: [sqlite] SQLite3 Issue

David Gelt <[EMAIL PROTECTED]> wrote: > > db_reset_stmt(dbo, stmt); > * SEGMENTATION FAULT AT THE > NEXT LINE * > return_code = db_fetch_first(dbo, stmt); /* initial call to retrieve

Re: [sqlite] Lemon: Conflicts with repeated TERMINALS

Joe Wilson <[EMAIL PROTECTED]> wrote: >The following grammar may be clearer to you: Yes, it is many thanks! I believe I am making progress! At least I can see the picture much clearer now and was able to come up with the following grammar with just one conflict unsolved: %left NEWLINE.

Re: [sqlite] quickstart

Here is a small code sample. Open the database and then: Result = sqlite3_prepare_v2(hdb, "select Name, FilePrefix from Application", 100, , 0); if (Result != SQLITE_OK) { fprintf(stderr, "cannot select from Application table. Error Code: %d\n", Result); exit(1); }

[sqlite] SQLite3 Issue

Hi there, I have started using recently SQLite which is pretty great for what I need, (i.e. a scientific application). After going through PostgreSQL, CDB, Tiny CDB and Berkeley DB it feels like coming home when I am looking at the size, speed, number of features and license. :)

Re: [sqlite] Performance tuning using PRAGMA, other methods

Hi Scott, Thanks for the information related to Performance tunning using PRAGMA. My embeded app needs to be tunning too. I have serveral questions for you. Current I had these PRAGMAS in my app: sqlSt = sqlite3_exec(pDb, "PRAGMA page_size=32768", NULL, 0, ); sqlSt = sqlite3_exec(pDb, "PRAGMA

[sqlite] quickstart

So a friend of mine was asking me how to get started using SQlite, so I pointed him here: http://www.sqlite.org/quickstart.html This page still shows the old callback method for usign sqlite3_exec(). I actually haven't used SQlite in quite a long time, but judging from recent list topics, this

RE: [sqlite] Performance tuning using PRAGMA, other methods

BTW, several PRAGMAS actually increase performance in my embedded app case - maybe 15-30% depending upon transaction activity and the way I structure transaction commits. Specific PRAGMAS that helped include: // // Synchronous OFF (0) // rc = sqlite3_exec(*dbHandle, "PRAGMA

RE: [sqlite] Re: Different between BEGIN, END and "begin transaction", "

Actually the first looks like Pascal and the second COBOL (Well, it should be all upper case)... > -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 29, 2007 12:47 PM > To: SQLite > Subject: [sqlite] Re: Different between BEGIN, END and "begin

[sqlite] Re: Re: Different between BEGIN, END and "begin transaction", "

Joanne Pham wrote: Sorry. I meant to say What is the different between BEGIN insert . END and begin transaction insert ... commit transaction commit transaction NOT end transaction Still no difference. COMMIT and END are synonyms. Igor Tandetnik

Re: [sqlite] Re: Different between BEGIN, END and "begin transaction", "

Thanks Igor Sorry. I meant to say What is the different between BEGIN insert . END and begin transaction insert ... commit transaction commit transaction NOT end transaction Thanks JP - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To:

[sqlite] Re: Different between BEGIN, END and "begin transaction", "

Joanne Pham wrote: What is the different between BEGIN insert . END and begin transaction insert ... end transaction None whatsoever. Igor Tandetnik - To unsubscribe, send

[sqlite] Different between BEGIN, END and "begin transaction", "

Hi All, What is the different between BEGIN insert . END and begin transaction insert ... end transaction Are they the same? Thanks, JP Be a better pen

Re: [sqlite] ftruncate() for values greater than file size

Joe Wilson <[EMAIL PROTECTED]> wrote: > > On Nov 29, 2007, at 9:19 PM, Mark Brown wrote: > > > I have finally tracked down a bug that has plagued by vxWorks > > > port. It > > > appears that our file system's implementation of ftruncate() does > > > not like > > > to "truncate" a file larger

Re: [sqlite] Doubtful code in os_unix.c

"Alexandre Balaban" <[EMAIL PROTECTED]> wrote: > Hello, > > did someone recently tested the unix code with the locking > style enabled ? No. Locking styles are not recommended right now. Watch for updates to that code in a future release. -- D. Richard Hipp <[EMAIL PROTECTED]>

RE: [sqlite] RE: Doubtful code in os_unix.c

My fix is to REMOVE the lines of code I mentioned. The malloc is done outside of this method already. Thanks, Mark > -Original Message- > From: Alexandre Balaban [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 29, 2007 11:13 AM > To: sqlite-users@sqlite.org > Subject: [sqlite]

Re: [sqlite] FTS Usage

Also http://code.google.com/apis/gears/api_database.html#sqlite_fts might add some information. I have an item on my todo list which goes something like "Refactor the FTS docs on the wiki". Unfortunately, it's been on my todo list for a couple months, now, with little progress. -scott On Nov

[sqlite] RE: Doubtful code in os_unix.c

Hi Simon, yes but here this is not a memory leak issue i was talking about, but rather a crash : if( pNew==0 ){ [...] releaseLockInfo(pNew->pLock); ^- Here releaseOpenCnt(pNew->pOpen); ^- and here But okay, locking style aren't working

[sqlite] 'nuther gui for SQLite

another gui for SQLite, among many other databases. Uses their own jdbc driver to connect. -- Puneet Kishor - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Doubtful code in os_unix.c

See http://www.nabble.com/SQLite-3.5.2---Unix---Memory-issue--tf4851124.html Rgds, Simon On 29/11/2007, Alexandre Balaban <[EMAIL PROTECTED]> wrote: > Hello, > > did someone recently tested the unix code with the locking > style enabled ? > I ask because I saw dubious code in this file,

[sqlite] Doubtful code in os_unix.c

Hello, did someone recently tested the unix code with the locking style enabled ? I ask because I saw dubious code in this file, specifically : if( pNew==0 ){ close(h); enterMutex(); releaseLockInfo(pNew->pLock); releaseOpenCnt(pNew->pOpen); leaveMutex(); return

RE: [sqlite] Sqlite3Explorer Version 3.0 is available

will do asap > -Original Message- > From: Miha Vrhovnik [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 29, 2007 5:15 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Sqlite3Explorer Version 3.0 is available > > Hi Mike, > > Thanks for updated version, but still no drag n

Re: [sqlite] Sqlite3Explorer Version 3.0 is available

Hi Mike, Thanks for updated version, but still no drag n drop support for opening database files :( Regards, Miha "Cariotoglou Mike" <[EMAIL PROTECTED]> wrote on 29.11.2007 9:09:59: >New version with a lot of enhancements to the user interface, also >updated to be compatible with >the

Re: [sqlite] ftruncate() for values greater than file size

On Nov 29, 2007, at 9:19 PM, Mark Brown wrote: Hi- I have finally tracked down a bug that has plagued by vxWorks port. It appears that our file system's implementation of ftruncate() does not like to "truncate" a file larger than its current size, and returns EINVAL for this

Re: [sqlite] Segmentation fault in syncJournal (pPager=0x102028) at src/pager.c:2417

"Joseph Hsu" <[EMAIL PROTECTED]> wrote: > Hello, > I use SQLite 3.5.2 on ARM9 embedded system. ( Linux 2.4 ) > My program sometimes meets segmentation fault ! ( randomly, maybe several > hours, maybe several days ! ) > Here is a clip from GDB: > -- snip -- > (gdb) backtrace > #0 syncJournal

[sqlite] ftruncate() for values greater than file size

Hi- I have finally tracked down a bug that has plagued by vxWorks port. It appears that our file system's implementation of ftruncate() does not like to "truncate" a file larger than its current size, and returns EINVAL for this operation. My question...assuming that I can't get ftruncate to

Re: [sqlite] Lemon: Conflicts with repeated TERMINALS

--- Ralf Junker <[EMAIL PROTECTED]> wrote: > > paragraph ::= PARA text. > > I observed the new PARA terminal token (the clear separator!?). Unfortunately > the lexer does not > generate such a token. Paragraph repeats are also removed. It was just an HTML-like example. I just wanted to

Re: [sqlite] FTS Usage

On 11/29/07, Jiri Hajek <[EMAIL PROTECTED]> wrote: > Hello, > > I'm considering usage of FTS, but from the documentation it's a little > unclear to me what's the recommended way of using it, particularly in > the following scenario: > > Let's say that I already have some database structure

[sqlite] Re: Re[2]: rollback fails incomprehencibly

??? <[EMAIL PROTECTED]> wrote: Ok, I tried to do reset for my statement and ... got SQLITE_BUSY too! I.e. sqlite_reset() (and sqlite_finalize() too) returns SQLITE_BUSY, althought statement seems to become reset and rollback complete at last. When sqlite3_step fails, it always

[sqlite] FTS Usage

Hello, I'm considering usage of FTS, but from the documentation it's a little unclear to me what's the recommended way of using it, particularly in the following scenario: Let's say that I already have some database structure containing several tables with mixes type of data (some string fields

Re: [sqlite] Undefined collation: Peculiar observations ...

Hello Trevor Talbot, >> Trevor, I am not sure what you mean by "subselect on its own". Is this what >> you are looking for? > >> sqlite> SELECT * FROM (SELECT * FROM a); >> SQL error: no such collation sequence: unknown > >Yes, exactly. I was curious to see if it made any kind of difference.

[sqlite] Re[2]: rollback fails incomprehencibly

Ok, I tried to do reset for my statement and ... got SQLITE_BUSY too! I.e. sqlite_reset() (and sqlite_finalize() too) returns SQLITE_BUSY, althought statement seems to become reset and rollback complete at last. Now I have a question: is it normal in my case that sqlite_reset() returns an error,

Re: [sqlite] Lemon: Conflicts with repeated TERMINALS

Many thanks, Joe, >Your grammar is ambiguous. The text tokens run together for >various rules because the grammar lacks clear separators between >them. OK, I begin to understand. The "clear separators" need to be TERMINALs, right? I believed that these were imlicit because there are TEXT and

[sqlite] Sqlite3Explorer Version 3.0 is available

New version with a lot of enhancements to the user interface, also updated to be compatible with the latest sqlite dll. information, change list and download here : http://www.singular.gr/sqlite (New features are described in the link near the top). Documentation, such as it is, is out of

Re: [sqlite] Undefined collation: Peculiar observations ...

On 11/28/07, Ralf Junker <[EMAIL PROTECTED]> wrote: > >> Imagine that a SQLite3 database opened in a custom application with a > >> registered a collation sequence named "unknown" has created the following > >> table: > >> > >> CREATE TABLE a (b COLLATE unknown); > Trevor, I am not sure what