SQLite In-Memory Database
SQLite has an option for running completely in-memory, rather than using a […]
Month: April 2021
JavaScript splice, slice, shift, pop
These four functions are commonly used to copy or modify arrays in […]
Simple SQL Server backup/restore
— Back Up ———————————————declare @filename nvarchar(255) = ‘C:\backups\’ + format(sysutcdatetime(), ‘yyyyMMddHHmmss’) + […]
NodeJS read/write text files
“use strict”;(function() { var fs = require(“fs”); var readline = require(“readline”); fs.readFile(“input.json”, […]
NodeJS Read/Write Files
const fs = require(“fs”);const readline = require(“readline”);// Read full filefs.readFile(“myfile.txt”, { encoding: […]
Modify web.config appsettings value
var config = WebConfigurationManager.OpenWebConfiguration(“~”);var section = (AppSettingsSection)config.GetSection(“appSettings”);section.Settings[“something”].Value = “newValue”;config.Save();
SQL Print output in ADO.NET
Thank you to this StackOverflow answer for showing how to retrieve PRINT […]
Make database readonly
Pretty straightforward to set a database to readonly mode. If the database […]
Javascript rest parameters
// collects parameters and turns them into an array// must be the […]
Javascript arguments vs named parameters
// different behavior in ES5 non-strict vs ES5 strict and ES6function go(id, […]