sql syntax
SQL Query 2.2.2 Beta 1
SQL Query 2.2.2 Beta 1 is a user-friendly tool which can be used to connect to a MYSQL or ODBC Database and Display the Records in a table view. more>> <<less
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>>
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.
SQLite Manager 0.3.12
Firefox add-on that allows you to manage any database you want. more>> Firefox add-on that allows you to manage any database you want.
Manage any SQLite database on your computer. An intuitive heirarchical tree showing database objects. Helpful dialogs to manage tables, indexes, views and triggers. You can browse and search the tables, as well as add, edit and delete the records.
Facility to execute any sql query. A dropdown menu helps with the sql syntax thus making writing sql easier. Easy access to common operations through menu, toolbars, buttons and context-menu.
SQLite Manager allows you to export tables/views in csv or xml format.
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. An SQLite database is a single ordinary disk file that can be located anywhere in the directory hierarchy. It is likely that most of the storage in Mozilla applications, in near future, will use SQLite.
Note: The SQLite Manager add-on is cross-platform and it works on Mac OS X, Windows and Linux.
Main features:>
- dialogs for creation, deletion of tables, indexes, views and triggers
- ability to rename, copy, reindex tables
- ability to add and drop columns
- create new db, open any existing db, copy an existing db
- a tab for database settings (no need to write the pragma statements) where you can view and change the sqlite library settings
- export tables as csv files
- a dropdown menu showing all profile db (*.sqlite)
- an intuitive hierarchical tree showing all tables, indexes, views and triggers
- ability to browse data from any table
- dialogs to allow searching in a table
- allows editing and deleting selected record while browsing a tables data
- an extensive menu that helps with writing sql by hand and then executing it
- remembers the last used db across sessions
System requirements:
-
Enhancements:
- Issue #178 : Enhance new database to allow creation of in-memory database. Done. To open an in-memory db, go to Database menu -> New In-Memory Database. If the db opens successfully the title displays "in-memory database", in the left sidebar "in-memory" is displayed instead of db name and the statusbar displays "Memory" instead of Shared/Exclusive.
- Issue #180 : alert the user if a file from MRU could not be opened and remove the failed entry from MRU. Fixed.
Facility to execute any sql query. A dropdown menu helps with the sql syntax thus making writing sql easier. Easy access to common operations through menu, toolbars, buttons and context-menuLicense:Freeware
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.
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.
SqlBuilder 2.0.5
Open source Java library that will help you to easily generate SQL queries more>> Open source Java library that will help you to easily generate SQL queries
SqlBuilder is a library which attempts to take the pain out of generating SQL queries within Java programs. Using one programming language (Java) to generate code for another language (i.e. SQL) is always a challenge.
There are always issues with escaping characters within string literals, getting spaces in the right place, and getting the parentheses to match up. And often, even after the code is debugged and fully tested, it is still very fragile.
The slightest change will throw things out of balance and will require another round of tweaking and testing.
SqlBuilder changes that whole scenario by wrapping the SQL syntax within very lightweight and easy to use Java objects which follow the "builder" paradigm (similar to StringBuilder).
This changes many common SQL syntactical, runtime errors into Java compile-time errors! Lets dive right in to some quick examples to to see how it all works.
Enhancements
- Add support for additional query "set operators" (EXCEPT, INTERSECT), and add support for mixed usage of said operators. Fixes 2794171 .
- Add UnaryCondition EXISTS and UNIQUE operators.
- Fix isEmpty implementation for Subquery.
- Dont put double parens around IN condition with subexpression.
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.
Axamol SQL Library 0.1.4
Axamol SQL Library - Execute SQL statements stored in external library files more>>
Axamol SQL Library can often reduce code size of complex queries by 40%. You can also create HTML documentation with embedded documentation strings and a supplied XSLT stylesheet.
GalaXQL 2.0
GalaXQL - Unique interactive SQL tutorial more>>
Follow the instructions by your virtual teacher. The teacher can understand several possible mistakes that you may make, and gives hints on what may have gone wrong. You can skip to any chapter in the tutorial whenever you want.
Use the query editor to interact with the database, and to complete the assignments given by the virtual teacher. In case of syntax errors, SQLite (the database engine used in GalaXQL) returns helpful, human-readable error messages.
If you need more information, you can look things up in the integrated reference.
Oh, and the OpenGL-rendered galaxy map is not there just for show; you can alter the galaxy using SQL.
Enhancements:
- Changes include better layout, new rendering mode for lower-end computers, optional rendering of the 3d coordinate axes, updated SQLite database engine with CHECK constraints, and various little fixes.
- Mac OS X version is now ppc/intel universal binary, and source release supports both ansi and unicode builds.
because it is an interactive SQL tutorial where you interact with an OpenGL-rendered galaxy ... is an interactive SQL tutorial where you interact with an OpenGL-rendered galaxy using SQLSQLite Manager for Songbird 0.3.11
Songbird add-on that helps you manage your SQLite databases from your computer. more>> Songbird add-on that helps you manage your SQLite databases from your computer.
After installation, you will find a menu item under Tools menu. Click it to start the SQLite Manager.
An intuitive heirarchical tree showing database objects. Helpful dialogs to manage tables, indexes, views and triggers. You can browse and search the tables, as well as add, edit and delete the records.
SQLite Manager allows you to execute SQL Query.
A dropdown menu helps with the sql syntax thus making writing sql easier. SQLite-Manager gives you easy access to common operations through menu, toolbars, buttons and context-menu.
Note: The SQLite Manager add-on is cross-platform and it works on Mac OS X, Windows and Linux.
Main features:>
- dialogs for creation, deletion of tables, indexes, views and triggers
- ability to rename, copy, reindex tables
- add and drop columns in a table
- create new db, open any existing db, copy an existing db
- export tables/views as csv/xml files
- import table from csv/xml file
- a dropdown menu showing all profile db (*.sqlite)
- an intuitive hierarchical tree showing all tables, indexes, views and triggers
- ability to browse data from any table
- dialogs to allow searching in a table
- allows editing and deleting selected record while browsing a tables data
- an extensive menu that helps with writing sql by hand and then executing it
- remembers the last used db across sessions
- a tab for database settings (no need to write the pragma statements) where you can view and change the sqlite library settings
System requirements:
-
Enhancements:
- Issue #151 : "Copy Row" command should not include rowid if it is not a column in the table. Fixed.
- Issue #156 : Add Record, Edit Record, Search dialogs: Allow to paste constants instead of typing them. As of now, you can paste constants in input fields in dialogs for Add Record, Edit Record, Duplicate Record, Search by using the following shortcut keys: CTRL + 1: CURRENT_DATE, CTRL + 2: CURRENT_TIME, CTRL + 3: CURRENT_TIMESTAMP
- Issue #169 : Add New Record: Option to retain the previous values in the textboxes or to clear all textboxes and show default values where available. This can be done by setting the value of preference "extensions.sqlitemanager.whenInsertingShow" to either "previous" or "default". The default value is "previous". The preference can be set from the Options dialog. However, when the Add Record dialog is first opened, default values will be shown whatever the preference is set to.
- Issue #171 : support SeaMonkey 2.0a2. Done.
- Issue #174 : Export the Database Structure. This can be done through a menuitem "Export Database Structure" under the "Database" menu.
- Issue #175 : Default values for columns should not be converted to strings in all cases. The problem occurs in create table dialog and add column action under structure tab. Even if numbers like 12, 12.21, 12.1e-2, etc. are specified and while adding column even if the default value is left blank, the extension converts them to strings and adds the default clause in the column definition. This has now been fixed. If the default value field contains the string NULL (case-insensitive) or is blank, the default clause is omitted. If the value can be converted to a number it is considered as a number otherwise it is regarded as a string. The special strings CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP are treated as constants.
- Issue #176 : Add Record, Edit Record, Search dialogs: accesskey related errors. Fixed.
Serchilo 1.0
Quickly access Serchilo.net from your Dashboard. more>> Quickly access Serchilo.net from your Dashboard.
Serchilo is a nice widget that allows you to easily access Serchilo.net from your OS X Dashboard. Serchilo is a wiki-based command line for the web.
Main features:
- Use localized commands.
- Use user commands (free registration necessary).
- Preview command syntax with autocomple.
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.
countchar 1.1
countchar - Count occurences of a character in a string more>>
This small osax contains just a single command, "countchar" for this task.
To install the osax, just copy it into Library/ScriptingAdditions within your home directory. The syntax should be easy enough to understand with the provided example script.
