Hi,
Our production server is running SQLite v3.3.6 on CentOS release 5.2
(Final).
We're planning to upgrade SQLite to the latest version (atleast to v3.5.0)
but couldn't able to find any equivalent RPMs greater than v3.3.6.
Can somebody point me to the RPM download link location of the same?
Re
>> In the shell:
>>
>> SQLite version 3.7.3
>> Enter ".help" for instructions
>> Enter SQL statements terminated with a ";"
>> sqlite> CREATE VIRTUAL TABLE a_rt USING rtree( _id, min_x, max_x,
>> min_y, max_y );
>> sqlite> INSERT OR IGNORE INTO a_rt ( _id, min_x, max_x, min_y,
>> max_y )
>> VALUE
Hi Dave,
I turned to compiling it manually on Solaris for now and that latest version
of SQLite compiled perfectly.
Thanks for your comment though, I will give it a try later ;-)
Lynton
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On
Sql can do it. It just takes a properly designed query.
Woody wizard at large(I'm in shape. Round is a shape)
Connected by MOTOBLUR™ on T-Mobile
-Original message-
From: cricketfan
To: sqlite-users@sqlite.org
Sent: Mon, Nov 8, 2010 19:24:54 PST
Subject: Re: [sqlite] sqlite3_step to sele
SQL will not do the trick for me because I based on the select I have to
perform other operations(queries on other tables) and only then can I update
the table in question.
Kees Nuyt wrote:
>
> There is no need to do this in a loop with a cursor.
> Whenever possible, use the power of SQL set ope
On 8 Nov 2010, at 9:27pm, Stephen Chrzanowski wrote:
> I don't know how the code works, but logically speaking, if I'm at row B,
> and I update row B to E, row B physically remains B but has its data content
> changed to E. From there on in, it should go on to C then D then F, etc.
And naturall
On Sun, 7 Nov 2010 10:14:29 -0800 (PST), cricketfan
wrote:
>Just to make things clearer
>the value being fetched into ref from the database, is also the value being
>changed(ghi) in the update statement. When I change my query (just to debug)
>to update some other column in the table the whole th
I don't know how the code works, but logically speaking, if I'm at row B,
and I update row B to E, row B physically remains B but has its data content
changed to E. From there on in, it should go on to C then D then F, etc.
Since the full rowset results already exist somewhere, it shouldn't show
Hi,
Installed tcl8.5.8 - OK
Insalled sqlite-amalgamation-3.7.3 - OK
Installed sqlite-3.7.3-tea with:
./configure --prefix=/usr --with-system-sqlite
It installed:
/usr/lib/sqlite3.7.3/libsqlite3.7.3.so
/usr/lib/sqlite3.7.3/pkgIndex.tcl
It can work in tclsh if I do:
% load /usr/lib/sqlite3.7.3/li
On 8 November 2010 16:09, Lynton Grice wrote:
> Hi all,
>
> Anybody out there got the latest version of SQLite compiled on Solaris 10 64
> bit?
>
> Perhaps I must add some options to the "./configure"?
>
> Thanks for the help ;-)
>
> Lynton
I've built sqlite-3.6.22 on 64-bit SPARC and it installs
On Mon, 08 Nov 2010 12:24:22 -0500, George wrote:
> Hi there. I'm wondering what the best way to represent a 16 byte UUID in
> sqlite might be (I didn't see any specific data type for UUIDs in the
> documentation, but forgive me if there is).
>
> I could just stringify or blob it, but I might hav
Thousands doesn't seem like it will be problem...so I'd keep it simple and put
it in string form.
You'll cut the bytes in half for a blob but it doesn't sound like you need it
for just thousands unless you're really memory starved.
Michael D. Black
Senior Scientist
Advanced Analytics Dire
Hi there. I'm wondering what the best way to represent a 16 byte UUID in
sqlite might be (I didn't see any specific data type for UUIDs in the
documentation, but forgive me if there is).
I could just stringify or blob it, but I might have to index a large number
of items by this identifier (thousa
Hi all,
Anybody out there got the latest version of SQLite compiled on Solaris 10 64
bit?
Perhaps I must add some options to the "./configure"?
Thanks for the help ;-)
Lynton
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of
My guess is that you have a memory leak...
Care to post your code of how you're "creating" the database? You're probably
not freeing the SQL, or the statement handle.
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
_
Hi,
We are trying to Integrate SQLite in our Application and are trying to populate
as a Cache. We are planning to use it as a In Memory Database. Using it for the
first time. Our Application is C++ based.
Our Application interacts with the Master Database to fetch data and performs
numerous o
Anyone can tell me why no right/full in sqlite3?
because they can be replaced by other join/where/etc clause or other tech
issue?
Thanks in advance.
--
Jun Fang
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailma
Sqlite version 3.6.15
Client running Windows Vista SP2
Server running Windows Small Business Server 2008
Written in C++
All databases are on the same share, mounted as a drive letter
I'm sorry have not had time yet to write a smaller test app for you, but I'm
not sure it would be reproducible for
On Nov 8, 2010, at 5:12 AM, Alexey Pechnikov wrote:
> sqlite> .s object_record
> CREATE TABLE object_record
> (
> record_id INTEGER PRIMARY KEY,
> ts INTEGER NOT NULL DEFAULT (strftime('%s','now')),
> object_id INTEGER NOT NULL
> );
> CREATE INDEX object_id_ts_idx on object_record(object_id,ts
On Mon, Nov 8, 2010 at 2:44 AM, Simon Slavin wrote:
> Several bugs I've been reading about here seem to be cases where the query
> optimizer works differently between one version of SQLite and the next. So
> I wondered whether it would be possible for the testing suite to log the
> amount of tim
20 matches
Mail list logo
