Özgür Özkök
PostgreSQL, or Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance.
PostgreSQL is a popular choice for both small and large-scale deployments, and various companies use it.
Author: Philip McMahon In April, the Guardian significantly shifted its content management system (CMS) by migrating from MongoDB to PostgreSQL on Amazon RDS. The Guardian’s CMS tool, Composer, which produces most of its content, was previously backed by a MongoDB database on AWS. This database held about 2.3 million content […]
MySQL provides several functions to round numbers. Here are the primary rounding functions: ROUND(): This is the most commonly used rounding function. It rounds the number to the nearest whole number or the specified number of decimal places. CEIL() or CEILING(): These functions return the smallest integer value greater than […]
During Cloudflare’s “Birthday Week 2023”, the company unveiled the open beta of Hyperdrive. This new service leverages Cloudflare’s global network to accelerate queries to existing databases. Currently, Hyperdrive supports PostgreSQL-compatible databases, and there are plans to extend this support to MySQL shortly. Hyperdrive’s primary goal is to speed up data […]
COALESCE() It is a function that returns the first non-NULL value in a list of expressions. If all the values in the list are NULL, the COALESCE() function will return NULL. Syntax: The COALESCE() function is often used to replace NULL values with a default value. Examples: This will return […]
Amazon Web Services (AWS) Elastic Beanstalk is a fully managed platform for deploying, running, and scaling web applications and services. It supports several programming languages, including Java, .NET, PHP, Node.js, Python, Ruby, and Go, and web servers like Apache, Nginx, and IIS. With Elastic Beanstalk, you upload your application code, […]
Diving into the World of InfluxDB In the vast ocean of databases, InfluxDB emerges as a unique fish. It’s not just any database; it’s a time-series database explicitly designed for high-velocity event data. But what makes it so unique? Let’s embark on this journey to discover the magic behind InfluxDB. […]
In the technicolor landscape of cloud computing, AWS (Amazon Web Services) Relation Database Services (RDS) reigns as the grand matchmaker, uniting data and harmony in a musical symphony. As we embark on a journey of enchanting love stories between databases and AWS RDS, let’s explore its history, license model, benefits, […]
Apache Superset was initially developed by Maxime Beauchemin, a data engineer at Airbnb, as a hack-a-thon project in 2015. The project was open-sourced in 2017, and graduated from the Apache Incubator program in 2021. Superset is a web-based data visualization and exploration tool that allows users to easily create and […]
Apache Superset is an open-source data visualization and exploration tool built on Python, SQLAlchemy, and Flask. It allows users to easily create and share dashboards, charts, and other visualizations. Superset can be used with various databases, including MySQL, PostgreSQL, and Oracle. It also supports a variety of authentication methods, including […]
AWS AppSync is a fully managed service that makes it easy to develop GraphQL APIs by handling the heavy lifting of securely connecting to data sources like AWS DynamoDB, AWS Lambda, or any HTTP data source. AppSync also offers real-time and offline capabilities, making it an ideal solution for building […]