Igor Tandetnik writes:
> Karl Tomlinson wrote:
>
>> I really meant, as a first possibility, that writing the pages
>> to the database itself would be performed during the commit
>> process after syncing the replay journal (but the database need
>> not be synced until the journal is about to be rem
Gene Allen wrote:
[SNIP]
> Enter ".help" for instructions
>
> sqlite> attach 'c:\test\b.db3' as toMerge;
>
try this:
BEGIN;
> sqlite> insert into AuditRecords select * from toMerge.AuditRecords;
COMMIT;
>
> sqlite> detach database toMerge;
>
John
--
Regards
John McMahon
Igor Tandetnik <[EMAIL PROTECTED]> wrote:Karl Tomlinson
wrote:
> Thank you for your comments.
>
>>> Karl Tomlinson wrote:
>>>
One thing I'm trying to understand is whether there was a reason
for SQLite choosing to use a rollback journal (of the steps to
undo a transaction) rat
Hello,
I was wondering if there a way in sqlite, wherein I could validate the SQL
statement (for correct grammar, resource name - column name, table name etc),
w/o having to do prepare.
Thanks in advance
--- On Wed, 7/2/08, Alex Katebi <[EMAIL PROTECTED]> wrote:
From: Alex Katebi <[EMAIL PRO
This is the way I hoped it should work, and it does.
Thanks so much Igor!
-Alex
On Wed, Jul 2, 2008 at 9:39 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> "Alex Katebi" <[EMAIL PROTECTED]>
> wrote in message
> news:[EMAIL PROTECTED]<[EMAIL PROTECTED]>
> > Below is a section from The Definitive G
"Alex Katebi" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
> Below is a section from The Definitive Guide to SQLite book
> Is this not valid any more for the newer releases of SQLite.
This is not valid anymore. See the message from Dr. Hipp in this thread:
http://archives.devshed.c
Stephen Woodbridge wrote:
> Hi all,
>
> I'm on Linux and I would like to build sqlite3 with rtree and ft3
> support. How do I do that? I have read through the docs, website, the
> wiki and have evidently missed the needed page(s).
>
> For example:
> http://www.sqlite.org/compile.html
> talks ab
Below is a section from The Definitive Guide to SQLite book
Is this not valid any more for the newer releases of SQLite.
==
Table Locks
Even if you are using just one connection, there is a special edge case that
sometimes trips
people up.
Alex Katebi <[EMAIL PROTECTED]> wrote:
> Notice that I have multiple stmts stepping over the same table at
> the
> same time.
> Why is this OK?
Why shouldn't it be?
> There isn't a table level lock?
A file level lock, even. It happily locks out other connections (of
which you have none). Bu
Igor,
Notice that I have multiple stmts stepping over the same table at the
same time.
Why is this OK? There isn't a table level lock?
When is a table locked?
Thanks,
-Alex
On Wed, Jul 2, 2008 at 5:12 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMAIL PROTECTED]> wrote
Karl Tomlinson <[EMAIL PROTECTED]>
wrote:
> Thank you for your comments.
>
>>> Karl Tomlinson wrote:
>>>
One thing I'm trying to understand is whether there was a reason
for SQLite choosing to use a rollback journal (of the steps to
undo a transaction) rather than a replay journal (o
Thank you for your comments.
>> Karl Tomlinson wrote:
>>
>>> One thing I'm trying to understand is whether there was a reason for
>>> SQLite choosing to use a rollback journal (of the steps to undo a
>>> transaction) rather than a replay journal (of the steps to perform a
>>> transaction).
I didn
Alex Katebi <[EMAIL PROTECTED]> wrote:
>> I created a test file. It is attached in this email. I can not see
>> any
>> locking happening at all.
Which part of "you should never experience any locking at all in this
scenario" did you find unclear the first time round? Why exactly are you
surprise
Pejayuk wrote:
> I still can't get this to work.
> Can someone help please.
>
> :working:
>
>
> Pejayuk wrote:
>> That is fantastic Igor.
>> Thankyou.
>> All I need to do now is work out how to get an update query to use a
>> select query to update the records from stats_memory to stats_static a
I created a test file. It is attached in this email. I can not see any
locking happening at all.
On Wed, Jul 2, 2008 at 4:25 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMAIL PROTECTED]> wrote:
> > Do I need to enable shared cache mode plus read uncommitted option?
>
> You only
Pejayuk <[EMAIL PROTECTED]> wrote:
> I still can't get this to work.
Can't get what to work? What specifically seems to be the problem?
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listi
I still can't get this to work.
Can someone please help.
:working:
I don't understand how to do this.
Many thanks in advance.
Pejayuk wrote:
>
> That is fantastic Igor.
> Thankyou.
> All I need to do now is work out how to get an update query to use a
> select query to update the records from
I still can't get this to work.
Can someone help please.
:working:
Pejayuk wrote:
>
> That is fantastic Igor.
> Thankyou.
> All I need to do now is work out how to get an update query to use a
> select query to update the records from stats_memory to stats_static after
> doing the link.
> I th
Alex Katebi <[EMAIL PROTECTED]> wrote:
> Do I need to enable shared cache mode plus read uncommitted option?
You only have one connection (one call to sqlite3_open), right? Then it
doesn't matter. "Shared" only makes a difference if there are at least
two connections to share between.
> Also yo
Do I need to enable shared cache mode plus read uncommitted option?
Also you mentioned earlier:
"(but you will experience "dirty reads" with all the attendant problems)."
What is a dirty read? What problems does it cause?
Thanks,
-Alex
On Wed, Jul 2, 2008 at 2:55 PM, Igor Tandetnik <[EMAIL PROT
On Jul 2, 2008, at 10:56 AM, Igor Tandetnik wrote:
> Karl Tomlinson <[EMAIL PROTECTED]>
> wrote:
>> I've done a little looking into journals, fsyncs, and filesystems
>> recently.
>>
>> One thing I'm trying to understand is whether there was a reason for
>> SQLite choosing to use a rollback journa
В сообщении от Wednesday 02 July 2008 22:42:48 Alex Katebi написал(а):
> Do you mean the sqlite3_busy_timeout( ) ?
> I never thought I could use it for simulating this.
> I will give that a shot.
Client don't get database busy error but sleep some time and execute query
later.
On Jul 1, 2008, at 3:53 PM, Alexey Pechnikov wrote:
> В сообщении от Tuesday 01 July 2008 23:47:50
> [EMAIL PROTECTED] написал(а):
>> On Tue, 1 Jul 2008, Alexey Pechnikov wrote:
>>> Is any difference between "CREATE INDEX ev_idx ON events(type,eid)"
>>> and "CREATE INDEX ev_idx ON events(type,e
Igor Tandetnik <[EMAIL PROTECTED]> writes:
>
> Dom Dom <[EMAIL PROTECTED]> wrote:
> > Igor Tandetnik <[EMAIL PROTECTED]> writes:
> >
> >> Would it be possible to get SQLAlchemy to cast to REAL, FLOAT or
> >> DOUBLE rather than NUMERIC?
> >
Hi Igor,
Thanks for answering.
Seems SQLAlchemy had a
Alex Katebi <[EMAIL PROTECTED]> wrote:
> Just to make myself clearer. I have one memory connection and many
> stmts.
> Each stmt multiplexes the thread. This means that a stmt could give
> up the
> thread without finalizing itself.
That's OK. It used to be that, say, a SELECT statement in progres
Alexey,
Do you mean the sqlite3_busy_timeout( ) ?
I never thought I could use it for simulating this.
I will give that a shot.
Thanks,
-Alex
On Wed, Jul 2, 2008 at 11:40 AM, Alexey Pechnikov <[EMAIL PROTECTED]>
wrote:
> В сообщении от Wednesday 02 July 2008 19:11:58 Alex Katebi написал(а):
Just to make myself clearer. I have one memory connection and many stmts.
Each stmt multiplexes the thread. This means that a stmt could give up the
thread without finalizing itself.
On Wed, Jul 2, 2008 at 11:19 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Alex Katebi <[EMAIL PROTECTED]> wr
Hi all,
I'm on Linux and I would like to build sqlite3 with rtree and ft3
support. How do I do that? I have read through the docs, website, the
wiki and have evidently missed the needed page(s).
For example:
http://www.sqlite.org/compile.html
talks about compilation options but does not say whe
Regarding:
Is it safe do set PRAGMA synchronous = OFF when a transaction-safe
file system is used?
Others will likely reply with more authority, but I strongly suspect the
answer is "No" (though it may be slightly safer than non
transaction-safe filesystems).
A transaction in the database
Hello
Is it safe do set PRAGMA synchronous = OFF when a transaction-safe file system
is used?
We are working on WinCE with TFAT (see below) - but this might be a general
question.
Regards
Daniel
TFAT:
The original file allocation table (FAT) file system enabled file modification
operations t
Dom Dom <[EMAIL PROTECTED]> wrote:
> Igor Tandetnik <[EMAIL PROTECTED]> writes:
>
>> Would it be possible to get SQLAlchemy to cast to REAL, FLOAT or
>> DOUBLE rather than NUMERIC?
>
> Hello Igor,
> Thanks for answering.
>
>> Casting to NUMERIC leaves integers as integers;
>> basically, it's a no-o
Igor Tandetnik <[EMAIL PROTECTED]> writes:
> Would it be possible to get SQLAlchemy to cast to REAL, FLOAT or DOUBLE
> rather than NUMERIC?
Hello Igor,
Thanks for answering.
>Casting to NUMERIC leaves integers as integers;
> basically, it's a no-op in your query.
Are you sure ?
When I do in my
On Wed, Jul 2, 2008 at 4:58 AM, Dan <[EMAIL PROTECTED]> wrote:
> The idea here is to use a temp table as a cache for write operations
> on the
> real table, correct? To minimize the number of writes (and therefore
> fsync()
> operations) on the real table?
Yes, that is the overall goal.
> And the
В сообщении от Wednesday 02 July 2008 19:11:58 Alex Katebi написал(а):
> I have an in memory database and a single multiplexed thread for all
> readers and writes.
> I like to be able to read tables without locking out other readers and
> writers.
> Is this possible? I don't mind writers using l
Alex Katebi <[EMAIL PROTECTED]> wrote:
> I have an in memory database and a single multiplexed thread for all
> readers and writes.
> I like to be able to read tables without locking out other readers and
> writers.
As far as I can tell, you do everything on a single thread using a
single conne
Hi Igor,
I have an in memory database and a single multiplexed thread for all
readers and writes.
I like to be able to read tables without locking out other readers and
writers.
Is this possible? I don't mind writers using locks but some of my readers
are slow and I don't want them to hold lock
Karl Tomlinson <[EMAIL PROTECTED]>
wrote:
> I've done a little looking into journals, fsyncs, and filesystems
> recently.
>
> One thing I'm trying to understand is whether there was a reason for
> SQLite choosing to use a rollback journal (of the steps to undo a
> transaction) rather than a replay
Joanne Pham <[EMAIL PROTECTED]> wrote:
> I read the online document regarding "Table Level Locking" as below:
> At any one time, a single table may have any number of active
> read-locks or a single active write lock. To read data a table, a
> connection must first obtain a read-lock. To write to a
Thanks for having the patient to answer. I really deserved an RTFM for that.
On Wednesday 02 July 2008 13:51:29 Igor Tandetnik wrote:
> sqlite3_progress_handler
--
Graeme Pietersz
http://moneyterms.co.uk/
http://pietersz.co.uk/
___
sqlite-users maili
Lol. Thanks. If you want a schema I can attach and send to you.
Woody
from his pda
-Original Message-
From: flakpit <[EMAIL PROTECTED]>
Sent: Tuesday, July 01, 2008 11:30 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Multiple constraints per table?
Harold Wood & Meyuni Gani wrot
winstonma wrote:
> Then I wonder how can I "export" my DB4Designer work to the SQLite database?
>
>
I have no idea - again, please consult the DB4Designer documentation to
find out the available export options.
___
sqlite-users mailing list
sqlite-use
"Graeme" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Is there any way to limit the time a query takes? i.e. tell sqlite to
> give up and return an error is the query is not done within a certain
> time.
sqlite3_progress_handler
Igor Tandetnik
Is there any way to limit the time a query takes? i.e. tell sqlite to give up
and return an error is the query is not done within a certain time.
>From the limits page of the documentation, it appears not to be possible, but
also not to matter too much: the explanation of limits of LIKE and GLOB
MAX( ColumnName )>No column name
- Original Message -
From: "Bob Dennis" <[EMAIL PROTECTED]>
To: "SQLite user gorup"
Sent: Wednesday, July 02, 2008 4:01 PM
Subject: [sqlite] Can't get MAX value from table
>
> Hi, I am fairly new to SQLite, and using it to replace Microsoft db in
>
"Dom Dom" <[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
>> The query, translated into sql by SQLAlchemy, is (it returns tuple
>> objects): SELECT mytable.id AS mytable_id, mytable."colA" AS
>> "mytable_colA", mytable."colB" AS "mytable_colB", mytable."colC" AS
>> "mytable_colC", CAST(
Hi,
I am using SQLAlchemy which is an very nice ORM under python:
http://www.sqlalchemy.org/
I am only an amateur.
I attach a file, which will be helpful for people willing to help me.
I am trying to make a query with a simple table containing integers and
floats.
The purpose of the query is to d
Then I wonder how can I "export" my DB4Designer work to the SQLite database?
winstonma wrote:
>
> I tried to export the the SQL command exported from DBDesigner4 is not
> going to run on SQLite. But working on MYSQL. However I saw that the
> DBDesigner4 can connect to SQLite server.
>
> I trie
We are executing a query which does a select from two different tables and does
a union.(For eg :
select phonename,uid from contact_primary_info union select name,itemId from
Contact_SIM order by 1 ASC;
)
We are seeing that Sqlite lib is calling a openFile call two times with the
same file nam
On Jul 2, 2008, at 2:12 AM, Shawn Wilsher wrote:
> Hey all,
>
> I'm working with a partitioned table setup with a permanent table and
> a temp table with the same columns and indexes. Every X time we dump
> all the records in the temp table over to the permanent one. In order
> to make selectio
В сообщении от Wednesday 02 July 2008 08:25:10 Dan написал(а):
> > I'm using SQLite 3.5.9 and there are no differents in my tests
> > between DESC
> > and default indeces. I try create index with keywork DESC for
> > optimize DESC
> > sorting but it don't work for me. My tests you can see above
Hi, I am fairly new to SQLite, and using it to replace Microsoft db in
PocketPC applications.
I am having trouble getting a MAX value from a table as follows:-
SQL = SELECT MAX( ColumnName ) FROM TableName
Set Recs = db.Execute(sql)
Result = recs(1)(ColumnName)
I get nothing in the Result
51 matches
Mail list logo