Repo who contains files for the "Module 141"
Explore the documentation »
Report Mistake
·
Request Topic
This repo contain our project for the module 141. It's the project of David Araujo and Colin Fontanellaz.
On this repo you'll find:
- Scripts
- Documentation
- Database template file
To get a local copy up and running follow these simple steps.
During all our work, we used Ubuntu server. So we recommend to use the same OS or at least a Debian based one.
List of things to get to test our scripts:
- A Mariadb server
- File .my.cnf configured
Example of .my.cnf file
[mysql] user=root password=yourpwd [mysqldump] user=root password=yourpwd
- File .my.cnf configured
Example of .my.cnf file
- A PostgreSQL server
- A MongoDB server
To install these service just check the documentation.
To use this repo you can:
Clone the repo
git clone https://github.com/Fonfon02/Module141.gitor
Download this project as Zip on your local machine and decompress it
wget https://github.com/Fonfon02/Module141/archive/refs/heads/master.zip
unzip master.zip
# or
7z e master.zip- Backup and restore DBs
- User creation
- User give privileges
- User revoke access
- Install MariaDB
- Install PostgreSql
- Install MongoDB
- Mariadb versus Mysql
- Postgres versus Mysql
- Phpmyadmin versus Adminer
- Transactions definition
- Triggers definition
- Views definition
- Json definition
- Create Json fake data
- Escape specials characters
- LaTeX in MongoD
- Referential integrity, foreign keys, etc...
- Try blackhole and csv engines
See the open issues for a list of future topics.
Colin Fontanellaz & David Araujo
Project Link: https://github.com/Fonfon02/Module141