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

Getting Started with Dolthub

DoltHub
Dolt
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!
Last modified 4mo ago