Client APIs
Connection
The special value `:memory:` can also be postfixed with a name, for example: `:memory:conn3`.
When a name is provided, subsequent `duckdb.connect` calls will create a new connection to the same database, sharing the catalogs (views, tables, macros etc..).  
Using `:memory:` without a name will always create a new and separate database instance.  
#### Default Connection {#docs:api:python:dbapi::default-connection}  
By default we create an (unnamed) **in-memory-database** that lives inside the `duckdb` module.
Every method of `DuckDBPyConnection` is also available on the `duckdb` module, this connection is what's used by these methods.  
The special value `:default:` can be used to get this default connection.  
#### File-Based Connection {#docs:api:python:dbapi::file-based-connection}  
If the `database` is a file path, a connection to a persistent database is established.
If the file does not exist the file will be created (the extension of the file is irrelevant and can be `.db`, `.duckdb` or anything else).