Skip to content

SQL server

Lime CRM uses Microsoft SQL Server as database.

Configuration

Each Lime Application on a Lime Server can have different connection details. The can be set in the application.yaml file.

Other

global: 
    # Pessimistic connections means that we check the status of a
    # connection each time we request it from the engine. We do this
    # by doing a 'SELECT 1'.
    # This may be needed in situations where the database connections are
    # forcibly closed by the database server.
    pessimistic_connections: True

database: {
    # Should database info from registry be cached
    cache_databases_in_registry: True
    # Switch if database info should be loaded from registry or
    # application.yaml. This setting is ignored on UNIX
    load_databases_from_registry: True
    engine: 
        pool_size: 20
        max_overflow: 5