VirtualTam's bookmarks
22 bookmarks found
-
jackc/pgx - PostgreSQL Driver and Toolkit
2023-07-04 - Getting started with
pgx - https://donchev.is/post/working-with-postgresql-in-go-using-pgx/
- jackc/pgx/v5/pgtype - Map between all common base types directly between Go and PostgreSQL
- jackc/pgx/v5/pgxpool - Concurrency-safe connection pool for
pgx - scany/v2/pgxscan - Scan data into Go structs and other composite types
- Bulk INSERT in Postgres in GO using pgx
- Postgres table batch updates using golang pgxpool not reflected in database
- pgx.Conn can see uncommitted changes made from a pgx.Tx - TL;DR use
pgxpoolfor concurrency-safe transactions - Not clear if caller is required to close in case of QueryRow or if QueryRow properly closes in case of error
- Getting started with
-
Functional table-driven tests in Go
2023-04-18 -
- https://www.ikeahackers.net/2018/10/home-office-furniture-kallax-hack.html
- https://www.thehomestud.com/2018/10/20/ikea-kallax-into-office-storage/
- https://www.ikeahackers.net/2018/11/ikea-poang-3-seat-sofa.html
- https://www.ikeahackers.net/2010/11/the-dreaded-kids-train-table-with-a-new-twist.html
- https://www.ikeahackers.net/2008/06/train-in-your-coffee-table.html
- https://www.ikeahackers.net/2017/06/diy-hidden-cat-litter-station.html
-
-
Go - Formatting tabular data
2018-07-16 Reference:
- https://golang.org/pkg/text/template/
- https://golang.org/pkg/text/tabwriter/
- https://golang.org/pkg/strings/
Articles:
Threads:
-
iptables
2018-07-04 Documentation:
- https://www.netfilter.org/documentation/index.html
- https://www.netfilter.org/documentation/HOWTO//netfilter-hacking-HOWTO.html
- https://www.netfilter.org/documentation/HOWTO//networking-concepts-HOWTO.html
- https://www.netfilter.org/documentation/HOWTO//NAT-HOWTO.html
- https://www.netfilter.org/documentation/HOWTO//packet-filtering-HOWTO.html
Articles:
- https://www.digitalocean.com/community/tutorials/how-the-iptables-firewall-works
- https://www.digitalocean.com/community/tutorials/how-to-list-and-delete-iptables-firewall-rules
- https://www.digitalocean.com/community/tutorials/iptables-essentials-common-firewall-rules-and-commands
- https://www.digitalocean.com/community/tutorials/a-deep-dive-into-iptables-and-netfilter-architecture
- https://www.digitalocean.com/community/tutorials/how-to-choose-an-effective-firewall-policy-to-secure-your-servers
How-tos:
- https://wiki.centos.org/HowTos/Network/IPTables
- https://www.digitalocean.com/community/tutorials/how-to-set-up-a-firewall-using-iptables-on-ubuntu-14-04
Routing:
- https://www.frozentux.net/iptables-tutorial/iptables-tutorial.html
- https://www.frozentux.net/iptables-tutorial/images/tables_traverse.jpg
- https://www.frozentux.net/iptables-tutorial/images/table_subtraverse.jpg
- https://upload.wikimedia.org/wikipedia/commons/3/37/Netfilter-packet-flow.svg
RHEL Documentation:
- https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/6/html/security_guide/sect-security_guide-firewalls-common_iptables_filtering
- https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/6/html/security_guide/sect-security_guide-firewalls-forward_and_nat_rules
- https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/6/html/security_guide/sect-security_guide-firewalls-malicious_software_and_spoofed_ip_addresses
- https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/6/html/security_guide/sect-security_guide-firewalls-iptables_and_connection_tracking
- https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/6/html/security_guide/sect-security_guide-iptables
- https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/7/html/security_guide/sec-setting_and_controlling_ip_sets_using_iptables
-
PowerShell Survival Kit
2018-03-07 Home:
- https://docs.microsoft.com/en-us/powershell/
- https://docs.microsoft.com/en-us/powershell/scripting/getting-started/fundamental/using-windows-powershell-for-administration?view=powershell-6
Wikiversity:
- https://en.wikiversity.org/wiki/PowerShell
- https://en.wikiversity.org/wiki/PowerShell/Variables
- https://en.wikiversity.org/wiki/PowerShell/Arrays_and_Hash_Tables
- https://en.wikiversity.org/wiki/PowerShell/Loops
Basics:
- https://stackoverflow.com/questions/1825585/determine-installed-powershell-version
- https://stackoverflow.com/questions/8343767/how-to-get-the-current-directory-of-the-cmdlet-being-executed
- https://superuser.com/questions/237902/how-can-one-show-the-current-directory-in-powershell
- https://stackoverflow.com/questions/6138849/how-do-you-move-files-folders-across-volumes-with-powershell
Commands and executables:
HTTP:
ZIP archives:
- https://serverfault.com/questions/18872/how-to-zip-unzip-files-in-powershell
- https://stackoverflow.com/questions/27768303/how-to-unzip-a-file-in-powershell
- https://www.reddit.com/r/PowerShell/comments/454e4y/how_do_i_unzip_a_zip_file_with_powershell/
- https://github.com/auberginehill/unzip-silently
- To extract silently: https://github.com/auberginehill/unzip-silently/blob/master/Unzip-Silently.ps1#L352
-
An Introduction to GCC - Table of Contents
2017-02-07 -
The C Book - Table of Contents
2017-02-07 -
Pragma statements supported by SQLite
2016-08-20 1# List databases 2PRAGMA database_list; 3 4# Describe table 5PRAGMA table_info(<table_name>); -
SQLite Memo
2015-03-14 Common ops & clauses:
- CREATE TABLE - https://www.sqlite.org/lang_createtable.html
- ALTER TABLE - https://www.sqlite.org/lang_altertable.html
- UPDATE - https://www.sqlite.org/lang_update.html
