Skip to content

use NullPool for SQLite by default for non-:memory: connections ? #1921

Closed
@sqlalchemy-bot

Description

@sqlalchemy-bot

Migrated issue, originally created by Michael Bayer (@zzzeek)

it shouldn't be too hard these days to just switch off of a ":memory:" connection or not and just use NullPool for file-based connections. Its a little dated for us to still be doing threadlocal-by-default here.


Attachments: sqlite_nullpool.patch

Activity

sqlalchemy-bot

sqlalchemy-bot commented on Sep 19, 2010

@sqlalchemy-bot
CollaboratorAuthor

Michael Bayer (@zzzeek) wrote:

attached patch is complete. Also removes the usage of "threadlocal" pool with the "threadlocal" engine strategy (not really needed).

sqlalchemy-bot

sqlalchemy-bot commented on Nov 18, 2010

@sqlalchemy-bot
CollaboratorAuthor

Michael Bayer (@zzzeek) wrote:

put a note in the SQLite docs also about the "pool_threadlocal" flag, which will help a lot of folks with locking in a single thread.

sqlalchemy-bot

sqlalchemy-bot commented on Dec 8, 2010

@sqlalchemy-bot
CollaboratorAuthor

Michael Bayer (@zzzeek) wrote:

61840ab

sqlalchemy-bot

sqlalchemy-bot commented on Dec 8, 2010

@sqlalchemy-bot
CollaboratorAuthor

Changes by Michael Bayer (@zzzeek):

  • changed status to closed
added this to the 0.7.0 milestone on Nov 27, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @sqlalchemy-bot

        Issue actions

          use NullPool for SQLite by default for non-:memory: connections ? · Issue #1921 · sqlalchemy/sqlalchemy