D. Richard Hipp skrev:
> Perhaps: SELECT CAST(b AS TEXT) FROM table
>
Ok, I was kinda hoping for a more "permanent" solution such as:
int sqlite3_cast_column_type(sqlite3* db, const char* zDBname, const char*
zTable, const char* zColumn, int newColumnType);
that would cast the column into
That seems like it would cut down on some of your query times. When you
say it's running slow, how slow are you talking about?
Eric Pankoke
Founder
Point Of Light Software
http://www.polsoftware.com/
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
I fixed my OPTS in the Makefile so that they are in sync
with my compilation options.
Now all the unresolved references in the parser have dis-
appeared, but I'm still left with two unresolved references
to the function sqlite3MaterializeView():
delete.obj : error LNK2019: unresolved external
Tuesday, April 22, 2008, 2:52:37 PM, you wrote:
Why not just keep the rowid's in an array and query the actual row
contents as needed. This is typical with virtual list or tree
controls. That is you keep a reference to the data, not the data
itself.
F> Thanks for the quick reply Epankoke.
F> We
Thanks for the quick reply Epankoke.
We tried as you mentioned. But we are restricted with the memory size and
the storage of the needed data occupies some MB's of space in the memory so
we cannot go for it. Is there any other work around to perform the scrolling
condition.
Kindly help in this
Hi,
Richard Klein wrote:
> [...]
> (2) Perforce (our version control software) has trouble diff'ing
> two versions of a large file.
We have the amalgamated sqlite3.c source file under Perforce control
here and I don't recall any problems with diff, except I had to wait a
bit longer than usual.
"Gaurav Mathur" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
>> Why not just use ROWID as a unique identifier?
>
> This is because I need to avoid one property of ROWID fields and
> that's
> that SQLITE reuses
> the ROWID values.
http://sqlite.org/autoinc.html
Igor Tandetnik
Many thanks for your response Igor. Please see response and additional query
inline.
On Mon, Apr 21, 2008 at 7:40 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> "Gaurav Mathur" <[EMAIL PROTECTED]>
> wrote in message
> news:[EMAIL PROTECTED]<[EMAIL PROTECTED]>
> > Suppose I have the following
"Gaurav Mathur" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
> Suppose I have the following schema:
>
> CREATE TABLE t1
> (
> f1 integer,
> f2 text
> );
>
> CREATE TABLE t2
> (
> val integer
> );
>
> Suppose the following inserts statement are executed by two processes
> over the
D. Richard Hipp wrote:
> On Apr 21, 2008, at 9:03 PM, Richard Klein wrote:
>> I regenerated and recompiled the source files
>> specifying that the following features (among
>> others) are to be omitted:
>>
>> SQLITE_OMIT_REINDEX
>> SQLITE_OMIT_VIEW
>> SQLITE_OMIT_VIRTUALTABLE
>
> It worked OK
Hi All,
I would appreciate help with the following scenario.
Suppose I have the following schema:
CREATE TABLE t1
(
f1 integer,
f2 text
);
CREATE TABLE t2
(
val integer
);
Suppose the following inserts statement are executed by two processes
over the above schema.
insert into t1 values
On Apr 21, 2008, at 9:03 PM, Richard Klein wrote:
> I regenerated and recompiled the source files
> specifying that the following features (among
> others) are to be omitted:
>
> SQLITE_OMIT_REINDEX
> SQLITE_OMIT_VIEW
> SQLITE_OMIT_VIRTUALTABLE
It worked OK when I tried this combination. Are
I regenerated and recompiled the source files
specifying that the following features (among
others) are to be omitted:
SQLITE_OMIT_REINDEX
SQLITE_OMIT_VIEW
SQLITE_OMIT_VIRTUALTABLE
Nevertheless, I am getting the following link
errors:
delete.obj : error LNK2019: unresolved external symbol
For what it is worth, while I had done a few simple things in MySQL prior to
using SQLite, I think it would be nice if there were a couple of different
"tracks" of tutorials. Maybe they could be one for the "Novice", one for an
"Experienced" user, and then one for those that are doing actual C
You cannot create a trigger which crosses between databases because
the system cannot know that the database will be attached when the
trigger fires. Triggers are part of the consistency guarantee, so
this is bad.
It would be interesting to have something like "CREATE TEMPORARY
TRIGGER ... "
Hi, I'm trying to create in the main db a trigger on "after insert on
ATTACHED_DB.TABLE" but I get an error
"SQL error: trigger TEST_TRIGGER cannot reference objects in database
ATTACHED_DB"
Can I obtain TABLE_1 in the attached db and TABLE_2 and TRIGGER (who read
from TABLE_1 and write to
On 4/21/08, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> FWIW, I'll be happy to give write access to the documentation
> repository (http://www.sqlite.org/docsrc/) and even a
> prestigious "sqlite.org" email alias to anybody who is
> willing to step up and make some improvements and
> updates
Understood. I use the amalgamated source for maximum performance.
Re 1: Look at Source Insight for editing. The only dig I have at it is
that it won't let me split a window into the same source file like the
VC editor will. Since I do all my building with command line tools, I
don't need
On Apr 21, 2008, at 4:25 PM, Richard Klein wrote:
> Thanks, Mark!
>
> I use the individual source files rather than the amalgamation,
> for several reasons:
To generate individual source files run
make target_source
>
>
> (1) Visual Studio has trouble generating line number info for
>
interesting. thanks for the tip.
I"ll give it some consideration.
-James
On Apr 21, 2008, at 1:07 :50PM, Scott Hess wrote:
> If you create a file on disk and set PRAGMA synchronous = OFF, you
> should get pretty close to the performance of a shared in-memory
> database on most modern desktop
On Apr 21, 2008, at 3:10 PM, Robert Bielik wrote:
> Hi all,
>
> I'm using the sqlite3_blob_* api to write a larger text stream
> incrementally. Works a charm, but is there a way to
> change the datatype of the blob to text afterwards ? I'd like to see
> the text easily in f.i. SQLiteSpy.
>
[EMAIL PROTECTED] wrote:
>
> I've got two processes running. Each has it's own instance of the database
> open. When I update the database from process 1 the select on that data
> from process 2 doesn't see the change.
>
> Of course if I close and re-open I see the change but surely that's
My experience is that this kind of problem tends towards a he-said,
she-said type of thing, and what happens in the end is that everyone
is correct from their perspective, but there was some little bit of
non-obvious thing that made one party's understanding of the encoding
slightly different from
Thanks, Mark!
I use the individual source files rather than the amalgamation,
for several reasons:
(1) Visual Studio has trouble generating line number info for
files that have more than 64K lines.
(2) Perforce (our version control software) has trouble diff'ing
two versions of a large file.
If you create a file on disk and set PRAGMA synchronous = OFF, you
should get pretty close to the performance of a shared in-memory
database on most modern desktop operating systems - maybe close enough
that you won't care to do anything beyond that. If you further look
at the recent
That's what I do. Once your makefile is set up, make the "sqlite3.c"
target if you want an amalgamated source file. Be sure to carefully
coordinate the defined values between the preprocessing step (to
generate your source file(s)) and the build of your application/dll.
If you are using
I've got two processes running. Each has it's own instance of the database
open. When I update the database from process 1 the select on that data
from process 2 doesn't see the change.
Of course if I close and re-open I see the change but surely that's not
how this has to work.
I'm
Hi all,
I'm using the sqlite3_blob_* api to write a larger text stream incrementally.
Works a charm, but is there a way to
change the datatype of the blob to text afterwards ? I'd like to see the text
easily in f.i. SQLiteSpy.
TIA
/Rob
___
> Richard Klein wrote:
>> In order to reduce SQLite's memory footprint in my embedded
>> application, I want to use the SQLITE_OMIT_xxx options to
>> remove unneeded features from SQLite.
>>
>> Using Cygwin running on Windows, I have successfully down-
>> loaded the canonical sources and
Richard Klein wrote:
> In order to reduce SQLite's memory footprint in my embedded
> application, I want to use the SQLITE_OMIT_xxx options to
> remove unneeded features from SQLite.
>
> Using Cygwin running on Windows, I have successfully down-
> loaded the canonical sources and autoconfigured
Mike Johnston <[EMAIL PROTECTED]>
wrote:
> OK, so that makes sense. What I see happening is creation of a
> journal file when i do the update/insert/delete statement each of
> which return SQLITE_OK. However, nothing is visible from an outside
> process (like sqlite3). If I understand you,
D. Richard Hipp wrote:
> FWIW, I'll be happy to give write access to the documentation
> repository (http://www.sqlite.org/docsrc/) and even a
> prestigious "sqlite.org" email alias to anybody who is
> willing to step up and make some improvements and
> updates to the current documentation.
>
>
FWIW, I'll be happy to give write access to the documentation
repository (http://www.sqlite.org/docsrc/) and even a
prestigious "sqlite.org" email alias to anybody who is
willing to step up and make some improvements and
updates to the current documentation.
D. Richard Hipp
[EMAIL PROTECTED]
Along these lines, also note that the "quickstart" (url below) still
shows the callback method instead of the v2 methods. The last time
another programmer asked me for help, I referred him there and I was
shocked later at the code he produced. "Nice code, but you could have
done the same thing a
OK, so that makes sense. What I see happening is creation of a journal file
when i do the update/insert/delete statement each of which return SQLITE_OK.
However, nothing is visible from an outside process (like sqlite3). If I
understand you, this journal will be applied once the
Is it possible to store all of the needed data in memory? If so, why not read
the required information into an array and just update an index variable to
keep track of where you are at in the array when the user clicks the up and
down buttons? That should be quite fast.
--
Eric Pankoke
"Mike Johnston" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> I'm running the 3.5.7 version now. My understanding was that if I
> have a prepared statement and currently using sqlite_step to walk
> through the results, the database was unable to commit a write.
You cannot commit
I'm running the 3.5.7 version now. My understanding was that if I have a
prepared statement and currently using sqlite_step to walk through the results,
the database was unable to commit a write.
In my case, I would be using the same connection. Would you explain more?
Also, what if same
Thanks for your reply Igor.
We tried populating the listbox as mentioned in the URL.We are successful in
populating the listbox but when we go for scrolling the data, it takes more
time to move forward and backward since it has to execute the query
everytime. We are using a PocketPc so it is
* Jay A. Kreibich:
> Yeah, I screwed that up. I was too caught up on the other error.
>
> In the original function (-1 << network_size) returns the wrong bit
> mask. For example, 10.0.0.0/8 should return a netmask of 255.0.0.0,
> or 0xFF00. The original function will return
40 matches
Mail list logo