@ Igor - Thank you thats a fantastic example. :D
@ Gerry - Thanks. Your right. Diplicates are ranked one point below. Your
right, Instead of joint points being ranked as 3rd place, they are being
ranked at the lowest rank.
This is what I will end up using.
update stats set rank = (select count(*)
Hi All,
We are facing a problem with the select command with union on an attached
database and getting an error "SQL logic error or missing database"
1.We have an active database connection (for eg a.db which contains a table
with following columns)CREATE TABLE Contact_Primary_Info([uid]
Hi, all
I have met a very strange problem:
I want to load some binary data from SQLite3 database into a defined
structure, so I used the following codes:
==
Sqlite3_stmt * stat;
For (int i = 0; i< 100; i++)
{
//Step1:
sqlite3_prepare_v2(...)
Hey guys,
I just ported Sqlite to my device. I want to know any feature I can turn
on/off in order to save memory! I have only 2mb of disk space, so any byte
is important! :)
Do you guys have any tip for me?
Thanks in advance,
Mauricio
___
Hi
In order to avoid fragmentation, we use sql as a buffer: all I/O have
been rewritten to use a buffer instead a file writting.
The previous solution (which cause fragmentation then) was to load a DB
from file, creta a :memory: db, and then copy all data and structure
from file DB --> mem DB.
I have successfully created an ASP.Net web page that uses the Membership &
Role providers (http://www.codeproject.com/KB/aspnet/SQLiteProviders.aspx)
and System.Data.SQLite (http://sqlite.phxsoftware.com/). It works fine on my
development computer. However, I have the following problems that I
I'm learning SQL and SQLite C API.
1)Suppose I have a table with many columns indexed on a column.
I want to change one value in a column only.
How can I make it with SQL ?
2)Is it possible to index a table on an expression (composed from column
names) ?
thanks for answers
--
View this
c.panel <[EMAIL PROTECTED]> wrote:
> I'm learning SQL and SQLite C API.
>
> 1)Suppose I have a table with many columns indexed on a column.
> I want to change one value in a column only.
> How can I make it with SQL ?
If I understand your question, you want something like this:
update tableName
In my previous post I wrote:
>I have successfully created an ASP.Net web page that uses the Membership &
>Role providers (http://www.codeproject.com/KB/aspnet/SQLiteProviders.aspx)
I was in error. I actually am using the membership and role providers
developed by Dr. Peter Bromberg
Oh yes! "set" is the solution.
I know that I have missed something...
thanks a lot.
no possibilities for indexing on an expression : is it a particularity of
SQL or SQLite ?
Igor Tandetnik wrote:
>
> c.panel <[EMAIL PROTECTED]> wrote:
>> I'm learning SQL and SQLite C API.
>>
>> 1)Suppose I
c.panel <[EMAIL PROTECTED]> wrote:
> no possibilities for indexing on an expression : is it a
> particularity of SQL or SQLite ?
Personally, I never saw any DBMS that supported anything like this. I
can't prove that none such exists, of course.
Igor Tandetnik
On Jun 27, 2008, at 7:15 PM, Igor Tandetnik wrote:
> Personally, I never saw any DBMS that supported anything like this. I
> can't prove that none such exists, of course.
Oracle provides something called Function Based Indexes:
c.panel wrote:
> Oh yes! "set" is the solution.
> I know that I have missed something...
> thanks a lot.
>
> no possibilities for indexing on an expression : is it a particularity of
> SQL or SQLite ?
postgresql provides function based indexes.
___
>On Thu, Jun 26, 2008 at 11:58 AM, Brooks, Phil <[EMAIL PROTECTED]>
wrote:
>> Can anyone suggest additional things I might try to:
>>
>>1) reduce db creation time
>> - or -
>>2) reduce the size of the file?
>>
> Jay Kreibich suggested creating
> a hash number and making that a key for
On Fri, Jun 27, 2008 at 12:20:28PM -0700, Brooks, Phil scratched on the wall:
> I created my hashes in a perl script:
>
> $hash=md5($key);
> $hash_num = unpack( "%32N*", $hash ) % 4294967295;
>
> so they end up being big 32 bit integer numbers.
>
> This ends up saving a lot of
I have a large table and a two column index:
CREATE TABLE events (eid INTEGER PRIMARY KEY,
time INTEGER,
aid INTEGER,
subtype INTEGER,
type INTEGER,
tid INTEGER,
verbose
On Jun 27, 2008, at 6:28 PM, Jeff Gibson wrote:
> I have a large table and a two column index:
>
> CREATE TABLE events (eid INTEGER PRIMARY KEY,
> time INTEGER,
> aid INTEGER,
> subtype INTEGER,
> type INTEGER,
>
Thanks for your help. I created the index:
CREATE INDEX ev4_idx ON event(type);
According to "EXPLAIN QUERY PLAN", it's being used. When I run the query:
SELECT events.* FROM events WHERE ( events.type=22) AND
(events.eid<=3261976) AND (tid=9) AND (verbose<=1) ORDER BY events.eid
DESC LIMIT
2008/6/26 Alex Katebi <[EMAIL PROTECTED]>:
> Steven,
>
> If SQLite runs on ARM9/Linux, then I don't see any problems. I think you
> should watch the SQLite video on youtube.
> http://www.youtube.com/watch?v=giAMt8Tj-84
Thank you. I will go youtube
>
> Enjoy!
> -Alex
>
> 2008/6/24 Steven Woody
> I am considering to use SQLite in my current embedded application
> project. It's a ARM9/Linux. Do you experts think it is a good idea?
> And, is there any tips or considerations in this combination?
Currently using SQLite on an ARM7 running ucLinux.
SQLite is an excellent choice for many
2008/6/28 dcharno <[EMAIL PROTECTED]>:
>> I am considering to use SQLite in my current embedded application
>> project. It's a ARM9/Linux. Do you experts think it is a good idea?
>> And, is there any tips or considerations in this combination?
>
> Currently using SQLite on an ARM7 running
> As an option, we also think about Berkeley DB, do you experts has
> experience using Berkeley DB on ARM/Linux with ulibc or glibc?
Berkeley DB may also be an option. It really depends upon what you are
trying to accomplish, what your data set looks like, etc.
Ironically yes; I am translating
22 matches
Mail list logo