-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 06/23/2010 08:50 PM, Peng Yu wrote:
> Is there a way to use Shebang for sqlite3 script?
What happened when you tried it?
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.moz
On Tue, May 25, 2010 at 3:25 PM, Black, Michael (IS)
wrote:
> sqlite3 main.db < main.txt
>
> or
> cat main.txt | sqlite3 main.db
>
> or
>
> echo "create table tbl1(one varchar(10), two smallint);" | sqlite3 main.db
Is there a way to use Shebang for sqlite3 script?
http://en.wikipedia.org/wiki/Sh
I'm trying to following the convention. If I'm going to save sql
commands in a script and run them as needed, could you let me know
what suffix people in general use? I'm thinking of the suffix '.sql',
but I'm not sure what the most common one in sqlite community.
--
Regards,
Peng
___
I only find html format document but not pdf format. In case I miss
anything, could you please let me know if there are pdf format of the
complete document of sqlite3?
http://www.sqlite.org/docs.html
--
Regards,
Peng
___
sqlite-users mailing list
sqlit
i don't quite get how i can wrap around triggers. My stated
case is i have to take that i have no access to application logic.
however, as you state below, having some kind of global access
to a variable, via a function call will be very useful.
net net, i see the need for simple facility like be
- Original Message
From: Jay A. Kreibich
To: General Discussion of SQLite Database
Sent: Wed, June 23, 2010 11:15:59 AM
Subject: Re: [sqlite] marking transaction boundaries
On Wed, Jun 23, 2010 at 09:19:05AM -0700, b s scratched on the wall:
> I can put the transaction identifier in
>> (2) Update the old table (t1) using this expression:
>> UPDATE OR REPLACE t1 SET f1 = (SELECT f1 FROM t2 WHERE t2.row = t1.row) WHERE
> t1.row IN (SELECT row FROM t2)
>
> 1. I dont think that "WHERE t1.row IN (SELECT row FROM t2)" is necessary
It is necessary. Otherwise all other rows will be
Is it possible in your application to try journal_mode = PERSIST? I
guess virus checkers wouldn't block writing to the file. But this way
you should be sure that journal size wouldn't be so big as for you to
want to truncate it...
Pavel
On Wed, Jun 23, 2010 at 7:02 AM, John Wood wrote:
> Hi all
Erik Wright writes:
> (2) Update the old table (t1) using this expression:
> UPDATE OR REPLACE t1 SET f1 = (SELECT f1 FROM t2 WHERE t2.row = t1.row) WHERE
t1.row IN (SELECT row FROM t2)
1. I dont think that "WHERE t1.row IN (SELECT row FROM t2)" is necessary
2. maybe you should do a little t
On Wed, Jun 23, 2010 at 09:19:05AM -0700, b s scratched on the wall:
> I can put the transaction identifier into tables via triggers.
>
> That's the million $ question. I don't know when transaction
> begins or ends! And my original question was pointing to
> a feature DRH had suggested way back i
On Wed, Jun 23, 2010 at 7:02 AM, John Wood wrote:
>
> My question is this: is there a way to make sqlite open the journal file in
> a locked manner, and keep the lock in effect while it's using it?
>
Have you tried PRAGMA locking_mode=EXCLUSIVE ?
See http://www.sqlite.org/pragma.html#pragma_lock
Hi all,
I want to update a field (f1) in a table with new data in some rows while
preserving data in the rest of the rows.
The way I am currently doing this is:
(1) Add new data into a temporary table (t2). A unique numeric identifier is
stored in the field named "row" that corresponds to eac
On Tue, Jun 22, 2010 at 08:35:14AM -0700, b s wrote:
> hi,
> long ago, drh had proposed a trigger like mechanism that
> can be invoked at the begin/end of a transaction.
> http://osdir.com/ml/db.sqlite.general/2003-04/msg00137.html
>
> the general consensus was there is no use other than up'ng
> a
Hi all,
I'm having real problems with locked sqlite journal files.
(Win32, V 3.6.23.1).
Very occasionaly, a commit fails with extended error code
SQLITE_IOERR_DELETE | SQLITE_IOERR.
It seems that the most likely cause is another application locking the file
at that point (e.g. virus checker).
I don't understand the driver for this but have you considered creating
a function that would be called as part of the insert or trigger that
would have greater access to application/sqlite internal info that might
be used to create a transaction id.
_
On 23 Jun 2010, at 6:14pm, David Bicking wrote:
> Did I miss Sqlite getting nested transactions?
>
> I thought it only had one transaction, in which you can have multiple
> savepoints, which are kind of sort of like nested transactions, but they use
> SAVEPOINT and not BEGIN. Doesn't an abort
> Store a value... I don't know when a transaction begins or ends, and I
> don't have a model of my own transaction. If i did, this conversation is moot.
And now please be so kind to explain why don't you know where
transaction begins and where it ends? Are you trying to mess up with
database belo
Did I miss Sqlite getting nested transactions?
I thought it only had one transaction, in which you can have multiple
savepoints, which are kind of sort of like nested transactions, but they use
SAVEPOINT and not BEGIN. Doesn't an abort rollback the full transaction?
David
--- On Wed, 6/23/1
On 23 Jun 2010, at 5:56pm, b s wrote:
> I get the point that transactions can be nested and i am assuming
> the begin transaction trigger only happens at the outer most transaction.
> It still is the logical envelope which will be rolled back on a default abort.
> (yes, i know one can back off to
I get the point that transactions can be nested and i am assuming
the begin transaction trigger only happens at the outer most transaction.
It still is the logical envelope which will be rolled back on a default abort.
(yes, i know one can back off to a save point).
Store a value... I don't know w
On 23 Jun 2010, at 5:19pm, b s wrote:
> I don't know when transaction
> begins or ends!
You are still ignoring the fact that transactions can be nested. One specific
INSERT command might be a member of three different transactions. Your model
allows only for one transaction per command.
If
I can put the transaction identifier into tables via triggers.
That's the million $ question. I don't know when transaction
begins or ends! And my original question was pointing to
a feature DRH had suggested way back in 2003. That would
have been the perfect way to do it (and probably the only
re
Richard Hipp writes:
[...]
>
> There are 2500+ people on this mailing list. In an effort to keep down
> noise, I immediately unsubscribe any user from whom I receive an
> out-of-office auto-reply. This policy may seem harsh, but if we don't
> maintain tight control of auto-replies, we will quic
Auto-responders aren't supposed to reply to anything that does not
have your email address on the To: line (or, sometimes, the CC: line).
Mail from a mailing list typically has the list address, and not your
own address, on the To: line. It should also do a "Reply", and not a
"Reply All
>> Ian Hardingham wrote:
>>> I'm just getting around to this. Can I do:
>>>
>>> ALTER TABLE userTable ADD upperName = upper(name) TEXT
>>>
>>> Will this retroactively and for all future inserts work?
>>
>> This is not a valid syntax, so it won't work - neither retroactively,
in the present, no
Just an idea - not checked (I never use Out-of-Office auto-replies),
but could work: if your email client is MS Outlook then probably it
would be better to not use Out-of-Office Assistant, but setup new rule
instead. Make this rule for every message except for those that sent
to sqlite-us...@sqlite
On Wed, Jun 23, 2010 at 8:57 AM, Odekirk, Shawn <
shawn.odek...@intelligrated.com> wrote:
> I will be out of the office beginning next week and was planning to turn
> on the out of office auto reply in my email client, but I would like to
> avoid spamming the group. I noticed a couple auto replies
I will be out of the office beginning next week and was planning to turn
on the out of office auto reply in my email client, but I would like to
avoid spamming the group. I noticed a couple auto replies got through to
the group earlier in the week.
Is there anything I should do on my end to minimiz
Greg,
Thanks for the explanation. So it's Sleepycat license, ok, but we still
can't use it in an application with proprietary code, right?
It would be interesting to track the progress of SQLite/BDB. Roger Binns has
noted some important issues, but granted those are solved, would you say
SQLite/
On Tue, Jun 22, 2010 at 5:22 PM, Eric Smith wrote:
> In another thread in this forum, someone says they noticed a behavior
> in sqlite version 3.6.18 different (better) than what I've observed in
> 3.6.23.1.
>
> Where can I find version 3.6.18 (or, more generally, any old version)
> for testing?
On 23 Jun 2010, at 12:53pm, Igor Tandetnik wrote:
> Ian Hardingham wrote:
>> I'm just getting around to this. Can I do:
>>
>> ALTER TABLE userTable ADD upperName = upper(name) TEXT
>>
>> Will this retroactively and for all future inserts work?
>
> This is not a valid syntax, so it won't work
Ian Hardingham wrote:
> I'm just getting around to this. Can I do:
>
> ALTER TABLE userTable ADD upperName = upper(name) TEXT
>
> Will this retroactively and for all future inserts work?
This is not a valid syntax, so it won't work - neither retroactively, in the
present, nor in the future. I
On 22 Jun 2010, at 5:44pm, Ian Hardingham wrote:
> If I have program 1 and program 2 which both open the same db file, but
> they never write to the same table (but might be reading one written by
> another), do I need to do a lot of locking? I'm not worried about race
> conditions.
SQLite w
Dear List
I have been compiling my own SQLite version with support for diacritic
sorting and searching for the iPhone. This has worked well so far,
described here in a blog post:
http://pp.hillrippers.ch/blog/2009/08/08/Static+SQLite+Library+with+Unicode+Support+for+the+iPhone/
Now when I compile
Hey guys,
If I have program 1 and program 2 which both open the same db file, but
they never write to the same table (but might be reading one written by
another), do I need to do a lot of locking? I'm not worried about race
conditions.
Thanks,
Ian
Hey guys.
I'm just getting around to this. Can I do:
ALTER TABLE userTable ADD upperName = upper(name) TEXT
Will this retroactively and for all future inserts work?
Thanks,
Ian
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:
I'd better do it this way:
int rc = sqlite3_close(db);
if ( rc == SQLITE_BUSY)
{
// shouldn't happen in a good written application but let's handle it
sqlite3_stmt * stmt;
while ((stmt = sqlite3_next_stmt(db, NULL)) != NULL) {
sq
> The question following your suggestion is how do i maintain transaction
> start and stop times? I have no control of knowing when a transaction
> starts and ends and i said earlier, i cannot use transaction hooks.
And you didn't answer my question: how will you put this transaction
identifier in
38 matches
Mail list logo
