1. REFERENCE
    9 min read

    So you want Database Versioning?

    Tim Sehn|

    Here at DoltHub, we've had a lot of success with our "So you want..." series of blog posts helping people find Dolt when they are looking for it. Dolt is a lot of things. Dolt is a version controlled database, a Git database, Git for data, data…

    Read More
Found 20 matching articles.
  1. REFERENCE
    5 min read

    Dolt Configuration

    Dolt configuration is a bit of a mess. To start, it's a union of Git and MySQL styles of configuration. Then, Dolt specific configuration is sprinkled on top. It's been on our list for a long time to consolidate and rationalize Dolt configuration...

    Read More
  2. REFERENCE
    2 min read

    Dolt SSL Authentication

    Dolt is the world's first and only version controlled SQL database. Dolt is fully MySQL-compatible. You connect to it with any MySQL client. Some MySQL clients require connection authentication using Transport Layer Security (TLS) . TLS is ofte...

    Read More
  3. REFERENCE
    4 min read

    Workbenches are Better with a Version Controlled Database

    The Dolt Workbench is a modern, open-source SQL workbench that works with any MySQL and PostgreSQL compatible database, including version controlled databases like Dolt and DoltgreSQL . We think that the workbench experience is vastly impro...

    Read More
  4. INTEGRATION
    8 min read

    Using Perl to Query Dolt Databases

    A couple of decades ago, as a brand-new CS grad just entering the world of big tech, I was given the Programming Perl book – also affectionately known as the "Camel Book". 🐪 I was told that I was now officially a Perl programmer and should lear...

    Read More
  5. REFERENCE
    9 min read

    Productionizing Dolt

    So you've been using Dolt for a while, and you are ready to take the next step and use it in production. Whether you are running your production environment on prem, or in the cloud, there are several steps you should take to ensure that your Dol...

    Read More
  6. REFERENCESQLDOLTGRES
    6 min read

    History independence, what it is and why it matters

    Dolt is the world's first and only version-controlled SQL database. It's a SQL database that you can fork, clone, branch, merge, push and pull just like a Git repository. Like files in Git, tables and other data in Dolt are content-addressed by a...

    Read More
  7. SQL
    5 min read

    Balancing Perf Trade-offs

    I ran into a performance trade-off last week attempting to improve long-running queries by changing the ways rows are structured. A more general row interface increases memory overhead but lets us skip encoding overhead. Unfortunately, joins create...

    Read More
  8. GOLANG
    10 min read

    Are Golang Generics Simple or Incomplete? A Design Study

    This comment on ycombinator lives rent-free in my head. Nothing before or since has captured my feelings on Go quite as succinctly. Take for instance, generics. Or its more precise name: parametric polymorp...

    Read More
  9. DOLTHUBREFERENCE
    7 min read

    Designing CI on DoltHub

    We recently announced support for continuous integration (CI) testing on DoltHub . This is a feature we're excited about since it allows our users to programmatically test changes on their data, instead of relying solely on human review. Fo...

    Read More
  10. REFERENCE
    4 min read

    Dolt Pro Tips

    Dolt is the world's first and only version controlled SQL database . We've been iterating on the concept for over six years now . We're the world's experts in database version control. Along the way we've learned a few things. This article...

    Read More
  11. SQLDOLTGRES
    5 min read

    Postgres's missing quality of life features

    We are hard at work building Doltgres , the Postgres-compatible version of Dolt . Dolt is the world's first and only version-controlled SQL database and is MySQL compatible, and most of us at DoltHub are more familiar with MySQL than with Postg...

    Read More
  12. SQL
    14 min read

    JSON Showdown: Dolt vs Sqlite

    Dolt was created to be the world's first truly version controlled database . We think it does a great job at that. And in the process of making Dolt, we realized that the same data structures that make Dolt fast and efficient at version control a...

    Read More
  13. REFERENCE
    2 min read

    DoltHub is HIPAA Compliant

    HIPAA certification is a security and privacy certification for organizations. HIPAA is generally required by customers dealing with health care data in the United States. This certification is very similar to Service Organization Controls 2 (SOC...

    Read More
  14. FEATURE RELEASE
    11 min read

    Continuous integration testing on data

    Continuous integration (CI) testing is a software development practice where automated tests are run against incoming code changes pushed by software developers collaborating on a code repository. If a developer pushes changes that fail to pass the...

    Read More
  15. REFERENCESQL
    7 min read

    Old School DBT

    Relational databases are an organizational step change improvement over flat files like Excel or JSON. Strict typing improves data quality and maintainability over time. Schema mutations, data versioning, lineage are tracked. And you get all of the...

    Read More
  16. SQLDOLTGRES
    7 min read

    Doltgres Correctness Update

    We are hard at work building Doltgres , the Postgres-compatible version of Dolt , the world's first and only version-controlled SQL database. We are planning a public Beta launch of Doltgres in the first quarter of 2025 , and one of the most ...

    Read More
  17. REFERENCE
    7 min read

    What's up with all these Hashes?

    When you are using Dolt, you'll come across a lot of 32 character random strings like k0j5gejn5ebnoqa3jr4pdkb6etbbrfri . For instance, each entry in your Dolt log has one. $ dolt log -n 3 commit o9vdhp8fj78nhoa2ul9fm5s7nkks5ovv ( HEA...

    Read More
  18. SQL
    4 min read

    fmt.Sprintf vs String Concat

    String concatenation isn't the most elegant looking code: getFieldName := gf . tableName + "+" + gf . ColName But it's quite a bit faster than fmt.Sprintf , which arguably looks more organized: getFieldName := fmt ....

    Read More
  19. DOLTGRESSQL
    6 min read

    Doltgres Now Supports Users

    We're continuing to make progress on DoltgreSQL , which is a version of Dolt built to be a drop-in replacement for PostgreSQL. Dolt , is a MySQL compatible database is built from the ground up with Git-influenced version control features. Th...

    Read More
  20. 7 min read

    Building at Scale, Amazon style

    A couple weeks ago, I discussed how Amazon was migrated to Git , and I mentioned the Brazil build system briefly. Brazil is a specialized version control system, which, in the past, was built on top of a SQL database. Today I'll talk a little ...

    Read More
JOIN THE DATA EVOLUTION

Get started with Dolt

Or join our mailing list to get product updates.