SQL Databases

This is a simple repository to store any database I've made. Namely the accounting database. That took a long time.

---

Features

• accountingDB.sql - A double entry accounting system I made for a hybrid manufacturing company. This database is used in the real world by Army Glass, to operate a Glass Blowing Company and has outperformed expectations in tracking daily operations. This database is used in conjunction with interlink

• blogDB.sql - A very basic blog for personal websites which may not receive much traffic, or high volume of users.

• repositoryDB.sql - A database used for managing personal repositories.

Getting Started

Prerequisites

• Arch Linux (or compatible Unix-like environment)
• bash (>= 5.1)
• 'mariadb' (>=12.2.2)

Installation

  $ git clone https://github.com/padsRepo/sql.git
  $ sudo mariadb < sql/accountingDB.sql

OR

   $ for db in sql/*.sql; do sudo mariadb < $db; done

Usage

• Use however you would manipulate data from a database. (It must be compatible with mariadb/mysql).

• (OPTIONAL)

  • Use in conjunction with interlink to generate your forms, reports, and a url.

  $ mkdir -p path/to/my/company/website/{run,log,static/{css,js,img},templates}
  $ touch path/to/my/company/website/{{__init__,views,wsgi}.py,nginx.conf,uwsgi.ini}
  $ python -m venv path/to/my/company/website/venv
  $ . venv/bin/activate
  $ python -m pip install --upgrade pip
  $ python -m pip install git+https://github.com/padsRepo/interlink.git

• Follow the docs for interlink if you want to use that lib.

Contributing

Fork the repository

Create your feature branch (git checkout -b feature/thing)

Commit your changes (git commit -am 'Add thing')

Push to the branch (git push origin feature/thing)

Open a pull request

License

This project is licensed under the MIT License.

This README template was generated by ChatGPT.