Sisense

JANUARY 25, 2020

If we’re using Postgres, regexp_split_to_table comes to the rescue. Let’s take an example from Sisense’s own schema: Each Sisense for Cloud Data Teams dashboard has a comma-separated list of users who receive that dashboard by email every day. MySQL users, however, are in the dark.

92

92

Sisense

APRIL 17, 2020

This article only scratches the surface of the ways materialized views of all kinds, from SQL server materialized views and Postgres materialized views to a wide array of other systems are changing analytics and data. What is a materialized view, anyway?

Data Warehouse 90

Data Warehouse Visualization 90

Cprime

JUNE 7, 2021

db: image: postgres. . - "9092:9092". volumes: - sonarqube_conf:/opt/sonarqube/conf. sonarqube_data:/opt/sonarqube/data. sonarqube_extensions:/opt/sonarqube/extensions. sonarqube_bundled-plugins:/opt/sonarqube/lib/bundled-plugins. restart: unless-stopped. environment: - POSTGRES_USER=sonarqube. POSTGRES_PASSWORD=sonarpass.

Agile 52

Agile 52

Sisense

NOVEMBER 12, 2020

Given that both data warehouses and databases can be queried with SQL , the skillset required to use a data warehouse versus a database is roughly the same.

Data Warehouse 52

Data Warehouse Skillset 52

Argon Digital

OCTOBER 11, 2023

Step 2 In Step 2 we pull 10 records back from the postgres database. Step 3 In step 3 we create a Variables by Workato List using the Postgres data as a source. Because we use the Rows field, a batch create is done and all the rows from the Postgres query are loaded into the list.

97

97

Sisense

MAY 27, 2019

They also use data pipelines and workflow management tools such as Azkaban, Luigi, and Airflow and with relational SQL and NoSQL databases like Postgres and Cassandra.

Skillset 75

Skillset Cloud Computing Big Data Visualization 75

InfoQ Articles

MARCH 21, 2024

Explore Cloudflare's distributed PostgreSQL clusters and learn how a cross-region architecture ensures resilience. Discover how data storage and access at the edge deliver massive performance gains by reducing location-sensitive latency and why architecting for degraded states is much harder than for failure states.

105

105

Sisense

JANUARY 7, 2020

We’ve used Postgres’ DISTINCT ON syntax to easily query for only one widget per user_id. We’ve used Postgres’ DISTINCT ON syntax to easily query for only one widget per user_id. If your database doesn’t support something like DISTINCT ON, you have two options: Use Nested Subqueries if you have an ordered ID column.

101

101

InfoQ Articles

MARCH 6, 2024

The rising popularity of managed relational databases brings hidden costs and informed decisions are crucial for optimal use. This article shows the importance of monitoring service expenses, revising default settings, and understanding operational constraints, considering limitations like reduced flexibility and observability.

Monitoring 104

Monitoring 104

Astera

MAY 25, 2023

MySQL’s compact size reduces memory requirements making it often better suited to run on low-end systems compared with other DBMSs such as Postgres or Oracle. With an open-source license, Postgres can be modified freely with the source code available in public repositories.

E-Commerce 52

E-Commerce Data Security Data Modelling Big Data 52

Sisense

JANUARY 29, 2020

Some SL languages, like SQL Server, use = for assignment, while others like MySQL and Postgres use :=. Postgres Json. Postgres has great support for json types , including a slew of character operators to extract data out of a json blob. Symbol Operation + Addition – Subtraction * Multiplication / Division % Modulo.

Digital 105

Digital 105

Tableau

MARCH 30, 2021

we added the ability to use Azure Postgres database as an external repository for Tableau Server. In addition to connecting to your data in Azure, you can also deploy Tableau Server on the Azure cloud while leveraging key Tableau enterprise capabilities.

Data Warehouse 99

Data Warehouse Big Data Product Management Product Management 99

InfoQ Articles

AUGUST 17, 2022

The emergence of Big Data and data lakes, doesn't necessarily mean the disappearance of the trusted relational database. The two can coexist, relational databases just need to adjust.

Big Data 90

Big Data 90

Tableau

MARCH 29, 2021

we added the ability to use Azure Postgres database as an external repository for Tableau Server. In addition to connecting to your data in Azure, you can also deploy Tableau Server on the Azure cloud while leveraging key Tableau enterprise capabilities.

Data Warehouse 52

Data Warehouse Big Data Product Management Product Management 52

InfoQ Articles

APRIL 1, 2022

The wildfly-jar-maven-plugin and the brand new wildfly-datasources-preview-galleon-pack from the WildFly project are worthy of your attention. These tools add on-the-fly generation of an Uber JAR including configuration for containerization and datasources, and make it a pleasure to write applications for Jakarta EE and WildFly. By Dennis Gesker.

75

75

Sisense

APRIL 9, 2019

but you can also write code in other languages and add it to your Postgres database without recompiling your database. One amazing asset that PostgreSQL brings to the table is flexibility. Not only does it run on all major operating systems (Windows, all your favorite Linux distros, etc.),

Big Data 75

Big Data Visualization 75

Sisense

JUNE 5, 2019

Popular examples of RDBM systems include Microsoft SQL, Oracle, MySQL, and Postgres. An RDBMS is usually made up of a collection of tables, each with columns (fields) and records (rows). Some of the strengths of an RDBMS include flexibility and scalability.

Big Data 75

Big Data Data Warehouse 75

Sisense

FEBRUARY 16, 2021

DBTs support databases such as BigQuery, Snowflake, Postgres, and Redshift. DBT does the transform part of the ELT process, transforming data that has already been extracted and loaded into the warehouse in an efficient way. The DBT function takes code, compiles it in SQL , and runs against the database.

Data Modelling 52

Data Modelling Data Warehouse Banking Real-time Data 52

Astera

FEBRUARY 7, 2024

This article serves as a comprehensive guide to change data capture (CDC) in PostgreSQL, also known as Postgres. It will take you through the different ways of implementing Postgres CDC, including the pros and cons, as well as an automated alternative to all the manual methods. Why Do You Need Postgres CDC ?

E-Commerce 52

E-Commerce Data Warehouse Monitoring Data Management 52

Sisense

SEPTEMBER 3, 2019

Let’s say your use case fits an OLAP database. Then, you may be one of many who opt to use a Redshift Warehouse. There are a few settings available that can tailor the performance of your Redshift queries.

Data Warehouse 78

Data Warehouse Data Architecture Big Data Planning 78

Astera

JUNE 6, 2023

PostgreSQL, also known as Postgres, is a widely used open-source database management system. In this article, we will explore these two popular database systems, comparing their features, performance, and suitability for various applications, all in a way that is easily understandable for non-technical readers. What is PostgreSQL?

Documentation 52

Documentation Data Warehouse Data Security Data Management 52

Astera

JUNE 6, 2023

PostgreSQL, also known as Postgres, is a widely used open-source database management system. In this article, we will explore these two popular database systems, comparing their features, performance, and suitability for various applications, all in a way that is easily understandable for non-technical readers. What is PostgreSQL?

Documentation 52

Documentation Data Warehouse Data Security Data Management 52