Monday, June 30, 2008

SQuirreL, Universal SQL Client

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Introduction.

The minimum version of Java supported is 1.5.x as of SQuirreL version 2.4. See the Old Versions page for versions of SQuirreL that will work with older versions of Java.

The SQuirreL desktop in Ocean Theme:

Features:

- Object Tree of Session window - right-click to access the popup menu which provides access to advanced script generation and graphing features. The graph plugin allows the user to create table charts
- SQL Editor with code completion popup (ctrl+space) open - code completion can be used to access drop-down lists of options that include keywords, tables, columns, views, stored procedures. Code completion also provides join generation functions. For example, look at the table structure here. Hitting ctrl+space after the expression
- SQL Editor with tools popup menu (ctrl+t) shown - with the tools popup any editor function can be located with only a single short cut: ctrl+t Additionally, the list can be searched incrementally with just a few keystrokes
- SQL Editor with bookmark selection popup (ctrl+j) shown - bookmarks are user-defined code templates. SQuirreL comes with several pre-defined example bookmarks for the most common SQL and DDL statements
- Abbreviations and auto corrections dialog - this feature works much like auto corrects in common office products. With the entries shown in the dialog you may for example type 'sf' which will expand to 'SELECT * FROM'
- Editing of SQL results - the result tabs of SQL queries support editing the rows returned from a query on a single table. You may also edit the contents tab of tables in the Object tree
- Graph: Charts of tables and their relations - To create new charts or to add tables to existing charts right mouse click tables in the Object tree and choose the 'Add to graph' menu. Graph manipulation functions can be accessed by using the right-click context popup menu
- Graph: Scaling and distributing tables on configurable page sizes to prepare for printing - use the right-click context popup menu to switch to the scaling and printing mode

For more detailed description see the paper by Gerd Wagner:
- English version
- German version

In theory SQuirreL should work with any DBMS that has a JDBC 2.0 driver. However not all drivers/DBMS's are fully complient with the JDBC 2.0 specification.


Reported working databases:

- Axion Java RDBMS
- Daffodil (One$DB)
-
Apache Derby (formerly Cloudscape)
- Fujitsu Siemens SESAM/SQL-Server
with the SESAM/SQL JDBC driver
-
Firebird with the JayBird JCA/JDBC Driver
-
FrontBase
-
HSQL
-
Hypersonic SQL
-
H2
-
IBM DB2 for Linux, OS/400 and Windows
-
Informix
-
CA Ingres 2.6 SP2 with EDBC driver v1.8
- InstantDB

-
Interbase with the Interclient JDBC driver
-
Mckoi SQL
-
Microsoft Access with the JDBC/ODBC bridge
-
Microsoft SQL Server with the Microsoft, WebLogic and jTDS JDBC drivers
-
Mimer SQL
-
MySQL with the MM MySQL JDBC driver
-
Oracle 8i, 9i and 10g with the Oracle thin and OCI drivers
-
Pointbase
-
PostgreSQL 7.1.3 and higher
-
Progress OpenEdge 10.1x
-
SAPDB
-
Sybase
-
Sunopsis XML Driver (JDBC Edition)
-
Teradata Warehouse
-
ThinkSQL RDBMS


Available translations:

- Spanish
- Brizilian
- Czech
- Bulgarian
- Chinese
- French
- Italian
- German
- Russian


Download & Installation:

The SQuirreL SQL Client is installed with the IzPack Java installer. Download the file squirrel-sql--install.jar and execute it using the following command:

java -jar squirrel-sql--install.jar

Make sure that you have write privileges to the directory that you want to install into.

Note that some browsers may attempt to open this file rather than download it. In this case, right-click on the download link and click your browser's equivalent of the "Save as..." menu item.

On Windows, execute the file squirrel-sql.bat to run the application. On Unix, the file is squirrel-sql.sh.

Download: SQuirreL SQL 2.6.6
WebSite: http://www.squirrelsql.org

Source:
http://javaclick.blogspot.com/2007/10/squirrel-universal-sql-client.html

65 comments:

Anonymous said...

I am trying to install squirrel on windows without any luck. Since it is windows i should use a .bat file, where can I find that?

abe said...

For any version of operating System, to install Squirell SQL just follow this syntax from command prompt in the folder where squirell jar file placed:

java -jar squirrel-sql-version-install.jar

Then follow the installation wizard. Make sure you haved installed java on your machine.

To run squirellsql you can use shortcut on start menu or on your desktop.

