DoltHub

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!

Tools & Resources - Previous

Internal tools

Next - Tools & Resources

Splunk

Last modified 4mo ago

Copy link

Edit on GitHub

Contents

Getting Started with Dolthub

Useful statements

Run two Dolt repos with sql-server

Method 1

Method 2