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

XPATH Language Usage With An Example In PostgreSQL

In these days XML documents are everywhere. They are mainly used to exchange information between applications; however, they are also used for many other purposes. Moreover, almost all database engines supported by TeamSQL include XML as a data type. In this article we use TeamSQL to store XML documents on a database table, then we extract elements from the XML by using XPath expressions, and finally, we execute queries inside the XML document.   XML Example XML documents are very ...

Basic Math Operations

TeamSQL comes with built-in, basic math 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. To get a quick overview of our data, we begin by selecting the data cells we want included in our calculations.   As soon as we do this, we can see the results of our math operations at the bottom right of the TeamSQL window...

TeamSQL Application Preferences

TeamSQL ships with a standard set of settings, called preferences, that you can change as you'd like. To access and set your application preferences, go to File > Preferences.   There are two tabs, each of which contains a different set of settings: General Keyboard   General Settings The general tab includes the settings and preferences that affect how your editor window behaves.   In the General tab, you can set the following parameters:...

Is TeamSQL written in Java?

No! We are using Electron and everything is mostly written in HTML, Node.js and TypeScript under the hood.    

Is TeamSQL open source?

TeamSQL is not a public repository, yet. However TeamSQL is written in Javascript / HTML and built on Electron, so practically all our code is accessible through Chrome DevTools (we allow our users to use DevTools inside TeamSQL, so they always know what's going on under the hood). Our initial plan is to make important parts of TeamSQL open source and start to receive pull requests. We opened our SQL Statement Parser as the first step of this effort. (https://github.com/TeamSQ...

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 (macOS)

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

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

Providing Feedback on TeamSQL

Thank you for taking part in our private beta and using TeamSQL. While we spend a lot of time testing to ensure that everything works as flawlessly as possible, we realize that your help in polishing our product is just as valuable. We use GitHub for issue tracking, so we welcome you to log any of the following to our GitHub repository: Bugs Usability issues Unintended features Feature requests     Not only will this making tracking input easier, but ...

Working with Teams in TeamSQL

In this article, we will cover the features TeamSQL has that enables easy collaboration between you and your colleagues.   Creating a Team To create a new team, which you can use to group any number of users, navigate to Teams > Create New Team using the main toolbar at the top. You will be prompted to provide a name for your new team.   Click Create to proceed. On the Teams & Management window that displays, you see your newly-created team, along ...

Saving and Managing Queries in TeamSQL

You can easily save the queries you execute in TeamSQL for future reference.     You can initiate a save by clicking Save Query, using CTRL + S (in Linux or Windows), or using ⌘ + S (in macOS). You will be prompted to provide a name for your query if this is the first time you’ve saved.   TeamSQL now displays the name of your query in the query’s tab, as well as in the left-hand navigation bar.   Viewing Your Saved Queries In addition to accessing ...

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

Using Keyboard Shortcuts in TeamSQL

There are numerous shortcuts that allow you to perform actions faster. Below is a list of shortcuts you can use in TeamSQL, as well as information on where you can use them.   Apple macOS   General Keyboard Shortcuts Open search box — search for any item ⌘ ⇧ F Open search box — search for table names ⌘ ⇧ T Open search box — search for functions and stored procedure ⌘ ⇧ P Import SQL file ⌘ O   Shortcuts for Use in the Editor Exec...

TeamSQL Quick Start for macOS

This guide is designed to get you up and running with TeamSQL as quickly as possible.     Installation Download TeamSQL. Drag and drop the TeamSQL icon onto the icon for your Applications folder.   3. Wait for the files to copy to your Applications folder. Launch TeamSQL 1. Once TeamSQL has been installed, you can launch it using its icon located in your Launchpad. 2. You will be asked to register to use TeamSQL.   If you ...