Connections
Browse a read-only sample of a Shiny.DocumentDb store. Run it yourself to point the tool at your own databases.
| Provider | Connection | Example |
|---|---|---|
| SQLite sqlite | File (uploadable) | Data Source=app.db |
| SQLCipher (encrypted SQLite) sqlcipher | File (uploadable) | Data Source=encrypted.db |
| PostgreSQL postgres | Server | Host=localhost;Port=5432;Database=mydb;Username=postgres;Password= |
| SQL Server mssql | Server | Server=localhost,1433;Database=mydb;User Id=sa;Password=;TrustServerCertificate=true |
| MySQL mysql | Server | Server=localhost;Port=3306;Database=mydb;User Id=root;Password= |
| MariaDB mariadb | Server | Server=localhost;Port=3306;Database=mydb;User Id=root;Password= |
| Oracle (23ai+) oracle | Server | User Id=myuser;Password=;Data Source=localhost:1521/FREEPDB1 |
| DuckDB duckdb | File (uploadable) | Data Source=analytics.duckdb |
| CockroachDB cockroach | Server | Host=localhost;Port=26257;Database=mydb;Username=root;SSL Mode=Disable |