I would like to bring an apparent SQLite bug to the attention of the SQLite
core
developers as a ticket, where build fails on sun4-solaris-64int 2.10.
This problem was reported to the DBD::SQLite (Perl binding) developers as an
automatically generated smoke tester ticket which can be seen here
"Artur Reilin" schrieb im
Newsbeitrag news:op.u5vno6hp1pq...@rear...
> If you are using something like an log system it
> would be better in this way, but in apps like an
> shop what wouldn't be so great. (thinking about
> ebay with the bets and such..)
Of course, but I think I made that alread
If you are using something like an log system it would be better in this
way, but in apps like an shop what wouldn't be so great. (thinking about
ebay with the bets and such..)
But the idea itself is nice.
Am 02.01.2010, 00:14 Uhr, schrieb Olaf Schmidt :
>
> "Artur Reilin" schrieb im
> News
"Artur Reilin" schrieb im
Newsbeitrag news:op.u5vlqcps1pq...@rear...
> But that means, if there is a power off or an system crash,
> your data which you send at this moment, goes nirvana.
Yep, as I wrote at the end of my post:
"...in case of an unexpected Close of the App (due to
whatever
But that means, if there is a power off or an system crash, your data
which you send at this moment, goes nirvana. But indeed it would be faster
and also would save the hard disc from some writing operations.
Am 01.01.2010, 23:33 Uhr, schrieb Olaf Schmidt :
>
> "Bert Nelsen" schrieb
> im New
"Bert Nelsen" schrieb
im Newsbeitrag
news:a5ffd531001010911r3de60ec1o44e2c14bce7a7...@mail.gmail.com...
> So SQLite looks at both the database on the disk
> and in memory?
> Wouldn't that be difficult???
Of course... ;-)
And what's so amazing with the SQLite-engine -
is, that all that comes in
That did the trick. THANKS and Happy New Year!
On Jan 1, 2010, at 4:00 PM, Igor Tandetnik wrote:
> Chris Vadnais wrote:
>> Is there a way to set the values in a given column to a series of sequential
>> numbers?
>>
>> For example, I have a Column called "qid" and 1002 rows. I would like to
>>
Chris Vadnais wrote:
> Is there a way to set the values in a given column to a series of sequential
> numbers?
>
> For example, I have a Column called "qid" and 1002 rows. I would like to tell
> SQL to set the values in "qid" to 1, 2, 3, 4, etc.
> all the way down to 1002.
update mytable set q
Is there a way to set the values in a given column to a series of sequential
numbers?
For example, I have a Column called "qid" and 1002 rows. I would like to tell
SQL to set the values in "qid" to 1, 2, 3, 4, etc. all the way down to 1002.
Thanks
___
On Fri, Jan 1, 2010 at 8:11 PM, Bert Nelsen wrote:
> So SQLite looks at both the database on the disk and in memory?
> Wouldn't that be difficult???
>
I don't think that only the memory can be used. Imagine you can have a very
big transaction, 1,000,000 inserts. As long as I understand the
archi
Bert Nelsen wrote:
> So SQLite looks at both the database on the disk and in memory?
> Wouldn't that be difficult???
The in-memory cache is an integral part of the architecture. The whole
transaction model depends on it in large part. For details, see
http://www.sqlite.org/arch.html
http://www.s
So SQLite looks at both the database on the disk and in memory?
Wouldn't that be difficult???
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Bert Nelsen wrote:
> By "corrupted" (the meaning of this word seems to differ depending on the
> user's perspective) you mean that the db is really destroyed and cannot be
> opened anymore?
Yes it's possible, if the power loss occurs at just the wrong moment.
> Another question would be: When I u
> Another question would be: When I use transactions, and I said
> ".BeginTrans"
> and insert new records and then, before saying ".CommitTrans", I query the
> records, they seem to be already saved. Can you tell me why this is so?
> Does
> a select command automatically trigger a ".CommitTrans"?
>
Hello Olaf!
Thanks again for the message.
By "corrupted" (the meaning of this word seems to differ depending on the
user's perspective) you mean that the db is really destroyed and cannot be
opened anymore?
Currently I am working on an application that tracks something like a GPS
signal, and if a s
"Bert Nelsen" schrieb
im Newsbeitrag
news:a5ffd530912311004p26a7cc5k1f1bf6f671bef...@mail.gmail.com...
> Your .Sychronous = False property does everything
> as fast as I want, and I am not afraid of losing some
> user data (it's not a critical application) but
> I am very much afraid of having a
16 matches
Mail list logo