Skip to content

Instantly share code, notes, and snippets.

View theGOTOguy's full-sized avatar
💭
On a mission

Ben Li-Sauerwine theGOTOguy

💭
On a mission
View GitHub Profile
@theGOTOguy
theGOTOguy / gist:dfcea71e2528b6ea24f9db710b59b244
Last active September 22, 2023 02:42
Connecting PowerBI to Planetscale Read-Only With Over 100,000 Rows
Today @MooreCar and I spent an hour figuring this out.
This only works on the PowerBI Desktop Application (not web).
1) In the Planetscale Web UI, create a new read-only connection string (https://planetscale.com/docs/concepts/connection-strings)
- Selecting "Mysql CLI", note the host (-h), username (-u) and password (-p).
2) In the PowerBI Desktop App, install the Oracle MySQL connector (https://learn.microsoft.com/en-us/power-query/connectors/mysql-database). Note that at the time of this writing, only 8.0.26 is supported.
3) Create a new MySQL Database data source in the PowerBI Desktop app.
- Host: The host from (a)
- Database: You can put the name of your database here. In our case, "simpleaq". I don't believe it matters.
- You cannot simmply select a table and proceed. You will get an error like "target: typebot.-.primary: vttablet: rpc error: code = Aborted desc = caller id: oqcm30z7knpwnk7x7mwq: row count exceeded 100000 (CallerID: oqcm30z7knpwnk7x7mwq)" if you have more than 100,000 rows i
@theGOTOguy
theGOTOguy / NVIDIA-proprietary.sh
Created April 9, 2023 03:50
NVIDIA Proprietary Drivers 525 Fail to Install on Ubuntu Jammy
# Since the 525 drivers, I noticed that, e.g.:
sudo ./NVIDIA-Linux-x86_64-525.105.17.run
# Has started failing with an error indicating that I should check /var/log/nvidia-installer.log
# Looking at those logs, I see an error indicating that the version of GCC being used doesn't match.
# In particular, the default version of cc at /usr/bin/cc is gcc-11, but gcc-12 is expected.
# This is easy to fix.
which gcc-12
@theGOTOguy
theGOTOguy / main.js
Created April 6, 2023 06:35
Bezier Bean Source Code for TinkerCAD "Cloud Gate"
// Convenience Declarations For Dependencies.
// 'Core' Is Configured In Libraries Section.
var Conversions = Core.Conversions;
var Debug = Core.Debug;
var Path2D = Core.Path2D;
var Point2D = Core.Point2D;
var Point3D = Core.Point3D;
var Matrix2D = Core.Matrix2D;
var Matrix3D = Core.Matrix3D;
var Mesh3D = Core.Mesh3D;