yacrud
v0.14.4
Published
Yet Another Create Read Update and Delete project.
Downloads
56
Maintainers
Readme
yacrud
Yet Another Create Read Update and Delete project.
Quickly run CRUD ops and more on databases like PostgreSQL and MySQL locally and in the Cloud.
npm i -g yacrud
Use case
This package is for development and testing purposes.
We can use this to create a test database and some tables and then fill them with fake values.
Table of Contents
Prerequisite
- Node (v14 or higher)
- NPM (v6 or higher)
- Database (any of the following supported database)
- PostgreSQL (v11 or higher)
- MySQL (v5 or higher)
- MariaDB (v9 or higher)
- DBeaver (Optional)
- MySQL Workbench (Optional)
Localhost
Start the database server and then use yacrud
.
Getting started
Install this package globally.
npm i -g yacrud
Commands
Usage: yacrud --help
Usage: yacrud command [-option=value]
Usage: yacrud command --help
Default database: PostgreSQL
Supported: PostgreSQL, MySQL, MariaDB
Commands:
=========================================
version Print the version.
init Initialise yacrud.
all [Re]create the default database, tables and fill it with fake values.
create-database Create the default database 'yacrud'.
recreate-database Recreate the default database 'yacrud'.
drop-database Drop the default database 'yacrud'.
create-tables Create the default tables.
recreate-tables Recreate the default tables.
fill-tables Fill the default tables with fake values.
list-tables List all the tables.
read Read rows from a table.
Configuration file:
=========================================
Run the following command to setup configuration file.
➜ yacrud init
The init command creates the .yacrudrc file in the home directory.
Database flags:
=========================================
Following are the flags that can be used with the above commands.
Note! Inline database flags overrides the .yacrudrc flags.
+------+---------------+---------------+
| Flag | Default Value | Note |
|------|---------------|---------------|
| -d | yacrud | Database name |
| -h | localhost | Hostname |
| -p | 5432 | Port |
| -U | | Username |
| -P | | Password |
| -C | pg | Client name |
+------+---------------+---------------+
The database name (-d flag) is always converted to lowercase.
Values for -C flag.
pg PostgreSQL
mysql MySQL/MariaDB
Example:
➜ yacrud init -C=pg -h=localhost -p=5432 -d=yacrud -U=yusufshakeel -P=root1234
➜ yacrud init -C=mysql -h=localhost -p=3306 -d=yacrud -U=yusufshakeel -P=root1234
License
It's free :smiley:
MIT License Copyright (c) 2023 Yusuf Shakeel
Donate
Feeling generous :smiley: Donate via PayPal