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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
27 matches
Mail list logo