SQLite Icon

SQLite

The most used database engine in the world.
9 Stories
All Topics

Patrick DeVivo github.com

Using SQL to query git repos

gitqlite is a tool for running SQL queries on git repositories. It implements SQLite virtual tables and uses go-git. It’s meant for ad-hoc querying of git repositories on disk through a common interface (SQL), as an alternative to patching together various shell commands.

Mine your repo’s history for goodies. Here’s how to get commit count by author email:

SELECT author_email, count(*) FROM commits GROUP BY author_email ORDER BY count(*) DESC

SQLite github.com

Sqlite To Rest

LGTM, but why?

Mostly because I wanted to dig deeper into node web server code, but also because I haven’t jumped onto the NoSQL bandwagon and think that web APIs are extremely useful. The result is a modest attempt at automating the CRUD boilerplate that every developer hates, while following the specs to make API consumption intuitive. I chose sqlite to keep the database side of things simple, with the intent that the API isn’t serving heavy loads.

Git github.com

LiteTree – a modification of the SQLite engine to support git-like branching

Imagine being able to have many connections to the same database, each one reading a separate branch or commit at the same time. Or even writing to separate branches.

This is a good idea and a testament to the versatility of SQLite. Click through to read how it works and how they’ve managed to 2x the performance of SQLite on Linux and macOS.

SQLite changelog.com/posts

Induction - Polyglot database client for Mac OSX supporting PostgreSQL, MySQL, SQLite, Redis, and MongoDB out-of-the-box

Induction is an ambitious new project from Matt Thompson to explore, query, and visualize data from SQL and NoSQL sources including PostgreSQL, MySQL, SQLite, Redis, and MongoDB. While in early alpha, the project shows promise.

Induction

Check out the project web site or grab the source on GitHub to contribute.

0:00 / 0:00