Ö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.
The EXPLAIN command in MySQL is used to obtain information about how a SELECT, INSERT, UPDATE, or DELETE statement will be executed. It provides information about the query execution plan and the estimated number of rows that will be examined for each table in the query. The data from EXPLAIN […]
Here’s a list of some of MySQL’s time functions with SQL samples: NOW() – returns the current date and time in the format ‘YYYY-MM-DD HH:MM:SS’ Example: SELECT NOW(); CURDATE() – returns the current date in the format ‘YYYY-MM-DD’ Example: SELECT CURDATE(); CURTIME() – returns the current time in the format […]
Date functions in MySQL are a set of functions that allow you to manipulate and extract date and time values from expressions, columns, or literals. Date functions help perform various operations on dates, such as finding the difference between two dates, adding or subtracting intervals from a date, formatting a […]
In MySQL, the WITH clause creates a temporary named result set known as a Common Table Expression (CTE). It allows you to define and reference a subquery in the main query. The syntax for using the WITH clause in MySQL is as follows: WITH cte_name AS (SELECT column1, column2, …FROM […]
The MySQL IFNULL() function is handy for handling NULL values in your queries. It allows you to specify a default value to be returned if a NULL value is encountered. This can be helpful for a variety of tasks, such as: Body: Syntax of the IFNULL() Function The syntax of […]
A graph data structure represents a set of objects (called nodes or vertices) and the relationships between them (called edges). Graphs can model real-world entities and associations, such as social networks, transportation networks, and computer networks. There are many reasons why we use graph data structures. Some of the most […]
Graphs are robust data structures that can represent relationships between entities. In Python, many libraries can be used to construct and manipulate graphs. Constructing Graphs in Python The NetworkX Library The NetworkX library is a popular Python library for constructing and manipulating graphs. It provides many features, such as: Code […]
Hibernate bir ORM kütüphanesidir. Hibernate ana görev olarak; verinin ilişkisel veri tabanları üzerine (CRUD işlemleri) kaydedilmesi, güncellenmesi, silinmesi ve sorgulanmasını sağlar. Hibernate ORM kullanılarak, veritabanı işlemleri soyutlanıp bir alt katmanda gerçekleşebilir. Hibernate kendi “native API” sine ek olarak JPA spesifikasyonuna da bir gerçekleme sağlamaktadır.
Amazon Timestream is a fast, scalable, serverless time series database service for IoT and operational applications. Timestream makes it easy to store and analyze trillions of events per day up to 1,000 times faster and at as little as 1/10th the cost of relational databases. It saves you time and […]
I use Amazon as a cloud service in my new Java/Kotlin projects. I couldn’t easily find a complete list of AWS modules. I was able to create this shortlist as a result of the reviews. Compute EC2 Virtual Private Servers Lightsail Amazon’s hosting provider (VPS, DNS, storage) Lambda Functions […]