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

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 ...

TeamSQL Charts: Scatter Plots

Today, we’ll finish up our blog series on the types of charts you can create using TeamSQL’s new charting feature by covering the final chart type available: scatter plots. Let’s say that we need to look at the correlation between height (in centimeters) and weight (in kilograms). Our returned data looks like this:       As ...

Why You Should Use TeamSQL Instead of the Command Line for Redis

Redis doesn’t require much in terms of software, and in fact, you probably went straight into working with Redis using the command-line interface (CLI). While there’s no arguing with simplicity, especially if it works, here’s why you might consider using TeamSQL to manage your Redis environments instead of relying on CLI-based tools.   ...

TeamSQL Extensions: Beautify SQL

Have you ever wished there were a simpler way of writing well-formatted SQL in your code editors? Well, in TeamSQL, there is. We recently introduced support for editor extensions, which are extensions that modify the way the editor in TeamSQL works. One of the first extensions that we created with this framework is Beautify SQL, which does exactly what ...