Databases

What is Oracle Database?

Oracle is a complete enterprise cloud platform that helps companies transform their business and accelerate innovation. Oracle offers a comprehensive and fully integrated cloud applications and platform services stack. With Oracle, businesses can take advantage of the latest technologies to improve operations, drive growth, and extend their reach into new markets. This article will discuss what Oracle is and how it can benefit your business.

ChaosSearch Named to DBTA 100 2022

ChaosSearch has been named to the 2022 DBTA (Database Trends and Applications) 100 list of “Companies that Matter Most in Data.” The DBTA 100 showcases forward-looking companies that are improving and expanding upon existing technologies and processes to help their customers use data more effectively. As data volumes grow and digital transformation initiatives take flight, many organizations are examining the right data architectures for them.

Build a Data Access Layer with PostgreSQL and Node.js

The Data Access Layer (DAL) is the most critical part of any application. This is where the code integrates with an external source of truth like a database. In this take, we'll show you how to build a DAL that talks to Postgres via Node. Then we'll go into best practices like Clean Architecture and what this means in practical terms. Ready? Let’s go! First, a quick note about the code: The code will have modern niceties like TypeScript, unit tests, and will tackle potential scalability issues.

What is Grafana Mimir? with maintainer Marco Pracucci (k6 Office Hours #53)

Maintainer Marco Pracucci talks about the new Grafana project, Mimir, a next-generation time-series database for Prometheus. He joins Developer Advocates Nicole van der Hoeven and Paul Balogh to talk about what Mimir is, why it was needed, and how he helped scale it using k6. RESOURCES.

MongoDB vs. PostgreSQL: Detailed Comparison of Database Structures

One of the most important parts of the function of any company is a secure database. With phishing attacks, malware, and other threats on the rise, it is essential that you make the right choice in order to keep your data safe and process it effectively. However, it can be extremely difficult to choose among the wide variety of database solutions on the market today. Two commonly-used options are Mongodb and Postgresql. What do you need to know about MongoDB vs. PostgreSQL?

SQL Puzzle Optimization: The UDTF Approach For A Decay Function

How do you implement a decay function in SQL? You can use window functions, which scale better than joins, or better yet, you can try what Felipe Hoffa did: use tabular UDFs. In this video, Felipe shows you how you can use a tabular UDF to write custom code that can analyze a table row by row while preserving state. Felipe wrote a table UDF in JavaScript that uses a low amount of memory to keep track of the decaying values. He was able to run it in 36 seconds, instead of the 46 seconds that the SQL with windows solution took; and then he optimized the JavaScript even further and ran it in just 9 seconds.

Stored Procedures: Native API/Native Code vs SourcePro DB

In the previous article, we walked through an example of how to use input parameter binding to send data to a MySQL database using the native MySQL C API and then compared that to the clean simplicity of using the SourcePro DB API. In this final article, we are going to walk through building an example that can invoke a stored procedure with an input parameter of the name of a new account holder and an output parameter of the new account id assigned by the database.