DEV Community: timsehn

So you want Data Quality Control

timsehn — Thu, 08 Dec 2022 20:21:09 +0000

I wrote an opus on data quality control.

I cover:

The evolution of the modern data stack.
A model to think about data quality.
a survey of tools in the space.

Learn SQL using Dolt

timsehn — Mon, 01 Jun 2020 18:47:24 +0000

Hi dev.to,

I'm the CEO of the company that built Dolt. Dolt is a SQL database with git-style versioning. DoltHub is a place on the internet to share Dolt databases.

We think Dolt is an especially good way to learn SQL. Dolt is almost effortless to set up, contains real data, you can make write queries without fear, examine your diffs, and publish your work to the DoltHub community.

We wrote a blog post expanding on all those topics here:

https://www.dolthub.com/blog/2020-06-01-learn-sql-dolt/

Check it out!

A better way to publish CSVs

timsehn — Mon, 01 Jun 2020 18:43:37 +0000

I'm the CEO of the company that built Dolt and DoltHub(https://www.dolthub.com). Dolt is as if Git and MySQL had a beautiful baby. DoltHub is GitHub for Dolt, a place on the internet to share Dolt repositories.

I wrote a blog about how to publish CSVs on DoltHub so you can do it too.

https://www.dolthub.com/blog/2020-04-29-dolt-dolthub-publish-csv/

This blog uses the Tatoeba sentence translation database as am example. It's a collaborative database of sentence translations that is published weekly.

Check it out and publish some data. Pretty please.

A better way to publish CSVs

timsehn — Thu, 30 Apr 2020 00:21:55 +0000

I'm the CEO of the company that built Dolt and DoltHub. Dolt is as if Git and MySQL had a beautiful baby. DoltHub is GitHub for Dolt, a place on the internet to share Dolt repositories.

I wrote a blog about how to publish CSVs on DoltHub so you can do it too.

This blog uses the Tatoeba sentence translation database as an example. It's a collaborative database of sentence translations that is published weekly.

Check it out and publish some data. Pretty please.

How to become an open data publisher using Dolt

timsehn — Fri, 10 Apr 2020 16:54:03 +0000

Dolt is a SQL database with Git-style versioning. In Git the unit of versioning is files. In Dolt, the unit of versioning is SQL tables. Dolt will eventually support 100% of the Git command line and 100% of MySQL SQL. Moreover, anything you can do on the Git command line, you will be able to do via SQL. Right now, we're at about 90% coverage of the Git command line and SQL.

DoltHub is a place to share Dolt repositories. In the Git context, you clone, push, and pull from DoltHub as if it was a remote. Like GitHub, DoltHub is a central place to collaborate on Dolt data projects. You can create or find public data to work on. You can give read and write permissions to your Dolt repositories to other users. You can have them create pull requests to improve your data. In the future we imagine DoltHub issues and releases. We also expect to invent some new data-specific features.

Sound interesting? We think so.

In an earlier blog post, we showed you you how to get started as a data consumer.

In this blog post, we'll show you how to publish data for other people to use.

Continuous Integration/Deployment for Data

timsehn — Thu, 09 Apr 2020 00:01:56 +0000

Ever wanted to run continuous integration or continuous deployment on a database. With Dolt and DoltHub Webhooks now you can!

Dolt for Git Noobs

timsehn — Fri, 03 Apr 2020 16:56:02 +0000

TLDR

Dolt is a SQL database with built-in Git versioning, branching, and distribution semantics that makes collaborating on and distributing data effortless.
What Git does for files, Dolt does for data.
Where Git versions files, allowing for fine-grained control, tracking, and management of files over time, Dolt versions data and database schema, allowing for fine-grained control throughout an entire Dolt repository and every branch it houses.
Where Git supports the branching and merging of files for true user collaboration, Dolt supports branching and merging of data and databases, finally giving data producers and data consumers the tool they need to truly collaborate on data in a meaningful way.

If this is interesting and you don't know much about Git or SQL databases, read the full blog on DoltHub

Dolt is Git For Data

timsehn — Wed, 01 Apr 2020 23:54:55 +0000

Dolt is an open source SQL database with Git-style versioning. In Git the unit of versioning is files. In Dolt, the unit of versioning is SQL tables. Dolt will eventually support 100% of the Git command line and 100% of MySQL SQL. Moreover, anything you can do on the Git command line, you will be able to do via SQL. Right now, we're at about 90% coverage of the Git command line and SQL.

Sound interesting? We think so. This blog post is a guide to getting started.