Resources

Below are some links to useful resources grouped by theme

Python

• Python – Using the Sierra REST API
  • Getting Started
    • General Concepts
  • Generating the Access Token
• Python – Creating a VPS (Virtual Private Server) with Digital Ocean for Hosting Datasette
  • Setup VPS (Digital Ocean Droplet) + Ubuntu + Apache + Environment for Datasette Recipe
    • Setup and Configure the Server
    • Install and Configure the Software From Package Managers

SQL

• Sierra SQL Tips And Tricks
  • Tables of Note
  • Account for possible NULL Values
  • Picking the Correct Key to JOIN On
  • Unique SQL Queries (can’t easily be done via the SDA / CreateLists)
  • Using Indexes Effectively
  • Unexpected One-to-Many Situations
  • Helpful / useful queries
  • Additional Resources

Helpful Presentations and Resources from Past IUG Conferences

• IUG 2021 HOWTO SQL: SIERRA SQL Sandbox (if this is down of you have questions, dm @ray_voelker)

• HOWTO SQL: SIERRA - PART 1 HTML | PDF

• HOWTO SQL: SIERRA - PART 2 PDF

• IUG 2019 How to SQL (Sierra) : https://iug2019-sql.github.io/

• TODO: add some resources pages (topics like, connecting to the Sierra PostgreSQL db, using Pandas / DataFrames, SQLAlchemy, etc)

TODO: Maybe this page should just be part of the main page?