Skip to content

Instantly share code, notes, and snippets.

View CliffCrerar's full-sized avatar
😎
There is a time to code, and a time to code.

C1I7F05D-C53545 CliffCrerar

😎
There is a time to code, and a time to code.
View GitHub Profile
@CliffCrerar
CliffCrerar / angular.txt
Last active June 19, 2020 02:02
Dev env lists
AESSoft.aessoft-class-autocomplete
Angular.ng-template
AngularDoc.angulardoc-vscode
codezombiech.gitignore
CoenraadS.bracket-pair-colorizer
dbaeumer.vscode-eslint
dzhavat.rxjs-cheatsheet
EditorConfig.EditorConfig
eg2.tslint
ghaschel.vscode-angular-html
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Create the Department table.
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[Department]')
AND type in (N'U'))
BEGIN
@CliffCrerar
CliffCrerar / spinner.html
Created May 12, 2020 12:59
Html spinner
<style>
.spinner-overlay {
position: absolute;
background:transparent;
display: flex;
justify-content: center;
align-items: center;
top: 0;
@CliffCrerar
CliffCrerar / child_process.exec.cb.js
Created May 12, 2020 04:27
child process output callback function standard from node docs
function(error, stdout, stderr){
if (error) {
console.error(`exec error: ${error}`);
return;
}
console.log(`stdout: ${stdout}`);
console.error(`stderr: ${stderr}`);
}
@CliffCrerar
CliffCrerar / file-extensions-with-mime-types.json
Created May 5, 2020 04:14
File extensions as keys and mime types as values
{
".123" : "application/vnd.lotus-1-2-3",
".3dml" : "text/vnd.in3d.3dml",
".3g2" : "video/3gpp2",
".3gp" : "video/3gpp",
".a" : "application/octet-stream",
".aab" : "application/x-authorware-bin",
".aac" : "audio/x-aac",
".aam" : "application/x-authorware-map",
/*
Highest Value Hour Glass Solutions
Author: Cliff Crerar
*/
// function: determines the current our glass
// - will be executed during iterations
// - takes the xc and yc parameter which are the two parts of a co-ordinate
// - then from that origin and returns it's sum to the current iteration
// - r is the two dimensional array or table
:root {
--blue: #007bff;
--indigo: #6610f2;
--purple: #6f42c1;
--pink: #e83e8c;
--red: #dc3545;
--orange: #fd7e14;
--yellow: #ffc107;
--green: #28a745;
--teal: #20c997;
{
"command": "SELECT",
"rowCount": 35,
"oid": null,
"rows": [
{
"propertyid": 1,
"estateid": 4,
"estatename": "habitibility",
"addressid": 42,
@CliffCrerar
CliffCrerar / declare-temp-table-example.sql
Last active April 3, 2020 20:20
Temporary tables in SQL and how they behave
/* BEGIN FILE (transaction) */
-- SYMANTICS:
-- In the context of SQL there is an idea of a table veriable and a temporary
table. A table variable has a table structure and is more maluable than a
temp table but it is less persistent than a temp table.
create table #OneRowOneLine (num int) -- declare the temp table
@CliffCrerar
CliffCrerar / list-of-vscode-fav-ext.json
Last active January 1, 2020 04:51
A list of my bare min and most useful extensions
[
"whtouche.vscode-js-console-utils",
"steoates.autoimport",
"mrmlnc.vscode-autoprefixer",
"streetsidesoftware.code-spell-checker",
"lenconda.theme-darkplusplusplus",
"usernamehw.errorlens",
"eamodio.gitlens",
"christian-kohler.path-intellisense",
"christian-kohler.npm-intellisense",