Hi Stephen,
I have a slightly different requirement. Because the second device is
the hot-standby part of my device hosting the database, I must be sure
that the change was successfull. Everything else would lead to
confusion when there is a failover and some data is not yet changed.
I'm
I have made .dump for each database, original and clone, and saved into
separated files. Than compare them.
Differences are in INSERT INTO entries, in the clone database those entries
are missing which I did not copy from the original. But the CREATE TABLE,
CREATE INDEX, CREATE TRIGGER Commands
Could there be a different page_size, resulting in differing amounts of
'wasted' space?
Check with PRAGMA page_size; or sqlite3_analyzer program.
Thanks
Steve
csabi81 wrote:
I have made .dump for each database, original and clone, and saved into
separated files. Than compare them.
Thanks Steve, I think I am on the right way.
It is a difference between the page sizes of the two databases. I have
opened each database with Firefox SQLite Manager, and at the DB Settings I
have seen a lot of differences, such as page size, Cache size, max page
count etc. How can I Copy all
first of all, hello to the board and all users!
now to my problem: i want a jdbc:sqlite connection per
mysql-connector-java-5.1.6-bin.jar. everthing works fine, as long as the
db-file is not packed with the rest of the program to a jar-file. i found
out that the files in a jar-file are reachable
I have done again a test, its nice to work with you guys :)
So, I query all the PRAGMAs from the original database, and note them,
temporary on a sheet of paper;
then after dooing a .dump obtain the hole schema of the database, CREATE
TABLE, INDEX, INSERT stc..., saved in a file. I append from
Hello!
I did read prezentation of SQL Anywhere® 11
http://www.sybase.com/files/White_Papers/Sybase_SQLAnywhere_Top10newFeatures_wp.pdf
and there are very useful features which can make replication very simple. How
may be it realised in SQLite?
1. UNLOAD to a Variable
The LOAD and UNLOAD
Hello everybody,
Using sqlite 3.6.0 with fts3 enabled:
create table indexes(docid int);
create virtual table texts using fts3(reading);
insert into texts values(text1);
insert into indexes values(last_insert_rowid());
select * from indexes join texts on texts.docid == indexes.docid where
Hi everyone,
i need to backup a sqlite database on a remote device for
configuration redundancy purposes. Due to a really slow connection
between the devices triggering rsync is not the best solution yet.
Although rsync is efficient it is transfering kilobytes of data to see
what it has to
The new VFS implementation is probably the way to go. If you wrote some
wrapper code around the default VFS, you could capture all the writes that
go to the main db and clone/wirexfer those writes to a 2nd sync file.
Just an idea -- haven't worked with VFS's yet, though I plan on implementing
On Tue, 5 Aug 2008 18:57:10 +0200, you wrote:
Hi everyone,
i need to backup a sqlite database on a remote device for
configuration redundancy purposes. Due to a really slow connection
between the devices triggering rsync is not the best solution yet.
Although rsync is efficient it is
FWIW, on a Dell Inspiron 530 running Ubuntu 7.10 with Tcl8.4 installed,
../configure --with-tcl=/usr/lib/tcl8.4
make
works fine, but
make fulltest
generates the following:
perm-memsubsys1.tcl-1.1...
Expected: [1 {wrong # args: should be sqlite3 HANDLE FILENAME
?-vfs
On Tue, 05 Aug 2008 17:22:05 -0500, you wrote:
Jeffrey Becker wrote:
I have a table 'SiteMap' defined as :
Create Table SiteMap
(
NodeID blob not null PRIMARY KEY,
Title text NOT NULL UNIQUE,
Url text NOT NULL
);
I'd like to index on the node's parent value as defined
On Wed, Aug 6, 2008 at 4:10 PM, Kees Nuyt [EMAIL PROTECTED] wrote:
On Tue, 05 Aug 2008 17:22:05 -0500, you wrote:
Jeffrey Becker wrote:
I have a table 'SiteMap' defined as :
Create Table SiteMap
(
NodeID blob not null PRIMARY KEY,
Title text NOT NULL UNIQUE,
Url text NOT
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 I'm inserting are actually a binary representation designed
Good afternoon list,
I would like to load my current database file completely into memory,
mostly as an experiment to check SQLite's maximum memory footprint,
however searching through the documentation I can only find references
about how to create new databases that are completely memory
On Wed, Aug 6, 2008 at 6:26 PM, Brown, Daniel [EMAIL PROTECTED] wrote:
Good afternoon list,
I would like to load my current database file completely into memory,
mostly as an experiment to check SQLite's maximum memory footprint,
however searching through the documentation I can only find
Stephen Oberholtzer wrote:
On Wed, Aug 6, 2008 at 6:26 PM, Brown, Daniel [EMAIL PROTECTED] wrote:
Good afternoon list,
I would like to load my current database file completely into memory,
mostly as an experiment to check SQLite's maximum memory footprint,
however searching through the
On Wed, Aug 06, 2008 at 03:26:30PM -0700, Brown, Daniel scratched on the wall:
Good afternoon list,
I would like to load my current database file completely into memory,
mostly as an experiment to check SQLite's maximum memory footprint,
however searching through the documentation I can only
Hi Stephen Woodbridge,
(although it might
be an interesting academic exercise to make a VFS port of SQLite
that uses
memory arrays for read/write ops.)
Do u have any ref impl of this kind?
regards
ragha
20 matches
Mail list logo