Anonymous said...

[B]NZBsRus.com[/B]
Dont Bother With Sluggish Downloads With NZB Files You Can Easily Find High Quality Movies, Console Games, MP3s, Applications and Download Them @ Maxed Out Speeds

[URL=http://www.nzbsrus.com][B]Usenet[/B][/URL]

Anonymous said...

Hello,

I mostly visits this website[url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips].[/url]Lots of good information here abraham-sulaeman.blogspot.com. Do you pay attention towards your health?. In plain english I must warn you that, you are not serious about your health. Recent Research shows that nearly 90% of all U.S. adults are either chubby or overweight[url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips].[/url] Therefore if you're one of these individuals, you're not alone. Its true that we all can't be like Brad Pitt, Angelina Jolie, Megan Fox, and have sexy and perfect six pack abs. Now the question is how you are planning to have quick weight loss? You can easily lose with with little effort. Some improvement in of daily activity can help us in losing weight quickly.

About me: I am blogger of [url=http://www.weightrapidloss.com/lose-10-pounds-in-2-weeks-quick-weight-loss-tips]Quick weight loss tips[/url]. I am also health trainer who can help you lose weight quickly. If you do not want to go under difficult training program than you may also try [url=http://www.weightrapidloss.com/acai-berry-for-quick-weight-loss]Acai Berry[/url] or [url=http://www.weightrapidloss.com/colon-cleanse-for-weight-loss]Colon Cleansing[/url] for quick weight loss.

Anonymous said...

It isn't hard at all to start making money online in the undercover world of [URL=http://www.www.blackhatmoneymaker.com]google blackhat[/URL], Don’t feel silly if you haven’t heard of it before. Blackhat marketing uses little-known or not-so-known methods to generate an income online.

Anonymous said...

unlock iphone 4
iphone 4 unlock
how to unlock iphone 4

https://greencine.com/central/2011oscarnominees http://www.gpucomputing.net/node/6013?q=node/1280
For the past 2 weeks Kaspersky has told me that I have 2 viruses..... but.... it does not give me the choice to remove them!! I really need help!! they are starting to cause my computer trouble!! ha does anyone know how to work kaspersky to get rid of viruses?? please help!! thanks!
unlock iphone 4 unlock iphone 4

unlock iphone 4 [url=http://unlockiphone44.com]unlock iphone 4[/url] unlock iphone 4 iphone 4 unlock

Anonymous said...

buy tramadol online buy tramadol online no prescription overnight - tramadol hcl 200

Anonymous said...

buy tramadol online tramadol for dogs price - buy tramadol online with mastercard

Anonymous said...

buy tramadol online tramadol withdrawal opiate - tramadol no prescription cheap

Anonymous said...

buy tramadol online buy tramadol online usa - buy online texas tramadol

Anonymous said...

buy tramadol online tramadol 50mg recommended dosage - tramadol 50 mg purchase

Anonymous said...

buy tramadol online no prescription cod tramadol for dogs 50mg dosage - reliable online pharmacy tramadol

Anonymous said...

buy tramadol online buy tramadol overnight delivery no prescription - buy tramadol egypt

Anonymous said...

buy tramadol online no prescription overnight can take 3 50 mg tramadol - tramadol hcl or tramadol

Anonymous said...

buy tramadol online tramadol 200mg online - order tramadol online to florida

Anonymous said...

generic xanax generic xanax ingredients - xanax withdrawal symptoms

Anonymous said...

order tramadol overnight buy tramadol in florida - tramadol buy dogs

Anonymous said...

buy xanax online cod buy xanax online without rx - buy xanax online

Anonymous said...

buy tramadol online tramadol urban dictionary - buy tramadol online no prescription cheap

Anonymous said...

generic xanax xanax effects reviews - xanax effects wiki

Anonymous said...

buy tramadol online no prescription buy tramadol now - buy tramadol for dogs online

Anonymous said...

buy tramadol online buy tramadol online no prescription overnight - tramadol for high

Anonymous said...

generic xanax xanax for anxiety - xanax side effects 2mg

Anonymous said...

carisoprodol 350 mg buy carisoprodol online us - carisoprodol dosage forms

Anonymous said...

buy xanax bars xanax bars order - mixing xanax and alcohol side effects

Anonymous said...

buy tramadol online tramadol hydrochloride 100 mg side effects - buy tramadol online no prescription usa

Anonymous said...

carisoprodol 350 mg carisoprodol orange juice - carisoprodol c-iv

Anonymous said...

buy tramadol online buy cheap tramadol overnight - tramadol hcl what is it prescribed for

Anonymous said...

buy tramadol online buy tramadol cod overnight delivery - tramadol generic ultram 50 mg 180 pills

Anonymous said...

buy tramadol online tramadol withdrawal dogs - where to buy tramadol online safely

Anonymous said...

cialis online cialis-72 saat - cialis ed reviews

Anonymous said...

order cialis no prescription secure tabs online cialis 20 mg - cialis daily or 36

Anonymous said...

buy cialis online generic cialis user reviews - cialis online senza ricetta

Anonymous said...

xanax online order xanax bars online - xanax dosage 0.5mg

Anonymous said...

buying xanax xanax pills bars - xanax bars and alcohol

Anonymous said...

cialis tadalafil buy cialis online in u.k - generic cialis made

Anonymous said...

generic cialis online generic cialis vs real cialis - cialis online rezeptfrei kaufen

Anonymous said...

buy cialis online cheap cialis reviews - cialis 100mg

Anonymous said...

buy tramadol online cod overnight tramadol dosage 70 lb dog - is it ok to take 100mg of tramadol

Anonymous said...

http://landvoicelearning.com/#62431 buy tramadol online australia - can buy tramadol online legally

Anonymous said...

buy tramadol cod fedex buy tramadol valium online - tramadol dosering

Anonymous said...

buy tramadol no prescription overnight tramadol 50mg over counter - is tramadol online real

Anonymous said...

07 ativan cost - lorazepam online pharmacy http://www.ativanonlinenorx.net/#buy-ativan, [url=http://www.ativanonlinenorx.net/#cheap-lorazepam-2mg]ativan cost[/url]

Anonymous said...

1, sibutramine diet pills - reductil for sale http://www.meridiaforyourdiet.net/#buy-meridia, [url=http://www.meridiaforyourdiet.net/#sibutramine-diet-pills]buy meridia[/url]

Anonymous said...

buy tramadol generic tramadol extended release - buy tramadol no prescription

Anonymous said...

generic tramadol online tramadol 100mg buy online - tramadol bargain

Anonymous said...

http://buytramadolonlinecool.com/#96430 tramadol 300 er - buy tramadol online new zealand

Anonymous said...

buy tramadol buy tramadol extended release - tramadol hcl lexapro

Anonymous said...

http://buytramadolonlinecool.com/#50897 buy tramadol dogs usa - tramadol for dogs - crush

Anonymous said...

http://reidmoody.com/#49853 ativan overdose prognosis - + ativan withdrawal + exercise

Anonymous said...

buy tramadol online tramadol 100 mg inyectable - tramadol 100mg no prescription

Anonymous said...

tramadol 50 buy tramadol online without rx - tramadol 50 mg safe

Anonymous said...

http://staam.org/#90873 best place to buy tramadol online reviews - buy tramadol online no prescription usa

Anonymous said...

http://staam.org/#41652 tramadol 50 mg and alcohol - tramadol ultracet

Anonymous said...

http://ranchodelastortugas.com/#71453 what is xanax withdrawal like - xanax 2 mg daily

Anonymous said...

buy tramadol for dogs tramadol 50 mg for dogs - tramadol hcl and codeine

Anonymous said...

cheap xanax online drug test for xanax how long - withdrawal side effects xanax xr

Anonymous said...

http://bayshorechryslerjeep.com/#7724 xanax 1mg with alcohol - xanax generic price

Anonymous said...



Feel free to surf to my blog post: homepage

Anonymous said...



Here is my website ... homepage

Anonymous said...



Feel free to surf to my blog ... site

Anonymous said...



Feel free to visit my web page: site

Anonymous said...



Also visit my homepage :: website

Anonymous said...

Woah! I'm really loving the template/theme of this site. It's simple,
yet effective. A lot of times it's challenging to get that "perfect balance" between superb usability and visual appearance. I must say you have done a fantastic job with this. Additionally, the blog loads very fast for me on Opera. Excellent Blog!

Look into my web blog :: dragon city cheat engine

Anonymous said...

Many people want to increase their muscle mass and create a toned, developed body that
is not only aesthetically pleasing, but strong
and healthy as well. Yes we would like muscle, but in the right way, and gaining lean muscle without fat is the key to doing this.
Whenever upgrades became ready you'll fully grasp this totally free no matter what quantity of money cost to establish them.

Also visit my site :: Somanabolic Muscle Maximizer Review