James Wade jpswade

## 2022-09-06-engineering-blogs.md

      
              1 file
            
          
              4 forks
            
          
              2 comments
            
          
              5 stars
            
          
                jpswade
                / 2022-09-06-engineering-blogs.md
            
            
              Last active
              February 26, 2024 19:47
            
              
                Engineering Blogs
              
          
  title
  published
  description
  tags
  cover_image
  
  
  Engineering Blogs
  true
  
  engineering, learning
  
  
I'm always interested in learning, especially around my roles in engineering and leadership.

  
## scratch_1.php
<?php

/** How to get the full SQL query with bindings using Laravel Eloquent **/
dd(vsprintf(str_replace('?', '\'%s\'', str_replace('%', '%%', $query->toSql())), $query->getBindings()));

## pipeline_duration.py
#!/bin/python
#aws codepipeline list-pipeline-executions --pipeline-name spectre-prod>codepipeline.json
import json
import sys
import dateutil.parser as parser
import datetime

data = json.load(sys.stdin)
total = 0
count = 0

## laravel-best-practices.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              2 stars
            
          
                jpswade
                / laravel-best-practices.md
            
            
              Created
              August 17, 2022 15:54
            
              
                Laravel Best Practices
              
          
    Laravel Best Practices

These are best practices, rather than coding standards.
Coding Standards should be guidelines that we should be aiming to stick to, relating to the way code is written and its readability.
Coding standards can be and should be defined by automation tools, such as phpCS and StyleCI.
Best Practices, however, are recommendations that may help with security, performance, or architectural patterns that are solutions to a commonly occurring problems.

  
## books.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                jpswade
                / books.md
            
            
              Created
              May 16, 2022 14:38
            
              
                Books about Nodejs, Angular2, Agile, Clean Code, Docker, Golang, Microservices, REST, TDD, BDD, and Startups.
              
          
    Books

Books about Nodejs, Angular2, Agile, Clean Code, Docker, Golang, Microservices, REST, TDD, BDD, and Startups.


topic
book


agile-software-development
Jenkins the definitive guide


agile-software-development
Continuous Delivery


agile-software-development
Agile Estimating and Planning


agile-software-development
Art of Agile Development


## SqliteTrait.php
<?php

namespace App\Traits;

use Illuminate\Database\SQLiteConnection;
use Illuminate\Support\Facades\DB;

trait SqliteTrait
{
    protected static function setUpSqlite(): void

## automail.pl
#!/usr/local/bin/perl
use warnings; use strict;
our $debug = 0;
our $writeml = 0;
#######################################################
#
#	eTicket, Open Source Support Ticket System
#	http://eticket.sourceforge.net/
#
#	Released under the GNU General Public License

## aws-tlds.csv

          
            TLD Name
            Registration and Renewal Price
            Change Ownership Price
            Restoration Price
            Transfer Price
            Transfer Term

            
              ac
              $48.00
              $48.00
              $48.00
              $0.00
              No change

            
              academy
              $12.00
              $0.00
              $83.00
              $12.00
              Renewed with transfer

            
              accountants
              $94.00
              $0.00
              $145.00
              $94.00
              Renewed with transfer

            
              adult
              $100.00
              $0.00
              $160.00
              $100.00
              Renewed with transfer

            
              agency
              $19.00
              $0.00
              $73.00
              $19.00
              Renewed with transfer

            
              apartments
              $47.00
              $0.00
              $100.00
              $47.00
              Renewed with transfer

            
              associates
              $29.00
              $0.00
              $83.00
              $29.00
              Renewed with transfer

            
              auction
              $29.00
              $0.00
              $83.00
              $29.00
              Renewed with transfer

            
              audio
              $13.00*
              $0.00
              Not supported
              Not supported
              Not supported

## php7.4-fpm-alpine
FROM php:7.4-fpm-alpine
# @see https://hub.docker.com/r/jpswade/php7.4-fpm-alpine
MAINTAINER Agent Software <dev@agentsoftware.net>

# Install gd, iconv, mbstring, mysql, soap, sockets, zip, and zlib extensions
# see example at https://hub.docker.com/_/php/
RUN apk add --update \
		$PHPIZE_DEPS \
		freetype-dev \
		git \

## DatabaseCreateCommand.php
<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

class DatabaseCreateCommand extends Command
{
    /**
	<?php

	/ How to get the full SQL query with bindings using Laravel Eloquent /
	dd(vsprintf(str_replace('?', '\'%s\'', str_replace('%', '%%', $query->toSql())), $query->getBindings()));
	#!/bin/python
	#aws codepipeline list-pipeline-executions --pipeline-name spectre-prod>codepipeline.json
	import json
	import sys
	import dateutil.parser as parser
	import datetime

	data = json.load(sys.stdin)
	total = 0
	count = 0
topic	book
agile-software-development	Jenkins the definitive guide
agile-software-development	Continuous Delivery
agile-software-development	Agile Estimating and Planning
agile-software-development	Art of Agile Development
	<?php

	namespace App\Traits;

	use Illuminate\Database\SQLiteConnection;
	use Illuminate\Support\Facades\DB;

	trait SqliteTrait
	{
	protected static function setUpSqlite(): void
	#!/usr/local/bin/perl
	use warnings; use strict;
	our $debug = 0;
	our $writeml = 0;
	#######################################################
	#
	# eTicket, Open Source Support Ticket System
	# http://eticket.sourceforge.net/
	#
	# Released under the GNU General Public License
TLD Name	Registration and Renewal Price	Change Ownership Price	Restoration Price	Transfer Price	Transfer Term
ac	$48.00	$48.00	$48.00	$0.00	No change
academy	$12.00	$0.00	$83.00	$12.00	Renewed with transfer
accountants	$94.00	$0.00	$145.00	$94.00	Renewed with transfer
adult	$100.00	$0.00	$160.00	$100.00	Renewed with transfer
agency	$19.00	$0.00	$73.00	$19.00	Renewed with transfer
apartments	$47.00	$0.00	$100.00	$47.00	Renewed with transfer
associates	$29.00	$0.00	$83.00	$29.00	Renewed with transfer
auction	$29.00	$0.00	$83.00	$29.00	Renewed with transfer
audio	$13.00*	$0.00	Not supported	Not supported	Not supported
	FROM php:7.4-fpm-alpine
	# @see https://hub.docker.com/r/jpswade/php7.4-fpm-alpine
	MAINTAINER Agent Software <dev@agentsoftware.net>

	# Install gd, iconv, mbstring, mysql, soap, sockets, zip, and zlib extensions
	# see example at https://hub.docker.com/_/php/
	RUN apk add --update \
	$PHPIZE_DEPS \
	freetype-dev \
	git \
	<?php

	namespace App\Console\Commands;

	use Illuminate\Console\Command;
	use Illuminate\Support\Facades\DB;

	class DatabaseCreateCommand extends Command
	{
	/**