Free fast database application development software for mac

Tcl Web Application Framework provides the features that form the basis for writing an application, such as sessions, users, privilege separation, and an abstract database interface.
Tcl Web Application Framework is currently under development, but stable for production use.
Tcl Web Application Framework is written in such a way that applications will be able to easily integrate into the framework without having to modify the framework itself, making upgrading the framework without breaking the application possible.

System requirements:
- Tcl

GestLab Database 22 gives you a free tool which starts with version 1.1, the application and database are separate files. In order to use it, you must download both files (GestLab and GestLab Database), and place them in the same folder.

The Application Enhancer SDK allows you to create Application Enhancer modules.
Application Enhancer SDK provides great features for everything that is needed to create a fully-functioning APE module. Application Enhancer SDK is used in such well-known products as WindowShade X, FruitMenu, Labels X, and many others.
Includes:
- ApplicationEnhancer.framework containing everything you need to start developing your own APE module.
- Interapplication and intermodule communication facilities.
- Application Enhancer client auto-installing facilities in case you dont want to send user to Application Enhancer homepage.
- Objective-C method and C/C++ function trapping facilities.
- Free technical support. (limited)
- Example extensions with source code, including Metallifizer sources.
Application Enhancer SDK is also available in APE Lite form, which only provides facilities to change Mach-O symbols inside of your running process.
APE Lite SDK is now available freely as a part of the SDK for you to use - you can look at the APELite.h file to get an impression what it can do for you.
However, even though APELite is free to use, it still requires a license agreement.

H2 is an SQL database engine written in Java (but also available as a native binary). JDBC and ODBC APIs are supported.
Embedded and server modes are available. A Web console application is included. Clustering is supported.
H2 Database Engine is a web based java database engine.

Main features:
- Fast database engine
- Free, source code is included
- Supports standard SQL
- Written in Java
- Disk based or in-memory databases
- Browser base Console application
- JDBC API
- Limited ODBC support
- Embedded and client/server (network) mode
- High availablility support (clustering / failover)
- Wide range of data types including large objects (BLOB/CLOB)
- Strong security features (SSL, users, roles, encrypted files)
- Multiple connections, table level locking
- Cost based optimizer, using a genetic algorithm for complex queries
- Transaction support (serializable transaction isolation)
- Zero-administration, automatic recovery
- Large resultset, external sorting
- Scrollable and updatable resultset support
- Read only views and inline views
- Inner and outer joins, subqueries
- Many functions already built-in
- Triggers and Java functions / stored procedures
- Referential integrity / foreign key constraints with cascade, check constraints
- Multiple schema support
- Compatibility modes for HSQLDB, MySQL and PostgreSQL
- Sequence and autoincrement columns
- Well tested (high code coverage, randomized stress tests)
- Small footprint (smaller than 1 MB)
- Uses a small number of database files
- Can be compiled to native code using GCJ
- Primary keys, multiple index types (b-tree, linear hash, tree, hash)
- ORDER BY, GROUP BY, HAVING, UNION, LIMIT
- Information Schema
- Multiple connections
- Collation support
- EXPLAIN PLAN support
- The database can generate SQL script files
- Support for linked tables, and a built-in virtual range table
- Automatic re-compilation of prepared statements
- Sophisticated trace options
- Low memory requirements
- Easy to understand exception messages
- Standard handling of NULL values
- Multilanguage console application (at this time, English and German).

Enhancements
- Shell tool: the built-in commands EXIT, HELP, ?, LIST, and so on didnt work with a semicolon at the end.
- JDK 1.5 is now required to build the jar file. However it is still possible to create a jar file for Java 1.4. For details, see buildRelease.sh and buildRelease.bat. As an alternative, compile using JDK 1.5 or 1.6 and use Retrotranslator to create a Java 1.4 version http://retrotranslator.sourceforge.net/).
- When deleting or updating many rows in a table, the space in the index file was not re-used in the default mode (persistent database, b-tree index, LOG=1). This caused the index file to grow over time. Workarounds were to delete and re-created the index file, alter the table (add a remove a column), or append ;LOG=2 to the database URL. To disable the change, set the system property h2.reuseSpaceBtreeIndex to false.
- Identifiers with a digit and then a dollar sign didnt work. Example: A1$B.
- MS SQL Server compatibility: support for linked tables with NVARCHAR, NCHAR, NCLOB, and LONGNVARCHAR.
- Android: Workaround for a problem when using read-only databases in zip files (skip seems to be implemented incorrectly on the Android system).
- Calling execute() or prepareStatement() with null as the SQL statement now throws an exception.
- Benchmark: the number of executed statements was incorrect. The H2 database was loaded at the beginning of the test to collect results, now it is loaded at the very end. Thanks to Fred Toussi from HSQLDB for reporting those problems. However the changed do not affect the relative performance.
- H2 Console: command line settings are no longer stored in the properties file. They are now only used for the current process, except if they are explicitly saved.
- Cache: support for a second level soft-references cache. To enable it, append ;CACHE_TYPE=SOFT_LRU (or SOFT_TQ) to the database URL, or set the system property h2.cacheTypeDefault to "SOFT_LRU" / "SOFT_TQ". Enabling the second level cache reduces performance for small databases, but speeds up large databases. It makes sense to use it if the available memory size is unknown. Thanks a lot to Jan Kotek!

A complete suite of GNU C, C++, Fortran, and Java Cross Compilers, and the GDB CPU Simulator and Debugger for embedded microprocessor applications development. Targets development for ARM7, ARM9, and XScale applications.

JumpBox for the PostgreSQL Relational Database Management System 1.1.5 is described as a convenient as well as powerful object-relational database system that's been under active development for over 15 years.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL has a SQL implementation that strongly conforms to the ANSI-SQL 92/99 standards.

It has full support for subqueries (including subselects in the FROM clause), read-committed and serializable transaction isolation levels. This JumpBox includes PostgreSQL 8 along with PHPPgAdmin setup and ready to run. The PostgreSQL server is network accessible and provides a great storage engine for a broad array of applications.

Deploying an application as a JumpBox provides a dramatically-reduced path to getting started with the software. Aside from installation benefits it yields other advantages such as portability across computing environments and simplified ongoing maintenance of the application.

This JumpBox is free so there's no risk in trying it out. Download it today and experience for yourself a whole new way of working with server software.

Major Benefits:

1. Self-contained deployment means easy to move or delete - it won't scatter files all over your operating system.
2. New versions of the JumpBox contain updates to each component in the software stack so there's no patching web servers, application servers, databases, dependencies, etc.
3. A web-based administration console simplifies the management of your application including SSL certs, email relaying, SSH, backups and more.
4. Once you know how to install a JumpBox you can deploy any of 50+ other JumpBoxes and take advantage of a growing library of conveniently-packaged Open Source software.

If you see duplicate application names in Open With, when you control-click on a document, it means that your LaunchServices database needs to be rebuilt.

The Rebuild LaunchServices Database script takes care of it without using terminal.

Completly freeware.