[{"_1":2,"_154":-5,"_155":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_133":134},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":17},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_83":-5,"_84":85,"_124":-5,"_125":11,"_126":17,"_127":11,"_128":-5,"_129":11,"_130":-5,"_131":132},"canonicalUrl","https://hub.docker.com/r/sitebay/dolt/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","sitebay","reponame","dolt","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":31,"_44":11,"_45":46,"_47":48,"_49":50,"_52":31,"_28":29,"_53":54,"_55":40,"_56":57,"_58":59,"_60":61,"_62":-5,"_63":57,"_64":65,"_66":11,"_67":29,"_68":69,"_74":11,"_75":76,"_80":29,"_81":82},"categories",[],"content_types",[40],"image","date_registered","2020-07-28T04:45:26.887583Z","description","is_private","last_updated","2020-07-28T04:54:17.4773Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[51],"application/vnd.docker.container.image.v1+json","name","pull_count",1628,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","## Dolt\n\nDolt is Git for data!\n\nDolt is a relational database, i.e. it has tables, and you can execute SQL queries against those tables. It also has version control primitives that operate at the level of table cell. Thus Dolt is a database that supports fine grained value-wise version control, where all changes to data and schema are stored in commit log.\n\nIt is inspired by RDBMS and Git, and attempts to blend concepts about both in a manner that allows users to better manage, distribute, and collaborate on, data.\n\nWe also built [DoltHub](https://www.dolthub.com), a cloud based storage solution for hosting Dolt databases, that facilitates collaborative management of databases. We host public data for free!\n\n## Dolt CLI\n\n```\n$ dolt\nValid commands for dolt are\n init - Create an empty Dolt data repository.\n status - Show the working tree status.\n add - Add table changes to the list of staged table changes.\n reset - Remove table changes from the list of staged table changes.\n commit - Record changes to the repository.\n sql - Run a SQL query against tables in repository.\n sql-server - Starts a MySQL-compatible server.\n log - Show commit logs.\n diff - Diff a table.\n blame - Show what revision and author last modified each row of a table.\n merge - Merge a branch.\n branch - Create, list, edit, delete branches.\n checkout - Checkout a branch or overwrite a table from HEAD.\n remote - Manage set of tracked repositories.\n push - Push to a dolt remote.\n pull - Fetch from a dolt remote data repository and merge.\n fetch - Update the database from a remote data repository.\n clone - Clone from a remote data repository.\n creds - Commands for managing credentials.\n login - Login to a dolt remote host.\n version - Displays the current Dolt cli version.\n config - Dolt configuration.\n ls - List tables in the working set.\n schema - Commands for showing and importing table schemas.\n table - Commands for copying, renaming, deleting, and exporting tables.\n conflicts - Commands for viewing and resolving merge conflicts.\n```\n\n## Installation\n\nThese installation instructions assume that you have Go installed, and that `go` is in your path.\n\n### From Latest Release\n\nTo install on Linux or Mac based systems run:\n\n```sudo bash -c 'curl -L https://github.com/liquidata-inc/dolt/releases/latest/download/install.sh | bash'```\n\nThis will download the latest ```dolt``` release and put it in ```/usr/local/bin/```, which is probably on your ```PATH```.\n\nFor Windows, locate the latest Microsoft Installer (`.msi` file) in [releases](https://github.com/liquidata-inc/dolt/releases), and run it. This will install the latest dolt. \n\n### From Source\n\nAlternatively clone this repository and then, assuming you cloned the repository into your home directory:\n\n```\n$ cd ~/dolt/go\n$ go install ./cmd/dolt\n[...]\n$ go install ./cmd/git-dolt\n[...]\n$ go install ./cmd/git-dolt-smudge\n[...]\n```\n\nThis will install the requisite binaries at `$GOPATH/bin`, which defaults to `$HOME/go`, thus you should see something like (unless you set `$GOPATH` to something else):\n\n```\n$ ls -ltr $HOME/go/bin/\ndolt git-dolt git-dolt-smudge\n```\n\nEnsure that `$GOPATH/bin` is on your path, and then proceed.\n\n### Verify\n\nWhichever method you used, verify that your installation has succeeded as follows:\n\n```\n$ dolt\nValid commands for dolt are\n[...]\n```\n\nFinally, setup your name and email in the global config (this should be very familiar to Git users):\n\n```\n$ dolt config --global --add user.email YOU@DOMAIN.COM\n$ dolt config --global --add user.name \"YOUR NAME\"\n```\n\nYou're all set to start getting value from Dolt!\n\n## First Repository\n\nSuppose we want to create a table of state populations from 1790 in Dolt, then:\n\n```\n$ mkdir state-populations\n$ cd state-populations\n```\n\nInitialize the directory, and load some data:\n\n```\n$ dolt init\nSuccessfully initialized dolt data repository.\n$ dolt sql -q \"create table state_populations ( state varchar(14), population int, primary key (state) )\"\n$ dolt sql -q \"show tables\"\n+-------------------+\n| tables |\n+-------------------+\n| state_populations |\n+-------------------+\n$ dolt sql -q 'insert into state_populations (state, population) values\n(\"Delaware\", 59096),\n(\"Maryland\", 319728),\n(\"Tennessee\", 35691),\n(\"Virginia\", 691937),\n(\"Connecticut\", 237946),\n(\"Massachusetts\", 378787),\n(\"South Carolina\", 249073),\n(\"New Hampshire\", 141885),\n(\"Vermont\", 85425),\n(\"Georgia\", 82548),\n(\"Pennsylvania\", 434373),\n(\"Kentucky\", 73677),\n(\"New York\", 340120),\n(\"New Jersey\", 184139),\n(\"North Carolina\", 393751),\n(\"Maine\", 96540),\n(\"Rhode Island\", 68825)'\nRows inserted: 17\n```\n\nNow let's run some SQL against it:\n\n```\n$ dolt sql -q \"select * from state_populations where state = 'New York'\"\n+----------+------------+\n| state | population |\n+----------+------------+\n| New York | 340120 |\n+----------+------------+\n```\n\nAssuming you're satisfied, create a commit as follows:\n\n```\n$ dolt add .\n$ dolt commit -m \"Add state populations from 1790\"\n$ dolt status\nOn branch master\nnothing to commit, working tree clean\n```\n\nYou've just generated your first commit to a relational database with version control!\n\nAlternatively, you can import CSV and PSV files, where the file type is inferred from the extension. Suppose your state populations are in a file:\n\n```\n$ head -n3 data.csv\nstate,population\nDelaware,59096\nMaryland,319728\n$ dolt table import -pk=state state_populations data.csv\n```\n\nNote if you do not have a file extension, i.e. your file is called `data`, Dolt will think you are trying to import from another table and thus not behave in the way you expect.\n\n## Modifying Data\n\nOverride the table with the contents of another file:\n\n```\n$ dolt table import --update-table \n```\n\nTo add or update rows, use the SQL interface:\n\n```\n$ dolt sql --query 'INSERT INTO state_populations VALUES (\"My State\", 0)'\nRows inserted: 1\n$ dolt sql --query 'UPDATE state_populations SET population=1 where state=\"My State\"'\nRows updated: 1\n```\n\nNow you can see that you have changes to a table that are not staged for commit, in the same way that Git does not automatically stage modified files for commit:\n\n```\n$ dolt status\nOn branch master\nChanges not staged for commit:\n (use \"dolt add

\" to update what will be committed)\n (use \"dolt checkout

\" to discard changes in working directory)\n\tmodified: state_populations\n$ dolt diff\ndiff --dolt a/state_populations b/state_populations\n--- a/state_populations @ u0b70pnkhsl1s6rmc6o44nlphdslgipj\n+++ b/state_populations @ gbk38aq4o35hfj692fnb32apbpfpamu0\n+-----+----------+------------+\n| | state | population |\n+-----+----------+------------+\n| + | My State | 1 |\n+-----+----------+------------+\n```\n\nIf you're happy with the changes, you can go ahead and commit them:\n\n```\n$ dolt add state_populations\n$ dolt commit -m \"Added 'My State'\"\n```\n\nWell done, you updated a table, and committed your changes!\n\n## Simple Branching Workflow\n\nWhen making changes it is advisable to create a new branch which will serve as the workspace for your changes. Choose a short branch name that describes the work you are planning to do. Again, this works identically to Git:\n\n dolt checkout -b \n\nOnce you've made your changes, add and commit the modified tables like you did previously. Once your work is done and you are ready to get all your changes back into the master branch run:\n\n dolt checkout master\n dolt merge \n\nThen you'll need to add and commit the merged data:\n\n dolt add .\n dolt commit -m \"Merge work from into master\"\n\n## Adding Remotes\n\nDolt supports remotes in a similar manner to Git. Liquidata, the company behind Dolt, also created DoltHub, a hosting service for Dolt databases. In the following we use DoltHub as an example for setting up a remote.\n\nIf you haven't done so already, setting up your default servers will make it easier to add and clone remotes\n\n```\n$ dolt login\n[...]\n```\n\nWhich should open a browser window where you can create a credential for HTTPS. Upon successful creation the following will appear in the shell:\n\n```\nKey successfully associated with user: youusername email you@youremail.com\n```\n\nNext you'll want to make sure you've created the remote at https://www.dolthub.com . Once created you can add the remote. As an example, if the repository is created under an organization named \"org\", with the name \"repo\" you could add the remote like so:\n\n dolt remote add origin org/repo\n\nOnce the remote is added viewing the remote using the command:\n\n dolt remote -v\n\nshould show something like this:\n\n origin https://doltremoteapi.dolthub.com/org/repo\n\nIf you've created the repository on the web and added a remote, you should be able to push the branch \"master\" to the remote named \"origin\" like so\n\n dolt push origin master\n\nOnce that is succeeded others can clone the repository (assuming you've given them permission.)\n\n dolt clone org/repo\n\n## Interesting Datasets to Clone\n\nJust like Git, run `dolt clone Liquidata/word-net` to get a clone from DoltHub of the WordNet repository locally once you have run ```dolt login``` to log in to [DoltHub](https://www.dolthub.com).\n\n- WordNet: https://www.dolthub.com/repositories/Liquidata/word-net\n- ImageNet: https://www.dolthub.com/repositories/Liquidata/image-net\n- Google Open Images: https://www.dolthub.com/repositories/Liquidata/open-images \n- Iris Classification: https://www.dolthub.com/repositories/Liquidata/classified-iris-measurements \n- Public Holidays: https://www.dolthub.com/repositories/oscarbatori/holidays \n- IP Address to Country: https://www.dolthub.com/repositories/Liquidata/ip-to-country\n\n## Other remotes\n\ndolt also supports directory, aws, and gcs based remotes:\n\n- file - you can use a directory as a remote that can be pushed to, cloned, and pulled from just like any other remote by providing a file uri for the directory\n\n dolt remote add file:///Users/xyz/abs/path/\n\n- aws - you can use your aws cloud resources directly (If you are interested in trying this contact the dolt team directly as we are still writing documentation).\n\n dolt remote add aws://dynamo-table:s3-bucket/database\n\n- gs - you can use a GCS bucket as well. Setup here should be straight forward. You'll need to create a gcs bucket, and you'll need to use the gcloud auth login command in order to setup your credentials.\n\n dolt remote add gs://gcs-bucket/database\n\n## Issues\n\nIf you have any issues with Dolt, find any bugs, or simply have a question, feel free to file an issue!\n\n# Credits and License\n\nDolt relies heavily on open source code and ideas from the [Noms](https://github.com/attic-labs/noms) project. We are very thankful to the Noms team for making this code freely available, without which we would not have been able to build Dolt so rapidly.\n\nDolt is licensed under the Apache License, Version 2.0. See\n[LICENSE](https://github.com/liquidata-inc/dolt/blob/master/LICENSE) for\ndetails.\n","has_starred","hub_user","immutable_tags_settings",{"_70":11,"_71":72},"enabled","rules",[73],".*","is_automated","permissions",{"_77":17,"_78":11,"_79":11},"read","write","admin","user","storage_size",49133474,"orgData","recentTags",[86],{"_87":40,"_88":89,"_90":91,"_92":93,"_94":95,"_45":113,"_114":89,"_115":29,"_116":51,"_52":117,"_118":119,"_120":104,"_121":113,"_122":61,"_123":17},"content_type","creator",10130170,"full_size",49128309,"id",110682614,"images",[96],{"_97":98,"_99":100,"_101":102,"_103":104,"_105":106,"_107":108,"_109":102,"_110":-5,"_111":91,"_58":61,"_112":-5},"architecture","amd64","digest","sha256:8fc6917517fa15bb63bab86b9d26d458e35485a63384582319d7ad077f64adc8","features","","last_pulled","2026-09-24T07:34:11.54876538Z","last_pushed","2020-07-28T04:54:18Z","os","linux","os_features","os_version","size","variant","2020-07-28T04:54:17.126391Z","last_updater","last_updater_username","media_type","latest","repository",9532890,"tag_last_pulled","tag_last_pushed","tag_status","v2","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":135,"_142":143,"_131":152,"_153":11},{"_36":136,"_38":137,"_41":42,"_43":31,"_44":11,"_45":46,"_47":48,"_49":138,"_52":31,"_28":29,"_53":54,"_55":40,"_56":57,"_58":59,"_60":61,"_62":-5,"_63":57,"_64":65,"_66":11,"_67":29,"_68":139,"_74":11,"_75":141,"_80":29,"_81":82},[],[40],[51],{"_70":11,"_71":140},[73],{"_77":17,"_78":11,"_79":11},"tags",{"_144":59,"_145":-5,"_146":-5,"_147":148},"count","next","previous","results",[149],{"_87":40,"_88":89,"_90":91,"_92":93,"_94":150,"_45":113,"_114":89,"_115":29,"_116":51,"_52":117,"_118":119,"_120":104,"_121":113,"_122":61,"_123":17},[151],{"_97":98,"_99":100,"_101":102,"_103":104,"_105":106,"_107":108,"_109":102,"_110":-5,"_111":91,"_58":61,"_112":-5},[],"canDeleteTags","actionData","errors"]

sitebay/dolt

Tags for sitebay/dolt