2. Lightning-fast database guide

Welcome to Trevor.io! πŸ‘‹

Here are a few quick points to help you hit the ground running. πŸƒ

Your Database

  • Your database is a rich store of information separated into multiple tables

  • Each table is made up rows and columns, just like in Google Sheets / Excel.

  • Table rows represent instances of what the table itself represents (e.g. each row in a Users table is a user). 

  • Each column represents a value that relates to the rows in that table (e.g. email_address, sign_up_date).

Data Types

Each column has a data type. The main data types you'll come across are:

  1. String = text (e.g. "Hello to you") 

  2. Int = a whole number (e.g. 10, 20, 30)

  3. Timestamp = date and time of day (e.g. 01/01/2019 14:25:03)

  4. Float = a number with a fractional part (e.g. 4.7)

  5. Bool = a value of either true or false.

  6. JSON = a data type used for storing and transporting data. JSON is made up of key-value pairs between curly brackets (e.g. {"Book Title": "Ready Player One"} where the key in this instance is "Book Title" and the value is "Ready Player One").

  7. Array = a data type used for storing multiple values, enclosed in square brackets (e.g. ["Ready Player One", "Ender's Game", "Children of Time"]). 

Other things to note

  • Data in different tables can be connected (e.g. an order in an Orders table might belong to a customer in a Customers table). 

  • You’ll see the word NULL frequently - this simply means no value exists. 

  • There are a ton of calculations, manipulations and questions you can answer with Trevor. There’s a cheatsheet here with the main formulas you might need, or continue reading our guides to learn more!

That's it for now!

Go ahead and dive in, and let us know if you need anything - we're here to help, every step of the way! πŸ˜ƒ

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.