What is a database schema? Types and uses in data integration
Database schemas help with data integration and database optimization to drive better analysis and faster results.
Databases
Hidden Gems: ActiveRecord Store
PostgreSQL and MySQL are great for structuring data using relationships, but what if you don't always know the structure up-front? That's where `ActiveRecord::Store` really shines. It's like NoSQL, without changing databases.
Advanced rate limiting policies with Kong and Hazelcast
Kong Gateway integrates with Hazelcast to implement advanced policies for rate limiting besides the fundamental options provided by the Kong plugins, including distributed compute, security, zero downtime, and cloud agnostic.
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.
Install MongoDB on Ubuntu: 5 Easy Steps
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!
A developer's guide: The differences between SQL and NoSQL
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.