Getting Started with SQL

When you first open the dashboard, you’ll be greeted by a “Welcome to Pacuare Reserve!” screen (if you have full access, this screen will be skipped; this screen shows while restricted accounts’ personal databases are being created), followed by the SQL playground.

This is the simplest way to query the database, and queries you enter here will be run directly on your copy of the database (if your access is restricted) or the database itself (if you have full access).

Note

See Accounts & Access for more information on access levels.

Click on the book icon in the top left corner for a quick reference sidebar with useful queries and statements. Try copying and running (one at a time) the statements under turtle_occurrences and Unique Turtles to show a list of unique turtles. The turtle_occurrences function is now stored in your personal database, and can be called again at any time.

Note

spanish_bool (also provided in the sidebar) is also a very useful function to have around.

Caution

If you try to run multiple statements at once, you’ll get an error! This is because the app runs your query as one single prepared statement, which can (as the name suggests) only contain one statement. For more complicated queries, consider making a stored function or using Python.