How to get latitude and longitude using addresses and the GoogleMaps API
My data set comes from http://book.flowingdata.com/ch08/geocode/costcos-limited.csv
Passing json to Rest handlers in Go.
In Go, you should know about exported fields. Exported fields must be capitalized. Also, there are two ways to parse json data. Marshaling and marshaling is one way, the other is decoding. Decoding deals with streams. Since we are dealing with the request to a Rest handler it is a stream. Therefore we should opt…
Go, how to copy data from on excel file to another
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 Hello, World through channels
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…
Oracle 1Z0-071, SQL Constraints
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…
How to query a MS SQL Server database in Go, (Golang)
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…
Oracle 1Z0-071, Subqueries
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…
Best practices for testing, development and production environments
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…
Oracle 1Z0-071, Character Data Types
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…
C# Auto Properties and Mixed Access Modifiers
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…