Skip to content

Instantly share code, notes, and snippets.

@jgarza9788
jgarza9788 / PosInterviewQuestions_SE3.md
Last active March 19, 2025 10:54
PosInterviewQuestions_SE3.md

Technical Questions:

Python & Spark

  1. How have you used Python and Spark in previous projects?
    • Used for data processing, ETL, machine learning, and real-time analytics. Example: optimizing large-scale data pipelines.
  2. How does RDD differ from DataFrame in Apache Spark?
    • RDDs are low-level, immutable, and distributed objects, unstructured;
    • DataFrames provide higher-level abstraction, table-like structure, and optimizations via Catalyst.
  3. Explain lazy evaluation in Spark and how it impacts performance.
@jgarza9788
jgarza9788 / PLSQL.md
Last active March 16, 2025 00:31
Oracle PL/SQL 19.0 Guide

Oracle PL/SQL 19.0 Guide

Table of Contents

  1. Introduction to PL/SQL
  2. PL/SQL Architecture
  3. PL/SQL Block Structure
  4. Variables and Data Types
  5. Control Structures
  6. Cursors
  7. Exception Handling
@jgarza9788
jgarza9788 / mp3 to wav
Created November 20, 2022 18:59
mp3 to wav
# put the \ffmpeg\bin\.*.exe files in the same directory
import os
from pydub import AudioSegment
DIR = os.path.dirname(__file__)
print(DIR)
@jgarza9788
jgarza9788 / MeshDestroy.cs
Created September 12, 2020 17:53 — forked from ditzel/MeshDestroy.cs
MeshDestroy => Put it on a game object with a mesh filter and renderer. Make sure to have read/write enabled on fbx import
using System;
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
public class MeshDestroy : MonoBehaviour
{
private bool edgeSet = false;
private Vector3 edgeVertex = Vector3.zero;
private Vector2 edgeUV = Vector2.zero;
@jgarza9788
jgarza9788 / purgeAndroid.txt
Created March 14, 2018 06:43 — forked from tahmidsadik/purgeAndroid.txt
How to completely remove Android Studio from Mac OS X
How to Completely Remove Android Studio
Execute these commands from the terminal
rm -Rf /Applications/Android\ Studio.app
rm -Rf ~/Library/Preferences/AndroidStudio*
rm ~/Library/Preferences/com.google.android.studio.plist
rm -Rf ~/Library/Application\ Support/AndroidStudio*
rm -Rf ~/Library/Logs/AndroidStudio*
using UnityEngine;
using System.Collections;
using System.Collections.Generic;
public class BezierCurveScript : MonoBehaviour {
public class BezierPath
{
public List<Vector3> pathPoints;
private int segments;
@jgarza9788
jgarza9788 / CustomEditorBase.cs
Created August 30, 2016 05:24 — forked from t0chas/CustomEditorBase.cs
Default Custom Inspector-Editor for Unity3D with ReorderableLists for arrays handling
using UnityEngine;
using UnityEditor;
using UnityEditorInternal;
using System.Collections.Generic;
using UnityEditor.AnimatedValues;
[CustomEditor(typeof(UnityEngine.Object), true, isFallback = true)]
[CanEditMultipleObjects]
public class CustomEditorBase : Editor
{
@jgarza9788
jgarza9788 / ZPL to M3U Converting Script
Created July 11, 2014 03:50
Converts a ZPL file to a M3U file
// ---------------------------------------------------------------
// Developer: Justin Garza
// Date Written: 5/6/2012
// Purpose: ZPL to M3U
// ---------------------------------------------------------------
//Specification: Append and display records in a address database
#include <iostream>
#include <fstream>
#include <string>
@jgarza9788
jgarza9788 / ScanDirectory Form
Created July 11, 2014 02:18
ScanDirectory.xls
Private Sub Scan_Click()
Call clean
''check for errors
If Dir(Me.Folder2Scan.Value & "\" & client, vbDirectory) = "" Or Len(Me.Folder2Scan.Value) = 0 Then
MsgBox "There seems to be something wrong with the path you've entered." & vbNewLine & "Please make sure the folder exist.", vbOKOnly, "Path Not Found"
Exit Sub
Else
@jgarza9788
jgarza9788 / CloseConnection subprocedure
Last active August 29, 2015 14:03
CloseConnection subprocedure to use in Excel based applications
'Requires
'Microsoft ActiveX Data Objects 2.8 Library
Private Sub CloseConnection()
cn.Close
Set cn = Nothing
Set rs = Nothing
End Sub