97

I imported the full Linux kernel git history into pgit

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.

9 hours agotombert

The sqlite project actually benefited from this dogfooding. Interestingly recursive CTEs [0] were added to sqlite due to wanting to trace commit history [1]

[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?'

5 hours agoanitil

On and of course, the discussion board is itself hosted in a sqlite file!

5 hours agoanitil

"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

8 hours agogjvc

So SQLite is versioned in SQLite.

6 hours agoptdorf

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.

2 hours agoyjftsjthsd-h

Makes sense, I haven't used the software in quite awhile.

7 hours agotombert

Very cool

6 hours agoniobe

Technically correct title would be: s/Kernel into/Kernel Git History into/

    Pgit: I Imported the Linux Kernel Git History into PostgreSQL
9 hours agogurjeet

Wow that has a very different meaning from what I thought.

7 hours agoworldsayshi

Read the title and immediately thought "what a weird way to solve the performance loss with kernel 7..." The mind tricking itself :)

9 hours agoJodieBenitez

[dead]

8 hours agosrslyTrying2hlp

very nice, thank you for the effort spent to do this and the results