Bypass Paywalls Clean extension

making the ubnt wifi awesome (uap ac lite) w/ openwrt - uap-ac-lite-openwrt.txt

Clone me to create your Manubot manuscript. Contribute to manubot/rootstock development by creating an account on GitHub.

Source code plagiarism detection tool. Contribute to manuel-freire/ac2 development by creating an account on GitHub.

GitHub Gist: star and fork markasoftware's gists by creating an account on GitHub.

Inofficial repository for Dymo's offical FOSS CUPS printer drivers for Linux - matthiasbock/dymo-cups-drivers

(~)};) jerryradio.com/downloads GDead & Jerry Garcia Band mp3bretmiller.com/downloads GDead & Jerry Garcia Band mp3 mediafire.com/Grateful Dead SBDs shared by sgrmag741974-05-21 Edmundson Pavilion, University of Washington1976-06-14 Beacon Theatre, New YorkFall 1979 Road Trips 1.1 + Bonus Fall 1979 East Coast 'RT 1.1'1990-03-14/16 Capital Centre Landover, MD mediafire.com/Grateful_Dead SBDs shared by CandymanDick's Picks 1-36,Dave's Picks 1-22,Dave's Picks Bonus 2012-2016 (2012 7/29/74,2013…

(~)};) jerryradio.com/downloads GDead & Jerry Garcia Band mp3bretmiller.com/downloads GDead & Jerry Garcia Band mp3 mediafire.com/Grateful Dead SBDs shared by sgrmag741974-05-21 Edmundson Pavilion, University of Washington1976-06-14 Beacon Theatre, New YorkFall 1979 Road Trips 1.1 + Bonus Fall 1979 East Coast 'RT 1.1'1990-03-14/16 Capital Centre Landover, MD mediafire.com/Grateful_Dead SBDs shared by CandymanDick's Picks 1-36,Dave's Picks 1-22,Dave's Picks Bonus 2012-2016 (2012 7/29/74,2013…

Software Engineering Manager interested in all kinds of development related topics. Strong focus on automating workflows and lean development processes. - memoryleak

Software Engineering Manager interested in all kinds of development related topics. Strong focus on automating workflows and lean development processes. - memoryleak

Posts about metadata matters written by ruaok

Teaching online gardening classes worldwide & building coops & beehives locally!

Contribute to micheal-donald/ATS-BEATER development by creating an account on GitHub.

使用micropython实现MAC 管理帧的发送. Contribute to LinJing517/micropython-deauth development by creating an account on GitHub.

