Data 12 results

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 know that occurs, especially on data warehouses schemas. Then, in this environment where we don’t have primary keys or unique constraints ...

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 using different SQL clauses. We expect you can find some of the exciting queries presented here usable and applicable perhaps to your business data. ...

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 article, we will cover one example where query response time is critical.   SCENE ONE: 911 CALL CENTER Let’s suppose we are at the ...

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, or even creating JSON data from regular relational data.   What Is JSON? JSON is an acronym for JavaScript Object Notation. It ...

Exporting Data to CSV or JSON in TeamSQL

You can easily export the data contained in your database tables in one of the following formats: CSV JSON Tab Separated         Read full article and tutorial on TeamSQL Blog.

Filtering Data Grid

After executing a query that returns a large results set, TeamSQL allows you to filter the returned data without running another query. This allows you to analyze your results set without any additional queries or strain on your server. Let’s look at an example. This is what our initial results set looks like after executing a query.   Notice the search bar and funnel icon located above each column. These allow you to filter on one or more columns. If you have search ...

Adding a new database connection

In the Explorer pane, click on the plus icon next to CONNECTIONS.   This launches the Add Connection window where you can create new connections from TeamSQL to your server(s).   To create a connection to a MySQL database set the Database Type to MySQL.   Note how the window now displays Create a new MySQL connection at the top. To connect to your MySQL database server, you’ll need to provide the following parameters to TeamSQL:   &...

Can I download TeamSQL now?

Currently there are many people using TeamSQL in their routine development cycles and we want to make sure that our support system scales efficiently as the number of users grows. We also want to keep communicating with everyone to let the product fit to our user base's needs. So we are rolling out TeamSQL at a controlled pace and we are trying hard to make the process run faster.    

Using Keyboard Shortcuts in TeamSQL (Windows & Linux)

Open search box — search for any item Ctrl + ⇧ + F Open search box — search for table names Ctrl + ⇧ + T Open search box — search for functions and stored procedures Ctrl + ⇧ + P Import SQL file Ctrl + O Execute query Ctrl + R Save query Ctrl + S Open tab by index Ctrl + [1–9] Example: ⌘ + 1 opens the first tab Open a new tab using the current connection Ctrl + N Open a new tab after prompting the user to select a connection Ctrl + ⇧ + N Close ...

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 sort, 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 post, we’ll demonstrate TeamSQL Charts using this sample MySQL database, which contains employee and salary records for a fictional company. ...

Math Operations on Selected Cells

TeamSQL now comes with built-in, basic operations, so you have easy access to summary statistics for your data, such as totals, counts, averages, and maximum and minimum values. You can have these operations run on any set of cells you’ve highlighted. Here’s how you can get this information. Let’s say that we’ve executed a query and have the following sales information:       To get a quick overview of our data, we begin by selecting the data cells we want to ...

Exporting Data Using TeamSQL

    You can easily export the data contained in your database tables in one of the following formats: CSV JSON Tab Separated NOTE: You can connect to AWS Redshift with TeamSQL, a multi-platform DB client that works with Redshift, PostgreSQL, MySQL & Microsoft SQL Server and runs on Mac, Linux and Windows. You can download TeamSQL Beta for free: https://teamsql.io/   How to Export Data 1. Launch TeamSQL, and connect to your database server by ...