Systems | Development | Analytics | API | Testing

Latest News

Redshift Join: How to use Redshift's Join Clause

Redshift’s JOIN clause is perhaps the second most important clause after SELECT clause, and it is used even more ubiquitously, considering how interconnected a typical application database’s tables are. Due to that connectivity between datasets, data developers require many joins to collect and process all the data points involved in most use cases. Unfortunately, as the number of tables you’re joining in grows, so does the sloth of your query.

What Are The Best ETL Tools For Vertica?

Vertica claims to offer the "most advanced unified analytical warehouse" in the world, providing actionable data insights you can't find anywhere else. The truth is, like any data warehouse, Vertica is only as good as the data you put into it. Moving data to Vertica can be a headache for organizations without a data engineering team. Data might live in various locations — transactional databases, relational databases, customer relationship management (CRM) systems, you name it.

PostgreSQL to Amazon Redshift: 4 Ways to Replicate Your Data

PostgreSQL is the preferred platform of millions of developers around the world. The open-source tool is one of the most powerful databases on the planet, with the ability to handle sophisticated analytical workloads and high levels of concurrency. That makes PostgreSQL (also called Postgres) a popular DB for scientific research and AI/ML projects. It’s also a popular production database for data-driven companies in every industry. But no database is perfect.

Adopting a Production-First Approach to Enterprise AI

After a year packed with one machine learning and data science event after another, it’s clear that there are a few different definitions of the term ‘MLOps’ floating around. One convention uses MLOps to mean the cycle of training an AI model: preparing the data, evaluating, and training the model. This iterative or interactive model often includes AutoML capabilities, and what happens outside the scope of the trained model is not included in this definition.

Top 3 CloudOps Priorities for 2022, from Hitachi Vantara & AWS

As an estimated 92% of enterprises have adopted hybrid and multicloud strategies, according to the 2021 State of the Cloud Report from Flexera, cloud operations (CloudOps) teams face increasing pressure to simultaneously manage costs while improving business outcomes. What levers can CloudOps teams pull to achieve operational objectives such as reducing hybrid and distributed cloud complexity, enhancing security, and automating processes?

What's New in Rails 7

Rails 7 is just around the corner. We don't have a confirmed release date, but it is expected to be available before Christmas, so not very long to go. The latest version as of this post's publication is 7.0.0.rc1, the first release candidate. Basecamp, HEY, Github, and Shopify have all been running the Rails 7 alpha in production, so we can expect even the release candidate to be pretty stable. In this post, we will look at some of the new features and changes that Rails 7 will bring.