Re: [sqlite] make sqlite3 ends with error "make: Fatal error: Command failed for target `libsqlite3.la'"

Hi, > The make ends with the message: > *** Error code 1 > make: Fatal error: Command failed for target `libsqlite3.la' This is not a significant error message. The important messages are before this one. > Has anybody an idea, what the problem can be and how I can solve it? It's hard to tell

[sqlite] PRAGMA journal_mode

I have a question about the new PRAGMA journal_mode: Since PERSIST is likely to be faster than DELETE on most platforms, is there ever a reason *not* to use it? Put differently, is there any advantage to DELETE over PERSIST? - Richard Klein ___

[sqlite] Indexing virtual tables

Just thinking again about indexing strategies on virtual tables, I'm wondering why virtual tables could not be indexed using the "normal" SQLite command "INDEX". Indeed, I just expected that the data inside the column of the virtual table could be sequentially scanned (using the "xColumn"

Re: [sqlite] Concerns regarding sqlite on jffs2

On Mon, May 5, 2008 at 4:05 AM, Dan <[EMAIL PROTECTED]> wrote: > On May 5, 2008, at 1:59 PM, John Passaniti wrote: > > I am trying to decide if sqlite is appropriate for my system. > > [...] > > Use transactions if you did not already plan to. Yes, thanks. In the simplest case, I would be

Re: [sqlite] concatenation operator

You must use || (doble pipe) to concatenate strings or what ever. Note that || don't concatenate nulls 'CHE' || null is null sorry about my poor english Joanne Pham escribió: > Hi All, > I had the table, appMapTable as defined below: > appId, appName, appType > 1, appname, 2 > 2, appname, 3 >

[sqlite] concatenation operator

Hi All, I had the table, appMapTable as defined below: appId, appName, appType 1, appname, 2 2, appname, 3 appName always has string as appname and now I want to concatenate the appName with appId so the result will be: 1,appname1,2 2, appname2,3 . I ran the following sql statement :

Re: [sqlite] Virtual tables declaration statements

Hi Fred, I agree with you but I think that a specific rule could be added in the parser in order to deal with an identifier containing dots only when it is used after a "using" in a "create virtual table" statement... Am I wrong? Anyway, this is not a very big issue :-) Aladdin > Date: Mon,

Re: [sqlite] import files with more than 2GB?

On May 5, 2008, at 11:37 AM, Michael Lackhoff wrote: > Hello, > > thanks to the flexibility of sqlite I can use a sybase database dump > as > a source for import into my database. Only problem: the file to import > is over 2GB and I get a "file not found" error. The file is there, it > can be

[sqlite] import files with more than 2GB?

Hello, thanks to the flexibility of sqlite I can use a sybase database dump as a source for import into my database. Only problem: the file to import is over 2GB and I get a "file not found" error. The file is there, it can be read by split and imported after the split and the resultung

Re: [sqlite] database always locked

[EMAIL PROTECTED] wrote: > I use a c++ program to > open a connection to my database with no issues, but when trying to > exec any sql statements after that, i get SQLITE_BUSY (i.e. database > is locked). > > Even if I change the sql statement, I always get SQLITE_BUSY. This is >

Re: [sqlite] Virtual tables declaration statements

Don't think that will happen. "Dot" notation is used as in "databasename.tablename" and is therefore a restricted use notation. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Aladdin Lampe Sent: Monday, May 05, 2008 8:57 AM To:

[sqlite] Virtual tables declaration statements

Hi list! I've just finished a set of sqlite3 virtual tables and I would like to name them with a "dot notation", ie "data.source1", "data.source2" created like that: sqlite3_create_module(db, "data.source1", , 0); sqlite3_create_module(db, "data.source2", , 0); ... and then use the following

[sqlite] ANN: SQLite Data Wizard 8.4 released

Hi! SQL Maestro Group announces the release of SQLite Data Wizard 8.4, a powerful Windows GUI solution for SQLite data management. http://www.sqlmaestro.com/products/sqlite/datawizard/ SQLite Data Wizard provides you with a number of easy-to-use wizards to generate PHP and ASP.NET scripts for

[sqlite] make sqlite3 ends with error "make: Fatal error: Command failed for target `libsqlite3.la'"

I try to install sqlite3 on my sun solaris 2.10 machine. I use the amalgamation (3.5.8), run configure and then call make. The make ends with the message: *** Error code 1 make: Fatal error: Command failed for target `libsqlite3.la' Has anybody an idea, what the problem can be and how I can

Re: [sqlite] Concerns regarding sqlite on jffs2

On May 5, 2008, at 1:59 PM, John Passaniti wrote: > I am trying to decide if sqlite is appropriate for my system. > > The target is an embedded system. It's an ARM9 processor running > under Linux 2.6. The system's primary storage is NAND flash, using > jffs2. The system is essentially a

Re: [sqlite] Concerns regarding sqlite on jffs2

Hi, Without knowing the details of sqlite implementation on indexing, I would imagine if you do some benchmarking runs, and collect systrace like log, and see if # of writes and reads are exceeding you requirement. Regards, - Kun On Sun, May 4, 2008 at 11:59 PM, John Passaniti <[EMAIL

[sqlite] Concerns regarding sqlite on jffs2

I am trying to decide if sqlite is appropriate for my system. The target is an embedded system. It's an ARM9 processor running under Linux 2.6. The system's primary storage is NAND flash, using jffs2. The system is essentially a datalogger, where at regular intervals (typically once per