Show HN: Pgit – A Git-like CLI backed by PostgreSQL

This is incredibly neat and might actually become a part of my toolbox.

smartmic 2 hours ago | parent | prev | next [-]

Of course, we can’t leave out a mention of Fossil here — the SCM system built by and for SQLite.

	▲	Pay08 a few seconds ago \| parent \| next [-]
		How much does it take advantage of being a DB underneath?
	▲	thunderbong an hour ago \| parent \| prev \| next [-]
		And fossil itself is an SQLite database!
	▲	ImGajeed76 2 hours ago \| parent \| prev [-]
		yeah fossil is great, but can fossil import the linux kernel (already working on the next post)

▲

aljgz 2 hours ago | parent | prev | next [-]

Still halfway through reading, but what you've made can unlock a lot of use cases.

> I tried SQLite first, but its extension API is limited and write performance with custom storage was painfully slow

For many use cases, write performance does not matter much. Other than the initial import, in many cases we don't change text that fast. But the simpler logistics of having a sqlite database, with the dual (git+SQL) access to text is huge.

That said, for the specific use case I have in mind, postgres is perfectly fine

	▲	ImGajeed76 2 hours ago \| parent [-]
		sounds great yes. maybe an SQLite version will come in the future

▲

Fire-Dragon-DoL an hour ago | parent | prev | next [-]

Wouldn't duckdb be better suited for this? Forgive the stupid question. I just connected "csv as sql" to "git as sql" and duckdb comes to mind

	▲	ImGajeed76 an hour ago \| parent [-]
		I did actually look into writing the extension for duckdb. But similar to SQLite the extension possibilities are not great for what I needed. Though duckdb is a great database.

▲

killingtime74 2 hours ago | parent | prev | next [-]

I love it. I love having agents write SQL. It's very efficient use of context and it doesn't try to reinvent informal retrieval part of following the context.

Did you find you needed to give agents the schema produced by this or they just query it themselves from postgres?

	▲	ImGajeed76 2 hours ago \| parent [-]
		so most analyses already have a CLI function you can just call with parameters. for those that don't, in my case, the agent just looked at the --help of the commands and was able to perform the queries.

▲

Zardoz84 3 hours ago | parent | prev [-]

Interesting... could be used to store multiple git repos and do a full text search across the multiple repos ?

	▲	ImGajeed76 2 hours ago \| parent [-]
		in theory yes. you just need to do the full text search across the databases. pgit doesnt support it but at the end its just postgres under the hood.