Tiago Peres tiago-peres

1. Get database from phpMyAdmin

To get the database, the quickest way is to export it

Open phpMyAdmin. If you are using XAMPP, click in the MySQL admin button

Click in the database you want to export.

I've used a Smart Scale since 2020 with its own app which eventually became Zepp Life.

Having acquired a Garmin a while ago, would be a pity to lose all that data.

The good news is that we can pull data from other accounts or activity trackers into Garmin Connect in the import page

https://connect.garmin.com/modern/import-data

So, I exported the Body data as CSV from Zepp Life.

What is possible?

Slash commands offer a way to integrate your bot commands directly into the Discord UI. However, these commands are still very limited and cannot replace every use-case for now. I'll explain the limitations and possibilities of this new feature a bit here.

Slash Commands work entirely through the Webhook API. Which introduces a number of moderation issues. See the Moderation section below. It also causes some Rate Limit Problems.

Things you can do with slash commands

Simple Q/A type commands that just take an input and return an answer
Simple commands that have side-effects such as kick/ban/music

`multipart/form-data` handling in Falcon proposal

Design philosophy

Multipart form handling should be performant, straightforward, and leave full control of the parsing process to the user, i.e. no surprising magic such as automatic creation of large files and saving anything there by default (although tools/helpers may exist to assist in that too).

Node.js Deployment

Steps to deploy a Node.js app to DigitalOcean using PM2, NGINX as a reverse proxy and an SSL from LetsEncrypt

1. Sign up for Digital Ocean

If you use the referal link below, you get $10 free (1 or 2 months) https://m.do.co/c/5424d440c63a

2. Create a droplet and log in via ssh

I will be using the root user, but would suggest creating a new user

DevCamper Backend API Specifications

Create the backend for a bootcamp directory website. The frontend/UI will be created by another team (future course). The html/css template has been created and can be used as a reference for functionality. All of the functionality below needs to be fully implmented in this project.

Bootcamps

List all bootcamps in the database
- Pagination
- Select specific fields in result
- Limit number of results

Filter by fields

Disk cleanup.
Open run then use the %TEMP% command and delete every file in there. Windows won't delete anything it needs
Open up run again but this time use the prefetch command and delete everything in this folder. Again, Windows won't delete anything it needs.
If there's memory issues (Windows telling you you're running out of memory when opening a lot of different apps), increase the virtual memory. For example, if you have 4GB of RAM, do 1024 x 4 so that would be 4096 then take that number and multiply by 2 and get 8192 so initial size would be 8192 and max size would be 91992.
Run msconfig, go to boot tab, then advanced options, check the number or processors box and then change the number to the number of processors you have. Also check the max memory box. Uncheck anything in startup you don't need as well.

	<html>
	<head>
	<link rel="stylesheet" href="https://pyscript.net/latest/pyscript.css" />
	<script defer src="https://pyscript.net/latest/pyscript.js"></script>
	</head>
	<h1>Some places I have visited over the years:</h1>
	<div id="folium"></div>
	<body>
	<py-config>
	packages = ["folium"]

	library(rayshader)
	library(rayrender)

	popdata = raster::raster("gpw_v4_population_density_rev11_2020_15_min.tif")

	population_mat = rayshader:::flipud(raster_to_matrix(popdata))

	above1 = population_mat > 1
	above5 = population_mat > 5
	above10 = population_mat > 10

	import ctypes, sys
	from ctypes import windll, wintypes
	from uuid import UUID

	class GUID(ctypes.Structure): # [1]
	_fields_ = [
	("Data1", wintypes.DWORD),
	("Data2", wintypes.WORD),
	("Data3", wintypes.WORD),
	("Data4", wintypes.BYTE * 8)