IllusiveMilkman

# This script was intended to get raw IMDB datasets into Postgres
# The script worked on my mac setup.
#
# You may have to update your psql command with appropriate -U and -d flags and may have to 
# provide appropriate permissions to new folders.
#
# Customise as you see fit and for your setup.
#
# Tables are NOT optomised, nor have any indexes been created
# The point is to "just get the data into Postgres"

IllusiveMilkman

## This script should open the SQLite database of your Flutter app, while the iOS Simulator is running an instance of your app.

# Note the following assumptions BEFORE using this script:
# 1. You have DB Browser for SQLite installed and set as the default app for opening .sqlite or .db files.  You could try alternative viewers as well, but I have not tested with another.
# 2. Flutter defaults the naming of ".xcodeproj" to "Runner.xcodeproj".  This script assumes this as well.
# 3. Your Flutter app code created a database with the ".db" extension.  If not, feel free to modify this code to whatever you used.
# 4. You are running an instance of your app on your iOS Simulator

#!/bin/bash

IllusiveMilkman

-- Window Function examples
-- PostgreSQL conference South Africa 2018
-- By Willem Booysen 
-- Youtube: https://www.youtube.com/watch?v=blHEnrYwySE


-- Create database and templates for demo
DROP DATABASE IF EXISTS WindowFunctions;
CREATE DATABASE WindowFunctions;

IllusiveMilkman

' The following Sub can be used in VBA to print the contents of an Array to the Immediate Window for debugging purposes

Sub DebugPrintArray(arr As Variant)
    Debug.Print ("----------------------Debugging Array----------------------")
    Debug.Print ("Array row count (from zero): " & UBound(arr))
    Debug.Print ("Array col count (from zero): " & UBound(arr, 2))
    
    Dim rowString As String
    rowString = ""