resql: Database For Beginners

Quick Examples

imports

pip install resql

import resql

database = resql.ReSql("mydb.db")
# default is in :memory:

.create_table(name)

creates a database table.

database.create_table("newtable")
# {'status': 'success', 'table': 'newtable'}

.insert(key, value, [table])

insert into given table.

database.insert("key","value")
# {'status': 'success'}

.all([table])

find data from given table.

database.all()
# [('key','value')]

.find(key, [table]) or .get(key, [table])

find data from given table.

database.find("key")
# value

.wipe([table])

wipe complete table.

database.wipe()
# {'status': 'success'}

.run(sql)

directly run sql query.

database.run("SELECT * FROM table")
# cursor

.delete(key, [table])

delete key from table.

database.delete("key")
# value

thanks to avonryle#2022 for letting me make the python version of ByteDatabase