I couldn’t find a good example on this. For a project I am working on, I needed to be able to take an input excel document, xlsx to be specifc, and write the data to another excel file matching another standard for processing. I am going to keep the commentary to a minimum, but here…
Go is well known for it’s use of goroutines, the lightweight thread managed by the Go runtime. In the use of goroutines, we utilize channels. Channels, Channels are a conduit through which you can send and receive values. By default, sends and receives block until the other side is ready. This allows goroutines to synchronize…
Unique Constraints Requires data in the column to be unique, multiple nulls are allowed. When used in conjunction with NOT NULL, it is effectively identical to a PRIMARY KEY. Cannot be applied to UNIQUE constraint on a column of TIMESTAMP WITH TIME ZONE , CLOB or BLOB datatype. Primary Key May be applied to more…
Assumptions: That you have Go installed on your machine. That your GOPATH and GOROOT variables are set, and you have a Go work space. For instance I work out of c:\go-work. Moving on. Open a text editor and save a file in your work space as example.go , I use Visual Studio Code and the…
What is subquery in SQL? A subquery is simply a SQL query nested inside a larger query. You may also hear or see subqueries referred to as inner queries or inner selects, and the outer query also referred to as the parent, outer query or outer select. How the SQL Engine works Be aware that…
As I am sitting here working through one of our integrations, all I can think is how badly I want to throw my computer. The situation I am in could have easily been avoided by simply following best practices for testing environments. Unfortunately, my situation was beyond my control as the powers that be didn’t…
Objective: Using DDL Statements to Create and Manage Tables, Describe data types that are available for columns. Char Fixed length Stored 1 character as 1 byte NChar Fixed Length Stores 1 character as 2 bytes UTF-16 encoding Typical outside of America In the case of NChar or Char, if you designate a column as 10…
In this article, we will discuss two features of the .Net framework that help us more quickly write cleaner code. First, The Old Method Before auto properties, if I wanted to create a new property in a class with get and set methods, I could write the lengthy: This is a lot to write out…
Kind of like a list except immutable. Tuples serve as heterogeneous list. What are Tuples? Tuples are similar to lists, except they tend to be designed to be diverse in character as compared to lists in addition to performance advantages. The performance advantages of Tuples is largely attributed to their immutable nature. The immutability of…
I usually make this with leftovers from my Roasted Chicken Dinner. This is a favorite of everyone in my family. A comfort food that is also relatively healthy with the added bonus of being extremely cheap to make. If you are not making it from leftovers, you will want to brown some chicken pieces in…
