SQL Simulator
  • Welcome
  • Getting Started
    • About SQL Simulator(beta)
    • Features
    • Benefits
    • Pricing
    • Platform List
    • Supported Databases
    • Technical Overview
      • PostView Merge
        • Step 1
        • Step 2
        • Step 3
        • Step 4
        • Step 5
      • PreView Merge
        • Step 1
        • Step 2
        • Step 3
        • Step 4
      • Dry Run
        • Step 1
        • Step 2
        • Step 3
        • Step 4
        • Step 5
        • Step 6
    • Self Destruct Events
    • K8s Install Guide
      • Azure Marketplace
      • Azure AKS
      • Google GKE
      • Amazon EKS
      • Other Cloud Provider
      • On Prem K8s
    • Limitations
    • Schedule Free Onboarding
  • Hello World Tutorials
    • SQL Server
      • Pod Setup
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
    • Oracle
      • Pod Setup
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
    • MySQL
      • Pod Setup
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
    • Postgres
      • Pod Setup
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
  • API Tutorials
    • Introduction
    • SQL Server
      • Windows Batch File
    • Oracle
      • Windows Batch File
    • MySQL
      • Windows Batch File
    • Postgres
      • Windows Batch File
  • Help
Powered by GitBook
On this page
  1. Hello World Tutorials
  2. Postgres

SQL Scripts

PreviousDatabase SetupNextAdd SQL Script

Last updated 1 year ago

Please make sure you do a "Destroy Merge" after you run a scenario.

Download the following SQL Scripts:

Scenarios

  • You have 2 developers that want to make change to the system. Try the following files in the simulator to see what would happen. Remember that order the files are executed in is important.

  • A developer tries to select more SSN's at one time than the audit table amount allows. How will SQL Simulator react?

  • A developer submits a SQL that is only supposed to delete 1 record. Try doing a Preview and a Postview merge to see the difference in how SQL Simulator reacts.

  • A developer submits a update SQL. Try doing a Preview and a Postview merge.

  • A developer submits an insert SQL. You have a sneaky suspicion that he did not test his code and if you ran this in production you would get a unique key constraint error. Try doing a dry run to see what would happen.

144B
developer_A.pgsql
90B
developer_B.pgsql
27B
select_no_where_clause.pgsql
After doing a postview merge try adding the a where clause: where employee_id = 1
215B
delete.pgsql
89B
Update.pgsql
92B
insert.pgsql