Tag: Database
-
The rise and fall of the OLAP Cube
Posted on January 30, 2020, Level beginner Resource Length long
One of the biggest shifts in data analytics over the past decade is the move away from building "data cubes", or "OLAP cubes", to running OLAP workloads directly on columnar databases. By Cedric Chin.
Tags big-data data-science miscellaneous database software-architecture
-
SQL Injection: A beginner's guide for WordPress users
Posted on January 22, 2020, Level beginner Resource Length medium
SQL injection, or SQLi, is an attack on a web application by compromising its database through malicious SQL statements. As it's a common attack, let's try to learn more about what it is, how it happens, and how to defend yourself from it. By Shaunik Daityari.
Tags sql database miscellaneous cloud
-
Geospatial queries, reinvented
Posted on December 12, 2019, Level interemediate Resource Length long
In this article author goes through the details of how Beat managed to achieve lightning fast queries during the driver dispatching process; getting the nearest driver to a passenger. by Fotis Papadopoulos.
Tags software-architecture google data-science database
-
Building a distributed time-series database on PostgreSQL
Posted on October 18, 2019, Level intermediate Resource Length long
TimescaleDB, a time-series database on PostgreSQL, has been production-ready for over two years, with millions of downloads and production deployments worldwide. Authors publicly shared their design, plans, and benchmarks for the distributed version of TimescaleDB. By Mike Freedman and Erik Nordström.
Tags database software-architecture distributed performance
-
Managing hundreds of millions of orders with Table Store
Posted on September 16, 2019, Level intermediate Resource Length medium
This article discusses how Table Store can help you store and manage massive amounts of data by using a fictional e-commerce platform as an example.
Tags sql database performance how-to cloud
-
To run or not to run a database on Kubernetes: What to consider
Posted on July 21, 2019, Level beginner Resource Length short
Benjamin Good, Solutions Architect, Google Cloud, wrote this piece in which he considers if you should run a database on Kubernetes. Today, more and more applications are being deployed in containers on Kubernetes—so much so that we've heard Kubernetes called the Linux of the cloud.
Tags database devops kubernetes google
-
Look at how Twitter handles its time series data ingestion challenges
Posted on June 11, 2019, Level intermediate Resource Length short
Ram Dagar is author of this overview on the time series topic. The components of time-series are as complex and sophisticated as the data itself. With increasing time, the data obtained increases and it doesn't always mean that more data means more information but, larger sample avoids the error that due to random sampling.
Tags devops database machine-learning data-science software
-
Indexes bad practices
Posted on June 1, 2019, Level beginner Resource Length medium
In this article author will discuss secondary indexes common mistakes and bad practices. While the article is focused on MySQL and the InnoDB storage engine, most of this information applies to any DBMS. Published by Federico Razzoli.
Tags database sql miscellaneous linux
-
Exposing MyRocks internals via system variables: data writing
Posted on May 31, 2019, Level intermediate Resource Length medium
Peter Sylvester wrote this blog post about new storage engine for MySQL that's rising in popularity. MyRocks, the log-structured merge-driven RocksDB engine in MySQL.
Tags database sql miscellaneous
-
Building stateful apps with serverless functions and Postgres
Posted on April 2, 2019, Level intermediate Resource Length medium
Tirumarai Selvan, Product Lead at Hasura, published this guide which explores the different ways to deal with application state when writing business logic in serverless functions. Author uses Postgres as the database when talking about these different approaches, and often use Hasura as one of the glue solutions between your serverless functions and your Postgres database.
Tags database microservices nosql servers distributed apis
-
Code Migration in Production: Rewriting the Sharding Layer of Uber's Schemaless Datastore
Posted on March 20, 2019, Level intermediate Resource Length medium
An older article by Jesper Lindstrøm Nielsen and Anders Johnsen about how Uber Engineering built Schemaless, their fault-tolerant and scalable datastore, to facilitate the rapid growth of our company.
Tags database data-science nosql
-
MySQL high availability framework explained – part one
Posted on February 24, 2019, Level intermediate Resource Length medium
This is three-part blog series, in which author explains the details and functionality of a High Availability (HA) framework for MySQL hosting using MySQL semisynchronous replication and the Corosync plus Pacemaker stack. Published by Prasad Nagaraj VP Engineering at ScaleGrid.
Tags sql database software devops