Home » Databases » Page 2

Tag Archives: Databases

A guide to the InfluxDBMapper and QueryBuilder for Java Part: 2

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 ...

Read More »

DynamoDB explained – Part 1

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 ...

Read More »

DBMS vs RDBMS: Comparison and Differences between DBMS and RDBMS

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. ...

Read More »

9 Of The Most Common Mistakes In Database Design

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 ...

Read More »

Reactive Programming and Relational Databases

Imperative code eats threads at the pace of incoming requests while Software is eating the world. This post discusses the assumptions for reactive programming on the JVM and what this means for integrations – in particular, relational databases. The motivation to come up with a post is the constant increase in reactive programming adoption while some major building blocks are not yet available ...

Read More »

How to Remove Leading/Trailing White Space from a String in SQL Server? LTRIM, RTRIM Example

Unlike Java, Microsoft SQL Server 2008, 2012, 2014,  and even the latest version don’t have a built-in trim() function, which can remove both leading and trailing space from the given String. But, SQL Server does have two built-in functions LTRIM() and RTRIM() to remove leading and trailing space. The LTRIM() function removes space from the left side of String so you ...

Read More »

PostgreSQL on Open Liberty

Open Liberty is an interesting new OSS Java EE application server that originated from WebSphere Liberty. You can configure Open Liberty to use PostgreSQL as its default data source as follows: Add directives for <datasource>, <jdbcDriver>, and <library> to the server.xml configuration: <?xml version="1.0" encoding="UTF-8"?> <server description="OpenLiberty Java EE 8 Server"> <featureManager> <feature>javaee-7.0</feature> </featureManager> <httpEndpoint id="defaultHttpEndpoint" host="*" httpPort="9080" httpsPort="9443"/> <keyStore ...

Read More »