title |
---|
FAQ |
It's named dolt
to pay homage to how Linus Torvalds named
git:
Torvalds sarcastically quipped about the name git (which means "unpleasant person" in British English slang): "I'm an egotistical bastard, and I name all my projects after myself. First 'Linux', now 'git'."
We wanted a word meaning "idiot", starting with D for Data,
short enough to type on the command line, and
not taken in the standard command line lexicon. So,
dolt
.
We released a Postgres version of Dolt called DoltgreSQL.
However, Dolt is a production-grade version controlled database today. Dolt is 1.0. If you are ok with using a MySQL-client, we recommend using Dolt for all use cases. Doltgres is experimental.
This is a SQL variable that you can turn on for your SQL session like so:
SET @@autocommit = 1
It's on by default in the MySQL shell, as well as in most clients. But some clients (notably the Python MySQL connector) turn it off by default.
You must commit your changes for them to persist after your session
ends, either by setting @@autocommit
to on, or by issuing COMMIT
statements manually.
COMMIT
is a standard SQL statement that commits a transaction. In
dolt, it just flushes any pending changes in the current SQL session
to disk, updating the working set. HEAD stays the same, but your
working set changes. This means your edits will persist after this
session ends.
DOLT_COMMIT()
commits the current SQL transaction, then creates a
new dolt commit on the current branch. It's the same as if you run
dolt commit
from the command line.
I want each of my connected SQL users to get their own branch to make changes on, then merge them back into main
when they're done making edits. How do I do that?
We are glad you asked! This is a common use case, and giving each user their own branch is something we've spent a lot of time getting right. For more details on how to use this pattern effectively, see using branches.
Yes, it should exactly work the same as MySQL, but with fewer locks for competing writes.
It's also possible for different sessions to connect to different branches on the same server. See using branches for details.
Most of them! Check out the docs for the full list of supported features.
You can check out what we're working on next on our roadmap. Paying customers get their feature requests bumped to the front of the line.
Probably! Have you tried it? If you try it and it doesn't work, let us know with an issue or in our Discord and we'll see what we can do. A lot of times we can fix small compatibility issues really quick, like the same week. And even if we can't, we want to know about it! Our goal is to be a 100% drop-in replacement for MySQL.
Previously, Dolt automatically synced doc files from the file system to the
dolt_docs
table. This process is now manual and performed with the dolt docs
CLI command. dolt docs upload [doc name] [file name]
reads a file into the
dolt_docs
table with the given name. dolt docs print [doc name]
prints a
doc with the given name to stdout.
Dolt has a command called read-tables that reads the tables at a remote, commit pair and creates a new Dolt database without any history. This new database is often much smaller than the database it was created from. Note, this new database cannot be merged with the database it was created from. It is a new thing.
Note, a remote can be local to your filesystem using filesystem remotes.
You can also dolt dump
the database and import
the dump to a new database using dolt sql
.
Dolt collects anonymous usage metrics and sends them over the network to DoltHub metrics servers. No
personally identifiable information is collected. You can disable this behavior by setting the
metrics.disabled
config key:
dolt config --global --add metrics.disabled true