Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #95259 > unrolled thread

Re: Data integrity problem with sqlite3

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: Data integrity problem with sqlite3 Chris Angelico <rosuav@gmail.com> - 2015-08-11 22:44 +1000

#95259 — Re: Data integrity problem with sqlite3

On Tue, Aug 11, 2015 at 10:37 PM, Frank Millman <frank@chagford.com> wrote:
> My PostgreSQL is inaccessible at the moment as I am moving machines around,
> but I have tested it with MS SQL Server, and it behaves as expected – the
> transaction is fully rolled back and nothing is committed to the database.

Does MS SQL offer any hints in its logs? Can you enable full statement
logging, and then grep it for anything that doesn't begin INSERT or
UPDATE or SELECT?

> BTW, I am not using sqlite3 ‘in production’. Rather, I offer a choice of 3
> databases to my users – PostgreSQL, SQL Server, and sqlite3, so I have to
> make sure that my program works with all of them.

Ah. Comes to the same thing, anyway; if you can't get enough info out
of one backend, verify it with the others.

ChrisA

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web