{"repo":"gitvipin/sql30","free":true,"listed":false,"github":"https://github.com/gitvipin/sql30","clone":"git clone https://github.com/gitvipin/sql30.git","description":"A zero weight ORM for sqlite3 in Python","language":"Python","stars":12,"topics":["python","sqlite3","sqlite3-database","orm"],"license":null,"category":"databases-storage","readme_excerpt":"SQL30 sql30 is a zero weight ORM for sqlite3 in Python. It is written using pure python constructs and has no dependency on any other module. There is no requirements.txt in the project in fact. Having zero dependency on any other module makes this package usable on variety of platforms including the ones which have limited or delayed support such as ESX. Usage SQL30 is incredibly simple to use. All it requires is to define your database schema using a simple JSON. Then, pre-defined interface can be used to perform CRUD operations. As is true for any ORM, user doesn't need to know how the operations are translated back to SQL statements for sqlite3 . In the schema, - Database filename is provided using the key db name . - Multiple tables can be defined under tables key in JSON. - Fields / Columns for each table are added using fields key in JSON. Field name and it's type is provided as key value pair again. - Primary Key for each table can be defined using key primary key Let's take an example. Example Let's say we have to store the reviews of a product in database and we chose sqlite3 for the purpose. Using SQL30, a sample schema can be defined as shown below. Now, we can create instance of Review and that will handle CRUD operations to database for us. Browsing Database Contents SQLITE database can be browsed a couple of ways. Some of these are mentioned here. sql30 server Traditionally, sqlite3 has been used to browse database contents. However sql30 comes with a utility t","default_branch":null,"files":null,"tree":[],"storefront":"/r/gitvipin","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/gitvipin/sql30/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}