Özgür Özkök
Databases are an essential part of many modern applications. They provide a way to store and manage large amounts of data in a structured and efficient way.
In MySQL, VARCHAR and LONGTEXT are two different data types used to store character strings. VARCHAR is a variable-length character string type that can store up to 65,535 characters. When you define a VARCHAR column, you need to specify the maximum number of characters it can hold. For example, if […]
In MySQL, the GROUP BY keyword is used with the SELECT statement to group the result set by one or more columns. When a SELECT statement includes the GROUP BY clause, the result set is divided into groups based on the unique values in the specified columns. Then an aggregate […]
DoorDash’s prediction service, Sibyl, was created to handle real-time predictions in their machine learning infrastructure. Sibyl retrieves both models and features from independent stores to make predictions. The prediction service allows batch and shadow predictions to test multiple models on the same data in the background. Sibyl was built to […]
As your application needs grow and scale, you want to focus on innovation and not pay for increasing costs. By building modern applications with AWS purpose-built databases, you can take control to optimize your spending. Customers using Amazon DynamoDB, a fully managed, serverless, key-value NoSQL database, can run high-performance applications […]
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 […]
Graphic theory, or graph theory, is a branch of mathematics that studies the properties and characteristics of graphs. In graph theory, a chart refers to a mathematical object that consists of a set of vertices (also known as nodes) and a bunch of edges that connect the vertices. The field […]
AWS Neptune AWS Neptune is a fully managed graph database service provided by Amazon Web Services (AWS). It is designed to store and process highly connected data, such as social network data, recommendation engines, fraud detection, and knowledge graphs. AWS Neptune is built on a purpose-built, graph-native storage engine and […]
MySQL query optimization is improving the speed and efficiency of database queries by reducing the amount of data that needs to be scanned, increasing the use of indexes, reducing the complexity of the question, and improving the way the data is retrieved and processed. It involves analyzing query execution plans, […]
SRID stands for Spatial Reference Identifier, a unique identifier assigned to a spatial reference system used in Geographic Information Systems (GIS). SRIDs define the coordinate system, projection, and geographic location of the data being used in a GIS system. SRIDs are used in maps like Google Maps and Yandex Maps […]
Amazon Web Services (AWS) is a collection of remote computing services (also called web services) that comprise a cloud computing platform provided by Amazon.com. These services operate from 12 geographical regions across the world. The most central and well-known of these services arguably include Amazon Elastic Compute Cloud and Amazon […]