--- Ted Mielczarek <[EMAIL PROTECTED]> wrote:
> While working on a Mozilla task related to debugging information, I
> ran into a problem triggered by the fact that sqlite3.c was > 32k
> lines. It turns out that the "stabs" debugging format uses a short
> integer to store source line numbers. We f
--- [EMAIL PROTECTED] wrote:
> "Scott Hess" <[EMAIL PROTECTED]> wrote:
> > If you have an fts1 table f, you could drop f_term and f_content, but
> > you won't be able to drop f itself. So you would have to name the
> > fts2 version of f something else, like f2.
> >
>
> I probably shouldn't tell
--- Chris Eich <[EMAIL PROTECTED]> wrote:
> I realize that but thought that device_id would be included because of the
> d.device_id=dpi.device_id term. What am I missing?
dpi.device_id is not constant.
You'd be better off with this index for your query:
CREATE INDEX dpi3 ON device_perf_interva
> > >DELETE sqlite_master WHERE type='f';
> >
> > Will all the btree pages orphaned at rootpage for these rows
> > not be recyclable until you run a full VACUUM?
>
> Yes - but the virtual fts1 table doesn't have any btree pages!
Fair enough. I wasn't sure what was going on behind the scenes.
--- Chris Eich <[EMAIL PROTECTED]> wrote:
> The output of EXPLAIN QUERY PLAN doesn't change when I use the CROSS JOIN
> trick to disable table reordering:
>
> sqlite> explain query plan SELECT d.device_type, dpi.* FROM device d,
> device_perf_interval dpi WHERE d.device_id=dpi.device_id AND
> dpi.
> > >DELETE sqlite_master WHERE type='f';
> >
> > Will all the btree pages orphaned at rootpage for these rows
> > not be recyclable until you run a full VACUUM?
> But if you delete the record for a regular table or index from
> the sqlite_master table using the "writable_schema" backdoor,
>
The problem is schema design.
Just use a single task table with another key column for the task number.
Queries on N task tables with UNIONS are killing your performance.
--- Bharath Booshan L <[EMAIL PROTECTED]> wrote:
> TaskN_table
> | Name | TaskID |
>
> TaskN_info_table
>
> | TaskID REFE
--- Chris Eich <[EMAIL PROTECTED]> wrote:
> Thanks, I tried both 3.3.13 and 3.4.0. With 3.3.13 the +'s didn't make a
> difference; the loops always were in d, dpi order with index dpi1 used. With
> 3.4.0 the loops were always in dpi, d order with index dpi1 used, unless I
> used CROSS JOIN.
Index
--- Chris Eich <[EMAIL PROTECTED]> wrote:
> Joe, the numbers are 100, 4236301 and 100 respectively (as you suspected,
> there are few devices, many intervals, and all devices have intervals).
>
> Richard, sqlite_stat1 has these rows for the dpi indexes:
> INSERT INTO "sqlite_stat1" VALUES('devic
--- Scott Hess <[EMAIL PROTECTED]> wrote:
> do_test test-1.1 {
> execsql {PRAGMA encoding}
>
> sqlite3 db2 test.db
> execsql {CREATE TABLE t (id int)} db2
> db2 close
>
> #execsql {SELECT * FROM sqlite_master}
> catchsql {SELECT * FROM t}
> } {1 {no such table: t}}
>
> Looks like the
> SELECT d.device_type, dpi.* FROM device d, device_perf_interval dpi
> WHERE d.device_id=dpi.device_id AND dpi.interval_type=1 AND
> dpi.interval_duration=300
> ORDER BY dpi.interval_end_date LIMIT ;
>
> What can I do to speed this up? I tried a third index on interval_end_date
> but can't ge
> CREATE INDEX dpi5 on device_perf_interval(
> interval_end_date,
> interval_type,
> interval_duration
> );
>
> explain query plan
> SELECT d.device_type, dpi.*
> FROM device d, device_perf_interval dpi
> WHERE d.device_id=dpi.device_id AND
>dpi.interval_type=1 AND
>dpi.
The sqlite3 commandline shell has always defaulted to '|' for the
separator. You may have been using .mode csv which changes the
separator before returning to .mode list:
SQLite version 3.4.0
Enter ".help" for instructions
sqlite> .mode list
sqlite> select 1,2,3;
1|2|3
sqlite> .mode csv
sqlite>
--- [EMAIL PROTECTED] wrote:
> CREATE VIEW _VCustomerData_1 AS
> SELECT AC.*,
>M1.MargineIntermediazioneLordo AS MargineIntermediazioneLordo_m1,
>AP.MargineIntermediazioneLordo AS MargineIntermediazioneLordo_ap,
>M1.MargineInteresseAS MargineInteresse_m1,
>
> CREATE TABLE 'Months'
> (
> IDMonth INTEGER PRIMARY KEY NOT NULL,
> MonthRef INTEGER
> );
>
> (where MonthRef is the date of the first day of the month - created in the
> code)
>
> CustomerData
> --
> CREATE TABLE 'CustomerData'
> (
--- Christian Smith <[EMAIL PROTECTED]> wrote:
> > Much faster - add 3 new fields in CustomerData which you can populate
> > via SQLite's trigger mechanism, or an explicit UPDATE prior to your
> > SELECT:
> >
> > MonthRef-- populate from Months table
> > MonthRef2 -- date(Months.MonthRef,
Let's assume we're using this schema:
CREATE TABLE A(Id INTEGER PRIMARY KEY, Field1, Flag);
CREATE TABLE B(Id INTEGER PRIMARY KEY, Field_Temp, Price);
CREATE INDEX B2 on B(Field_Temp, Price);
CREATE INDEX A1 on A(Field1, Id);
You can extend Igor's pattern for more than 1 column:
explain que
Scott, I've attached a possible patch to the ticket.
It seems to work, but I may have missed some something.
Tell me what you think.
--- Scott Hess <[EMAIL PROTECTED]> wrote:
> I've updated the bug with an example of how this breaks fts tables
> (fts1 or fts2). I'm thinking on the problem.
> http
--- John Stanton <[EMAIL PROTECTED]> wrote:
> Using a single Sqlite connection for each database and holding the
> connection open means that maximum effect is obtained from Sqlite's
> cache. As far as we can ascertain avoiding fcntl removes any issues
> regarding multiple threads accessing a s
--- John Stanton <[EMAIL PROTECTED]> wrote:
> Try looking at the SORT opcode. You can track it through the Sqlite source.
OP_Sort doesn't sort any longer.
It just does a rewind on the cursor.
/* Opcode: Sort P1 P2 *
**
** This opcode does exactly the same thing as OP_Rewind except that
** it in
I noticed delays of an hour or so in posts hitting the mailing list recently.
Or is it just my mail server?
Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo! Games.
http:
--- [EMAIL PROTECTED] wrote:
> A single connection can only be used by a single thread at
> a time. If you have multiple threads running at the same
> time, they each need to have their own connection.
>
> If you are not running on a Linux 2.4 kernel, then you can
> pass connections from one thre
--- Scott Hess <[EMAIL PROTECTED]> wrote:
> S, as far as I can tell, this behaviour changed in October, with
> http://www.sqlite.org/cvstrac/chngview?cn=3470 . Which is before fts2
> even existed! So fts2 has been broken in this way essentially
> forever. *sigh*. [I'm not entirely clear why
> How can check if a row exists in the db or not without querying for it?
Isn't the very act of asking whether it exists a query unto itself?
Looking for a deal? Find great prices on flights and hotels
> When i do a insert is there a way to know row already exists!!
Not without querying.
But you could do something like this:
CREATE TABLE t1(a PRIMARY KEY, b, c);
insert into t1
select 7, 'foo', 'bar' where not exists (
select null from t1 where a=7);
which is similar to:
INS
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > I noticed delays of an hour or so in posts hitting the mailing list
> > recently.
> > Or is it just my mail server?
> >
>
> The server (www.sqlite.org) seems to be doing OK.
> Loa
--- Ken <[EMAIL PROTECTED]> wrote:
> Is this an error or by design?
> create table ss( ssid, ss_value);
> create table s(id, s_value);
...
> select id from s where id in ( select id from ss);
(In the 5 hour lag it takes to post to the list, this has
probably already been answered 5 times, but w
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> >
> > (In the 5 hour lag it takes to post to the list, this has
> > probably already been answered 5 times, but what the heck...)
> >
>
> I'd love for you to work on the slow email
--- John Stanton <[EMAIL PROTECTED]> wrote:
> I think that you misunderstood the shared cache description. Cache is
> shared by many connections but connections may not be passed between
> threads. Each thread must maintain and use its its own connection. In
> our case a thread has an associa
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Thu, Jul 26, 2007 at 08:11:22AM -0700, Joe Wilson wrote:
>
> > Try
> >
> > PRAGMA temp_store_directory = 'directory-name';
> >
> > Otherwise, the temp file location order for U
--- Rohit Mordani <[EMAIL PROTECTED]> wrote:
> I wanted to know if I can reuse the parser from sqlite. I want the
> different sections of the query (like the SELECT part, the FROM part etc.) I
> wanted to know if there is a parsed tree of some sorts that is the end
> result of parsing (in sqlit
-- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> The problem is, that the error message actually gives not any clue. It just
> tells, that "there was problem while truing to open temporary database file"
> - but there (considering the above) shouldn't be any problem. /var/tmp has
> rwxrwxrwx priv
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
>
> While using SQLite as FastCGI module from within PHP-scripts, sometimes I'm
> getting error messages, like:
>
> (mod_fastcgi.c.2551) FastCGI-stderr: PHP Warning:
> sqlite_open() [function.sqlite-open
> malformed database schema - unable to o
I guess that the sqlite authors only want to include the core library
in the amalgamation and rely on loadable extension modules for the rest.
Perhaps fts1 and fts2 could be statically added to the amalgomation, but
ifdef'd out by default.
--- David Crawshaw <[EMAIL PROTECTED]> wrote:
> I was w
> Shared cache mode would be better named "persistent cache mode" because
> its main effect is to permit one thread to not flush the cache after
> each transaction. The people at Mozilla report that they use it and get
> better throughput on small transactions.
You've probably read this. It's
Try using "strip -g" instead of "strip".
Alternatively, you could try --strip-unneeded
--- Chris Brown <[EMAIL PROTECTED]> wrote:
> I seem to have resolved the problem below linking to the static library by
> removing the STRIP command for the static library from the makefile.
>
> The problem I
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> Starting from 101st it just keeps reporting "malformed..." error everytime,
> when one tries to access the database using any of PHP-scripts. Until I
> "manually" restart lighttpd server.
I have no idea about the architecture of lighttpd and its
--- Rohit Mordani <[EMAIL PROTECTED]> wrote:
> However, how do I pass the
> SQL statement, get it parsed and populate the structure? sqlite3SelectNew()
> is a function that I saw, however that just takes in the different sections
> of the SQL Statement. I want to start with a user specified SQL que
--- Chris Brown <[EMAIL PROTECTED]> wrote:
> I modified my file to use '--strip-unneeded' aswell as putting '-O2
> -DTHREADSAFE=1 -DNDEBUG' into my compile line. I have the static library
> down to 679.7k (and still linking in my application) but from what I have
> read on some of the other forum p
--- Rohit Mordani <[EMAIL PROTECTED]> wrote:
> So just to confirm - the Select structure (Select *p) is populated after the
> call to sqlite3Select() method right?
No. sqlite3Select() uses the Select tree - it does not produce it.
See parse.y for the parser that builds the Select tree.
See also
--- Ken <[EMAIL PROTECTED]> wrote:
> You should be using the external API calls not the internal sqlite calls and
> types.
Please point us to where you can get the Select parse tree from the external
API.
>
> See: http://www.sqlite.org/capi3ref.html
__
Maybe the php wrapper is not closing sqlite connections correctly
(or at all).
See if you can get the stack traces of all threads in the php process
162 via pstack, lsstack or by attaching gdb to it at runtime.
> COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
> php
Can you post the output for the failed tests?
i.e.:
footest-13.1...
Expected: [10]
Got: [0]
--- Victor Secarin <[EMAIL PROTECTED]> wrote:
> Hello, everyone. I just started to look at the software and I have two
> questions:
> > Question 1:
> >
> > Building sqlite-3.4.1, as obta
--- Paul Harris <[EMAIL PROTECTED]> wrote:
> I wanted to get a LOG10() function in sqlite3, and I found the
> extension-functions.tgz file in http://sqlite.org/contrib
>
> I am using the all-in-one sqlite3.h/c version of sqlite3, and the
> extension-functions files don't seem to fit at all.
>
> F
> This is probably a stupid question but has frustrated me a couple of times.
>
> When using the command line interface sqlite3, a couple of times I have
> forgotten to use the "." before a command. After that I get a "...>"
> prompt that I can't seem to escape from and accepts no commands? M
--- John Stanton <[EMAIL PROTECTED]> wrote:
> Sqlite3 will get into a tangle with certain sequences where it does not
> accept a semicolon as a terminator or obey a CTL c.
To reproduce:
1. build sqlite3 without readline support.
2. run sqlite3 in an xterm
3. at the prompt, press cursor up
4. hit
You already have the answer to your question.
There's no need for badgering.
--- Rohit Mordani <[EMAIL PROTECTED]> wrote:
> Hi Ken,
>Do you have an answer to what external api we can use to get the
> Select parse tree?
>
> Rohit
>
> On 7/31/07, Joe
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 01, 2007 at 03:04:35PM -0700, Joe Wilson wrote:
>
> > Maybe the php wrapper is not closing sqlite connections correctly
> > (or at all).
> >
> > See if you can get the stack traces of all thr
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> > Your trace seems to indicate it has 20 or so open
> > connections to the same database file in the same process.
>
> I think, at last I've traced the problem:
>
> One of the scripts doesn't make use out of database contents at all. But at
> t
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- John Stanton <[EMAIL PROTECTED]> wrote:
> > > Sqlite3 will get into a tangle with certain sequences where it does not
> > > accept a semicolon as a terminator or obey a CTL c.
&
--- Gilles Ganault <[EMAIL PROTECTED]> wrote:
> As I'd like to be able to build my own SQLite DLL for use with Visual
> Basic Classic, I followed Todd Tanner's instructions at
> www.tannertech.net/sqlite3vb/ to make the (few) required changes and
> compile with Visual C++ 6.0.
This has co
./testfixture test/select1.test
> Is there a way to run a single test of my choice?
Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search
http://search.yahoo.com/search?fr=oni_on
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> On Fri, Aug 03, 2007 at 09:27:22AM -0700, Joe Wilson wrote:
>
> > You are not checking the return code of the sqlite3 connection close.
>
> Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it
:
update test set FieldOne = '1';
--- Luís Santos <[EMAIL PROTECTED]> wrote:
> sqlite> CREATE TABLE test (
>...> id INT NOT NULL,
>...> FieldOne TEXT NOT NULL,
>...> FieldTwo TEXT,
>...> "1" TEXT
>...> );
> sqlite> insert into t
rtrim was introduced on 17-Mar-07, and was in the sqlite 3.3.14 release.
http://www.sqlite.org/cvstrac/chngview?cn=3698
What sqlite version is your ODBC driver?
select sqlite_version();
--- Mitchell Vincent <[EMAIL PROTECTED]> wrote:
> If I use sqlite3.exe to execute the query "Select
> cus
> 3 errors out of 110199 tests
> Failures on these tests: lock4-1.3 malloc2-1.1.34.5 malloc2.1.5
>
> lock4-1.3...
> Error: database is locked
> malloc2-1.1.34.5...
> Expected: [7150405b58e993f161c43b93edd13553]
> Got: [bc598bca7e7514b7f
It should be possible to do what you're trying to do as of 3.3.8.
See the Tcl examples at the bottom of this patch:
Allows UPDATE, INSERT, and DELETEs to occur while
a SELECT is pending on the same table.
http://www.sqlite.org/cvstrac/chngview?cn=3355
Post a complete self-contained C program
--- Alain Bertrand <[EMAIL PROTECTED]> wrote:
> In a Qt4 application, I have the following bit of code :
>
> QString s;
> bool b;
> QSqlQuery q;
> QSqlError err;
> s= "CREATE TABLE ttd_bdata (sheetId integer primary key,";
> s+="creation_date date, modif_date date,";
>
= end ==
>
> ****
>
> This e-mail and attachments contain confidential information from HUAWEI,
> which is intended only for the person or entity whose address
--- Chase <[EMAIL PROTECTED]> wrote:
> here's the deal. i want this trigger to fire -- and insert valid guids
> into a table -- even outside the context of my app.
>
> using sqlite3_create_function(), i can create a sort of temporary
> function that only works from with my app (or other running
It is not reasonable to change a database file to read-only in the
middle of a transaction. I suppose sqlite could be changed to detect it,
but why bother?
By the same logic, if another process wrote random bytes in the middle
of an sqlite database file, should sqlite be responsible for recovering
Any particular reason why you're using 3.3.13?
I don't plan to compile it.
--- karthikeyan <[EMAIL PROTECTED]> wrote:
> Ah yes, in the sqlite3_bind_int, I need to pass id, thanks. Also, please try
> compiling, the sqlite code (3.3.13) with "-DSQLITE_OMIT_SHARED_CACHE=1". It
> should crash with the
There's nothing wrong with your query.
It works fine against this schema in sqlite 3.4.1:
CREATE TABLE Items(items_idx, name, active);
CREATE TABLE RelatedItems(item, related_item);
What language/tool are you using to query sqlite?
--- Lee Crain <[EMAIL PROTECTED]> wrote:
> The query at the bott
--- Lee Crain <[EMAIL PROTECTED]> wrote:
> I've queried it in both the command line interface and via an
> sqlite3_exec() call in a C++ environment.
You must have a typo somewhere.
SQLite version 3.4.1
Enter ".help" for instructions
sqlite> CREATE TABLE Items(items_idx, name, active);
sqlite> INS
If your database file is less than the size of your RAM,
then do this before the create index to speed it up:
cat your.db > /dev/null
See also:
PRAGMA cache_size = number-of-pages;
and
PRAGMA page_size = bytes; -- recommend at least 8192
http://www.sqlite.org/pragma.html
--- mos <[EMA
--- [EMAIL PROTECTED] wrote:
> We are considering a change to the SQLite API which is
> technically not backwards compatible. On the other hand,
> it is difficult to imagine a situation where the change
> would cause anyone any serious hardship. We suspect that
> most people will consider this ch
--- mos <[EMAIL PROTECTED]> wrote:
> At 10:19 AM 8/9/2007, you wrote:
> >If your database file is less than the size of your RAM,
> >then do this before the create index to speed it up:
> >
> > cat your.db > /dev/null
>
> Using Windows XP. :-0
Anyone know a simple Windows command line equival
--- "Babu, Lokesh" <[EMAIL PROTECTED]> wrote:
> Does anybody knows the exact code, a little hack where can I free up the
> memory, I don't want it to use it for future requests.
>
> Even drop table consumes memory. :-(.
>
> If we are doing in-memory database operation, why do we want to maintain
Do you also intend to use just a single file descriptor for all
connections to the same database file in the same process?
--- [EMAIL PROTECTED] wrote:
> We are considering a change to the SQLite API which is
> technically not backwards compatible. On the other hand,
> it is difficult to imagine
--- mos <[EMAIL PROTECTED]> wrote:
> Is there no way to allocate more memory to SQLite index buffers like you
> can with MySQL and most other databases? I suspect SQLite is building the
> index on disk which will be 100x slower than if it used RAM. The indexing
> process has used 400MB of RAM so
--- mos <[EMAIL PROTECTED]> wrote:
> At 01:42 PM 8/9/2007, you wrote:
> >--- mos <[EMAIL PROTECTED]> wrote:
> > > Is there no way to allocate more memory to SQLite index buffers like you
> > > can with MySQL and most other databases? I suspect SQLite is building the
> > > index on disk which will b
--- Brickl Roland <[EMAIL PROTECTED]> wrote:
> where can i find information about how the config-file should look like and
> what is possible?
You can put any command seen in ".help" in the sqlite3 shell
or any SQL command in ~/.sqliterc, such as:
select 'no place like home';
.mode column
.head
Not much you can do.
You could examine the output of EXPLAIN QUERY PLAN for those statements.
Hard to know without knowing the schema, but try making the "id" an
INTEGER PRIMARY KEY, assuming it's appropriate for your data.
Try to have as few indexes as possible on the table being inserted into.
--- Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 8/11/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
>
> > You can put any command seen in ".help" in the sqlite3 shell
> > or any SQL command in ~/.sqliterc, such as:
>
> ...and of course, I would comple
If you recompile sqlite3 with -DSQLITE_DEBUG=1, run sqlite3 in a
debugger, and set a breakpoint on sqlite3Corrupt you can get
a stack trace showing what led up to SQLITE_CORRUPT.
But although this will show you roughly where the file is corrupt,
it probably won't help you with why.
If your OS
--- Christopher Backhouse <[EMAIL PROTECTED]> wrote:
> I have a table:
> create table foo(bar text,baz text);
>
> I want to produce a list of all bar's paired with the longest baz they
> are ever associated with. I came up with the following query:
>
> select distinct bar,baz as z from foo where
> sqlite> INSERT INTO "foo" VALUES('432','13');
> sqlite> INSERT INTO "foo" VALUES('7654321','13');
> sqlite> INSERT INTO "foo" VALUES('1234567','345');
> sqlite> select * from fo
Workaround for 3.3.13:
select distinct bar, baz as z from foo where bar in ((
select bar from foo where baz==z order by length(bar) desc limit 1
));
It's just different enough to prevent sqlite 3.3.13 from choking on
the "order by" clause in the "in" subquery.
--- Christopher Backhouse <[EM
You probably have another shared sqlite library in your path somewhere.
Explicitly link with /absolute/directory/to/your/libsqlite.a rather than
-lsqlite.
--- Daniel Berenguer <[EMAIL PROTECTED]> wrote:
> I've downloaded the sqlite-2.8.17 source code in order to create my own
> static library for
This should be faster:
insert into x
select * from a.x x1
where exists (select 1 from Y where x1.id = y.id);
See if adding an order by statement will make it faster by speeding
up the inserts:
insert into x
select * from a.x x1
where exists (select 1 from Y where x1.id = y.id)
orde
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> This should be faster:
>
> insert into x
> select * from a.x x1
> where exists (select 1 from Y where x1.id = y.id);
>
> See if adding an order by statement will make it faster by speeding
> up the inserts:
>
&g
Forget about the alternate insert statements I suggested.
Assuming "id" is declared INTEGER PRIMARY KEY in all tables,
you can't get better performance than this in a single
insert statement:
insert into x select x1.* from a.x x1, y where x1.id = y.id;
Rather than count the number of connections which would be prone
to failure due to race conditions, you should do this instead:
BEGIN EXCLUSIVE;
-- run whatever SQL statements you want here,
-- or copy the database file.
COMMIT;
Just schedule this job off-hours when people are not likely usi
--- T&B <[EMAIL PROTECTED]> wrote:
> As mentioned, all the associated triggers are deleted. IS there a way
> to systematically locate and keep them? Such as:
>
> set viewDefinition to SQLExec( "select sql || ';' from sqlite_master
> where type = 'view' and name = 'MyView';" )
> set triggerDefi
--- Mikey C <[EMAIL PROTECTED]> wrote:
> John Stanton wrote:
> > We have
> > added a DECIMAL type to Sqlite. This stores fixed point numbers in
> > ASCII display format and performs accurate artithmetic and presents
> > nicely from HTML.
>
> In which release was the DECIMAL affinity added to
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> DISQLite3 Personal is free for non-commercial use. Source code is available
> after registering
> DISQLite3 Pro. Both editions benefit from 'register' calling conventions,
> include full text
> search (FTS1 and FTS2) as well as ample Delphi additions l
--- Scott Hess <[EMAIL PROTECTED]> wrote:
> This may mean that I'll need to branch fts2 to fts3 and deprecate
> fts1/2 as being not safe for use. If the code is going to have to
> create new tables and populate them, then there's not a lot of gain
> versus just having the developer do that.
Is it
--- [EMAIL PROTECTED] wrote:
> "Scott Hess" <[EMAIL PROTECTED]> wrote:
> > I was getting ready to checkin the rowid-versus-fts2 fix, and wanted
> > to add one last bit, to upgrade older tables.
> >
> > Unfortunately, code of the form:
> >
> >ALTER TABLE x_segments ADD id INTEGER PRIMARY KEY;
--- T&B <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
> > It appears that you can set
> >
> > PRAGMA writable_schema=ON;
> >
> > Then do a manual UPDATE of the sqlite_master table to insert
>
> > I tried it and it seems to work. But it is dangerous. If you mess
> > up, you corrupt
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> >Does it support external sqlite loadable extensions?
>
> Loadable extensions are currently omitted. FTS1 and FTS2 extensions are
> provided as built-in
> modules. User-aware collations sequences using the Windows sorting functions
> are provided in
>
--- T&B <[EMAIL PROTECTED]> wrote:
> > Even if you got the sqlite_master table entries right, the in-
> > memory sqlite schema data structures would not be in sync.
>
> Yes, but my point/question was, would that not only apply to tables
> and indexes? I expect that views and triggers have no da
--- Mark Brown <[EMAIL PROTECTED]> wrote:
> There is a .lock file for each database. From my understanding, that should
> prohibit 2 connections from using the same database at the same time.
> However, that is not the situation I am wondering about. I am specifically
> wondering if database acti
--- Scott Hess <[EMAIL PROTECTED]> wrote:
> On 8/15/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > If you find a way to get sqlite3 to re-parse the schema after your direct
> > sqlite_master change, please post it to the list. I don't think it can
> > be done
--- Adam Megacz <[EMAIL PROTECTED]> wrote:
> Hello, I need to create a perpetually-unique column in an FTS2 table.
> For example:
>
> create virtual table t using fts2(c);
> insert into t (c) values ('a');
> select rowid,c from t;
> 1|a
> delete from t;
> insert into t (c) values ('b')
You want to enable readline to allow command history editting, not disable it.
--- "Rachmel, Nir (Nir)" <[EMAIL PROTECTED]> wrote:
> I recently upgraded from sqlite 3.2.8 to sqlite 3.4.0.
> I have only made minor changes in my system to get the new version up
> and running, however I encountered a
--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> >Your product is not useful to a few users like me who require custom
> >sqlite functions for their databases.
>
> I am not sure I understand currectly. Only loadable extensions are currently
> omited from
> DISQLite3.
>
> sqlite3_create_function() i
> We're Hiring! Seeking a passionate developer to join our team building
> products. Position is in the Washington D.C. metro area. If interested
> contact [EMAIL PROTECTED]
>
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
>
http://www.google.com/
--- "Rachmel, Nir (Nir)" <[EMAIL PROTECTED]> wrote:
> Tried without this line - it still doesn't work.
> Any ideas?
>
> Thanks, Nir.
>
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
> Sent: Thursda
SELECT t_dados.id
FROM Points1 LEFT JOIN t_dados ON Points1.object_id = t_dados.id
ORDER BY t_dados.id, Points1.geom_id;
--- "Bruno S. Oliveira" <[EMAIL PROTECTED]> wrote:
> I'm having problems with the following query (and, in general, in
> queries using left joins):
>
> [EMAIL PROTECTED]:~
--- Mina R Waheeb <[EMAIL PROTECTED]> wrote:
> I have some questions about the behavior of aggregate functions and
> the result LIMIT.
> After register TEST function and executing query (SELECT TEST() FROM
> objects group by id LIMIT 30,3)
>
> I was expect calling back TEST() only 3 times but wh
201 - 300 of 764 matches
Mail list logo