If I recall correctly, the Fossil SCM uses SQLite under the covers for a lot of its stuff.
Obviously that's not surprising considering its creator, but hearing that was kind of the first time I had ever considered that you could translate something like Git semantics to a relational database.
I haven't played with Pgit...though I kind of think that I should now.
anitil 7 hours ago [-]
The sqlite project actually benefited from this dogfooding. Interestingly recursive CTEs [0] were added to sqlite due to wanting to trace commit history [1]
On and of course, the discussion board is itself hosted in a sqlite file!
20after4 49 minutes ago [-]
When you import a repository into Phabricator, it parses everything into a MySQL database. That's how it manages to support multiple version control systems seamlessly as well as providing a more straightforward path to implementing all of the web-based user interface around repo history.
gjvc 9 hours ago [-]
"If I recall correctly, the Fossil SCM uses SQLite under the covers for a lot of its stuff."
a fossil repository file is a .sqlite file yes
ptdorf 7 hours ago [-]
So SQLite is versioned in SQLite.
yjftsjthsd-h 4 hours ago [-]
Yep:) To be fair, I expect git to be stored in git, mercurial to be in mercurial, and... Actually now I wonder how svn/cvs are developed/versioned.
deepsun 2 hours ago [-]
SVN in SVN for sure, it's a well made product. The market just didn't like it's architecture/UX that doctates what features available.
CVS is not much different from copying files around, so would not be surprised if they copied the files around to mimic what CVS does. CVS revolutionized how we think of code versioning, so it's main contribution is to the processes, not the architecture/features.
tombert 9 hours ago [-]
Makes sense, I haven't used the software in quite awhile.
niobe 8 hours ago [-]
Very cool
gurjeet 11 hours ago [-]
Technically correct title would be: s/Kernel into/Kernel Git History into/
Pgit: I Imported the Linux Kernel Git History into PostgreSQL
worldsayshi 9 hours ago [-]
Wow that has a very different meaning from what I thought.
JodieBenitez 11 hours ago [-]
Read the title and immediately thought "what a weird way to solve the performance loss with kernel 7..." The mind tricking itself :)
srslyTrying2hlp 10 hours ago [-]
[dead]
QuiCasseRien 10 hours ago [-]
very nice, thank you for the effort spent to do this and the results
Rendered at 08:06:34 GMT+0000 (Coordinated Universal Time) with Vercel.
Obviously that's not surprising considering its creator, but hearing that was kind of the first time I had ever considered that you could translate something like Git semantics to a relational database.
I haven't played with Pgit...though I kind of think that I should now.
[0] https://sqlite.org/lang_with.html#recursive_query_examples
[1] https://fossil-scm.org/forum/forumpost/5631123d66d96486 - My memory was roughly correct, the title of the discussion is 'Is it possible to see the entire history of a renamed file?'
a fossil repository file is a .sqlite file yes
CVS is not much different from copying files around, so would not be surprised if they copied the files around to mimic what CVS does. CVS revolutionized how we think of code versioning, so it's main contribution is to the processes, not the architecture/features.