The PRQL language allows you to build a pipeline from a series of SQL-like commands, then compile those commands to correct SQL that can be used to make actual queries.
The PRQL Playground provides a way to, well, play with entering PRQL statements to see
the resulting SQL.
Enter the PRQL in the middle column, see the resulting SQL on the right.
(Click output.sql)
This repo contains a Dockerized version of Ubiqiti Network's Unifi Controller.
No more hassling with Controller, Java, or OS updates: a Docker container simplifies the installation procedure and eliminates problems with dependencies and versions.
The current version is Unifi Controller 7.1.66. This container has been tested on Ubuntu, Debian, and even Raspberry Pi hardware.
I have used up my data cap on my LTE wifi hotspot, consequently, my cell provider is only giving speeds much lower than 100 kbps download. This is evidenced by these tests from Speedtest.net and betterspeedtest.sh
Speedtest.net shows 0.6/3.6 mbps - https://www.speedtest.net/result/13183816484
Betterspeedtest.sh shows 0.4/3.25 mbps
√ OpenWrtScripts % sh betterspeedtest.sh -t 20 -p 4.2.2.1 -H netperf-west.bufferbloat.net -n 1
2022-05-21 21:43:10 Testing against netperf-west.bufferbloat.net (ipv4) with 1 simultaneous sessions while pinging 4.2.2.1 (20 seconds in each direction)
........................
The following steps will install the YAMon (Yet Another MONitor) software on your OpenWrt router. This procedure requires use of an SSH connection to your router.
Note: The procedure below has been tested with OpenWrt 19.07.
You need external storage (for example, a USB memory stick) to hold the data collected by YAMon.
| /** | |
| * Generate a "cone of data" centered around a median value | |
| * | |
| * There will be 24 rows of data, each containing 120 samples. | |
| * Each row is centered around a "median" value of 50 | |
| * Each row's sample is a random value multiplied by the "hour" so that | |
| * later hours have a larger spread. | |
| * | |
| * This should have an obvious appearance in a plot | |
| */ |
| --- | |
| ############################################################## | |
| # | |
| # setup_accounts.yml | |
| # | |
| # This Ansible playbook configures the accounts for an initial | |
| # connection to a newly provisioned VPS. It performs the following tasks: | |
| # | |
| # 1. Log into the target server using the root password (not public key) |
Child theme makes it easy to customize the theme files without having to worry about any updates breaking the changes you have made in the theme files.
You can generate a child theme for Astra from here.
In Astra Theme, the default header breakpoint is 921px. That means mobile header will be triggered at 921px screen size.
To change the default header breakpoint, edit the astra_header_break_point in a child theme. In the example below, the mobile header will be triggered at 1120px screen size. Change 1120 to the screen size of your choice.
/**
* Change the breakpoint of the Astra Header Menus
*
* @return int Screen width when the header should change to the mobile header.
*/
This set of instructions configures a fresh LEDE installation to run Homenet. They will likely work on a current build of OpenWrt.
There's lots of good info about Homenet elsewhere. See the External References section (below).
The general strategy is to connect your computer to the router's LAN Ethernet, convert the wireless and WAN interfaces to run Homenet, and test the changes so far. After things are working, configure the LAN Ethernet to Homenet through connect one of the (now Homenet) wireless interfaces.