Systems | Development | Analytics | API | Testing

Databases

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.

What Is the Difference Between AWS Redshift and RDS?

AWS Redshift and RDS are two different database products that AWS offers. If you're not sure which one is right for you, there are a few essential questions to answer before making your decision. This article will explore the differences between these two products and help determine which one would be best for your needs. We'll also take a look at how much it costs to use each product so that you can compare them side-by-side and see what's most affordable for your business.