Go To SQL

Gabe Schmidt Articles, Databases, Go, Programming, SQL, Tutorial Leave a Comment

In between projects here at Keyhole, Iโ€™ve been tasked with applying a relational database access and mapping framework in the Go language.

In this post, I go step by step to create a Postgres relational database, then perform CRUD operations against it in the Go language.

I wonโ€™t get into the specifics of configuring Go in this blog, but you can check it out yourself here – https://golang.org/. Additionally, Keyholeโ€™s very own David Pitt wrote an excellent primer on the subject here – https://keyholesoftware.com/2019/09/26/go-on-the-fly/.

Picking A Graph Database: ArangoDB, Neo4j, or OrientDB

John Hoestje Articles, Databases, Opinion, Programming Leave a Comment

TL;DR

– Spoiler alert! Graph databases are a great option for storing complex and highly connected data.
– In this post, I compare the benefits and risks of graph databases ArangoDB, Neo4j, and OrientDB for a client project.
– Due to the combination of performance and cost, I chose ArangoDB for my clientโ€™s needs.

Integrating Azure Functions with Cosmos DB SQL API in .NET Core 2.2

Zach Gardner .NET Core, API Development, Articles, Azure, Cloud, Development Technologies & Tools, SQL, Tutorial Leave a Comment

I am working on a project that leverages both Azure Functions as well as Cosmos DB. In trying to get both of these components wired together, I found that there are very few examples that work with the most recent versions of these components. I also saw examples that could work at a small scale, but donโ€™t show industry-standard best practices, and would lead to performance issues if deployed in an environment with any meaningful traffic.

To that end, I put together this blog post showing how to set up an Azure Functions project in .NET Core 2.2 to integrate with Cosmos DBโ€™s SQL API using its native tooling.

Default image for blog posts - purely decorative

Quick Introduction To SQL Server Profiler

Brian Clay .NET, Articles, Databases, Development Technologies & Tools, Tutorial Leave a Comment

When working with SQL Server, you might run across a situation where it is just not running fast enough. While there could be many reasons for this, there are tools that can help you track down just what is going on behind the scenes. SQL Server Management Studioโ€™s SQL Server Profiler or just (Profiler) is a tool that can be used to monitor queries run on your database.

In this blog post Iโ€™ll give a brief demonstration of the SQL Server Profiler tool. Iโ€™ll show you how to keep an eye on all the queries that are being run against your database, as well as how to use a filter to narrow your search to just slower-running queries…

Default image for blog posts - purely decorative

Creating a SQL Database Project for Isolated Development

Rusty Divine .NET, Articles, Databases, Development Technologies & Tools, SQL, Tutorial 2 Comments

In this article you see how to create a database project that will let you quickly and consistently deploy a database to your local environment. This approach can help to solve some issues from team members interfering with each otherโ€™s work on a shared development database.

Then, in an upcoming article, we will show you how to take the next step to include this database project in your continuous integration process and deploy it to each environment up the chain to production so that you can eliminate the need for any direct interaction with database updates.