Search…
DoltHub
This is how we keep our data stream safe and accurate.

Getting Started with Dolthub

dolt/quickstart.md at main Β· dolthub/dolt
GitHub
Here’s our dolt org.
There's some great video tutorial content for using DoltHub if you learn best that way.
Anyone can create a Pull Request to be merged into the database via the SQL UI at DoltHub, SQL editor integration, command line, or Python.

Useful statements

​Supported statements are limited, so dolt is not great for managing a bunch of schemas.
Spreadsheets
Dolt has a guide here for spreadsheets generally, including ODBC setup. Using the CLI, first ensure you’ve initialized the repo you’d like to pull from. Export a table like this:
1
dolt table export source_types > source_types.csv
2
dolt table export <table_name> > <file_name>
Copied!
Add new files
1
dolt table import -c --pk <primary_key> <table_name> <file_name>
2
dolt table import -c --pk name format_types format_types.csv
Copied!
Use dolt add . to start tracking all new files in the directory.

Run two Dolt repos with sql-server

Dolt's documentation on this is here.
There are two ways to run the dolt server with multiple databases served in one instance, in which you can use use db_name to switch databases.

Method 1

1
dolt sql-server -H 0.0.0.0 -P 3306 -u root -p root123 --multi-db-dir /path_to_dir_that_hosts_multi_repos/
Copied!

Method 2

Create a config file, example.cnf:
1
log_level: info
2
​
3
behavior:
4
read_only: false
5
autocommit: true
6
​
7
user:
8
name: root
9
password: "root123"
10
​
11
listener:
12
host: 0.0.0.0
13
port: 3306
14
max_connections: 10
15
read_timeout_millis: 28800000
16
write_timeout_millis: 28800000
17
18
databases:
19
- name: richardji_datasets
20
path: /home/oracle/work/pdap/dolt/richardji_datasets
21
- name: rji_test
22
path: /home/oracle/work/pdap/dolt/rji_test
23
​
24
performance:
25
query_parallelism: null
Copied!
Then run it with:
1
dolt sql-server --config my2.cnf
Copied!