zachmu

22 ms·

211.
by zachmu 4y ago
You're suffering from a failure of imagination. Consider a CMS, one of the most common forms of database backed applications. What if you could give your customer a "dev" branch of all their data to make their changes on and
212.
by zachmu 4y ago
Merge is cell-wise. If the two heads being merged edited disjoint cells, there's no conflict, they merge together. If they touched the same cell, or if one branch deleted a row another added, then you get a conflict. Merge conflicts ar
213.
by zachmu 4y ago
Lots of databases offer time travel / historical querying, including datomic, MySQL, Postgres, etc (plugins required in some cases). Dolt's unique functionality isn't time travel, although it has that. It's version contr
214.
by zachmu 5y ago
Yup, it's a real product :) If you want experiment quickly and aren't squeamish about putting your data on the internet, DoltHub is easier to get started with. DoltLab is just a (limited) self-hosted version of DoltHub.
215.
by zachmu 5y ago
You should check out dolt, does exactly what you're describing, and is a drop-in MySQL replacement: https://github.com/dolthub/dolt
216.
by zachmu 6y ago
Or for a SQL database with Git versioning semantics: https://github.com/dolthub/dolt
217.
by zachmu 6y ago
Merge conflicts get put into a special conflicts table. You have to resolve them one by one just like text conflicts from a git merge. You can do this with the command line or with SQL. It's true we don't support SSH remotes yet.
218.
by zachmu 6y ago
It's DOLT. San serif fonts.
219.
by zachmu 6y ago
Push it to DoltHub, tell them to clone it. Just like with source code.
220.
by zachmu 6y ago
We think dolt can :)
221.
by zachmu 6y ago
We have 200 GB databases in dolt format that are totally queryable. They don't work well querying on the web though - you need a local copy to query it effectively. Making web query as fast as local is an ongoing project.
222.
by zachmu 6y ago
Yup.
223.
by zachmu 6y ago
That's a great use case, let us know how we can help. We have a discord if you want to chat about it: https://discord.com/invite/RFwfYpu
224.
by zachmu 6y ago
If all you want is AS OF semantics, then SCD2 is a great match. Used it a ton in application development myself. Dolt actually makes branch and merge possible, totally different beast.
225.
by zachmu 6y ago
We totally agree on all points! Come chat with us on our discord about how we can help your org solve its problems: https://discord.com/invite/RFwfYpu
226.
by zachmu 6y ago
Say, network configuration.
227.
by zachmu 6y ago
We'll be in touch :)
228.
by zachmu 6y ago
The application backing use case is best suited for when you have parts of your database that get updated periodically and need human review. So you have a production database that you serve to your customers. Then you have a branch /
229.
by zachmu 6y ago
Merge is built in, same as with git. Same syntax too: dolt checkout -b <branch> dolt merge <branch> What do you mean git-style syncing? It has `push`, `pull`, and `fetch`.
230.
by zachmu 6y ago
Free for public repositories, and for private repos under a gig.
231.
by zachmu 6y ago
It's not just snapshots though. Dolt actually stores the tables, rows, and commits in a Merkle DAG, like Git. So you get branch and merge. You can't do branch and merge with snapshots. (You also get the full git / github tool
232.
by zachmu 6y ago
This ambiguity in sans serif fonts has actually been pretty annoying. Especially since GitHub doesn't let you choose your font on readmes and stuff.
233.
by zachmu 6y ago
Also private repos under a gig, but you have to give us a credit card to be private.
234.
by zachmu 6y ago
This is correct. Specifically, to pay homage to git and how Linus named it.
235.
by zachmu 6y ago
It is a database. It implements the MySQL dialect and binary protocol, but it isn't MySQL. Totally separate storage engine and implementation.
236.
by zachmu 6y ago
It uses the mysql SQL dialect for queries. But it's its own database.
237.
by zachmu 6y ago
A portion of it was sourced from openelections, yes. These were attributed in the PRs, but not in the README for the repository. We've corrected this oversight in attribution and issued an apology.
238.
by zachmu 6y ago
How much do you want to be taxed for this service? We got it from strangers for $25,000 in 2 months. I'm guessing it would be slightly more if dictated by statute.
239.
by zachmu 6y ago
Differences are down to reporting entity. In the US this is usually the state, but is often the county. I don't think I saw any state with congressional district level differences.
240.
by zachmu 6y ago
The data is easily available in most places. The issue is that every place uses a different reporting format, including using slightly different names for the same candidates. The value of the bounty is getting this data into a single schem

More ›