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

Groups > comp.lang.python > #98577

Re: Commit: postgres on cursor and sqlite on connection

Show all headers | View raw

Cecil Westerhof <Cecil@decebal.nl> writes:

> I have written some code I like to use with several databases. At the
> moment sqlite and postgres. It looks like with progres I can use:
>   cursor.execute('COMMIT;')
> but that with sqlite I need to use:
>     conn.commit()
>
> Is this true, or am I doing something wrong?

There might be differences between various database interface libraries.
I am using "psycopg" to interface with Postgres - and which it,
you can also use "conn.commit" (as with "sqlite").

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Commit: postgres on cursor and sqlite on connection Cecil Westerhof <Cecil@decebal.nl> - 2015-11-09 16:44 +0100
  Re: Commit: postgres on cursor and sqlite on connection Ian Kelly <ian.g.kelly@gmail.com> - 2015-11-09 10:46 -0700
  Re: Commit: postgres on cursor and sqlite on connection dieter <dieter@handshake.de> - 2015-11-10 07:53 +0100

csiph-web