RE: [sqlite] Database locked. Any idea ?

2006-06-20 Thread Lodewijk Duymaer van Twist
Hi, I don't know if I can help you with your problem, but I'm interested in what you are trying to do, are u using uCos on a Z-World based system? Kind regards, Lodewijk Duymaer van Twist

Re: [sqlite] Database locked. Any idea ?

2006-06-20 Thread Mario . Hebert
Yes I am using a :memory: database created from 3 flash database that were previously attached to it. I am not quite sure of the amount of work that would be required for me to port it to linux. I will try later today to build it under cygwin and see if the same behavior occurs. Regards,

Re: [sqlite] Database locked. Any idea ?

2006-06-20 Thread drh
[EMAIL PROTECTED] wrote: > > Anyone has an idea of what may be wrong ? Oh yeah, I am running of my own > port using uCos and a memory database. > You say you are using a ":memory:" database and this is happening? Can you provide a test program running under Linux? -- D. Richard Hipp

Re: [sqlite] Functions embedded in SQL statements

2006-06-20 Thread drh
Eric Bohlman <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions > > http://www.sqlite.org/lang_expr.html#corefunctions > > > > I will admit that the SQLite website is not particularly > > well indexed for human browsing. But you

Re: [sqlite] SQLiteSpy 1.5.4 released

2006-06-20 Thread C.Peachment
On Tue, 20 Jun 2006 15:34:21 +0200, Ralf Junker wrote: >SQLiteSpy 1.5.4 is released. Changes include: >* Updated to SQLite3 3.3.6. >* The schema tree view did not automatically reflect if a table was emptied or >initial records were being added. >* The default text encoding for newly

Re: [sqlite] Index usage

2006-06-20 Thread Paul Smith
At 14:25 20/06/2006, Mikey C wrote: Hi, I just wanted to ask for confirmation that my understanding on how the query optimiser works is correct. SQLite only uses one index for each table in a FROM? Yes What if tables are joined? Does an index get used for each joined table? No, just

Re: [sqlite] SQLite performance for 10 Million Records

2006-06-20 Thread Dennis Cote
Manzoor Ilahi Tamimy wrote: Here Is The Schema For these Tables. CREATE TABLE HVH ( Field1 VARCHAR(8), IDC VARCHAR(4), Field3 VARCHAR(2), Field4 VARCHAR(4), Field5 VARCHAR(7), Field6 VARCHAR(8), Field7 VARCHAR(1), Field8 FLOAT); CREATE TABLE ITM( IDC VARCHAR(4),ITEMNAME

Re: [sqlite] What wrapper for SQLite?

2006-06-20 Thread Clay Dowling
I've been using SQLite from Delphi. I found it easiest to use the native API, and put my own wrappers around it when necessary. In general I've kept it pretty simple, because I'm using SQLite as an intermediate database to manage data conversions. For the main data store of an application

[sqlite] SQLiteSpy 1.5.4 released

2006-06-20 Thread Ralf Junker
SQLiteSpy 1.5.4 is released. Changes include: * Updated to SQLite3 3.3.6. * The schema tree view did not automatically reflect if a table was emptied or initial records were being added. * The default text encoding for newly generated database files is now UTF-8. * Fixed a nasty bug which

Re: [sqlite] What wrapper for SQLite?

2006-06-20 Thread Ralf Junker
Different tasks require different approaches. Therefore DISQLite3 offers three levels of abstraction to Delphi developers: 1. The full SQLite3 API, all contained in a single Delphi unit. Best suited to all who like direct access to the SQLite3 interface or want to write their own, app-specific

Re: [sqlite] SQLite performance for 10 Million Records

2006-06-20 Thread Eduardo
At 03:30 20/06/2006, you wrote: Here Is The Schema For these Tables. CREATE TABLE HVH ( Field1 VARCHAR(8), IDC VARCHAR(4), Field3 VARCHAR(2), Field4 VARCHAR(4), Field5 VARCHAR(7), Field6 VARCHAR(8), Field7 VARCHAR(1), Field8 FLOAT); CREATE TABLE ITM( IDC VARCHAR(4),

[sqlite] Index usage

2006-06-20 Thread Mikey C
Hi, I just wanted to ask for confirmation that my understanding on how the query optimiser works is correct. SQLite only uses one index for each table in a FROM? What if tables are joined? Does an index get used for each joined table? So if I have SELECT * FROM A INNER JOIN B ON A.COL1 =

Re: [sqlite] SQLite performance for 10 Million Records

2006-06-20 Thread Derrell . Lipman
"Manzoor Ilahi Tamimy" <[EMAIL PROTECTED]> writes: > Here Is The Schema For these Tables. > > CREATE TABLE HVH ( > Field1 VARCHAR(8),IDC VARCHAR(4), > Field3 VARCHAR(2),Field4 VARCHAR(4), > Field5 VARCHAR(7),Field6 VARCHAR(8), > Field7 VARCHAR(1),Field8 FLOAT); > > CREATE

Re: [sqlite] What wrapper for SQLite?

2006-06-20 Thread Micha Bieber
> A lot of the time using the vanilla API keeps you from coding in the > style most suited for a modern lang, which may only help introduce > bugs which the dev isn't used to worrying about. I don't think it's > right to recommend using it when there are wrappers tailored to keep > the dev

Re: [sqlite] What wrapper for SQLite?

2006-06-20 Thread drh
"Cory Nelson" <[EMAIL PROTECTED]> wrote: > > > > > > I would certainly suggest to not > > > use any library and use directly the sqlite procs. > > > > > I would endorse that approach. The Sqlite API is simple and easy to > > use, so why not take advantage of that and KISS (Keep It Simple Senor)?

Re: [sqlite] What wrapper for SQLite?

2006-06-20 Thread Cory Nelson
On 6/20/06, John Stanton <[EMAIL PROTECTED]> wrote: Costas Stergiou wrote: >>Hello, >> >>I need a server-less SQL engine. Unless someone recommends a better tool >>(embedded FireBird? Something else?), I'm thinking of using SQLite. >> >>Problem is, several wrappers are listed in the SQLite wiki.

Re: [sqlite] What wrapper for SQLite?

2006-06-20 Thread John Stanton
Costas Stergiou wrote: Hello, I need a server-less SQL engine. Unless someone recommends a better tool (embedded FireBird? Something else?), I'm thinking of using SQLite. Problem is, several wrappers are listed in the SQLite wiki. Can you recommend one, ideally under active development, easy