{"repo":"FreeLeh/GoFreeDB","free":true,"listed":false,"github":"https://github.com/FreeLeh/GoFreeDB","clone":"git clone https://github.com/FreeLeh/GoFreeDB.git","description":"GoFreeDB is a Golang library that provides common and simple database abstractions on top of Google Sheets.","language":"Go","stars":89,"topics":["database","golang","google-sheets-api","google-sheets-api-v4","key-value-store","row-store","orm"],"license":"MIT","category":"databases-storage","readme_excerpt":"GoFreeDB Ship Faster with Google Sheets as a Database! GoFreeDB is a Golang library that provides common and simple database abstractions on top of Google Sheets. Features 1. Provide a straightforward key-value and row based database interfaces on top of Google Sheets. 2. Serve your data without any server setup (by leveraging Google Sheets infrastructure). 3. Support flexible enough query language to perform various data queries. 4. Manually manipulate data via the familiar Google Sheets UI (no admin page required). For more details, please read our analysis on other alternatives and how it compares with FreeDB . Table of Contents Protocols Getting Started Installation Pre-requisites Row Store Querying Rows Counting Rows Inserting Rows Updating Rows Deleting Rows Struct Field to Column Mapping KV Store Get Value Set Key Delete Key Supported Modes KV Store V2 Get Value Set Key Delete Key Supported Modes Protocols Clients are strongly encouraged to read through the protocols document to see how things work under the hood and the limitations . Getting Started Installation Pre-requisites 1. Obtain a Google OAuth2 or Service Account credentials. 2. Prepare a Google Sheets spreadsheet where the data will be stored. Row Store Let's assume each row in the table is represented by the Person struct. Please read the struct field to column mapping section to understand the purpose of the db struct field tag. Querying Rows Counting Rows Inserting Rows Updating Rows Deleting Rows Struct F","default_branch":null,"files":null,"tree":[],"storefront":"/r/FreeLeh","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/FreeLeh/GoFreeDB/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."}