Best Practices for Resource Management in PrestoDB

Resource management in databases allows administrators to have control over resources and assign a priority to sessions, ensuring the most critical transactions get a significant share of system resources. Resource management in a distributed environment makes accessibility of data more accessible and manages resources over the network of autonomous computers (ie, Distributed systems). The basis … Read more

What is JDBC? Introduction to Java Database Connectivity

JDBC (Java Database Connectivity) is the Java API that manages connecting to a database, issuing queries and commands, and handling result sets obtained from the database. Released as part of JDK 1.1 in 1997, JDBC was one of the earliest libraries developed for the Java language. JDBC was initially conceived as a client-side API, enabling … Read more

TiDB’s Timestamp Oracle – DZone Database

Today, distributed databases lead the market, but time synchronization in distributed systems remains a hard nut to crack. Due to the clock skew, the time in different nodes of a distributed database cannot be synchronized perfectly. Many computer scientists have proposed solutions such as the logic clock by Leslie Lamport (the 2013 Turing Award winner), … Read more

How Does the Database Understand and Execute Your Query?

A vector query in Milvus is the process of retrieving vectors via scalar filtering based on a boolean expression. With scalar filtering, users can limit their query results with certain conditions applied to data attributes. For instance, if a user queries for films released during 1990-2010 and scores higher than 8.5, only films whose attributes … Read more

Spring data R2DBC with H2 database not working

I am developing a spring command line application where I connect to a db using data r2dbc. For information, my application is written in Kotlin. the pom file contains: <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.6.7</version> <relativePath></relativePath> <!– lookup parent from repository –> </parent> … <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-r2dbc</artifactId> </dependency> <dependency> <groupId>org.mariadb</groupId> <artifactId>r2dbc-mariadb</artifactId> <scope>runtime</scope> </dependency> As it is a … Read more

How to Hash, Salt, and Verify Passwords in NodeJS, Python, Golang, and Java

Storing passwords can be a nuance due to the liability of them being compromised. To make matters worse, users tend to reuse passwords across services which makes storing them securely even more important. The aim behind storing passwords securely is that even if the database containing them is compromised, the attacker can’t decipher any user’s … Read more

Synchronization Methods for Many-To-Many Associations

The many-to-many association is a common thing in data modeling. In JPA entities, it is implemented as collections that store associated entities from the other side of the association. To keep collections consistent on both sides, developers usually implement data synchronization methods. This article will highlight common issues that happen when adding synchronized methods for … Read more

Counting Faster With Postgres – DZone Database

Count queries are probably the most-used aggregate queries in a relational database. Counting is a fundamental operation required for many CRUD applications like sorting, pagination, and searching. But counting records can become terribly slow as your dataset grows. Fortunately, there are strategies for dealing with this problem. This article will show you a few approaches. … Read more

A Smarter Redis – DZone Database

Everyone loves Redis. It’s fast, easy to use from almost any programming language, and works exactly as it should. In addition, it’s got an impressive list of modules for additional functionality. It’s an excellent product. Sometimes, though, we may want Redis to be a little smarter. We want some clients to have a different view … Read more

OpenTelemetry in Action: Identifying Database Dependencies

Microservices can help any organization achieve its goal of increasing agility by addressing critical factors such as improving team autonomy, reducing time to market, cost-effectively scaling for load, and avoiding complete outages of the applications. As organizations break their monolith applications into microservices, one of the major hurdles they encounter is identifying database dependencies. Database … Read more