Systems | Development | Analytics | API | Testing

Databases

integrate

MongoDB vs. PostgreSQL: Detailed Comparison of Database Structures

Apr 14, 2022 By Mark Smallcombe In Integrate
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?
Read Post

SQL Puzzle Optimization: The UDTF Approach For A Decay Function

Apr 6, 2022 By Snowflake In Snowflake
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.
View Video
perforce

Stored Procedures: Native API/Native Code vs SourcePro DB

Mar 24, 2022 By David Ritter In Perforce
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.
Read Post
integrate

What Is the Difference Between AWS Redshift and RDS?

Feb 25, 2022 By Mark Smallcombe In Integrate
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.
Read Post
hevo

Install MongoDB on Ubuntu: 5 Easy Steps

Feb 24, 2022 By Vivek Sinha In Hevo

Do you want to Install MongoDB on Ubuntu? Are you struggling to find an in-depth guide to help you set up your MongoDB database on your Ubuntu installation? If yes, then you’ve landed at the right place! Follow our easy step-by-step to seamlessly install and set your MongoDB database on any Ubuntu and Linux-powered system! This blog aims at making the installation process as smooth as possible!

Read Post
statuscake

A developer's guide: The differences between SQL and NoSQL

Feb 22, 2022 By Christopher Long In StatusCake

Choosing the right method to store your data can be a critical decision early in the development process. When deciding on which type of database to choose for your project it really comes down to the data structure you wish to use rather than the specific product or provider. In this blog post, we are going to look at relational and non-relational databases and explore the differences and use cases for both.

Read Post
bigquery

To user-friendly SQL with love from BigQuery

Feb 14, 2022 By Jagan R. Athreya In Google BigQuery

Thirty five years ago, SQL-86, the first SQL standard, came into our world, published as an ANSI standard in 1986 and adopted by the International Standards Organization (ISO) in 1987. On this Valentine’s Day, we, in BigQuery, reaffirm our love and commitment to user-friendly SQL through a whole slew of new SQL features that we’re pleased to share with you, our beloved BigQuery users.

Read Post
appsignal

How to Keep Database Table Sizes Down and Prevent Data Bloat

Feb 3, 2022 By Julik Tarkhanov In AppSignal

Most web applications use a data store of some kind, often a relational database. When a web app becomes successful, it can become all too easy to start "hoarding" data in the database. But hoarding data leads to the unbounded growth of database tables (both row count and stored data size). While this works fine to a certain point, it is very useful to prevent some data bloat — or, if you cannot prevent it, to plan for your infrastructure ahead of time to adequately manage growth.

Read Post
kong

Why We're Deprecating Cassandra Support

Feb 1, 2022 By Aapo Talvensaari In Kong

Starting with the 2.7 release, using Cassandra as a configuration datastore for the Kong Gateway will be considered deprecated. Cassandra features will remain in Kong throughout the (currently unreleased) 3.x series, and its use will not be prohibited. However, some newly introduced functionality throughout 3.x may not be optimized for performance or have full functionality when using Cassandra.

Read Post
Subscribe to Databases

Copyright © 2024 OpsMatters™. All rights reserved.