-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/04/2010 03:35 PM, Barton Torbert wrote:
> We are thinkng about writing C Extensions to SQLite to do this. But I was
> wondering if there are a set already written that could be used?
Not to my knowledge as every programming language already in
On 4 Nov 2010, at 10:35pm, Barton Torbert wrote:
> My company is using SQLite. We need to do some formatting to the data before
> posting it to a webpage. What we want to do are simplier tasks such as zero
> padding, limiting placess to the right of the decimal etc.
Can you tell us why you fe
Hi Joshua,
In reply to:
> The real issue I'm trying to solve is a sorting one. I run some SQL which
> takes some integers and creates a column for sorting with data like
> following:
> 1.1.2.3
> 1.2
> 1.12.4
Why not do something like:
select Column1 || '.' || Column2 || '.' || Column3 || '.'
My company is using SQLite. We need to do some formatting to the data before
posting it to a webpage. What we want to do are simplier tasks such as zero
padding, limiting placess to the right of the decimal etc.
We are thinkng about writing C Extensions to SQLite to do this. But I was
wonde
After more Googling, I found this tidbit which simulates lpad for sqlite:
substr('00' || mycolumn, -10, 10)
Thanks!
Josh
> Hello all,
>
> The simple question is, is there any way in SQLite to format (left align)
> integers? So for example I want to print 1 as 1, 23 as 00023, 102 as
Hello all,
The simple question is, is there any way in SQLite to format (left align)
integers? So for example I want to print 1 as 1, 23 as 00023, 102 as
00102, etc.
The real issue I'm trying to solve is a sorting one. I run some SQL which
takes some integers and creates a column for sorti
I had an application which had 5 cm meter accuracy and needed to get points
with 1 meter for example.
I ended up writing my own search method. I'm sure others are trying to do
similar.
The patch I submitted doesn't change the original code at all unless you enable
the RTREE_DOUBLE. So it s
On Thu, Nov 4, 2010 at 11:27 AM, Ben Harper wrote:
> Are you sure that double precision in the RTree is necessary for your
> purposes?
>
To put this another way, single-precision RTree is sufficient to locate any
point on the surface of the earth to within less than 2.5 meters. I'm
curious to k
If you're trying to get more than 6 or 7 significant digits, yes
And if you're dealing with lat/lon
1 degree = 69.04 miles or 364531.2 feet
So if youi're trying to get sub-foot accuracy/precision you need the digits.
Not quite so important for the RTree I would think as it is for the actua
Are you sure that double precision in the RTree is necessary for your purposes?
Here is a table of floating point precision at various values:
The 'flip' values are the 'org' values with the lowest bit flipped.
org flip (delta)
0.01 0.01 ( 0.0
On Thu, Nov 4, 2010 at 9:19 AM, Hakki Dogusan wrote:
> > In newer versions of Fossil, the "fossil ui" command binds to the
> loopback
> > IP only (127.0.0.1) meaning that it will only see TCP/IP traffic coming
> from
> > the local machine. This is a security feature. The "fossil server"
> comma
Hi,
04/11/2010 14:09, Richard Hipp wrote:
> On Thu, Nov 4, 2010 at 3:52 AM, Hakki Dogusan wrote:
>
>> Hi,
>>
>> 03/11/2010 23:51, Benjamin Peterson wrote:
>>> Richard Hipp writes:
Try setting:
fossil setting autosync off
before you do the
fossil
I'll send the patched C file to your email address. I think the 1M patched
version is a bit much for the email list.
Normally you would just use the "patch" utility to apply the patch to your file.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information S
Check out:
http://jaksprats.wordpress.com/2010/09/28/introducing-redisql-the-lightning-fast-polyglot/
On Nov 3, 2010, at 10:51 AM, Jay A. Kreibich wrote:
> On Wed, Nov 03, 2010 at 05:10:22PM +0300, Alexey Pechnikov scratched
> on the wall:
>> 2010/11/3 Jay A. Kreibich
>>>
>>> Why not j
sqlite.exe db_name .dump
It missed : table name is un quoted.(INSERT statement)
database conversion fails (version 2 to 3)
sqlite -version
2.8.17
- dump_test.sql
create table "where" (id INTEGER);
INSERT INTO "where" VALUES(1);
---
@rem create database
[critical bug] sqlite3: col name bug on select statemnt
sqlite3 --version
3.7.3
this bug occures with count or sum .
c:\tmp> sqlite3 test3.db
.header ON
-- bug
drop table t1;
drop table t2;
drop table t3;
CREATE TABLE t1 (col1 INTEGER)
>From: "Black, Michael (IS)"
>I made a patch which seems to do this for you...
>Use this switch to enable double precision on RTREE /DRTREE_DOUBLE
I am interested in this as well. Will this patch be included in a future
version of SQLite? Or, if not, how best to make use of this patch if I
no
On Thu, Nov 4, 2010 at 3:52 AM, Hakki Dogusan wrote:
> Hi,
>
> 03/11/2010 23:51, Benjamin Peterson wrote:
> > Richard Hipp writes:
> >> Try setting:
> >>
> >> fossil setting autosync off
> >>
> >> before you do the
> >>
> >> fossil update
> >
> > I actually get this from "fossil clon
On Nov 4, 2010, at 1:30 AM, Igor Tandetnik wrote:
> Pavel Ivanov wrote:
>>> Yes. That's precisely the intended use case. Remember though that
>>> the transaction is not really committed until COMMIT statement
>>> runs: if your application crashes or machine loses power, all
>>> changes to th
Hi,
03/11/2010 23:51, Benjamin Peterson wrote:
> Richard Hipp writes:
>> Try setting:
>>
>> fossil setting autosync off
>>
>> before you do the
>>
>> fossil update
>
> I actually get this from "fossil clone http://sqlite.org/src";, too.
>
I don't know it is same problem as this but
20 matches
Mail list logo