© 2022 Hashnode
#sql
This is my first data analysis (SQL) project and I wanted to infuse elements of data analysis and my personal touch (drama and beauty) According to beloved Wikipedia (this is me sweetly referencing Wi…
We are going to build a program that parses user search query and serializes it into a SQL statement. Here is an example of a search query: firstName:"Thomas" -jefferson birthdate:[1960 TO 1970] (prof…
Error: Log reader agent has failed with an error Login failed for user 'sql-user-account'. Solution: Right click on the publication name and open properties window. Go to Agent Security page and select Security Settings of log reader ag…
Introduction While ORM libraries like Gorm are great for working with databases in most Golang applications, raw Go sql query code is unmatchable in terms of efficiency. On the other hand, using the s…
Introduction Manipulating data to get information out of it is a vital skill to know as a developer. Even if you are not a developer, it is a great skill to learn. SQL is a query language that is very…
So far in this series all of our database accesses have been reads. Let's turn our attention to writing things to a database from GraphQL. A write in GraphQL terminology is referred to as a mutation. A mutation in GraphQL is defined by its …
Started last week with a lot of ginger to keep learning and complete my assigned tasks but damn the work is a lot, I'm not going to lie 💆♀. Remember I ended last week’s gist telling you of the work…
Overview Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing i…
Introduction We'll be building a simple backend application that creates, reads, update and deletes fruits and it's description in a SQL database with Python Flask. TABLE OF CONTENTS Getting Started…
The question "Why should I use GraphQL when I can just use SQL?" popped up in my twitter feed a few weeks ago. Like many posts designed to stir controversy, it was quickly followed by a number of comments about the relative superiority of o…
