cpursley

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

lavantien

Modern Software Engineering

Wake up dog, we're being enslaved! Don't ever join the army under any circumstance, or anything adjacent, you're just die and kill for the rich, meanwhile their sons are enjoying luxury and femoids abroad. All hierarchical power structures are inherently evil. They'll do whatever it takes to maintain the asymmetries of power, wealth, and information, whether it's deception, manipulation, coercion, or violent domination.

The Foundation (jump)

Knowledge and Education should be open and free. Hierarchy and Exploitation must be abolished.

Wayback Machine (internet's archive), Library Genesis/Anna's Archive (ebooks/papers library), 1337x/bk (media's archive).
Fight slavery & monopoly with FOSS, ad blockers, paywall bypassers, VPNs, proxies, peer to peer, tor snowflake,

kconner

macOS Internals

Understand your Mac and iPhone more deeply by tracing the evolution of Mac OS X from prelease to Swift. John Siracusa delivers the details.

Starting Points

How to use this gist

You've got two main options:

krezreb

notes for setting up power management under ubuntu 22.04 (kernel 5.15) on a dell xps

I am a developer and system admin. I have a LOT of browser tabs, lots of terminals open, as well as vscode and MS Teams. YMMV but as far as I can tell, the "best" balance of power savings (long battery life) vs maching usability is using tlp and tlpui. This gives approx 5 - 6 hours of battery life on my workload.

I am running an INTEL processor, the below does not apply to AMD

TL;DR

pkenil96

Spring Framework

Servlets - Java technology that you use to handle incoming requests on a server. Its a java object that has special methods for handling incoming HTTP methods. doGet, doPost, doDelete, doPut

Spring Framework

Concepts:

1. IOC Containers
2. Dependency Injection

jcubic

How to setup a literally free CDN

1. Create repo on GitHub where you'll put your files.
2. Use jsDeliver or statically to get your assets.

Here is repo I'm using:

https://github.com/jcubic/static

And links to files look like this:

sebastian-de

{
    "output": {
        "bass_enhancer": {
            "amount": 22.0,
            "blend": 0.0,
            "floor": 10.0,
            "floor-active": true,
            "harmonics": 9.999999999999995,
            "input-gain": 0.0,
            "output-gain": -8.0,

matthiasguentert

Iterate over all tables in a db and count its rows

declare @name varchar(100)
declare @sql nvarchar(300)

declare cur cursor for
    select name from sys.tables where type = 'U' and schema_id = 1
open cur

fetch next from cur into @name

simantaturja

Core Java

Chapter 0 : Fundamentals

1. Data Types and Variables - https://www.baeldung.com/java-primitives
2. Access Modifiers - https://www.baeldung.com/java-access-modifiers
3. If-Else
   1. https://www.baeldung.com/java-control-structures
   2. https://www.baeldung.com/java-using-not-in-if-conditions
   3. Switch Case - https://www.baeldung.com/java-switch
4. Loops - https://www.baeldung.com/java-loops
5. OOP Concepts - https://www.baeldung.com/java-oop

MohamedSahbi

T-SQL Database Administration Cheat Sheet

Credits

I collected these commands mainly from Microsoft Documentation. Credits goes to Microsofts Docs unless credits are stated under the code snippet.

Commands

Select Login

SELECT * FROM sys.sql_logins WHERE name = 'myapp';