Latests Posts

Selcuk Kiziltug

TeamSQL Connect & Execute #1: Building Backend Architectures with AWS CloudFormation

https://www.meetup.com/teamsql/events/254266862/ The TeamSQL community is proud to start a new meetup series called TeamSQL Meetup to gather its users and people interested in database management and development. We'll learn and demonstrate new technologies and discuss how to use them with our businesses in every meetup. On the 2nd of October 2018, we ...
Selcuk Kiziltug

Relational Algebra and TeamSQL - Part II

Sometimes is good to dive into the foundations of something, to find new elements to add more power to our current skills. This article is the second part of the previous week Relational Algebra article. In Relational Algebra, there are several data operations, and almost all of them have a simple SQL statement representing the same process. However, there ...
Selcuk Kiziltug

A day in the life of a Test Manager

Selcuk is a Test Manager in the product team here at TeamSQL. When he's not busy browsing Tech Crunch, he's verifying and evaluating the quality of TeamSQL before delivering it to the users. In this interview, Selcuk talks about his role, what makes a good Test Manager, and why he loves working at TeamSQL. What exactly does a Test & Release Manager ...
Selcuk Kiziltug

Relational Algebra and TeamSQL

In this article about Algebra Relational, we will cover a very rare in SQL operation called division. This operator has not an equivalent implementation in SQL. However, there is a technique to implement division in SQL, and we will explain here. Relational Algebra: Division, what is it? As any other algebra, relational algebra has operations (like ...
Selcuk Kiziltug

Recursive Queries with TeamSQL

In many relational database models, we have recursive data structures; it’s true that the relational data model is not oriented to support recursive data structures, and is also true that SQL, (as a query language) doesn’t have a healthy way to manage this recursive structures. However, every database engine has a particular clause to maintain the ...
Selcuk Kiziltug

Avoiding Duplication Of Records

The issue of avoiding duplicate records in relational databases is one of the most common issues or problems. The primary mechanism to prevent that are the primary keys, however, in many databases or tables, primary keys are not defined. We are not going to discuss if not having a primary key is unacceptable or acceptable under the specific circumstance. We ...
Selcuk Kiziltug

A Day At Races With TeamSQL 🏎

A DAY AT THE RACES WITH TEAMSQL   In this article, we took a public database with real and historical data about formula one races located at http://ergast.com/mrd/db/, we imported into a PostgreSQL database engine, and then we start querying using TeamSQL trying to cover and use a broad spectrum type of business queries and at the same time ...
Selcuk Kiziltug

Slow Query Improvement

HOW A GOOD INDEX STRATEGY CAN HELP POLICE SUCCESS As SQL developers, we are usually focused on creating queries which return the correct results. This is a good principle. However, there are more things to take into consideration when you create a query. One of them is the query performance. You think that query response time is not essential.? In this ...
Selcuk Kiziltug

What Is JSON?

JSON is a data interchange format that is designed to be lightweight and easy to work with. It’s quite popular in web applications, and it can be considerably more flexible than a traditional relational data model. Several database engines support JSON, so you can store JSON data and use functions to operate on it. This includes decomposing, transforming, ...
Selcuk Kiziltug

Tweens: The Power Of Set Operations In SQL

In relational databases, it is frequent to have many to many relationships. We can have a customer-product relation, a student-course relation, physician-patient relation among many other forms. In this article, we are going to solve a complex problem, a query which is complicated to write for many developers. In these days all of us know what a stream...