;switch -exact -- $Variable_Record_Type {
>
>HEADER { db1 eval "INSERT INTO HEADER($Variable_Column_Name) VALUES
>($Variable_Column_Value)"}
>TRAILER { db1 eval "INSERT INTO TRAILER($Variable_Column_Name) VALUES
>($Variable_Column_Value)"
>MOC { db1 eval
own Querie that may include
>columns that are not indexed.
Exact progress indicators are hard. It's better to optimize
the schema and selects and not need progress indicators at
all. With proper design, 40k rows and no joins, most selects
should be really fast.
HTH
--
( Kees Nuyt
)
c
is too much of an effort, and you have to use the
old database format, why not simply keep using the ancient
jdbc version that is able to access it?
>Best regards,
>Garp
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sql
istory tables in your
schema, and create an ON DELETE triggers to save deleted
rows to the history tables.
That way you even would be able to recover rows that have
been inserted and deleted after the most recent backup.
--
( Kees Nuyt
)
c[_]
___
=
>
>Maybe you would be preparing hundreds or thousands of different queries
>per minute -- but if by chance you're not -- could anyone be expected to
>notice the time for the prepare's?
Also, prepared statements can be re-used.
--
( Kees Nuyt
)
c[_]
_
w.sqlite.org/atomiccommit.html
>Thanks.
Hope this helps.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ine)?
>
> I bought the book: "Sqlite: the definitive guide"
> (by M. Owens).
>
> The book is great but, in my opinion, there are very
> few examples. Of course it is impossible to write
> everything in a singlo book :-)
>
> Thanks in advance
>
> B
mented as nested loops. The virtual
machine code can tell a lot about what part of the database
has to be scanned.
>I have other queries which worry me. But that trick did not help in
>these cases :-(
>
[...]
>
>Thank you again and bes
te the original row and insert the new one.
None of the original columns values in the affected row will
survive.
>thanks,
>ed
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
genuine sqlite3.dll
extension=php_pdo_sqlite_external.dll
>Thanks for help
>
>nobs
Hope this helps.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
So, I don't know exactly
> why at this time, But thought network latency
> can´t be denied.
>
> /Edward
Which of my suggestions did you already try?
>On Wed, Jan 7, 2009 at 4:07 AM, Kees Nuyt wrote:
>> On Tue, 6 Jan 2009 11:23:29 +0900, "Edward J. Yoon"
>&
chosen architecture isn't scalable, and code
tweaking in sqlite will not help much.
Opening and closing one of 20,000,000 files for every
logical transaction is not suitable for such a scale. An
operation of that size should be able to construc
nd the functions sqlite3_memory_used() and
>sqlite3_status(SQLITE_STATUS_MEMORY_USED, ...) but these look like they
>provide memory statistics for all of sqlite, not per database.
>
>thanks,
>ed
Hope this helps.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
PRIMARY KEY (member_id, idate) ON CONFLICT IGNORE
);
INSERT INTO talks SELECT * FROM talks_with_dups;
>Craig Smith
>cr...@macscripter.net
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
de.
Without more details on your use case, people will only get
general advice like the above.
>Thanks.
Hope this helps.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
#x27;.mode tabs; select * from DS0001 limit 1;'
>
> but this doesn't work because the .mode tabs isn't
> separated from the regular SQL.
>
> Could someone point out how to accomplish this?
That's a one liner:
echo ".mode tabs\nselect * from DS0001 limit 1;&qu
e3_interrupt() call.
http://www.sqlite.org/c3ref/interrupt.html
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
is in the Delphi wrapper you use.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
le at the same time?
That is mainly determined by the page cache and can be
influenced with PRAGMA page_size and PRAGMA
[default_]cache_size.
Every database connection has its own page cache.
You'll have to add up the memory consumption.
http://www.sqlite.org/arch.html
&
tion.
Most you need to know about locking is found in:
http://www.sqlite.org/lang_transaction.html
sqlite3_exec() these statements one by one:
ATTACH 'filename' as db2;
BEGIN IMMEDIATE; -- or EXCLUSIVE
(error handling/retry)
-- this assumes table1 has the exact
===
== Restore =
C:\yourdir> sqlite3 newdatabase sqlite3 newdatabase
sqlte> .read dump.sql
sqlte> .quit
>thanks
Hope this helps.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the
CREATE TABLE SELECT ... syntax, but this has the
disadvantage of not creating any indexes.
http://www.sqlite.org/lang_createtable.html
>Thanks in advance,
> Simon
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ould go away as I could ensure its length.
SQLite is an embedded database, not a generic RDBMS backend
engine, and doesn't have strong typing. It assumes the
application (anything that calls the SQLite library) knows
the database schema. That may make life a bit harder for
generic wrapper librarie
ursor
>Thanks for all your help,
>
>Regards,
>Jay.
You're welcome.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
in a database.
>Please provide me the pointers to debug this issue.
http://www.sqlite.org/c3ref/funclist.html
http://www.sqlite.org/c3ref/exec.html
>Thanks and Regards
>Thiyags.
HTH
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqli
create table table1 (
recid integer PRIMARY KEY NOT NULL, label text);
create table table2 (
recid INT PRIMARY KEY NOT NULL, label text);
.bail OFF
insert into table1 (label) VALUES ('foo');
select * from table1;
1|foo
insert into table2 (label) VALUES ('foo');
ate)
VALUES
(1,julianday('now'));
END;
Notes
-
Code is not tested.
The on update and on delete triggers are left as an exercise
to the reader.
Alternatively, you can add an update timestamp column to
every table and update that usi
x27;t close SQLite
>and the batch can't continue.
>I have used .quit .exit .q but don't work and can't find
>an answer on an internet search.
Try like this:
sqlite3 mydb.db3 Best regards.
>
>Juan M. Perez
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
he has two issues. The second issue was discussed a lot
already.
My point was about [1]: anyone with write access to the
databasefile can corrupt it, encrypted or not.
>-Shibu
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqli
is used as / identical with ROWID.
Note: Use the exact words: INTEGER PRIMARY KEY
>Christophe Leske
HTH
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
st solution to provide security to my database without any
>Data loss.
Use ACL. Run the application in an account that has access
to the file, Refuse access to all other accounts.
>Regards,
>
>Satish.G
--
( Kees Nuyt
)
c[_]
___
sqlite-use
erview.html
http://www.sqlite.org/pragma.html
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ypted database and then how to open it.
>
>If somebody can bring me any idea i papreciate it. thanks.
HTH
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sat, 15 Nov 2008 02:32:21 -0800, Roger Binns
<[EMAIL PROTECTED]> wrote in General Discussion of
SQLite Database :
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Kees Nuyt wrote:
>> I assume the OP wants to collect updates from more than one
>> webpage into
tore session data,
one could rewrite the "PHP4 MySQL Session Handler" by Ying
Zhang for SQLite.
http://coding.derkeiler.com/Archive/PHP/comp.lang.php/2005-06/msg01492.html
HTH
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ashko4
http://www.developersdex.com/gurus/articles/112.asp
>Thanks for your help.
>
>Sébastien Roux
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
or messages, but at
least it aborts the sql script at the first error it
encounters.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
sourceforge.net/viewvc/sqlite-dotnet2/SQLite.NET/Doc/
Questions are best asked in the forum in the link you
provided.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
es CHAR/CLOB/VARCHAR/TEXT/BLOB all support
> size definition? let's say CHAR(50), VARCHAR(100),
> TEXT(200), BLOB(500) etc?
Yes, syntactically they do, but the size definition is
simply ignored.
If you want strict typing, you will have to add t
vstrac/wiki?p=ConverterTools
>which says
>Note: I don't think it supports SQLite right now, but this project can
>be continued and used for that purpose.
>
>to point to my article
It's a wiki, you can edit it yourself.
Click the [Edit] link in the bar belo
s explicity if I would like to set it to the current date in my
>particular time zone?
Instead of using DEFAULT you can create an ON INSERT trigger that sets
any column to any value you wish.
Or you could modify the SQLite source to suit your taste.
>Thanks.
--
( Kees Nuyt
)
c[_]
__
there is any plan for enhancing Sqlite's UPDATE
>statement in this direction ?
>
>Thank's
>
>Jean-Marie
There might be a workaround:
Create an updateble view and UPDATE that view.
An updateble view is a view plus an INSTEAD OF trigger.
http://www.sqlite.org/lang_createt
sqlite/ (close to the bottom of the page)
It should be possible to use any report generator that can connect to
ODBC (even MS Access) together with one of the SQLite ODBC drivers.
See also (you probably already found):
http://www.sqlite.org/cvstrac/wiki?p=SqliteReporting
http://www.sqlite.org/cvstra
TOINCREMENT, name
>TEXT);
>COMMIT;
I think MySQL uses AUTO_INCREMENT. You will have to dive
into the documentation to make sure.
A mailing list is not a manual lookup service.
>Thank you.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
eek in the file(seek value is simply calculated as index*size_of_structure)
>3) read
>4)close file
>
>In this case file is opened once and only steps 2 & 3 need to
>perform for reading data and this is 10 times faster than sqlite.
>
>Than
base
(INSERT, UPDATE, DELETE) in a transaction (BEGIN / COMMIT).
http://www.sqlite.org has more on performance optimisation.
It's also interesting to read about its architecture.
> or only relies on OS caching?
The OS cache comes on top of the internal
tion DRH
>suggests is perfect for my needs.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Tue, 23 Sep 2008 14:37:11 -0400,
Enrique Ramirez wrote:
>On Tue, Sep 23, 2008 at 1:16 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote:
>> Steps to take (you need all of them, except 1):
>>
>> 1) Use v6.2.3
>>
>
>Probably meant to say 1) Use v3.6.2?
Oops, ye
hes on Objects.Name
(or Objects.Keyword) with a UNION.
7) Wrap the
SELECT ... JOIN UNION SELECT ...
in a SELECT DISTINCT to get unique results.
8) You probably don't use 'abc' but some
variable in your host
ine2
line3');
>is importing xml supported in sqlite
>(I did not see it from the documentation)?
No, it isn't. Perhaps Tcl can do it, or xgawk.
> thank you
>
> Qianqian
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>http://www.sqlabs.net
>http://www.sqlabs.net/blog/
>http://www.sqlabs.net/realsqlserver/
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Fri, 12 Sep 2008 11:19:41 -0700 (PDT), you wrote:
>I am new to SQLite
Since 51 weeks, to be exact ;)
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
of crashes you won't be able to
log rollbacks, anyway, whereas SQLite will rollback using
the journal the first time a new connection is made.
>Best regards, Alexey.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
PRAGMA page_size;
8192
sqlite> select count(*) from blob;
3374
sqlite> .q
\research>dir tmp\fossil
2008-08-25 23:43 4.775.936 fossil
So, it works.
Perhaps there is an esential difference between your test
program and the command line tool?
--
( Kees Nuyt
)
c[_]
_
_version;
1
PRAGMA page_size=1024;
VACUUM;
PRAGMA schema_version;
2
PRAGMA page_size;
1024
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, 21 Aug 2008 02:18:39 +0530, Mrinal wrote:
>>As Dennis said, that looks like a bug.
>
> Created a new ticket (number 3320:
> http://www.sqlite.org/cvstrac/tktview?tn=3320)
> which has been fixed now.
Wow, that's fast.
>- Mrinal
On Wed, 20 Aug 2008 06:33:17 +0530, Mrinal wrote:
>>Try:
>>PRAGMA [database.]table_info(table-name);
>
>> ( Kees Nuyt
>
>Thankyou Kees for the solution
yw.
>But, I am facing another problem
[...]
As Dennis said, that looks like a bug.
I just confirmed SQL
? Or is it planned in some future version?
Try:
PRAGMA [database.]table_info(table-name);
Most other databse specific PRAGMAs support the
databasealias. prefix, so does this one, although it isn't
documented in http://www.sqlite.org/pragma.html#schema .
>
ively, you can use
PRAGMA auto_vacuum =
0 | none | 1 | full | 2 | incremental;
PRAGMA incremental_vacuum(N);
http://www.sqlite.org/pragma.html#pragma_incremental_vacuum
>Thanks,
>Richard
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
to squeeze more performance out of this box.
Hint:
For a genuinely level playing field you'd have to use more
PRAGMAs, like page size and cache size. Defaults might be
different in different environments.
--
( Kees Nuyt
)
c[_]
___
sqlite
On Thu, 14 Aug 2008 13:25:56 -0700, you wrote:
>--
>-- A LITTLE CLEANUP BEFORE WE CONTINUE
>--
>
> DROP TABLE TEST1;
I don't think you really want to drop TEST1.
We'll need it later.
ATE | UPDATE OF
column-list
http://www.sqlite.org/lang_createtrigger.html
>Regards,
>Marton
I hope this helps.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sat, 9 Aug 2008 09:21:07 +1200, you wrote:
>The second question is what can I do to prevent this problem occurring?
Is the database shared over NFS?
Do you use any dangerous PRAGMA, like PRAGMA synchronous =
OFF; ?
--
( Kees Nuyt
have of this matter?
I agree (3) should be removed. If it would break any of my
applications (which I doubt), I'll gladly repair it, because
I would have done a bad job, not you.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sql
'C')),
useridVARCHAR(8) NOT NULL,
:
:
);
CREATE INDEX idx_jobs_tsn ON jobs(TSN);
CREATE TRIGGER jobs_ins AFTER INSERT ON jobs
FOR EACH ROW BEGIN
DELETE FROM jobs WHERE jobid < (NEW.jobid - );
END;
--
( Kees Nuyt
)
c[_]
__
On Wed, 6 Aug 2008 16:45:35 -0400, Jeffrey Becker wrote:
> On Wed, Aug 6, 2008 at 4:10 PM,
> Kees Nuyt <[EMAIL PROTECTED]> wrote:
>> Additionally: NodeID and ParentID shouldn't be blobs.
>> Integer is the most suitable type for IDs.
>
>The blobs
index on (ParentID, NodeID) or something like that.
>
>-Steve
Additionally: NodeID and ParentID shouldn't be blobs.
Integer is the most suitable type for IDs.
http://article.gmane.org/gmane.comp.db.sqlite.general/17286/match=managing+trees+database
and
http://www.sitepoint.com
greetings from hamburg, germany
>Till
Greetings from Rotterdam, Netherlands.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
can't update a join
2- you can't define a trigger over
main and attached databases
> once for foo, and also for
> db2.foo (which means conditional logic, testing for
> recordid range)?
>
> Thanks in advance.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ce, but it might work for you.
>Thanks for you help.
>
>David
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
mp|Sensor_ID|Sensor_Name|Sensor_Type|Sensor_Value|Sensor_Units|Location|Alarm
2008-08-02 18:33:12|4|S4|Temp|0.0|NotSet|Kitchen|False
2008-08-02 18:33:13|5|S5|Temp|293.5|K||False
>David Goadby
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
gt;
>Thanks a lot
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ALUES (1, 'A',
>10.0, 10.0);
>BEGIN;
>INSERT INTO GEO_TEST(FID, NAME, E_UTMX, E_UTMY) VALUES (2, 'B',
>20.0, 20.0);
[snip]
>then every thing goes right.
>
>Am I doing something wrong ?
I don'
ready mentioned, SQLite is not a
server.
If DBDesigner can handle ODBC, you could try one of the
SQLite_ODBC drivers. But that will not solve everything, as
DBDesigner probably doesn't know the SQLite syntax.
--
( Kees Nuyt
)
c[_]
___
sqlite-users
Small. Fast. Reliable.
Choose any three
==>
Small. Fast. Reliable. Free.
Choose any four
:)
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ged,
then subtract that same value minus 1.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
nclose all command
between one pair of double quotes and use \n as a newline
between commands.
Or use the solution of Simon Davies.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
if you know the way to append the data to the file
> and print the tablename as well as table's columns name to the file.
On one line:
echo ".headers on\n.separator ,\nselect 'myTable' as
tablename,* from myTable;" | sqlite3 databasefile
e general information:
http://csrc.nist.gov/groups/STM/cmvp/validation.html
>Thanks, Dan
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ovfl_unused int, -- Number of unused bytes on overflow
pages
gap_cnt int -- Number of gaps in the page layout
);
A wealth of information, really.
sqlite3_analyzer is available on the download page
http://www.sqlite.org/download.html .
--
( Kees Nuyt
)
c[_]
_
acked by disk
storage.
The same happens in the SQLite command line tool if you do
not use a database file name as a commandline parameter.
In-memory databases created in this way disappear completely
after sqlite3_close(), or after exit program, or after the
.quit command in the command line tool.
a bug.
For every transaction there are several fsync() calls to the
operating system to flush buffers of both journal and
database to disk. See the documentation for more details.
http://www.sqlite.org/atomiccommit.html
If you don't care about SQLites ACID fe
The PHP version on the webspace probably expects an
SQLite version 2 database.
You will have to convert your SQLite v3 database to
SQLite v2 before uploading:
sqlite3 .dump your.db3 | sqlite2 your.db2
And hope you didn't use SQL that SQLite v
ail: [EMAIL PROTECTED]
>The answer is 42.
Indeed.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
terested in from a shell
script, or associate my preferred sqlite3 filename
extension (.db3) with it.
The command (wrapped by mail):
\firefox.exe -chrome
chrome://sqlitemanager/content/sqlitemanager.xul
mydb.db3
just doesn't do the trick.
--
( Kees Nuyt
)
c[_]
___
eturn rows in the region of interest.
>i am having 6 records.
>Is there any other way to optimize.
Have a look at
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
for how and why to optimize a scrolling list.
>Thanks & Regards,
>Mahalakshmi
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e, classe,
istanza);" | sqlite3 test.db
$ sqlite3 test.db
SQLite version 3.5.7
Enter ".help" for instructions
sqlite> .schema
CREATE TABLE test (id, nome, classe, istanza);
sqlite> .q
HTH
--
( Kees Nuyt
)
c[_]
___
sqlite-u
/en-us/library/ms682586.aspx
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
; .read test.sql;
>can't open "test.sql;"
>sqlite> .read C:/_source/test.sql;
>can't open "C:/_source/test.sql;"
Drop the semicolon, .read is not an SQL statement.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t;Moreover I am using ext3 tinyfilesystem
>somewhat similar to busybox file system !
If you had to port the sources to a new OS it is easy
to make mistakes in the platform specific file I/O
routines. They might not return the correct status.
--
ernative is:
extension=php_pdo_sqlite_external.dll
plus the current sqlite3.dll
That works for me.
php_pdo_sqlite_external.dll can be in the php/ext
directory, as usual.
You may have to copy sqlite3.dll to the apache/bin
directory.
>Thank you.
HT
on-disk database, whereas the magic
filename ":memory:" refers to an in-memory database.
>Thanks
>
>Fred
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the DB anymore, due to the
>malformed schema error.
Ok, I understand now.
>Thanks again
>Marco
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ould do.
So, it is not a problem until you create your own
problem by using undocumented, unsupported backdoors.
Consider it the same as patching table pages by
hex-editing the database file.
Feel free to do it, but don't expect a safety net.
>Thanks again
>Marco
--
( Kees Nuyt
)
c[
on
>..w 20 17 6 23 6
>..e on
I'm sure it is explained in a previous chapter, but
you can always type .help in the command line tool.
It recognizes commands as soon as it the first 1..N
characters are unique.
HTH
--
( Kees Nuyt
)
c[_]
__
here is a SQLite3 capable PDO_sqlite
for PHP4 (I doubt it, PHP4 practically reached end of
life).
>best regards
>
>Giovanni Rossati
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-b
On Wed, 12 Mar 2008 18:44:36 -, Bart wrote:
>Kees,
>
>Would you be interested to do a project for me for a fee?
[..]
>Regards, Bart Smissaert
Answered in private mail.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
ategoryIndex
FROM CategoriesContent
WHERE new = 1
ORDER BY categoryIndex ASC;
SELECT DISTINCT [categoryIndex] AS catindex
FROM CategoriesContent
WHERE [new] = 1
ORDER BY [categoryIndex] ASC;
I agree it seems slightly inconsistent behaviour.
[] around identifiers are not
urse, incorrect SQL INSERTs, DELETEs, DROPs and
UPDATEs can damage your data as well.
>Best Regards,
>A. Sreedhar.
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
works for every value type.
Just my 0.02
--
( Kees Nuyt
)
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
601 - 700 of 883 matches
Mail list logo