TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

SQLite Doesn't Use Git

181 pointsby bkqover 2 years ago

16 comments

int_19hover 2 years ago
I really like the notion of having the whole repo including issue tracking in a single file that can be easily copied around. But Fossil's stance on history - specifically, the deliberate refusal to implement history-editing functionality like squash and rebase - is a showstopper, and their rationale for it reads very much along the lines of "you're holding it wrong".
评论 #32809990 未加载
评论 #32809310 未加载
评论 #32811432 未加载
评论 #32809364 未加载
评论 #32809201 未加载
评论 #32811328 未加载
评论 #32809152 未加载
评论 #32818647 未加载
评论 #32809602 未加载
sshineover 2 years ago
SQLite also doesn&#x27;t use CVS, SVN, or Perforce.<p>If this title were &quot;SQLite uses Fossil&quot;, it&#x27;d be more apparently just another ad for Fossil.
评论 #32809361 未加载
评论 #32808908 未加载
评论 #32810001 未加载
评论 #32810369 未加载
masukomiover 2 years ago
Richard Hipp (SQLite guy) spoke about the thinking behind writing Fossil instead of using Git on Corecursive episode 66.<p>If i remember correctly, it wasn&#x27;t that they had any real problem with git, but that git didn&#x27;t really fit with how they wanted to work, so they created their own thing.<p><a href="https:&#x2F;&#x2F;corecursive.com&#x2F;066-sqlite-with-richard-hipp&#x2F;" rel="nofollow">https:&#x2F;&#x2F;corecursive.com&#x2F;066-sqlite-with-richard-hipp&#x2F;</a>
2143over 2 years ago
Fun fact: Fossil uses sqlite. And sqlite uses fossil. Think about that.<p>SQLite is what I consider a well-engineered product.<p>And Richard Hipp is an excellent engineer. Listen to his podcast episodes on the changelog. It&#x27;s fun. His mentality is interesting.<p><a href="https:&#x2F;&#x2F;changelog.com&#x2F;person&#x2F;drh&#x2F;podcasts#feed" rel="nofollow">https:&#x2F;&#x2F;changelog.com&#x2F;person&#x2F;drh&#x2F;podcasts#feed</a>
评论 #32811221 未加载
headsup2022over 2 years ago
The single file repository is super convenient for one person projects, but just a word of caution to fossil users - backup the repo file often. A while back I downgraded the fossil binary (by accident) and committed a change to a local repo which caused it to be corrupted. It was a repeatable thing, and was annoying at the time, but not a showstopper. I only lost a day&#x27;s worth of work. I wish fossil had done a version check between the binary and the repo to refuse to alter the repo if the binary version was incompatible.
72deluxeover 2 years ago
I use Fossil at home since it&#x27;s just me. The single file approach takes up less space than the comparable git tree.<p>Fossil has the ability to push to git, which I do periodically just for curiosity.
评论 #32808896 未加载
dierover 2 years ago
With regard to rebase and fossil vs git when you have a small team of trusted developers rebase is harmful because you lose information that could help you understand the _why_ of something. In contrast if you are working with thousands of untrusted developers you need a way to increase the signal-to-noise at the cost of some granularity.<p>This comes about from their development styles (see: <a href="http:&#x2F;&#x2F;www.catb.org&#x2F;~esr&#x2F;writings&#x2F;cathedral-bazaar&#x2F;" rel="nofollow">http:&#x2F;&#x2F;www.catb.org&#x2F;~esr&#x2F;writings&#x2F;cathedral-bazaar&#x2F;</a>).<p>- Use fossil if you prefer the cathedral style of development SQLite is open source but does not accept contributions.<p>- Use Git if you prefer the bazaar style of development. You want to accept hit-and-run style contributions from anyone.
评论 #32812770 未加载
vouaobrasilover 2 years ago
To be honest, I hate Git. The commands don&#x27;t really make sense outside some basic stuff. For certain organizational setups it seems like overkill. I am not a full-time programmer but I do programming for my job and for personal projects sometimes and I never enjoy using Git.
评论 #32809921 未加载
评论 #32810669 未加载
ddevaultover 2 years ago
Important note mentioned here is that sqlite doesn&#x27;t accept external contributions and has a very small team. The Fossil folks and the sqlite folks are also essentially the same team. Fossil is a boutique VCS which essentially only exists for sqlite.
评论 #32809143 未加载
donatjover 2 years ago
&gt; I still believe that a squash+merge (or sometimes, rebase) workflow pairs better with pull requests<p>Unpopular opinion, but I find the value of having the actual surrounding context in which the code was developed more valuable than having a flat history.
评论 #32808858 未加载
评论 #32809962 未加载
评论 #32808830 未加载
samatmanover 2 years ago
Author confuses SQLite&#x27;s development model with Fossil&#x27;s at the end, the latter welcomes contributions: <a href="https:&#x2F;&#x2F;www.fossil-scm.org&#x2F;home&#x2F;doc&#x2F;trunk&#x2F;www&#x2F;contribute.wiki" rel="nofollow">https:&#x2F;&#x2F;www.fossil-scm.org&#x2F;home&#x2F;doc&#x2F;trunk&#x2F;www&#x2F;contribute.wik...</a>
评论 #32810117 未加载
hprotagonistover 2 years ago
I’d use fossil more for personal work if i wasn’t hopelessly addicted to magit.
评论 #32809313 未加载
gwbas1cover 2 years ago
Anyone use Fossil for professional &#x2F; team development?<p>I&#x27;d love to hear some real-world experiences.
评论 #32809957 未加载
RockingGoodNiteover 2 years ago
The sound of it from the article reminds me some of <a href="https:&#x2F;&#x2F;trac.edgewall.org&#x2F;" rel="nofollow">https:&#x2F;&#x2F;trac.edgewall.org&#x2F;</a>
benreesmanover 2 years ago
The SQLite people not using git or hg is like the Bell Labs people and three-button-mouse heavy sam&#x2F;acme: when you’re right about everything 99&#x2F;100 times, that 100th time you’re really going to double down on some dumb-ass thing.<p>In what possible world is telling the most successful set of design decisions about document management in the history of documents or management to get fucked not just “I’ve got goodwill to burn, let’s ride.”? SQLite is indeed badass, but cool it djb, I’m already stressing about the zero bugs ever thing.
评论 #32811086 未加载
评论 #32813682 未加载
评论 #32811024 未加载
评论 #32809352 未加载
评论 #32811374 未加载
评论 #32810084 未加载
adagaover 2 years ago
Alt title - SQLite doesn&#x27;t Git it<p>Great read :D