Re: [sqlite] ANN: SQLiteSpy 1.5.1 released

2006-02-02 Thread Ken & Deb Allen
Cool. When will you release a MacOS X version? -ken On 2-Feb-06, at 7:58 AM, Ralf Junker wrote: Hello, the new SQLiteSpy 1.5.1 has just been released. SQLiteSpy is a single-exe database manager for SQLite with the complete SQLite library already build in. SQLiteSpy is the ideal tool for

[sqlite] Problems with some SQL statements

2006-01-28 Thread Ken & Deb Allen
I have some SQL statements that the 3.3.2 engine does not seem to handle properly. The project with which this is associated is keeping track of the game schedule for a Little League division, and being able to produce the proper standings at the end of the season. The standings are first

[sqlite] SQLite 3.3.1

2006-01-17 Thread Ken & Deb Allen
Hmmm. The number of warnings compiling the 3.3.1 source is up to 10 from 6 in the 3.3.0 source. All of them appear to be related to inappropriate sign comparisons/assignments. -ken

Re: [sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-13 Thread Ken & Deb Allen
Thank you, kind sir. Sometimes it is difficult to see the individual ferns on the floor of the massive forest! Oddly enough, the problem seems to have been caused by the lack of the os.c file being compiled into the project at all? Some files that were in the 3.2.8 code stream are no longer

Re: [sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-13 Thread Ken & Deb Allen
For the life of me I cannot figure out where this is going wrong. I am not a below average intelligence individual, and I have been working with computers for over 30 years, but this one has me totally at a loss. I should point out that while I own MacOS based systems exclusively for home

Re: [sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-12 Thread Ken & Deb Allen
attempt to debug the 3.3.0 source and step into the sqlite3OsLock call, it simply drops me into some assembler and declares the bad instruction signal. -ken On 12-Jan-06, at 8:46 PM, [EMAIL PROTECTED] wrote: Ken & Deb Allen <[EMAIL PROTECTED]> wrote: I had a look, but I do not see

Re: [sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-12 Thread Ken &amp; Deb Allen
actual implementation (not even a typedef or wrapper for a native call). -ken On 12-Jan-06, at 7:20 PM, Ken & Deb Allen wrote: I have encountered a problem while attempting to execute some code with SQLite embedded. This code was working with the previous version of the source.

[sqlite] Problem executing SQLite 3.3.0 under MacOS

2006-01-12 Thread Ken &amp; Deb Allen
I have encountered a problem while attempting to execute some code with SQLite embedded. This code was working with the previous version of the source. I am developing a small framework to permit me to use the SQLite engine from within some Cocoa applications I am developing for personal us

[sqlite] Compilation warning improvements with 3.3.0

2006-01-12 Thread Ken &amp; Deb Allen
Wow! Am I impressed! A while back I initiated the email concerning the large number of compiler warnings that were being generated when I attempted to compile the SQLite source code using either the Visual Studio 2005 compiler or using XCode 2.2 (gcc 4). This sparked off some acrimonious comments

Re: [sqlite] SQLite as a Windows kernel tool

2005-10-29 Thread Ken &amp; Deb Allen
ermine the actual intent raises some concerns. -ken On 29-Oct-05, at 12:56 PM, [EMAIL PROTECTED] wrote: Ken & Deb Allen <[EMAIL PROTECTED]> wrote: vdbeapi.c e:\SQLITE\327\Source\vdbeapi.c(55) : warning C4244: 'return' : conversion from 'i64' to 'int', po

Re: [sqlite] SQLite as a Windows kernel tool

2005-10-29 Thread Ken &amp; Deb Allen
he warning suppressed universally. I can provide the entire log file (attaching it to the email, even compressed) caused the message to be rejected as it exceeded the 3000 byte limit for the mail list. -ken On 29-Oct-05, at 2:31 AM, Eric Bohlman wrote: Ken & Deb Allen wrote: I had a

[sqlite] SQLite as a Windows kernel tool

2005-10-28 Thread Ken &amp; Deb Allen
I have been toying with the idea of checking whether or not I can use SQLite in a Windows device driver as its database. I am working on an existing product that is implemented as a series of Windows device drivers, filter drivers and even a file system driver. The file system driver manage

Re: [sqlite] SQLite3 Explorer dates

2005-08-20 Thread Ken &amp; Deb Allen
This would be more effective if it were also available for MacOS and Linux. -ken On 20-Aug-05, at 5:32 AM, Ralf Junker wrote: Hello Clark Christensen, SQLiteSpy executes the query "select date('2005-08-19');" with no problems. SQLiteSpy is a free SQLite3 database manager and is similar

[sqlite] Problems using SQLITE .Net Data Provider (Windows)

2005-08-15 Thread Ken &amp; Deb Allen
I recently downloaded the (Finisar) .Net Data Provider for SQLITE from SourceForge in order to use this in a C# applications under Windoes XP. I had a few small problems getting the database created at all via .Net, but that is working, and I was able to also define the schema for my databa

Re: [sqlite] Manifest Typing question

2005-06-21 Thread Ken &amp; Deb Allen
Will declaring the column as VARCHAR not achieve the same thing? Does SQLITE not translate VARCHAR to TEXT, rather than numeric? -ken On 21-Jun-05, at 5:10 AM, D. Richard Hipp wrote: On Tue, 2005-06-21 at 00:13 -0400, Tito Ciuro wrote: Hello, When I add text to the database, it's getting

[sqlite] PRIMARY KEY Issue

2005-06-12 Thread Ken &amp; Deb Allen
I have seen frequent mention that the "most efficient" key for a SQLITE3 table is to declare a column as "INTEGER UNIQUE". I know from past experience that the primary key for any database table should consist of the first and contiguous column(s) in the table. Does SQLITE3 treat the follow

Re: [sqlite] updating records problem

2005-05-17 Thread Ken &amp; Deb Allen
All database tables should be defined with a unique primary key. Ideally this should consist of one or more integer columns; tect columns can be used but they are universally less efficient. If the data being stored does not contain a natural unique identifier, then one should be added; you can

Re: [sqlite] Merging databases

2005-05-07 Thread Ken &amp; Deb Allen
I am not certain that there is such a thing as a "good algorithm" to achieve this, especially as there are some decisions that need to be made. The first thing that you need to do is to load the text file information into a new set of tables, [newCustomers], [newProducts] and [newOrders]. Wh

Re: [sqlite] timestamp how to ?

2005-04-23 Thread Ken &amp; Deb Allen
Having used other databases extensively, and discovering that SQLITE does not have a native DATETIME data structure, I have elected to store the Date/Time value from the operating system (which is either a 32-bit or 64-bit value) directly into an INT field and then translate it into a string on

Re: [sqlite] Locking Methods

2005-04-19 Thread Ken &amp; Deb Allen
The largest drawback of this approach is scalability -- in my case I often deal with databases with 20-30 closely related tables, many of which can have 1,000,000 or more records in them, and containing multiple relations. Copying this into memory before each query would be very time consuming.

Re: [sqlite] Problem storing integers

2005-04-17 Thread Ken &amp; Deb Allen
When can we expect a 3.2.2 release that includes this correction? I am working on a database that depends on 64-bit integer values. -ken On 15-Apr-05, at 7:35 AM, D. Richard Hipp wrote: On Fri, 2005-04-15 at 10:53 +0100, Richard Boulton wrote: I'm running the latest sqlite 3.2.1 command line tool

Re: [sqlite] optimize table

2005-04-15 Thread Ken &amp; Deb Allen
statistics), and then timing the SELECT/JOIN. -ken On 15-Apr-05, at 6:15 AM, Ken & Deb Allen wrote: I cannot speak for SQLITE for certain, but I know with a number of commercial RDBMS packages the index is not used unless it contains a sufficient degree of distribution. Microsoft SQL Server, fo

Re: [sqlite] optimize table

2005-04-15 Thread Ken &amp; Deb Allen
I cannot speak for SQLITE for certain, but I know with a number of commercial RDBMS packages the index is not used unless it contains a sufficient degree of distribution. Microsoft SQL Server, for example, is quite explicit in stating that if the distribution of values across the range of recor

[sqlite] Some Functional Questions

2005-04-13 Thread Ken &amp; Deb Allen
I have been experimenting with SQLITE for a little over a week now, and I must say that I am fairly impressed with many of its capabilities. I have been experimenting with performance from several aspects, and the numbers are quite respectable. I have several years experience with Sybase, Acces

Re: [sqlite] create table question

2005-04-10 Thread Ken &amp; Deb Allen
So, would this problem still exist if the code were to open two 'connections' to the database, issue the SELECT on one open connection and then issue the CREATE TABLE via the other open connection? Does this in any way prevent an application from opening a single connection, issuing a SELECT, a

Re: [sqlite] Problem when asking for databases that don't exist

2005-04-09 Thread Ken &amp; Deb Allen
To determine whether a specific database exists, check to see if the file exists before calling sqlite3_open(), using stat() or some other call. To determine if a specific schema exists within an open database, use the query "SEELCT COUNT(*) FROM sqlite_master WHERE type = 'table' AND name IN

Re: [sqlite] SELECT (...) GROUP BY not returns!

2005-04-09 Thread Ken &amp; Deb Allen
In this specific case, examining your original data, there will be no records that match your selection criteria. Normally, one would expect a single record to be returned with a single column that contains a zero value. Using the GROUP BY changes this, and the query will attempt to return one