I am trying to get my head around the operation of WAL files and an
oddity that I can't explain.
As I understand it when a transaction is committed when a DB is in WAL
mode each changed page is appended to the WAL. Multiple transactions
work in the same way until a checkpoint occurs.
The WAL has
On Tue, Nov 10, 2015 at 10:38 PM, Richard Hipp wrote:
> The inventors and developers of the SQLite database engine to all to
> whom these presents may come, Greetings: Whereas Mr. Jay Kreibich has
> exhibited detailed knowledge of the use and inner workings of SQLite
> by publishing an outstandin
On 11/10/2015 08:41 PM, Richard Hipp wrote:
> http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
Congratulations!
When SQLite is the spoon, will they give us Linux binary compatibility for the
fork?
I wonder what the knife will be ;-)
--
Christian Werner
Will MS add a connection to SQLite from VBA?
RBS
On 10 Nov 2015 8:46 pm, "Warren Young" wrote:
> On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A <
> Richard.A.Rousselot at centurylink.com> wrote:
> >
> > What no love for their own Access DB?
>
> This from the same company that gave us ODBC,
What no love for their own Access DB?
Congrats!
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Stephen
Chrzanowski
Sent: Tuesday, November 10, 2015 2:19 PM
To: SQLite mailing list
Subject: Re:
Richard Hipp Sent: Tuesday, November 10, 2015 2:41 PM
>
> http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
Congratulations!
--
This message, and any attachments, is for the intended recipient(s) only, may
conta
On Tue, Nov 10, 2015 at 7:20 PM, Christian Werner
wrote:
> I wonder what the knife will be ;-)
Maybe there is no knife this time. Just kidding.
But yeah, kudos for R. Hipp and everyone that contributed to the project.
--
Bernardo Sulzbach
This issue seems to have been introduced in one of the recent releases -
setting PRAGMA cache_size to zero is a no-op and the default (2000 pages) will
be used if it's done right after opening a database.
The reason seems to be that sPragmaNames entry for cache_size has mPragFlag
value of zero,
On 11/10/15, Jay Kreibich wrote:
>
> I want to be a Certified SQLite Professional.
>
The inventors and developers of the SQLite database engine to all to
whom these presents may come, Greetings: Whereas Mr. Jay Kreibich has
exhibited detailed knowledge of the use and inner workings of SQLite
by
On 11/10/15, Paul Sanderson wrote:
>
> As the last thing I did was a wal-checkpoint then according to the
> documentation the page should have been written to the DB (it was see
> pic below of page two of the DB) AND the salts incremented and
> randomised (section 4.3 of the file format page).
>
* Dan Kennedy:
> On 10/18/2015 10:27 PM, Florian Weimer wrote:
>> My first surprise was SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE (see
>> ?SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE?). I have found another
>> source of such snapshot failures with WAL-mode databases.
>>
>> I like to pre-compile my
On 11/10/15, Keith Christian wrote:
>
> SQLite is an integral part in numerous other commercial software systems.
>
Many of which even I don't know about :-)
--
D. Richard Hipp
drh at sqlite.org
> On Nov 10, 2015, at 2:45 PM, Warren Young wrote:
>
>> On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A > centurylink.com> wrote:
>>
>> What no love for their own Access DB?
>
> This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet, DAO,
> RDO, ADO, ADO.NET, ADO Entity Fram
Exactly. How does this happen?
On Tue, Nov 10, 2015 at 3:31 PM, Jay Kreibich wrote:
>
> > On Nov 10, 2015, at 2:45 PM, Warren Young wrote:
> >
> >> On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A <
> Richard.A.Rousselot at centurylink.com> wrote:
> >>
> >> What no love for their own Access DB
On Tue, Nov 10, 2015 at 3:35 PM, Scott Robison
wrote:
> On Nov 10, 2015 2:19 PM, "John McKown"
> wrote:
>>
>> On Tue, Nov 10, 2015 at 3:15 PM, Keith Christian <
> keith1christian at gmail.com>
>> wrote:
>>
>> > A great thing for Windows users.
>> >
>> > My only caveat is: Beware corporate press
On Nov 10, 2015 2:19 PM, "John McKown" wrote:
>
> On Tue, Nov 10, 2015 at 3:15 PM, Keith Christian <
keith1christian at gmail.com>
> wrote:
>
> > A great thing for Windows users.
> >
> > My only caveat is: Beware corporate pressure. Stay Free.
> >
> >
> ?I agree. I'm not any kind of MS fan. I sim
On Tue, Nov 10, 2015 at 3:15 PM, Keith Christian
wrote:
> A great thing for Windows users.
>
> My only caveat is: Beware corporate pressure. Stay Free.
>
>
?I agree. I'm not any kind of MS fan. I simply don't trust them _at all_.
They like to "embrace" ... "extend" ... "eliminate". ?
?They trie
Wicked. Congrats!
On Tue, Nov 10, 2015 at 2:41 PM, Richard Hipp wrote:
> http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
>
> --
> D. Richard Hipp
> drh at sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sq
http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
--
D. Richard Hipp
drh at sqlite.org
On Tue, 10 Nov 2015 14:41:28 -0500, Richard Hipp
wrote:
>http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
Wow! High praise -- which you deserve.
--
Ned
A great thing for Windows users.
My only caveat is: Beware corporate pressure. Stay Free.
On Tue, Nov 10, 2015 at 12:41 PM, Richard Hipp wrote:
> http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/
>
> --
> D. Richard Hipp
> drh at sqlite.org
>
On Nov 10, 2015, at 1:29 PM, Rousselot, Richard A wrote:
>
> What no love for their own Access DB?
This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet, DAO, RDO,
ADO, ADO.NET, ADO Entity Framework, LINQ, the registry, Access, SQL Server
Express?
https://msdn.microsoft.com
op 10-11-2015 10:53 schreef YAN HONG YE op yanhong.ye at mpsa.com:
> Hi,
> I have two table with same field:
>
> Id int,
> Content text,
> Inserttime datatime,
> Updatetime datatime
>
> I want to do this:
> If id not in the other table, then insert it,
> if id is same, and inserttime diffirent,
On 10 Nov 2015, at 9:53am, YAN HONG YE wrote:
> I don't know if exist this tool, the target is synchronize two table to the
> same except ID field.
Cannot be done in one single command. Do it by programming.
Simon.
Hi,
I have two table with same field:
Id int,
Content text,
Inserttime datatime,
Updatetime datatime
I want to do this:
If id not in the other table, then insert it,
if id is same, and inserttime diffirent, then insert it to the other table ;
if id is same, and updatetime diffirent, then update i
On 10 Nov 2015, at 8:18am, OBones wrote:
> However, using tools to read the SMART values for this harddrive, I noticed
> that it had been eating up spare sectors for quite a while.
That's actually a good suggestion for you: look at the SMART values, run any
hard disk diagnostics you have, etc
Brice Andr? wrote:
> So, my question is the following : does someone has already experienced
> performance issues on database with an HDD device starting to fail (without
> any corruption problem) ? And if yes, is it possible that those performance
> issues come with no notification in the windows
Also look for failures at the bus level. I have had cases where some
component was mucking up the bus, and got long pauses because the OS kept
resetting the bus. These caused huge pauses, like 30 seconds or more, and
due to how various OS components mostly do synchronous disk access, that
kind of
Dear all,
Thank you very much for those advices. I will try them and get back if it
does not solve the issue.
Regarding the advice of Simon on HDD starting to fail, I have one more
question. In fact, I suspected this, as my client has other problems with
his computer. But, in such case, I expecte
On 11/10/15, jungle Boogie wrote:
> On 9 November 2015 at 19:29, Richard Hipp wrote:
>> Works for me on OpenBSD 5.8. No issues at all.
>
>
> Failing on freebsd with this make file:
> https://www.sqlite.org/src/artifact/4469ed8b02a9934f
>
> Introduced with this check-in:
> https://www.sqlite.org/
On 10 November 2015 at 04:52, Richard Hipp wrote:
> On 11/10/15, jungle Boogie wrote:
>> On 9 November 2015 at 19:29, Richard Hipp wrote:
>>> Works for me on OpenBSD 5.8. No issues at all.
>>
>>
>> Failing on freebsd with this make file:
>> https://www.sqlite.org/src/artifact/4469ed8b02a9934f
>
31 matches
Mail list logo
