goabonga

🕹️ Pong in SQL

A fully functional ASCII Pong game implemented entirely in MySQL, using:

• A pong_state table to track ball and paddle positions
• Stored procedures to simulate ball physics and paddle AI
• A MySQL EVENT to update the game state every second
• A visual render_full_frame_lines() procedure that returns a styled ASCII frame
• A Docker setup with MySQL + phpMyAdmin for testing

jwbee

Make Ubuntu packages 90% faster by rebuilding them

TL;DR

You can take the same source code package that Ubuntu uses to build jq, compile it again, and realize 90% better performance.

Setting

I use jq for processing GeoJSON files and other open data offered in JSON format. Today I am working with a 500MB GeoJSON file that contains the Alameda County Assessor's parcel map. I want to run a query that prints the city for every parcel worth more than a threshold amount. The program is

lyrixx

<?php

use App\Kernel;

require __DIR__.'/vendor/autoload_runtime.php';

use Symfony\Component\Console\Output\StreamOutput;
use Symfony\Component\DependencyInjection\Compiler\CompilerPassInterface;
use Symfony\Component\DependencyInjection\ContainerBuilder;

Glideh

/** Checks if the JWT is present and not expired
The token is expected to be found in `token` environment variable
*/
function isValidToken() {
    const token = pm.environment.get("token");
    if (!token) {
        console.log("Token is missing");
        return false;
    }
    // Payload is retrieved after JSON parsing the base64 decoded `atob()` 2nd part of the JWT `[1]`

Pierstoval

# Use it like this:
#
#     $ printf $(_TITLE) "Something in green" "The message"
#
# This will output something like this:
#
# [Something in green] The message
#
# (of course, with proper colors)
_TITLE := "\033[32m[%s]\033[0m %s\n" # Green text

drupol

<?php

declare(strict_types=1);

include 'vendor/autoload.php';

use loophp\collection\Collection;

$monteCarloMethod = static function ($in = 0, $total = 1) {
    $randomNumber1 = mt_rand() / mt_getrandmax();

Ocramius

<?php

final class RegisterRepositoriesForAllEntitiesPass implements CompilerPassInterface
{
    /** {@inheritdoc} */
    public function process(ContainerBuilder $container)
    {
        /** @var MappingDriver $metadata */
        $metadata = $container->get($this->mappingDriverServiceName());
        $entityManagerReference = new Reference('doctrine.orm.entity_manager');

simonbs

// Variables used by Scriptable.
// These must be at the very top of the file. Do not edit.
// icon-color: brown; icon-glyph: file-code;
// To use this script, you need to configure an OAuth App on GitHub.
// Follow the instructions on the link below to create your OAuth App.
//
// When you are asked to put in a redirect URL, you should put the URL for running this script in Scriptable. Assuming the name of this script is "Create Gist", the URL is scriptable:///run?scriptName=Create%20Gist
//
// https://developer.github.com/apps/building-oauth-apps/creating-an-oauth-app/
//

seanhandley

version: '2'
services:
  api:
    volumes:
      - "nfsmount:${CONTAINER_DIR}"

volumes:
  nfsmount:
    driver: local
    driver_opts:

roblabs

#!/bin/bash -e

# --------------------------------------------------------
# Generate app icons and xcassets file from a single image
# Ben Clayton, Calvium Ltd.
#  https://gist.github.com/benvium/2be6d673aa9ac284bb8a
# --------------------------------------------------------
#
# Usage with an input of 1024x1024 PNG file
#   generateAppIcon.sh AppIcon.png