Miftah Afina miftahafina

Garlic OS Tips (Windows-based)

GarlicOS Cookbook

Follow these instructions for an easy way to get up and going quickly! These are complete instructions, and will be the easiest way to get started on a new RG35XX.

Set up SD Card

Get a high quality SD (e.g. SanDisk Extreme) card, 128GB or larger, 256GB is recommended. Don't skimp here, they're cheap, and don't use the card that comes with the RG35XX as it's crap.

Taking Advantage of TextFinder for Google Spreadsheet

There is Class TextFinder in Spreadsheet service for Google Apps Script. Ref The TextFinder can search and replace the texts in the Spreadsheet using Google Apps Script. There is the method for createTextFinder in Class Spreadsheet, Class Sheet and Class Range. When these methods are used, you can search and replace the texts for all sheets in a Spreadsheet, the specific sheet, and the specific range in the specific sheet.

In this post, I would like to introduce the sample scripts for taking advantage of TextFinder.

I think that TextFinder is the strong method for searching values in Google Spreadsheet. Ref So I think that when this can be taken advantage of, the process cost of the script will become low.

Sample script 1

Electron is tricky to get set up on Windows Subsystem for Linux, but it can work!

Four things needed overall:

you need WSL2, not WSL1
you need node, of course, and that part isn't so bad
you need to apt install several dependencies
you need an X Server so it can display the electron GUI over in Windows-land

Setup instructions, in order:

Building a react native app in WSL2

Install, build and debug a react native app in WSL2 (Windows Subsystem for Linux) and Ubuntu.

Install tools in Windows
Install tools in WSL2
Connect to android hardware device from WSL2
Connect to android virtual device in Windows
- Start android virtual device in Windows
Start adb server in Windows

A non persistent way across reboots to change the DNS:

# scutil
> open
> d.init
> d.add ServerAddresses * 8.8.8.8 9.9.9.9
> set State:/Network/Service/PRIMARY_SERVICE_ID/DNS
> quit

To check the change:

Android Emulator Setup without Android Studio in Windows with Flutter

First Download the Android SDK Commandline Tool only.

https://developer.android.com/studio/

Goto Download Options

Find Commandline tools only Section

Edit the file php.ini (or PHP FPM if on Forge):

memory_limit = 512M

post_max_size = 20M

upload_max_filesize = 20M

Project Ideas

Ok. I'm going to list off some ideas for projects. You will have to determine if any particular idea is good enough to include in a portfolio. These aren't creative ideas. They likely already exist. Some are way too advanced while others are simplistic.

I will recommend to post any project you make to github and make a github project page for it. Explain in as much detail as possible how you made it, how it can be improved etc. Document it.

If you pick an advanced idea, setup a development roadmap and follow it. This will show some project management skills.

Another piece of advice for those who are design challenged. Use different front end frameworks and use different themes for those frameworks to provide appealing designs without looking like yet another bootstrap site.

 /**
  * Function to replace text in Google Slides with Google Sheet values
  * @reference https://hudsonatwell.co/2020/10/03/how-to-use-google-slides-to-autogenerate-featured-images/
  */
 function generate_featured_image() {
   /* get spreadsheet from public view link */
   var dataSpreadsheetUrl = "https://docs.google.com/spreadsheets/d/1necmbNPUsGJ3fwNiFpgNLbtH6c2RmJDwIQCPuhAfA7s/edit"; //make sure this includes the '/edit at the end
   var ss = SpreadsheetApp.openByUrl(dataSpreadsheetUrl);

	# Location: /mnt/c/windows/system32/drivers/etc/hosts
	127.0.0.1 virtualhost.local www.virtualhost.local