Hi,
This is my 1st post here. I hope someone can help. I've been using SQlite
for about a year and so far very impressed.
Trouble is the typeless nature when doing simple maths on the columns.
I have two columns, rating and votes, both declared as NUMERIC. I wan't to
calculate the average
on 06/05/21 17:05, Kon Lovett at [EMAIL PROTECTED] wrote:
> An XCode project for SQlite 3 would be nice but I don't have one.
Hey, it was easy. Summary: Download the "pure C" source code, create a new
Xcode "BSD Dynamic Library" project, add the source code, add Tcl.Framework
from /System,
Jay Sprenkle wrote:
score(x,y) = max(score(x+n,y+n)-n*penalty) where n < drc(x+n,y+n) < 256
So at some 'sample' you have the score and drc, but not the x,y value?
The x,y values can be interpolated using some algebra and the surrounding
samples?
Uh, no. Sorry my other emails were unclear. At
On May 21, 2006, at 2:09 PM, Thomas Chust wrote:
On Sun, 21 May 2006, Jerry Krinock wrote:
I would like to compile SQLite 3.3.5 for Mac OS 10.3 and Mac OS
10.4. [...] Are there any tricks that I should know about before
attempting this? [...]
Hello,
I had no trouble whatsoever to build
It is not permissions, more like a VB interface problem.
Robin Wilson wrote:
Hi all,
I've just started looking at SQLite - and think it is really impressive.
It would be just the thing to use with my students for teaching them
about RDBMS's (especially with some of the nice Windows UIs which
On Sun, 21 May 2006, Jerry Krinock wrote:
I would like to compile SQLite 3.3.5 for Mac OS 10.3 and Mac OS 10.4.
[...] Are there any tricks that I should know about before attempting
this? [...]
Hello,
I had no trouble whatsoever to build the standard UNIX tarball of SQLite
3.3.5 on MacOS X
I would like to compile SQLite 3.3.5 for Mac OS 10.3 and Mac OS 10.4. I see
from the list archives a couple months ago that some people were using the
TEA compatible distribution for this.
Are there any tricks that I should know about before attempting this? I
have compiled a couple packages
On 5/21/06, Unit 5 <[EMAIL PROTECTED]> wrote:
I am a bit confused on how to change the page_size
using the pragma command. The documentation says:
"The page-size may only be set if the database has not
yet been created."
The database is created when you create first table in it. Run the
I am a bit confused on how to change the page_size
using the pragma command. The documentation says:
"The page-size may only be set if the database has not
yet been created."
But, to be able to issue the pragma command, I need to
have a database connection in the first place. If the
database I
On 5/20/06, Brannon King <[EMAIL PROTECTED]> wrote:
So here's the real problem. Sorry about the long explanation, but if
anyone wants to help with the query, that would be great. I have a 2d
sparse matrix in a table where each point has two values, a score and a
diagonal run count. In other
Fred a <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I port successfully sqlite3 library on other platform...
> But i have some problems...
>
> When i try to insert some records, if for example i insert
> 80: good; if i try to insert 81 records the database is corrupted
This suggests to me
On 5/21/06, Fred a <[EMAIL PROTECTED]> wrote:
Hello all,
I port successfully sqlite3 library on other platform...
But i have some problems...
When i try to insert some records, if for example i insert 80: good; if i try
to insert 81 records the database is corrupted
I don t understand
On 5/20/06, Brannon King <[EMAIL PROTECTED]> wrote:
The benefits I'm trying to get out of sqlite are the data queries. I
collect a large, sparse 2D array from hardware. The hardware device is
giving me a few GB of data data at 200MB/s. Future hardware versions
will be four times that fast and
Hi all,
I've just started looking at SQLite - and think it is really impressive.
It would be just the thing to use with my students for teaching them
about RDBMS's (especially with some of the nice Windows UIs which are
available for the students who can't cope with command line tools!).
I
On Sat, 20 May 2006, Brannon King wrote:
John Stanton wrote:
You don't seem to need a data manipulation system like Sqlite, more a form
of high volume storage. Do you really need elaborate SQL, journalling,
ROLLBACK and assured disk storage?
Di you consider some form of hashed storage,
Hello all,
I port successfully sqlite3 library on other platform...
But i have some problems...
When i try to insert some records, if for example i insert 80: good; if i try
to insert 81 records the database is corrupted
I don t understand because if make a SELECT query with my
Sunday, May 21, 2006, 02:10:31, Brannon King wrote:
> The documentation says to put the database name on the front of the
> index name, not the table name when using the create index command. I
> thought it was weird myself.
Thank you, it has done the trick! I missed this in CREATE's
17 matches
Mail list logo