Raindrops Notion Database

Tables are where you store your data. Tables are similar to excel spreadsheets. They contain columns and rows. For example, this table has 3 "columns" (id, name, description) and 4 "rows" of data: idnamedescription1The Phantom MenaceTwo Jedi escape a hostile blockade to find allies and come across a young boy who may bring balance to the Force.2Attack of the ClonesTen years after the invasion of Naboo, the Galactic Republic is facing a Separatist movement.3Revenge of the SithAs Obi-Wan pursues a new threat, Anakin acts as a double agent between the Jedi Council and Palpatine and is lured into a sinister plan to rule the galaxy.4Star WarsLuke Skywalker joins forces with a Jedi Knight, a cocky pilot, a Wookiee and two droids to save the galaxy from the Empire's world-destroying battle station. There are a few important differences from a spreadsheet, but it's a good starting point if you're new to Relational databases. Creating tables# When creating a table, it's best practice to add columns at the same time. You must define the "data type" of each column when it is created. You can add and remove columns at any time after creating a table. Supabase provides several options for creating tables. You can use the Dashboard or create them directly using SQL. We provide a SQL editor within the Dashboard, or you can connect to your database and run the SQL queries yourself. DashboardSQL Go to the Table Editor page in the Dashboard. Click New Table and create a table with the name todos. Click Save. Click New Column and create a column with the name task and type text. Click Save. When naming tables, use lowercase and underscores instead of spaces (e.g., table_name, not Table Name). Columns# You must define the "data type" when you create a column. Data types# Every column is a predefined type. Postgres provides many default types, and you can even design your own (or use extensions) if the default types don't fit your needs. You can use any data type that Postgres supports via the SQL editor. We only support a subset of these in the Table Editor in an effort to keep the experience simple for people with less experience with databases. Show/Hide default data typesNameAliasesDescriptionbigintint8signed eight-byte integerbigserialserial8autoincrementing eight-byte integerbitfixed-length bit stringbit varyingvarbitvariable-length bit stringbooleanboollogical Boolean (true/false)boxrectangular box on a planebyteabinary data (“byte array”)charactercharfixed-length character stringcharacter varyingvarcharvariable-length character stringcidrIPv4 or IPv6 network addresscirclecircle on a planedatecalendar date (year, month, day)double precisionfloat8double precision floating-point number (8 bytes)inetIPv4 or IPv6 host addressintegerint, int4signed four-byte integerinterval [ fields ]time spanjsontextual JSON datajsonbbinary JSON data, decomposedlineinfinite line on a planelsegline segment on a planemacaddrMAC (Media Access Control) addressmacaddr8MAC (Media Access Control) address (EUI-64 format)moneycurrency amountnumericdecimalexact numeric of selectable precisionpathgeometric path on a planepg_lsnPostgres Log Sequence Numberpg_snapshotuser-level transaction ID snapshotpointgeometric point on a planepolygonclosed geometric path on a planerealfloat4single precision floating-point number (4 bytes)smallintint2signed two-byte integersmallserialserial2autoincrementing two-byte integerserialserial4autoincrementing four-byte integertextvariable-length character stringtime [ without time zone ]time of day (no time zone)time with time zonetimetztime of day, including time zonetimestamp [ without time zone ]date and time (no time zone)timestamp with time zonetimestamptzdate and time, including time zonetsquerytext search querytsvectortext search documenttxid_snapshotuser-level transaction ID snapshot (deprecated; see pg_snapshot)uuiduniversally unique identifierxmlXML data You can "cast" columns from one type to another, however there can be some incompatibilities between types. For example, if you cast a timestamp to a date, you will lose all the time information that was previously saved. Primary keys# A table can have a "primary key" - a unique identifier for every row of data. A few tips for Primary Keys: It's recommended to create a Primary Key for every table in your database. You can use any column as a primary key, as long as it is unique for every row. It's common to use a uuid type or a numbered identity column as your primary key. 1create table movies (2 id bigint generated always as identity primary key3); In the example above, we have: created a column called id assigned the data type bigint instructed the database that this should be generated always as identity, which means that Postgres will automatically assign a unique number to this column. Because it's unique, we can also use it as our primary key. We could also use generated by default as identity, which would allow us to insert our own unique values.

Webhooks Receive a web request with a JSON payload This trigger fires every time the Maker service receives a web request to notify it of an event. For information on triggering events, go to your Maker service settings and then the listed URL (web) or tap your username (mobile) Developer info API endpoint slug maker_webhooks.json_event Trigger fields Event Text input > Other Label Event Name Helper text The name of the event, like "button_pressed" or "front_door_opened". Use only letters, numbers, and underscores Slug event Required true Can have default value true Ingredients Event name The name of the event that was triggered. Slug event_name Filter code MakerWebhooks.jsonEvent.EventName Type String Example buzzer Json payload JSON payload sent with the event. Slug json_body Filter code MakerWebhooks.jsonEvent.JsonPayload Type String Example {"data": "Hello, world!"} Occurred at Date and time event occurred. Slug occurred_at Filter code MakerWebhooks.jsonEvent.OccurredAt Type Date with time (ISO8601) Example 2020-07-08T04:17:06+05:00

gh auth login gh auth login [flags] Authenticate with a GitHub host. The default hostname is github.com. This can be overridden using the --hostname flag. The default authentication mode is a web-based browser flow. After completion, an authentication token will be stored securely in the system credential store. If a credential store is not found or there is an issue using it gh will fallback to writing the token to a plain text file. See gh auth status for its stored location. Alternatively, use --with-token to pass in a personal access token (classic) on standard input. The minimum required scopes for the token are: repo, read:org, and gist. Take care when passing a fine-grained personal access token to --with-token as the inherent scoping to certain resources may cause confusing behaviour when interacting with other resources. Favour setting GH_TOKEN$ for fine-grained personal access token usage. Alternatively, gh will use the authentication token found in environment variables. This method is most suitable for "headless" use of gh such as in automation. See gh help environment for more info. To use gh in GitHub Actions, add GH_TOKEN: ${{ github.token }} to env. The git protocol to use for git operations on this host can be set with --git-protocol, or during the interactive prompting. Although login is for a single account on a host, setting the git protocol will take effect for all users on the host. Specifying ssh for the git protocol will detect existing SSH keys to upload, prompting to create and upload a new key if one is not found. This can be skipped with --skip-ssh-key flag. For more information on OAuth scopes, https://docs.github.com/en/developers/apps/building-oauth-apps/scopes-for-oauth-apps/. Options -p, --git-protocol <string> The protocol to use for git operations on this host: {ssh|https} -h, --hostname <string> The hostname of the GitHub instance to authenticate with --insecure-storage Save authentication credentials in plain text instead of credential store -s, --scopes <strings> Additional authentication scopes to request --skip-ssh-key Skip generate/upload SSH key prompt -w, --web Open a browser to authenticate --with-token Read token from standard input Examples # Start interactive setup $ gh auth login # Authenticate against github.com by reading the token from a file $ gh auth login --with-token < mytoken.txt # Authenticate with specific host $ gh auth login --hostname enterprise.internal See also gh auth