I had long been aware of the [effort of cznic](https://gitlab.com/cznic/sqlite) to automatically translate the C source of SQLite to Go while avoiding the complexity CGo would introduce. SQLite was always meant to be a database you embed into your application, and I was curious what tradeoffs that meant, if any, and just generally how it differed from the usual suspects (PostgreSQL, etc.). To explore these trade-offs and differences, I decided to dive deeper into the usage of this library. SQLite is a single-writer multiple-reader database. Using just a single instance of database/sql.DB will not work well with this, because it will make it hard to avoid receiving SQLITE_BUSY errors when multiple writers try to run at the same time (because sql.DB is a connection pool). So we will need to separate readers from writers by making two instances of database/sql.DB and limiting the writer to a single [MaxOpenConn](https://pkg.go.dev/database/sql#DB.SetMaxOpenConns) and the reader to as many as you require. So far, SQLite is behaving remarkably like other databases apart from the single-writer gotcha; we still have connections and per-connection settings. The usual way to pass these settings is usually in the DSN you pass to [sql.Open](https://pkg.go.dev/database/sql#Open) and this is [definitely possible](https://pkg.go.dev/modernc.org/sqlite#Driver.Open), but I find that it would be more straightforward if I could just run my custom SQL when a new connection is made[1]. We can do that with [sqlite.RegisterConnectionHook](https://pkg.go.dev/modernc.org/sqlite#RegisterConnectionHook). Now the question is what settings to use, because [there are quite a few of them](https://www.sqlite.org/pragma.html). These are the ones I am using personally: - `PRAGMA journal_mode = WAL;` Use write-ahead-logging. Better concurrency, but with an edge-case: with heavy writers, the wal can grow idefinitely ([see for more](https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md)). I don't expect this will happen in my use-case. For a good description on the various jornal modes, [see this blogpost](https://www.mycelial.com/learn/sqlite-journal-mode-options). - `PRAGMA synchronous = NORMAL;` Since with the WAL journal mode, this is safe, there is no reason to use FULL. - `PRAGMA temp_store = MEMORY;` Let's store temporary indices, tables, etc. in memory, my use-case is not very resource-constrained to require using the filesystem (also, [this is a fun read](https://www.sqlite.org/fasterthanfs.html) if we are talking about additional syscalls to the kernel) - `PRAGMA mmap_size = 30000000000; -- 30GB` Just making sure, access to my database is always done with memory-mapped I/O. - `PRAGMA busy_timeout = 5000;` How much time to wait in milliseconds after which SQLITE_BUSY is returned when waiting for the db to unlock. - `PRAGMA automatic_index = true;` Make sure [automatic indexing](https://www.sqlite.org/optoverview.html#autoindex) is enabled, it can only help, and is a great way to get warnings about indexes that should be created. - `PRAGMA foreign_keys = ON;` Make sure foreign key enforcement is enabled. - `PRAGMA analysis_limit = 1000;` Make sure [ANALYZE](https://www.sqlite.org/lang_analyze.html#approx) returns quickly in case the DB gets large. - `PRAGMA trusted_schema = OFF;` No idea what security audited functions are, but this setting makes sure only those can be run. The manual page tells me to turn it off anyway, so let's do that. Not all of these settings are per-connection settings, but it doesn't hurt to always run all of these on every connection, and having a single "Init SQL" makes things simpler. Let's deal with explicit transactions next. The default transaction mode is DEFERRED, meaning that it depends on the next statement what type of transaction is started (if a SELECT statement comes first, a read transaction is started, with the possibility of upgrading it to a write transaction depending on the statements that follow). With our setup, there should never be multiple writers concurrently, so making all transactions write transactions from the get-go (with BEGIN IMMEDIATE) can only help us show if this invariant is violated. Putting this all together, this is the code we arrive at: ```go package main import ( "bytes" "context" "crypto/sha1" "database/sql" "database/sql/driver" "encoding/hex" "fmt" "time" "modernc.org/sqlite" ) type DB struct { dbPath string Read *sql.DB Write *sql.DB } const initSQL = ` PRAGMA journal_mode = WAL; PRAGMA synchronous = NORMAL; PRAGMA temp_store = MEMORY; PRAGMA mmap_size = 30000000000; -- 30GB PRAGMA busy_timeout = 5000; PRAGMA automatic_index = true; PRAGMA foreign_keys = ON; PRAGMA analysis_limit = 1000; PRAGMA trusted_schema = OFF; ` func New(ctx context.Context, dbPath string) (db *DB, err error) { db = &DB{ dbPath: dbPath, } // make sure every opened connection has the settings we expect sqlite.RegisterConnectionHook(func(conn sqlite.ExecQuerierContext, _ string) error { _, err = conn.ExecContext(ctx, initSQL, nil) return err }) write, err := sql.Open("sqlite", "file:"+db.dbPath) if err != nil { return } // only a single writer ever, no concurrency write.SetMaxOpenConns(1) write.SetConnMaxIdleTime(time.Minute) if err != nil { return } read, err := sql.Open("sqlite", "file:"+db.dbPath) if err != nil { return } // readers can be concurrent read.SetMaxOpenConns(100) read.SetConnMaxIdleTime(time.Minute) db.Read = read db.Write = write return } func (db *DB) InTransaction(ctx context.Context, tx func(context.Context, *sql.Conn) error) (err error) { // cancel anything that takes longer than 5 seconds var cancel func() ctx, cancel = context.WithTimeout(ctx, time.Duration(5*time.Second)) defer cancel() // separate conn thats just for us // so that the transactions queries are executed together conn, err := db.Write.Conn(ctx) if err != nil { return } defer conn.Close() _, err = conn.ExecContext(ctx, "BEGIN IMMEDIATE TRANSACTION") if err != nil { return } defer func() { if r := recover(); r != nil || err != nil { if _, err = conn.ExecContext(ctx, "ROLLBACK"); err != nil { return } } }() err = tx(ctx, conn) if err != nil { return } _, err = conn.ExecContext(ctx, "COMMIT") return } ``` Just as a small added bonus, it's also very easy to register our own go functions that we can then call from SQL. In this example, we define the sha1 function, receiving and returning a single argument, and always returning the same output for the same input (thus the deterministic). For more information, [see the docs](https://www.sqlite.org/appfunc.html) ```go func registerFuncs() { // lets add our own sha1 hash function usable from SQL sqlite.MustRegisterDeterministicScalarFunction( "sha1", 1, func(ctx *sqlite.FunctionContext, args []driver.Value) (driver.Value, error) { var arg *bytes.Buffer switch argTyped := args[0].(type) { case string: arg = bytes.NewBuffer([]byte(argTyped)) case []byte: arg = bytes.NewBuffer(argTyped) default: return nil, fmt.Errorf("expected argument to be a string, got: %T", argTyped) } h := sha1.Sum(arg.Bytes()) return hex.EncodeToString(h), nil }, ) } ``` In conclusion, this solution works perfectly well for most of the usage scenarios out there where immense scaling is neither expected nor needed. There are faster ways to use SQLite with Go (see the [excellent cvilsmeier benchmarks](https://github.com/cvilsmeier/go-sqlite-bench)), but its still plenty-fast enough, and avoiding CGo makes it very convenient also. [1]: This is another thing that database/sql.DB being a connection pool makes harder.

After mounting a NTFS partiton in read/write, a NFS partition and just last week a LVM2_member partition. Its time for a new episode in the series: How to mount an unknown file-type in Linux. As they say, the saga continues. Note that I use proxmox (Debian spin) on this machines, this makes that ZFS was already installed. Installing ZFS is easy, and I done it before on Mint, the official ZFS (on linux) information is also a huge help, so head over there if you wan’t up-to-date install & configuration help.

Ansible role to manage Netplan. Contribute to mrlesmithjr/ansible-netplan development by creating an account on GitHub.

multiOTP open source strong two factor authentication PHP library, OATH certified, with TOTP, HOTP, Mobile-OTP, YubiKey, SMS, QRcode provisioning, etc. - multiOTP/multiotp

Behind the scenes of myNoise. Personal notes from the Stéphane, the creator of myNoise.

A curated list of amazingly awesome open-source sysadmin resources. - awesome-foss/awesome-sysadmin

Blackbox tool to disable SSL certificate validation - including certificate pinning - within iOS and macOS applications. - nabla-c0d3/ssl-kill-switch2

A scriptable music downloader for Qobuz, Tidal, SoundCloud, and Deezer - nathom/streamrip

🎧☁️ Your Personal Streaming Service. Contribute to navidrome/navidrome development by creating an account on GitHub.

📮 Self hosted bookmarking app. Contribute to ndom91/briefkasten development by creating an account on GitHub.

A collection of community-sourced DeviceType definitions for import to NetBox - netbox-community/devicetype-library

NetBox DNS is a NetBox plugin for managing DNS data. - netbox-plugin-dns/docs/using_netbox_dns.md at main · peteeckel/netbox-plugin-dns

NetBox DNS is a NetBox plugin for managing DNS data. - netbox-plugin-dns/examples/ansible/using_netbox_dns_with_ansible.md at main · peteeckel/netbox-plugin-dns

A short course designed to take new NetBox users from ‘Zero to Hero’. - netbox-zero-to-hero/custom_scripts/SiteStatusBulkUpdater.py at main · netbox-community/netbox-zero-to-hero

Using network observability to operate and design healthier networks - netenglabs/suzieq

NetXMS - Open Source network and infrastructure monitoring and management - netxms/netxms

nf-HiPAC: High Performance Firewall for Linux Netfilter

nginx config snippets: gzip, catchall, domain c14n, ssl, uwsgi, php, wordpress - nginx-config-snippets/ubuntu/etc/init/mounted-run-extra.conf at master · danielrichman/nginx-config-snippets

Updated list of public BitTorrent trackers. Contribute to ngosang/trackerslist development by creating an account on GitHub.

Currently a self employed freelance developer & teacher. I mainly work with Flask, Rails, Bash, Docker, Kubernetes, Ansible & Terraform. Also a @docker captain. - nickjj

This is a bit of a vent, I may be wrong, I may be a little caught up in the moment, but a simple task should not be this difficult. I’m currently trying to setup a Kiosk-mode Raspberry Pi for Leigh Hackspace to act as a ‘Hackspace Status’ screen, showing some stats and a rotating list of artwork to show upcoming events. I decided to just try and build something myself, but while I was using the Raspberry Pi Imager I spotted a section for purpose-specific OS installations, and within there was Anthias. “Hey, that looks good, Web UI and does what I need it to do” I thought to myself. Anthias is the rebadged Screenly OSE, as to avoid confusion they renamed it to split it away from the commercial Screenly option. Open source versions of commercial products never really work well, but maybe it’ll do the bare minimum I need.

Simple Linux router implementation for Debian + Netfilter/IPtables - noahbailey/ansible-router

CLI QuickTime AAC/ALAC encoder. Contribute to nu774/qaac development by creating an account on GitHub.

Director of DNS Engineering @ ISC. oerdnj has 129 repositories available. Follow their code on GitHub.

Posts about openbsd written by morecode

a simple captive Portal using OpenBSD. Contribute to overrider/openbsd-captive-portal development by creating an account on GitHub.

Applicant Tracking System (maintained code base). Contribute to opencats/OpenCATS development by creating an account on GitHub.