ambujraj / AmbSQL

AmbSQL is a DBMS that is most EASY to operate on.
MIT License
24 stars 35 forks source link
database database-management python sqlite3

ambsql

AmbSQL

Take a look at our website

Documentation

Please refer to the documentation at https://github.com/ambujraj/AmbSQL/wiki/Documentation

Compatibility

This program is compatible with python - 3.x

Installation

For Command-line Interface

For Python Package

You can use one of the below methods to download and use this repository.

Using pip:
$ pip install ambsql

Manually using CLI:
$ git clone https://github.com/ambujraj/AmbSQL.git
$ cd AmbSQL
$ sudo python3 setup.py install (Linux and MacOS)
$ python setup.py install (Windows)

Manually using UI:
Go to the repo on github => Click on 'Clone or Download' => Click on 'Download ZIP' and save it on your local disk.

Usage

If installed CLI, open the AmbSQL.exe file and get the work started.

If installed using pip or CLI:
$ python (Windows)
or
$ python3 (Linux or MacOS)
>>>from ambsql import *

If installed using UI, unzip the file downloaded, go to the 'AmbSQL' directory and use one of the below commands:
$ python3 AmbSQL.py (Linux or MacOS)
or
$ python AmbSQL.py (Windows)

Examples

If you installed package using pip or CLI, below is the sample code:
from ambsql import *
createtable('studenttable', 'name', 'age')
insertvalues('studenttable', 'Jack', 21)
showvalues('studenttable')

If you installed AmbSQL.exe, below is the sample code:
> connect
> createtable(studenttable, name, age)
> insertvalues(studenttable, Jack, age)
> showvalues(studenttable)

Contributors

Check the list of contributors here

Help Us Improve

You can suggest us of new improvements you want by creating new Issue here

Important Notice

AmbSQL has been selected at GirlScript Summer of Code 2021!!!

πŸ‘¨ Project Admin

πŸ‘¬ Mentors

Feel free to ask your queries!! πŸ™Œ

Slack Channel

License

MIT License