VMWare Fusion 13 is now released. Read Vagrant and VMWare Fusion 13 Player on Apple M1 Pro for the latest.
This document summarizes notes taken while to make the VMWare Tech preview work on Apple M1 Pro, it originated
Stephane B. sbailliez
sbailliez
/ vagrant-vmware-tech-preview-apple-m1-pro.md
Last active
May 28, 2026 02:06
Vagrant and VMWare Tech Preview 21H1 on Apple M1 Pro
sbailliez
/ vagrant-vmware-fusion-13-apple-m1-pro.md
Last active
December 21, 2025 21:09
Vagrant and VMWare Fusion 13 on Apple M1 Pro
This document summarizes notes taken to make VMWare Fusion 13 Player work on Apple M1 Pro. It builds upon a previous deprecated document.
VMWare Fusion 13 was released on November 17, 2022.
- Fusion 13.5 on October 19, 2023
- Fusion 13.6.4 on July 15, 2025
- Fusion 25H2 on October 14, 2025
sbailliez
/ install-libvips.sh
Last active
January 21, 2025 02:39
Attempt at compiling libvips on amazon linux 2023
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # | |
| # Compile libvips and some of its needed dependencies to support jpeg,avif,webp,png and gif processing | |
| # This has not been tested extensively, so use at your own risk. | |
| # | |
| # This takes ~18min to compile on a t3.small, ~10min on a m6a.large | |
| # | |
| # TODO cleanup the flags everywhere to be consistent | |
| # | |
| set -ex |
sbailliez
/ f_add_business_day.sql
Created
July 3, 2024 19:16
Equivalent to WORKDAY function in Excel/Google Sheet (does not support holidays, only handles weekends as saturday/sunday)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE FUNCTION f_add_business_day(start_date date, num_days integer) | |
| RETURNS date AS | |
| $BODY$ | |
| SELECT COALESCE( | |
| ( | |
| SELECT workdays.date | |
| FROM ( | |
| SELECT calendar.date::date, | |
| row_number() OVER (ORDER BY CASE WHEN num_days = abs(num_days) THEN calendar.date END, calendar.date DESC) as elapsed_days | |
| FROM generate_series( |
sbailliez
/ table_columns.sql
Created
June 17, 2024 22:06
Redshift - Returns all columns datatype, encoding, nullable and default value. Useful for maintenance
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH table_columns AS ( | |
| SELECT | |
| c.relowner as tableowner | |
| ,n.nspname AS schema_name | |
| ,c.relname AS table_name | |
| ,a.attnum AS ordinal | |
| ,QUOTE_IDENT(a.attname) AS column_name | |
| ,CASE WHEN STRPOS(UPPER(format_type(a.atttypid, a.atttypmod)), 'CHARACTER VARYING') > 0 | |
| THEN REPLACE(UPPER(format_type(a.atttypid, a.atttypmod)), 'CHARACTER VARYING', 'VARCHAR') | |
| WHEN STRPOS(UPPER(format_type(a.atttypid, a.atttypmod)), 'CHARACTER') > 0 |
sbailliez
/ compress.sql
Created
June 1, 2024 19:11
dbt macro (redshift only) to compress a specified set of columns
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {# | |
| Compresses the columns of a table to the specified encodings. Unlike the compress_table macro in dbt-redshift, | |
| you have to manually specify the encoding of the columns you want to compress, it does not run and use | |
| the result of `ANALYZE compression <table>` which would is extremely slow to run every time | |
| on a large table, especially when there is nothing to do and the table is already compressed. | |
| If the specified column does not exist or if the specified encoding is identical to the current encoding, | |
| the column is skipped. | |
| ALTER statements are generated for each column where encoding needs to be changed. |
sbailliez
/ vagrant-vmware-no-network.log
Created
November 20, 2022 04:29
Log file showing failure to run vmrun getGuestIPAddress
This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [11/19/2022, 11:19:07.391 PM] INFO global: Vagrant version: 2.3.2 | |
| [11/19/2022, 11:19:07.391 PM] INFO global: Ruby version: 2.7.6 | |
| [11/19/2022, 11:19:07.391 PM] INFO global: RubyGems version: 3.1.6 | |
| [11/19/2022, 11:19:07.391 PM] INFO global: VAGRANT_LOG="debug" | |
| [11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_EXECUTABLE="/opt/vagrant/embedded/gems/2.3.2/gems/vagrant-2.3.2/bin/vagrant" | |
| [11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_INSTALLER_ENV="1" | |
| [11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_INSTALLER_EMBEDDED_DIR="/opt/vagrant/embedded" | |
| [11/19/2022, 11:19:07.393 PM] INFO global: VAGRANT_INSTALLER_VERSION="2" | |
| [11/19/2022, 11:19:07.393 PM] WARN global: resolv replacement has not been enabled! |
sbailliez
/ postgresql_11_upgrade.md
Last active
May 7, 2021 14:11
Upgrading from Postgresql 10.6 to Postgresql 11.1
Spent a few hours dealing with errors on RDS when upgrading from a postgresql 10.6 to 11.1. In case someone else is dealing with the same problems, this might be helpful.
A few things to know about this database:
- PostGIS extension was installed but was not being used
- ip4r extension was installed but was also not used
This probably turned out to be a Good Thing (tm). If you are using PostGIS extensively, I wish you good luck.
sbailliez
/ keybase.md
Created
December 15, 2017 23:43
I hereby claim:
- I am sbailliez on github.
- I am sbailliez (https://keybase.io/sbailliez) on keybase.
- I have a public key ASBKBaDbi1k-vE33JKl3XDKxxhj-K6OANQ1lIJ0WRNZjMwo
To claim this, I am signing this object:
sbailliez
/ gist:5545294
Created
May 9, 2013 03:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| require 'etc' | |
| ssh_user = Etc.getlogin | |
| public_key_path = "~/.ssh/id_dsa.pub" | |
| ssh_public_key = File.read(File.expand_path(public_key_path)).strip | |
| Vagrant.configure("2") do |config| | |
| .... | |
| config.vm.provision :shell, :inline => "cat >>/tmp/ssh_key_pub <<EOF\n#{ssh_public_key}\nEOF" | |
| config.vm.provision :shell, :inline => "cat >>/tmp/ssh_user <<EOF\n#{ssh_user}\nEOF" |
NewerOlder