day : 28/10/2017 3 results

TeamSQL Extensions: Beautify SQL

Have you ever wished there was a more straightforward 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 you think it does: you type in SQL, Beautify SQL cleans it up.   Demo Let’s say that you wrote the following SQL ...

Custom Snippets

TeamSQL has supported snippets for some time, but we’re introducing custom snippets to help you work more effectively.   What are the snippets? From our snippets post: Snippets are templates that can help you to build longer queries. Because TeamSQL knows which database you’re working in, you’ll get the right snippet at the right time (if you work in multiple types of databases, you’ll know how easy it is to get similar-but-different syntaxes mixed up). Now, you’re less ...

TeamSQL Charts: Pie Charts

We’ve been covering some of the new charting features in TeamSQL, and today, we’ll take a look at the pie chart. If you’re already familiar with how the basic charting functionality works in TeamSQL, read on, but if you aren’t, please take a look at our overview post. In today’s example, we’ll be looking at the market share each of the major browsers held in the period from January to May of 2015. Here’s what our data looks like returned from the database.   We click ...