Point to local duckdb instance with database connector

[vacquah]

Looking to connect to a local instance of duckdb. Note that my observable notebook (2.0) runs in a python virtual env, so my duckdb instance lives outside of this.

In my database.json file i have :

{
  "airquality": {
    "type": "postgres",
    "host": "10.x.x.x",
    "port": "5432",
    "username": abc",
    "password": "123",
    "database": "postgres",
    "ssl": false
  },
  "fintech": {
    "type": "duckdb",
    "path": "../../duckdbProjects/fintech-project/db/fintech.duckdb"
  }
}

Where the path for db is relative to where the duckdb database file lives. Is this the right way to do it? The postgres connection works fine.

[mbostock]

It’s databases.json (plural), not database.json (singular). The full path relative to the notebook should be:

.observable/databases.json

Try renaming your database configuration file that and see? (The error “database not found” suggests that it isn’t finding the definition of the “fintech” database.)

[vacquah]

@mbostock all set , thank you. I did have the correct spelling for the database config file ( was a typo here), however my error was that I had placed the databases.json file in another project directory ( project1/.observable/databases.json). I needed to create the same for this new project. Is there a way to set this globally ?

I also had to do this ( to avoid concurrency issues )

{
  "duckdb-fintech": {
    "type": "duckdb",
    "path": "../../duckdbProjects/fintech-project/db/fintech.duckdb",
    "options": {
      "access_mode": "read_only"
    }
  }
}

[mbostock]

There’s not a way to share configuration files across projects (folders), no. But you can have multiple notebooks in the same folder. And you could use a symlink for your databases.json file if you don’t want to copy it into separate projects.

Eventually, we’ll support having multiple folders within the project to allow more organization of notebooks, but I still think we’d just have one .observable (and one .observable/databases.json) to configure the project.