Keep safe your data with QuerySense
March 21, 2018

Keep safe your data with QuerySense

Keep safe your data with QuerySense
Sharing Your TeamSQL Folders
January 9, 2018

Sharing Your TeamSQL Folders

Sharing Your TeamSQL Folders
Custom Snippets
October 28, 2017

Custom Snippets

Custom Snippets
Math Operations on Selected Cells
October 21, 2017

Math Operations on Selected Cells

Math Operations on Selected Cells
August 18, 2017

Filtering Your Data Grid

Filtering Your Data Grid

ALL YOU WANT TO KNOW ABOUT VIEWS

WHAT IS A VIEW? In a short sentence, a view is a “saved query” associated with a name. Once you create the view (or save the query), you can use it as a table in other queries. Trying to explain with more detail what a view is, we can say that a view is another type of database objects like tables, indexes or stored procedures. From a point of view of ...

DATE / TIME ARITHMETIC WITH TEAMSQL

In this article, we will cover some interesting operations involving date and time data values in SQL. The SQL standard specifies the following date and time-related data types that must be present in relational databases: date, time, timestamp and interval. -  date: Represents a single day. Example 15/12/2018 -  time: Represents the time with hour, ...

SQL COALESCE Function

The first time I saw the term COALESCE in a SQL manual, I thought it was a scientific function for some complex calculation. However, later I found that it is a straightforward and handy function. In this article, I will show several examples to explain how to use the COALESCE function.   THE REASON BEHIND COALESCE: THE NULL VALUE Before go deep ...

Keep safe your data with QuerySense

I will start this article with a real-life story, occurred to me. As a database consultant, I do a lot of different works. I write technical articles (obviously), but I also do some other database tasks like SQL development and database administration. So I have a lot of SQL clients and tools installed on my own notebook. One sunny day I begin to work in ...

Analyze A/B Tests in TeamSQL

In these days A/B Tests are a common tool used by owners of e-commerce web sites. In few words we can say that A/B tests are like the speedometer of a race car, they serve to measure the most important metric of an e-commerce site: The conversion rate. In this article we will explain how to create a chart in TeamSQL to see, compare and evaluate how an ...

Charting Your Data with TeamSQL

TeamSQL’s charts feature lets you visualize your database queries in just a few clicks. You can select from a variety of different chart types, perform complex data aggregation and sorting, and customize the appearance of your charts right from TeamSQL. Charts work with any database supported by TeamSQL and can even be exported as images. In this ...

Visualize your data with charts in TeamSQL

TeamSQL offers a new and redesigned feature to create your own charts based on query resulting data. The Charts feature of TeamSQL is now more powerful with advanced aggregation and visualization options. TeamSQL Charts is all free during Release Candidate period. Visualize your data by creating the charts you need, right in TeamSQL. You can easily ...

TeamSQL Extensions: Google Maps

One of the biggest perks to using TeamSQL is it’s extensibility. One size does not fit all, and what your colleague needs in their data client might not be what you need in yours. As such, TeamSQL will ship with a default set of features, and you can add as much as you’d like to create the client that works best for you! Today, we will take a look at ...

Sharing Your TeamSQL Folders

In our opinion, one of the biggest benefits to using TeamSQL is the ability to share your work with your teammates, either individually or with groups of individuals, with ease. Rather than going through the traditional practice of exporting your query, saving it somewhere, and then forwarding the access directions to your colleagues, you can let TeamSQL ...

Emulating UPSERT in PostgreSQL

Upsert is an interesting and powerful SQL statement not supported on all database managers. In this article we will cover a technique to emulate the upsert statement with other regular SQL statements in PostgreSQL. You can apply this technique in other database engines too.     The UPSERT statement The upsert statement is used when we ...