Update 2019-09-10 This tutorial Postgres guide [https://www.guru99.com/postgresql-tutorial.html] by Tushar Korat covers Postgres and is comprehensive and gets you up and going with details and excellent examples. -------------------------------------------------------------------------------- https://pgdash.io/blog/postgres-features.html This goes through some of the great capabilities of Postgres. Key points

.NET Core project Continuous Integration setups for public build SaaS services The following is a working appveyor.yml [https://github.com/Siliconrob/solcast_net/blob/master/appveyor.yml] file for a client library version: '0.0.{build}' configuration: - Release platform: Any CPU # Build worker image (VM template)

Telnet Is a friendly app that is on almost all Linux machines and many windows machines that you can use for some basic connectivity testing. telnet ip port Examples - 10.0.0.1 suppose is the server Test for RDP enabled telnet 10.0.0.1 3389 If telnet

Postgres is a powerful database that can run anything it seems, but to kepp it healthy may not be as obvious and that is where PgHero can step in and give you a nice dashboard [https://pghero.dokkuapp.com/datakick] to help review and monitor your database instance. This should

This is a visualization tool [https://www.elastic.co/products/kibana] that can be run as a docker container and hooked to your preferred datasource for increased visibility and information.  When running a SaaS it is incredibly useful for visualizing time interval windows easily.

When you need to find the appropriate Ubuntu base image for AWS EC2 machines https://cloud-images.ubuntu.com/locator/ec2/

Excellent IDE, this link [https://stackify.com/visual-studio-rider/] goes over the major points, will point out that the big difference to me between Rider and Visual Studio is the debugger immediate window where you can evaluate code snippets while debugging.  While Rider can evaluate expressions it is not as natural

SSH Key validation system to avoid the glut of passwords that y

Postman [https://www.getpostman.com/] has been an indispensable tool I have been using for doing one off testing on the SaaS API I have been developing side benefits it provides are conversion to cURL [https://curl.haxx.se/] statements and synchronization of saved requests when you create an account

If you have test code and it is not sufficient then improve it immediately. If you have monitoring and telemetry streams use those or improve them right now. If you have a legacy application with nothing, but logs then welcome to the special HELL of attempting to debug an issue

Currently this is the current process I am using for GitHub. * Fork the original repository from GitHub website. * Open the GitHub Desktop client. * Clone the newly forked repository with the GitHub Desktop client * Open the the folder with git shell Fetch all the changes on the main branch that have

Wanted to be able to search across multiple text columns at first thought about difficult joins and views, but then remembered that almost every modern database system has this builtin as default functionality and since I am having to do MS SQL Server databases for the most part this is

Wanted to create a User Defined Function in MS SQL server that would generate memorable aliases for users to use. First point is that a UDF function does not allow you to create temp tables within it or use side effecting functions like NEWID() which was not fun, but you

When creating complicated clauses for queries use the underlying IDBconnection with the template type of the underlying source, but make sure to use the db.From() and then append the Where clauses afterwards in a series to generate the appropriate parameterized and checked clause. Once the SqlExpression is built you

Created this file using the Push.js to allow simple push notifications in JavaScript like this Notify.info({ title: this.title, message: "No changes to undo." }); with an import like this import * as Notify from "../utilities/notify"; That references this file with the following contents. import

Solid project for simplifying the your react interactions with a server API data models react-refetch import React from "react"; import ReactDom from "react-dom"; import { connect, PromiseState } from "react-refetch"; import { globalStyles } from "../../styles"; import { Urls } from "../../redux/serviceurls"; import * as Notify

* Reduces cognitive load\n* Makes testing straightforward and clear* * Easier to build * Known resources can be versioned * Excellent post on this https://platform.sh/blog/containers-are-the-new-static-binaries * This part is so true and earned from many issues that come with experience. * Static typing is great because you really want the error

Created a glitch remixable project for use in turfjs presentation to be given. TurfJS - Glitch [https://blue-basement.glitch.me/] Did some simple cleanup and a few modifications to the empty test API. Easy tool to learn NodeJS programming with many assumed features to help you get started smoothly and

Working through writing prototype of NodeJS Web API using Hapijs and Postgres as the backing store. Compared to Visual Studio the process of development is so much lighter and easier.  Secondly as it is light and fluid the tests are being written quickly and validating cleanly. Choosing hapijs seems to

Had to learn about url rewrite engines for both **Apache **and **Nginx **to test a url rewrite for these servers Needed something like this http://server2:port/blah/zaps/#/pow?map=theMap By inputting something like this http://server/site/theMap Apache config that works <VirtualHost :80> ServerName

First download and setup docker on target server.  My current setup is Ubuntu 17.04 virtual machine run through VMWare Setup docker to run automatically on startup docker run -it --restart=always --name teamcity-server-instance -v /opt/teamcity/data:/data/teamcity_server/datadir -v /opt/teamcity/logs:/opt/teamcity/logs -p

This problem comes up when running Oracle XE Edition which is intentionally crippled to fuck with you. Hate Oracle databases so much. Find out the current tablespaces raw files.  You will need rights, but since this is Oracle XE you should be able to grant or log in as system

docker exec -t -i container_name /bin/bash This is important and most likely any container you log into you will be running as root so can make local modifications to a running instance if needed. Note Changes are transient and will disappear on next startup.

Start a thread in the background as a fire and forget, but have it check for cancellation in its internal notification loop. ThreadPool use to queue up the delegate that starts the thread threadSource = new CancellationTokenSource(); // Use thead pool to start a background thread ThreadPool.QueueUserWorkItem(NotificationListener, threadSource.Token); Details

https://mikehadlow.blogspot.se/2012/05/configuration-complexity-clock.html [https://mikehadlow.blogspot.se/2012/05/configuration-complexity-clock.html%5Cn%5CnThis] This [https://mikehadlow.blogspot.se/2012/05/configuration-complexity-clock.html%5Cn%5CnThis] happens every time.  Stick to hardcoded values whenever you can and simple configurations as much as possible such as simple ini.