This is just a short article (more of a blog-ette than a full blog) about some things we as developers need to consider when sending queries to Microsoftโs SQL Server. While some of this information may also be true for other flavors of database servers, these things are known to be true for SQL Server.
Every long-term project will outlive at least some of the technologies it was originally built with. For example, a project I have been involved with recently ran into this situation. The app is hosted on Heroku, and over the years, the available MongoDB add-ons have changed and dwindled until now, there is only one.
Several migrations between MongoDB add-ons have already happened because of shutdowns. So, it was decided that rather than migrating to the last one still in existence, the project would switch to using PostgreSQL, which is supported directly by the Heroku team.
Attention: This article was published over 6 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.I was recently tasked with summarizing the data of a several-million-row table, and the task proved to be a bit grueling at first. Eventually, …
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/.
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.