learn sql
Ronin SQL 0.1.1
Open source Ruby library that offers SQL security task support more>> Open source Ruby library that offers SQL security task support
Ronin SQL is a Ruby library for Ronin that provids support for SQL related
security tasks.
Ronin is a Ruby platform that has been designed for data exploration tasks and information security.
Ronin allows for the rapid development and distribution of code over many of the common Source-Code-Management (SCM) systems.
Enhancements:
- Trivial bug fix to URI::HTTP#sql_errors.
Freaky SQL 2.0a2
Freaky SQL allows the creation, viewing, and modification of REAL SQL Databases more>>
Main features:
- Full Table and Field Schema Modification
- Data Viewing, Querying, and Editing
- Indexing and Encoding Support
- Conversion from the Old Database Format
- Conversion Between Folders and Virtual Volumes
- XML and CSV Import and Export.
Enhancements:
- Fixed some things..... creating RSD databases isnt really a wise idea yet.
- Opens RDB folders now.
- Cant rename stuff..... not supported in SQLite, the workaround is annoying.
LRNJ build 53
LRNJ - Learn japanese with a retro-style RPG: Slime Forest more>>
The game is still under development, but many students already find it useful, and it can currently teach you katakana, hiragana, and over a thousand kanji, essential character recognition for reading Japanese.
Gorilla SQL 0.3
Gorilla SQL is considered as a professional and helpful network communication program. more>> Gorilla SQL 0.3 is considered as a professional and helpful network communication program. Gorilla SQL is a cross platform, universal sql client manager. Now you can connect to PostgreSQL (native), MySQL (native), Microsoft Access / SQL Server or other ODBC databases with one program.
Gorilla SQL also known as Gsql, is a straight SQL client which allows you to execute sql commands to any of its native or ODBC databases.
Gsql supports joins, sort results, supports inserts, updates and deletes. Also Gsql has supports bookmark sql commands, history commands and many other functions to make your time on your database more efficient. It is, the all in one universal sql client. Any command your database accepts, Gsql supports.
- Export results to XML or delimited format.
- Table schema window. Allows you to drag table and field names into the query box.
- Fixed Welcome Window.
- OpenBase Support Now Added. Now native support for OpenBase, PostGres, Mysql and ODBC (Any ODBC DB (mysql, access, exel etc...)
- Improved Error Checking
Requirements: Mac OS X 10.2 or later.
Silverwolfs SQL Query 2.2.0
Silverwolfs SQL Query - Connect to mysql database & display records more>>
Note: ODBC Support only functions in the windows version at this time.
Main features:
- Run Any SQL Query
- Server Address Book
- Export Records to CSV
- Save Queries as .SQL files
- recent query list
- Column Type Detection
- multi line sql queries
Enhancements:
- Bug Fixes in ODBC Server Entry Screen.
Silverwolf's SQL Query 2.2.0
Silverwolfs SQL Query brings a comprehensive, user friendly tool to connect to a MYSQL or ODBC Database and display the Records in a table view. more>>
Silverwolf's SQL Query 2.2.0 brings a comprehensive, user friendly tool to connect to a MYSQL or ODBC Database and display the Records in a table view.
Major Features:
- Run Any SQL Query, Server Address Book, Export Records to CSV, Save Queries as .
- SQL files, recent query list, Column Type Detection, multi line sql queries.
- ODBC Support only functions in the windows version at this time.
- This program is freeware for personal and corporate use.
- This program is currently in BETA status and may still have bugs.
Eduphant 2.0b2
PostgreSQL GUI client. more>>
You can use EduPhant regardless of your language or favorite operating system since it supports any text encoding PostgreSQL supports and works on Mac OS 8 and 9, OS X, Windows, and we have an experimental build for Linux too now.
Most other SQL clients dumbly enter data in PostgreSQL in their operating systems default text encoding, regardless of the encoding in which your database has been defined. This results in corrupted data that isnt usable cross-platform or with other clients that do respect the text encodings like EduPhant. The corruption is most noticable with non-ASCII characters like an accented "e."
EduPhants SQL query templates will allow the novices to quickly pick up the SQL syntax and logic, or they will jog the memory of the more advanced users. Plus they make it a breeze to rapidly construct your SQL queries. When you click on cells or headers of the query results table or of the database overview table, you enter their content into your query -- another very practical feature to reduce typing (and typos). You can also store your own custom SQL templates.
Carribean Dreams 1.0
Carribean Dreams - Marine fishes icon set more>>
The icons are best viewed in 128x128 at 32bit mode.
Completly freeware for personal use.
Eclipse SQL 3.5.0 RC8
A thin SQL client that allows you to query and browse any JDBC compliant database more>>
Eclipse SQL 3.5.0 RC8 provides you with a professional and useful thin SQL client which can allow you to query and browse any JDBC compliant database.
Eclipse SQL Explorer supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases. Eclipse SQL started as a fork from the original JFaceDb project which has gone commercial and uses some of the core libraries of the SQuirreL SQL project.
Major Features:
- Oracle Specific Features;
- Query Execution Explain Plan
- Function, JavaSource, Package, Procedure, Sequence and Trigger Nodes
- Session, User, Job, Top SQL and Parameter info for database node
- Source, Info, DDL and XML tabs for most of the nodes
- DB2 Specific Features:
- Query Execution Explain Plan
- Triggers Node in Database Structure View
- Trigger Source Displayed in Database Detail View
- MySQL Specific Features:
- Create Table Script Action
- Logs, Processes, Status, Variables and TableStatus detail tabs
Enhancements:
- Added preference to control sorting of column names in db structure view (feature #2663329, bug #1611426)
- Fixed problem that double click in file search results does not select found line in SQLEditor
- Added preference to show session name in SQL editor title too (feature #2638982)
- Fixed #2687620, general solution triggered from SQLite bug
- Fixed auto completion using table alias (Patch #2643772 by seekforth)
- Some internal changes (Patches #2637474,#2633721,#2633365,#2633298 by joco01)
- New action Generate Insert Statement (Patch #2695812, part of feature #1590278 by a_lazar)
- Fixed #1200935, missing foreign key in create table script (Patch #2708377 by sishi)
- Fixed #2709713, added new preference Log SQL Info Messages to check for SQLWarnings which displays raise info or print messages from stored routines
- Show server info node as root node in db structure view
- Added apache derby plugin (Patch #1612294)
- Internal cleanup for, removed deprecated sources
LanguageNow! 8.0
LanguageNow! is a tool created by Transparent Language, helping you to learn different languages (Dutch, English, Russian, Swedish, Spanish, French, Polish, Irish and many others) more>>
LanguageNow! 8.0 is a tool created by Transparent Language, helping you to learn different languages (Dutch, English, Russian, Swedish, Spanish, French, Polish, Irish and many others)
BigSQL 1.0
igSQL is a PostgreSQL client (not unlike psql). It enables the user to send SQL to a server and display the more>>
SQuirrel SQL Client 2.5
SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database more>>
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. SQuirreLs functionality may be extended through the use of plugins.
Main 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.
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.
Enhancements:
- Enhancements
- New plugins provide enhanced capabilities:
- DB2 Plugin: Stored Procedures, Triggers and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives DB2-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving DB2-specific information about them.
- H2 Plugin: Indexes and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives H2-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving H2-specific information about them.
- PostgreSQL Plugin: Stored Procedures, Triggers and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives PostgreSQL-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving DB2-specific information about them.
- Sybase Plugin: Allows the user to reverse engineer to the source code for Views and Stored Procedures displayed in the object tree.
- Added better support for executing large scripts so that SQuirreL remains responsive to UI interaction, as well as providing much faster execution.
- Added custom statement tokenizer framework to allow plugins to control how statements are tokenized.
- Drop tables, Delete Records and Copy Tables features now will order the tables according to Foreign Key dependencies instead of alphabetically by name.
- Oracle Plugin now supports executing create statements for triggers, stored procedures and functions using "/" just as is done in SQL-Plus. Also "@" can now be used to indicate a file to be parsed and executed while running another script in SQL Editor.
- SQL History Dialog allows for searching previously executed statements by regular expression.
- Many bug fixes
iPhoto To SQL 1.2
iPhoto To SQL - Creates SQL metadata dump of a photo from iPhoto more>>
iPhoto To SQL will create the following fields: id, title, comment, keywords, stars, date, album, thumbnail filename and image filename. You can set height/width maximums on the thumbnails and images and they will be rescaled with their aspect ratio preserved.
Enhancements:
- Minor fix to no longer clobber the SQL file when doing multiple exports.
- The SQL file is named for the album being exported also saved in the directory itself.

DzeroMagicSpell 1
DzeroMagicSpell is developed as a small piece of software which helps encourage young people to learn how to spell. more>>
DzeroMagicSpell 1 is developed as a small piece of software which helps encourage young people to learn how to spell.
The software presents images with a missing word that the user has to type. Educators (parents) are encouraged to supply their own images to taylor the task to the individual child using the software.
Requirements:
- Mac OS X
CarbonMaker 1.0b1
Visually build OS9 & OSX apps. more>>
Ever wanted to show your friends how creative you are? Ever felt tired of using the same applications over and over?
CarbonMaker is for you, and the most fantastic thing with this application is that you do not need to learn a programming language. Forget C++, Java, Objective-C!