GooseDB

goose-db is google spreadsheet based database.

In the development of programs, databases are used to store data collected from multiple PCs. If a relatively small database is needed or conditions are met, a database server is established and used directly. In this case, problems such as management problems or maintenance costs of PCs used as servers occur. GooseDB uses SQL query statements to use Google Spreadsheet, which anyone can expect to build a free 15GB database provided by Google.

Free 15GB database

If you have a google account, you can get 15GB free database because of default capacity of google drive storage, 15GB. The goose-db can use your google drive storage. So, you can get database storage as much as your google drive's empty space.

User-friendly user interface

You can access the database as a google spreadsheet that is presented by excel form. So, you can read your data easily.

SQL syntax

Database managers and database developers can use this library easily because this library supports SQL syntax. If you want to use SQL syntax, use the method, query(). If you need more information, read Goose DB method reference.

Dependencies

| Name | Version | | ---- | ------- | | Git | Latest | | npm | Latest | | chalk | 4.1.2 | | figlet | 1.5.2 | | google-spreadsheet | 3.1.15 | | googleapis | 89.0.0 | | node-sql-parser | 3.9.4 |

Setting for Google APIs

If you want more details for setting, access here.

First, You must have google developer console project.

You can access at google console.

And You have to enable apis. (Google Drive API and Google Sheets API)

If you want to full access, Select Role to Owner.

When you add credential to your project, you have to select Web server, Application Data, and you must have to key type, JSON.

And copy the key, key.json to this directory.

Guides

You can install goose-db according to following command.

$ npm i goose-db

First, if you create one database and you want to use that database, you have to make gooseDB object like this. (Add spreadsheetId) If you want more details, read Goose DB object reference.

const { google } = require("googleapis");

await gooseDB.connect(
        google,
        key,
        spreadsheetid
    );

SQL syntax guides (Not reflected yet)

GooseDB References

• Start GooseDB
• GooseDB object reference
• GooseDB method reference
• GooseDB handling history reference