Tag Archives: Databases

When building web applications, a great deal of optimization often occurs to speed up the flow of information from and to the user. The possible ways of speeding up this information flow are as varied as web applications themselves. In this article we will be focusing on the way a data model can be optimized to fit the specific use ...

Previously we used the group by statement extensively in order to execute complex aggregation queries On this tutorial we are going to have a look at ‘into’ statements and the ‘order by’ close. Apart from inserting or selecting data we might as well want to persist the results from one query into another table. The usages on something like this ...

This post is part of a series where I do my best to organize my thoughts around Go: its paradigms and usability as a programming language. I write this as a Java programmer that respects the principles of Elegant Objects. I am studying the Go Code Review mantra Accept Interfaces, Return Structs and was inspired to write this post after ...

Previously we executed some selection examples and aggregations against an InfluxDB database. In this tutorial we are going to check the group by functionality that the Query Builder provides to us with. Before you start you need to spin up an influxdb instance with the data needed. Supposing that we want to group by a single tag, we shall use ...

Previously we setup an influxdb instance running through docker and we also run our first InfluxDBMapper code against an influxdb database. The next step is to execute some queries against influxdb using the QueryBuilder combined with the InfluxDBMapper. Let’s get started and select everything from the table H2OFeetMeasurement. 01 02 03 04 05 06 07 08 09 10 private static ...

DynamoDB has been a bit of a buzzword recently, so after years working on relational and document databases I decided to give it a try. A lot of the assumptions I had made about DynamoDb before working with it turned out to be false, so I am hoping that this series of blog posts will help you decide if DynamoDB ...

With the release of latest influxdb-java driver version came along the InfluxbMapper. To get started we need to spin up an influxdb instance, and docker is the easiest way to do so. We just follow the steps as described here. Now we have a database with some data and we are ready to execute our queries. We have the measure ...

The World is all about Data. Know more about DBMS and RDBMS…and what’s next. Data and Information Management is not new. Nevertheless, this article is for those people who are new to the data world and are constantly seeking and searching for relevant information online. In this article, we are going to take a dip into DBMS and RDBMS. 1. ...

As a database designer, when you are tasked with a database project, you can expect to run into a couple of challenges during the design process and after the database is deployed to production. Some of these problems are unavoidable and outside your control. However, a number of them can be traced back to the quality of the database design ...