[sqlite] sqlite performance issues on Linux running on MIPS (BIG ENDIAN)

Hi, I am planning to use sqlite in an application program. The application will be running in Linux environment on MIPS processor (BIG ENDIAN). Are there any sqlite performance issues when running on MIPS processor with Linux as the OS. In particular are there any issues regarding non-aligned m

Re: [sqlite] Locking in sqlite

So if A, B and C are different files then they will not block despite leaving inside the same connection, right? BTW, by "block" I mean retrying after SQLITE_BUSY too. That's very good and convenient thing. Thank you, Pavel On Sat, May 2, 2009 at 10:05 PM, Nuno Lucas wrote: > On Sat, May 2, 2009

Re: [sqlite] Locking in sqlite

On Sat, May 2, 2009 at 3:48 PM, Pavel Ivanov wrote: [...] > update main.t set x = 1 > update B.t set x = 1 > update C.t set x = 1 > > My question is will these statements be able to execute in connections > in parallel simultaneously because they use different databases and > should lock only thos

[sqlite] Locking in sqlite

Hi, all! I wasn't able to find clear answer to my question about locking in sqlite in documentation, so please help me who knows things well. Let's say we have 3 different connections, all created with the same pattern: connect to database A, attach database B, attach database C. Then in these 3 c

Re: [sqlite] Names of Indexes (CREATE INDEX)

wrote in message news:49fbde2e.1050...@gmail.com > It was frustrating and confusing becuase I have not encountered this > index-name feature in any other DB I've worked with What feature? You are not saying that no other DB you worked with allowed you to create indexes, are you? What precisely,

Re: [sqlite] SQL sintaxe

On 2/05/2009 9:13 PM, Ernany wrote: > Hello John, > > I have 2 tables ("pcprod" and "pcdesc"). I´d like to *add *in my application > "MARCA" and "DESCR". > > This code is VB2005 .NET. How do I write SQL??? You already have columns named "descr" and "marca" in the "pcprod" table. You need to add

Re: [sqlite] SQL sintaxe

On Sat, May 2, 2009 at 6:13 AM, Ernany wrote: > Hello John, > > I have 2 tables ("pcprod" and "pcdesc"). I´d like to *add *in my application > "MARCA" and "DESCR". > > This code is VB2005 .NET. How do I write SQL??? http://www.google.com/search?q=sql+tutorial > > Thanks a lot > > Ernany > > > '

Re: [sqlite] SQL sintaxe

Hello John, I have 2 tables ("pcprod" and "pcdesc"). I´d like to *add *in my application "MARCA" and "DESCR". This code is VB2005 .NET. How do I write SQL??? Thanks a lot Ernany '*** Dim dr As Data.SQLite.SQLiteDataReader Dim Bd

[sqlite] Sqlite on Arm EP9302 processor

I am looking at using Sqlite on my TS-7250 board. (Debian 2.4) I currently cross-compile target software on a Win PC using Cygwin & gcc-3.3.4-glibc-2.3.2 xross Toolchain. Has anyone any comments on suitability or Installation ? thanks -Alan ___ sqlit

Re: [sqlite] SQL sintaxe

On 2/05/2009 4:21 PM, Ernany wrote: > Hello, > > CREATE TABLE [pcprod] ( > [codigo] NVARCHAR(20) NOT NULL ON CONFLICT ABORT PRIMARY KEY, > [descr] NVARCHAR(40), > [marca] NVARCHAR(20), > [codigoint] NVARCHAR(20), > [preco] NUMERIC(5, 7), > [preco2] NUMERIC(5, 7)); > > > > CREATE TAB

Re: [sqlite] Names of Indexes (CREATE INDEX)

Thank you. Alexander A. Gnatyna wrote: > you can name indexes as you wish. if you use select - you should specify > coluns names. engine well decide what index to use depend on CREATE INDEX > statement and you SQL query. > > On Saturday 02 May 2009 02:45:03 a a wrote: >> Do index names need t

Re: [sqlite] Names of Indexes (CREATE INDEX)

Thanks Igor!!! It was frustrating and confusing becuase I have not encountered this index-name feature in any other DB I've worked with, and its undocumented on sqlite.org. it doesnt give any restrictions or recommendations for index names, it doesnt even say when you must use them or not use