Ensode.net
Google
 

Home
Blog
Guides
Tips
Articles
Utilities
Reviews
About Us
Contact us


Facebook profile

XML

Introduction to Squirrel SQL Database Client
Bookmark and Share

Part II, Using Squirrel SQL

In this article we will cover how to access Squirrel SQL to access any JDBC compliant database. Squirrel SQL is a universal database client, this means that it can be used to access any JDBC compliant RDBMS including Oracle, Sybase, Microsoft SQL Server, Postgresql, MySQL and many others. In Part I of this article we discussed how to set up Squirrel SQL. In this part we will cover how to actually use it, some of the topics to be covered include viewing data in database tables without having to write queries, and how to use Squirrel SQL's auto completion feature to ease the task of writing a SQL query.

Connecting To A Database

To connect to a database, we need to set up a database alias (refer to Part I). All we need to do to connect to the database is double click on the alias. squirrel sql alias window

Then enter the password and click on the "Connect" button".

squirrel sql connect to database alias

After connecting to the database, Squirrel SQL should look something like the following screenshot.

squirrelsql initial login

The exact way Squirrel SQL looks will depend on the RDBMS used. The screenshot shows how it looks for Postgresql.

Next: Working With Database Data


Java EE 6 Development With NetBeans 7
Java EE 6 Development With NetBeans 7


Java EE 6 with GlassFish 3 Application Server
Java EE 6 with GlassFish 3 Application Server


JasperReports 3.5 For Java Developers
JasperReports 3.5 For Java Developers