git-sql 0.0.1

Git on SQL
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68

# Git SQL

This is an experimental implementation of Git storage and operations on top of PostgreSQL.

## Why

Git is a very flexible platform for version control and content-addressable storage.
GitSQL aims to take advantage of the server-side abilities of PostgreSQL to implement
Git operations using PostgreSQL features. This is still experimental, and is not
recommended for production use.

## Installation

Install from Git:

```bash
cargo install git-sql --git https://github.com/SpinlockLabs/GitSQL.git
```

Install from [crates.io](https://crates.io):

```bash
cargo install git-sql
```

## Usage

- Create a database in PostgreSQL, such as `gitdb`.
- Create a configuration file as `gitdb.toml`:

```toml
# Repositories are specified under named tables.
[repositories.mygitrepo]
# The URL to connect to the database.
postgres-url = "postgres://127.0.0.1/gitdb"
# A path to a local repository, used to update the SQL repository.
local-path = "/path/to/my/local/repo"

# Git Server Configuration
# URL format: http://myhost:port/mygitrepo
[server]
# Binds to the given host and port.
bind = "0.0.0.0:3020"
```

- Initialize the GitSQL schema:

```bash
git-sql -c config.toml -r mygitrepo init
```

- Import the Git repository into the SQL database:

```bash
git-sql -c config.toml -r mygitrepo update
```

- Run the Git server:

```bash
git-sql -c config.toml serve
```

- Clone the repository:

```bash
git clone http://localhost:8080/mygitrepo
```