Useful info for the Comcast Business Voice Edge service: The portal login is at – at the time of this writing the security certificate is expired (way to go Cumcast) To log in as admin, you m…

Improve device reliability and offer higher service availability by duplicating parallel power supplies. Understand concepts and corresponding mathetical formaluas

LibreELEC

Automated Malware Analysis – Cuckoo Sandbox Home About Download […]

Auf YouTube findest du die angesagtesten Videos und Tracks. Außerdem kannst du eigene Inhalte hochladen und mit Freunden oder gleich der ganzen Welt teilen.

Setting up OSSEC - A step by step guide on how to install and configure OSSEC.

Numbers stations and other odd radio stations, espionage, jamming, cryptography, code messages, SIGINT

A powerful two pane file manager for the Gnome desktop

Oblio13's Underground Coop I've been intrigued by colonial era bank houses and Anasazi pit houses for years, and I figured this was as good an excuse as...

"That was an awesome speech!" said the young man carrying my suitcase. "The second-years gave us a hint of what to expect. You're a riot in person. I can't believe you got our MBA class to sing 'Bohemian Rhapsody.'" "Are you excited about graduation?" I asked the young man. "Yes and no," [...]

Stewart Moving & Storage - Reputable Jacksonville FL moving company for local, long distance. Our professional movers Jacksonville FL ensure a stress-free move.

A timeline recording only some of the many disasters happening in crypto, decentralized finance, NFTs, and other blockchain-based projects.

Learn how to look people in the eye to improve your romantic life, your business life. Also eye contact tips so you don't look creepy.

Grateful Dead, Dead Heads and their pharmaceuticals

Grateful Dead was a rock band fronted by the late Jerry Garcia and Bob Weir. They are famous for their concert tours which attracted a groupie following who were dubbed as "dead heads." In 1988, they arranged The Rainforest Benefit, a concert to raise awareness for environmentalism. The Muppets...

Unisex Adult/KidsTee Shirts. Organic Cotton Shirts. Tie Dyed Graphic Tee Shirts. Sustainable Packaging.

Amazon.com: PiAware MicroSD +Pro Stick USB ADS-B Receiver + 1090MHz Band-Pass Filter frm FlightAware - Track Planes Live Near You!

RIPE Atlas is the RIPE NCC's main Internet data measurement system.

Crazy Arms Radio Backend is a flexible and fully featured Internet radio back-end written from the ground up.

tinc VPN setup instructions on Windows and Linux. GitHub Gist: instantly share code, notes, and snippets.

This article describes the ideas behind the system I designed and built myself. It started out as a "I wonder what it would sound like if..." exercise, and turned into the system I would choose to listen to even if I had the chance to swap it for commercial gear. It includes the first speakers I ever…

Auf YouTube findest du die angesagtesten Videos und Tracks. Außerdem kannst du eigene Inhalte hochladen und mit Freunden oder gleich der ganzen Welt teilen.

A replacement for SteelSeries GG software, to manage your Arctis device on Linux! - elegos/Linux-Arctis-Manager

A opinionated config for running Redmine with Nginx and thin. - perusio/redmine-nginx

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 Broadcom increased the license fees, other virtualization solutions than VMware ESXi become very popular. I already talked about other solutions like CBSD, running on FreeBSD using bhyve for virtual machines (VM) workloads or Harvester, as an HCI solution that also allows you to run VM in a different approach. However, we mostly hear Proxmox

Streaming Grateful Dead and More! 24/7/365

Day four of 100 cities in 100 days security campaign, let's explore some techniques and tools to increase the security stance of the Firefox web browser.

DNS is one of those services that still requires logging into some web portal and clicking buttons and entering data. Heaven forbid you enter a bad IP address and take down your service – there’s no “rollback to previous value” option. Want to track your configurations over time? Sorry, not something your web portal can often do. DNS configuration should be simple, trackable, and automatable.

Register email and IP for access to the Gnudb CD database

Auf YouTube findest du die angesagtesten Videos und Tracks. Außerdem kannst du eigene Inhalte hochladen und mit Freunden oder gleich der ganzen Welt teilen.

Auf YouTube findest du die angesagtesten Videos und Tracks. Außerdem kannst du eigene Inhalte hochladen und mit Freunden oder gleich der ganzen Welt teilen.

Smart SSH, HTTPS, MySQL and Postgres bastion/PAM that doesn't need additional client-side software - warp-tech/warpgate

This month I built and launched a website called Earlyname, which lets you claim your original “OG” usernames on new apps, games and websites (for example @ben, @mike or @mia). This is the story of how it went.

Learn to whistle loudly with your fingers.

You can use Sieve mail filters to control how mail is delivered.

I know what you came here to see. . Ernie receives 'it' will telling him he has wen the letter; but befire he can celebrate he is interrupted E "April Feels". T

Auf YouTube findest du die angesagtesten Videos und Tracks. Außerdem kannst du eigene Inhalte hochladen und mit Freunden oder gleich der ganzen Welt teilen.

Nginx installer for AlmaLinux, Rocky Linux and CentOS. Shell Menu based install and management for optimized LEMP stack - Nginx, PHP-FPM and MariaDB MySQL

In Here Is New York, E.B. White opens with this sentence: “On any person who desires such queer prizes, New York will bestow the gift of loneliness and the gift of privacy.” Sixty-four …

Build your own Timber Frame style Gazebo. Plans available for this Western Red cedar and Douglas Fir Gazebo. Timber Framing knowledge is not required.