Security vs. Performance in the SQL World

If you found yourself inside of the world of databases in one way or another, you already know a little about database security and performance. Database management systems certainly do come with benefits to your databases, but have you thought about what options you need to weigh from the security and performance perspectives for your … Read more

How to Store Text in PostgreSQL

DDL generation based on JPA entities definition is a daily task for many developers. In most cases, we use tools like Hibernate’s built-in generator or JPA Buddy plugin. They make the job easier, but there are exceptions. When it comes to storing big chunks of data in the database, things get a bit complicated. Use … Read more

Data Quality Metrics to Know and Measure

The most important characteristic for any organization is not data; it is quality data. In a study, IBM estimated that bad data costs the US economy $3.1 trillion per year. Such costs are incurred when your employees spend time cleaning data or rectifying the errors caused by bad data. Apart from financial costs, bad data … Read more

What Developers Need to Know About Table Partition Maintenance

Table partitioning is a very convenient technique supported by several databases including MySQL, Oracle, PostgreSQL, and YugabyteDB. In the first article of this series, we discussed an application that automates the operations of a large pizza chain. We reviewed how PostgreSQL improves the application’s performance with the partition pruning feature by eliminating unnecessary partitions from … Read more

Building Reactive Java Applications with Spring Framework

If you’re a Java developer who uses the Spring ecosystem, you’ve probably seen the Spring Pet Clinic. In this workshop, we will walk you through a new reactive implementation of the Pet Clinic backend that uses Spring WebFlux and Apache Cassandra® (via DataStax Astra DB). The cloud-native database-as-a-service built on Cassandra fits the highly concurrent, … Read more

Observability Exports: Metrics, Logs, and Tracing

This is the second in a series of blogs discussing unified observability with microservices and the Oracle database. The first piece went into the fundamentals and basic use cases. This second blog will take a deeper dive into the Metrics, Logs, and Tracing exporters (which can be found at https://github.com/oracle/oracle-db-appdev-monitoring), describing them and showing how … Read more

MongoDB vs DynamoDB Head-to-Head – DZone Database

Databases are a key architectural component of many applications and services. Traditionally, organizations have chosen relational databases like SQL Server, Oracle, MySQL, and Postgres. Relational databases use tables and structured languages ​​to store data. They usually have a fixed schema, strict data types, and formally-defined relationships between tables using foreign keys. They’re reliable, fast, and … Read more

Best Tools to Implement Kubernetes Observability

A properly managed and implemented observability system provides DevOps with granular insights that can be used to debug and heal complex systems. Observability combines monitoring, alerting, and logging with metrics visualization and its analysis. It allows development teams to get detailed insights into the real-time performance of Kubernetes clusters and applications so that they can … Read more

Tutorial: Build a Simple Rust App and Connect It to ScyllaDB NoSQL

ScyllaDB, an open-source database for data-intensive applications that require high performance and low latency, is an excellent match for Rust. Similar to the Rust programming language and the Tokio framework, ScyllaDB is built on an asynchronous, non-blocking runtime that works well for building highly-reliable low-latency distributed applications. The ScyllaDB team has developed the scylla-rust-driver, an … Read more