Today we have a closer look into dolt a SQL Server database combined with the functionalities of git.
We are following the introduction section on the DoltHub.
We were using DevPod (base image ubuntu) on a MacBook (m1) and creating a workspace cloning an empty GitHub repository.
To install dolt on Ubuntu you can use the following command
sudo bash -c 'curl -L https://github.com/dolthub/dolt/releases/latest/download/install.sh | sudo bash'You can find other options to install it on Windows, Mac or using Docker here.
Set the configuration data for dolt exactly you would do it for git
dolt config --global --add user.name "your name"
dolt config --global --add user.email "your email"Create a data folder
mkdir data
cd dataInitialise a new dolt database in the current folder. The name of the database is the folder name.
dolt initCheck data repository log
dolt log --onelineWe will use the employee.csv file in the root of the repository to add data to the database using the table import and the --create-table option which creates a new table "employee" with the primary key "id".
dolt table import --create-table --pk id employee ../employees.csvDolt works like git and has a staging area. You can see the status of the database using the status command.
dolt statusYou can query the data using SQL
dolt sql -q "select * from employee"Add the changes to the staging area
dolt add .Commit the changes to the database
dolt commit -m "feat: add employee table"You can create a new branch using the branch command
dolt checkout -b feature/employeeYou can add new data to the employee table
dolt sql -q "insert into employee values (21, 'Konrad','Zuse')Add the changes & commit the changes
dolt add .
dolt commit -m "feat: add Konrad Zuse to employee table"You can switch back to the main branch using the checkout command
dolt checkout mainYou can merge the feature branch into the main branch
dolt merge feature/employee