In the relational model, the unit of access is a tuple so you would expect a
DBMS to process all columns. Typically they also access in units of a page
(although a tuple of course might extend across more than one page)
The discussion seems to have moved onto selecting pages. Surely if you need
t
You seem to be asking about four separate issues - normalisation, table
creation, table loading, and SQLite syntax. The thing is I've just looked at
your book's index and I can't imagine a better source of answers to your
questions.
Maybe you would like to post some specific cases here?
--
View
Hi everyone!
I met no problem with win32 console application,but when it turn to MFC
in Visual C++,the same code dosen't work.
Anyone can give me some suggestion?
Thanks in advance!
*The error is:*
Unhandeled exception in xxx.exe(sqlite3.dll)0xC005 Access Violation
*More output:*
Loaded 'ntdll
On Sun, Sep 27, 2009 at 5:19 PM, Darren Duncan wrote:
> Following my previous message to the sqlite-users list, I've done a bit more
> research and decided to escalate my reply to a formal feature request.
>
> I was initially going to file a ticket, but it seems that non-registered
> SQLite
> dev
Roger Binns wrote:
>> intended for
>> use in situations where users do want most of the fields from a source but
>> don't
>> want a few.
>
> What is the harm in the extra fields being returned? Sure they take up a
> few bytes more space but that isn't a big deal. In tables where there may
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Darren Duncan wrote:
> I was initially going to file a ticket, but it seems that non-registered
> SQLite
> developers can't do that anymore, and we're supposed to do it on sqlite-users
> where a non-registered developer would then distill list chatt
Jean-Christophe Deschamps wrote:
> Darren,
>
> At 02:19 28/09/2009, you wrote:
> ´¯¯¯
>> So my proposed "" is identical to the old "> sublist>", and my addition is the optional EXCEPT plus list of not
>> derived columns.
>>
>> Note that I'm not stuck on the keyword EXCEPT, but it should be a word
Oops, let me try again!
>SELECT ALLBUT foo FROM t ...
Typing error! Should be
SELECT * ALLBUT foo FROM t ...
Could be as well
SELECT * BUTNOT foo, bar FROM t ...
The risk seems much higher with words like SAFE or WITHOUT, which
perhaps have greater probability of being used in some fuure
Darren,
At 02:19 28/09/2009, you wrote:
´¯¯¯
>So my proposed "" is identical to the old "sublist>", and my addition is the optional EXCEPT plus list of not
>derived columns.
>
>Note that I'm not stuck on the keyword EXCEPT, but it should be a word
>that
>reads similarly.
`---
I would love to s
Following my previous message to the sqlite-users list, I've done a bit more
research and decided to escalate my reply to a formal feature request.
I was initially going to file a ticket, but it seems that non-registered SQLite
developers can't do that anymore, and we're supposed to do it on sql
This makes a lot of sense now - I haven't read up on the C interface and
assumed that "step" was a JDBC thing. Thanks for clearing that up.
George.
On 09/26/2009 01:01 AM, Pavel Ivanov wrote:
>> Does anyone know why this method might be so expensive?
>>
> Because it's main method to execut
Stef Mientki wrote:
> hello,
>
> I often want to see most of the columns of a table / view / query, but a
> few I don't want to see.
> So I now create a huge list of fields,
> but isn't there a more typo-frindly way, like :
>
> select * - field33 from table
A syntax option introduced in Date an
hello,
I often want to see most of the columns of a table / view / query, but a
few I don't want to see.
So I now create a huge list of fields,
but isn't there a more typo-frindly way, like :
select * - field33 from table
thanks,
Stef Mientki
___
sqli
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dr. David Kirkby wrote:
> "sqlite3.c", line 18731: warning: integer overflow detected: op "<<"
> "sqlite3.c", line 18748: warning: integer overflow detected: op "<<"
> "sqlite3.c", line 32546: warning: statement not reached
> "sqlite3.c", line 69160: w
On Sat, Sep 26, 2009 at 5:31 PM, P Kishor wrote:
> On Sat, Sep 26, 2009 at 6:36 PM, marbex wrote:
>> Shopsland gmail wrote:
>>> select title from fts_news where fts_news match 'ined'
>>
>> It looks that you only want to query the title field, so the query should
>> be:
>> select title from fts
"sqlite3.c", line 18731: warning: integer overflow detected: op "<<"
"sqlite3.c", line 18748: warning: integer overflow detected: op "<<"
"sqlite3.c", line 32546: warning: statement not reached
"sqlite3.c", line 69160: warning: integer overflow detected: op "<<"
@Nuno: hey that is really nice. Thank you!
On 9/27/09, Nuno Lucas wrote:
> C. Mundi wrote:
>> I'm hoping someone will (please) tell me I missed something in the sqlite
>> docs. Otherwise, I guess I'll be using python's csv module to turn my CSV
>> file into SQL insert statements. This is likel
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sean Moss-Pultz wrote:
> OK. Then I'm going to need to escape this string since the insert is
> really coming from a import of a huge datadump generated in Python.
You should probably explain the big picture first. Python has at least two
wrappers ar
C. Mundi wrote:
> I'm hoping someone will (please) tell me I missed something in the sqlite
> docs. Otherwise, I guess I'll be using python's csv module to turn my CSV
> file into SQL insert statements. This is likely to be an infequent task,
> but it has to be done perfectly. So if someone know
I recently had to import an Excel based database into an SQL database. To
complicate the matters data was all over the place in each file (3 separate
tables in a single CSV file), and some numbers had commas (e.g. 8,253.45).
I used the Perl CSV module to read in each file (1500+) line at a time
On Sat, Sep 26, 2009 at 11:04:17PM +1000, aj scratched on the wall:
>
> what encoding does sqlite_exec() callback function receive data in ?
>
> some tests i've done seem to suggest UTF-8
>
> other tests show chars U+80 to U+FF are returned as single chars with
> values 128-255. (suggesting its
Hi List
I have a python script that runs 3 instances simultaneously on a
quadcore x86 system. I'm not using the multiprocessing libraries. The
programs are just run in parallel. They all access (for reading only)
a single sqlite3 database. I'm setting the following pragma commands:
offset_db.
Hi Roger
Thanks a lot for such a quick reply...
On Sun, Sep 27, 2009 at 3:18 PM, Roger Binns wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Sean Moss-Pultz wrote:
>> How can I get the string to stay 0123?
>
> It isn't a string - you supplied an integer and SQLite treated it that wa
aj wrote:
> what encoding does sqlite_exec() callback function receive data in ?
>
> some tests i've done seem to suggest UTF-8
>
> other tests show chars U+80 to U+FF are returned as single chars with
> values 128-255. (suggesting its not UTF-8)
This means that these strings were inserted this wa
On 26 Sep 2009, at 2:04pm, aj wrote:
> what encoding does sqlite_exec() callback function receive data in ?
>
> some tests i've done seem to suggest UTF-8
>
> other tests show chars U+80 to U+FF are returned as single chars with
> values 128-255. (suggesting its not UTF-8)
That would be some kin
what encoding does sqlite_exec() callback function receive data in ?
some tests i've done seem to suggest UTF-8
other tests show chars U+80 to U+FF are returned as single chars with
values 128-255. (suggesting its not UTF-8)
where is *any* documentation about this?
--
Not sent from an iPhon
Sean Moss-Pultz wrote:
> Hi List
>
> Here's basically what I'm doing:
>
> sqlite> create table test(t text);
> sqlite> insert into test values(0123);
> sqlite> select * from test;
> 123
>
> How can I get the string to stay 0123? I've read the docs about
> "Column Affinity." But I guess I'm
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sean Moss-Pultz wrote:
> How can I get the string to stay 0123?
It isn't a string - you supplied an integer and SQLite treated it that way
and then stored it. If you really wanted a string then you must quote it
(remember to use single quotes). If y
28 matches
Mail list logo