Free databases types software for mac

Tech Database is FileMaker Pro 5 based and simple to use. It is comprised of two databases using relationships to create some cool unit selections.

One for hardware information and the second to store whatever images you choose to represent a given piece of hardware, (i.e. Laptops, CPUs, Modems, etc.) Printing reports has not yet been implemented in this version as I always find my exported data more useful than a printed report from FMPro.

lease feel free to alter this database to suit your needs. Then send the developer a copy!

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!

Oracle9i Database is the state of the art in object-relational databases. Voted Editors Choice by PC magazine and the #1 database for Linux by Linux Journal, Oracle9i Database is the most scalable and full featured database available.

Whether driving your web site, packaged applications, data warehouses or OLTP applications, Oracle9i Database is a foundation technology for any professional computing environment..

Use Creator Types if you have a Creator file thats been stripped of its file type and/or its creator type.

Do not put this script in the Script Menu Folder. Instead, put it on the desktop, and drag and drop the Creator file onto the script icon.

Completly freeware.

Netinfo Database Loader 1.1 is created to be a tiny yet effective Filemaker pro database which assists you to import information in your local or shared Netinfo databases. It works by reformating and dumping all the entries in "raw format" that is copied in the Clipboard. Create a plain Textedit file, paste the dump in it, save it as UTF-8, then go back to the database to finish importation with AppleScript and the Terminal.

It is particularly well suited to create entries to use with OpenLDAP and Open directory in Mac OS X Server 10.2 so that you can create a shared LDAP directory to be exploited from Address Book, Entourage, or any other LDAP client.

BaseTen is a freeware, open source database framework created in Cocoa for working with PostgreSQL databases. BaseTen has been designed with familiar, Core Data -like semantics and APIs.

Main features:
- BaseTen Assistant imports Core Data / Xcode data models.
- Discovers the database schema automatically at runtime, including 1-1, 1-many and many-many relationships.
- Database changes are propagated to clients automatically, without polling.
- In-memory database objects are uniqued, and objects fetched via relationships are faults by default.
- Support for RDBMS features like database-driven data validation, multi-column primary keys and updateable views.
- Autocommit and manual save/rollback modes, both with NSUndoManager integration.
- A BaseTen-aware NSArrayController subclass automates locking and change propagation.
- Fetches are specified with NSPredicates (the relevant portions of which are evaluated on the database).

System requirements:
-
- AppKit for the optional BXSynchronizedArrayController.
-

Enhancements
BaseTen:
- BaseTens date and time type handling has been significantly overhauled.
- Timestamp and datetime types are now always returned as NSDates.
- NSDates are stored into the database in UTC. When fetching, database values are assigned the UTC time zone, or, if they are qualified with some other time zone on the database, converted to UTC.
- NSCalendar is now used instead of NSCalendarDate when converting NSDates to date strings.
- PostgreSQL "time" types are now handled. On the Cocoa side, they are converted to NSDates with the appropriate time offset from the reference date.
- New and changed data type support
- The XML data type can now be fetched as NSXMLDocument. This happens if the database schema is enforcing document-only values with a constraint such as CHECK(column IS DOCUMENT).
- "bit" and "varbit" fields are now fully supported. They are fetched as NSStrings because they cant easily be represented as octets.
- In additiong to fetching "point" fields as NSPoints, NSPoint values can now be saved into the database.
- Changes to the way BaseTen supports database relationships
- The default key names for to-many relationships have changed to the format "Set". The previous form, "", is now deprecated. Add a symbolic breakpoint to BXDeprecationWarning to find uses of these deprecated keys.
- BaseTen can now extract direction-specific relationship names from a foreign key constraints name. The combined length of these two names can be a maximum of 61 bytes of UTF-8. This facility is used by the updated BaseTen Assistant to import the direction-specific names from Xcode Data Modeler schemas.
- When creating new objects with a field values dictionary, to-one related objects (or their object IDs) can now be specified as an alternative to specifying the values of the foreign key fields. The relationship name is used as the key.
Other changes:
- All text transferred between the database and BaseTen will now be normalized to Unicode normal form D, ie. the format produced by -[NSString decomposedStringWithCanonicalMapping].
- Most locking queries sent by BaseTen can now be disabled, and documentation has been added to describe the locking functionality.
- More of BaseTens internals have now been documented in the reference manual.
- When inserting, updating or deleting rows, BaseTen now notices (and posts notifications of) changes that occur as a result of database triggers or rules firing. The only requirement is that said changes are to entities other than the one being changed by BaseTen; changes to the same entity will still be ignored.
- BXDatabaseObjectID is now documented as thread-safe since it only uses NSURL.
- BXSetProxies are now declared as deriving from NSMutableSet, as the NSCountedSets countability property isnt currently used by BaseTen.
- BaseTen will no longer try to unescape non-"bytea" columns.
- More SSL status codes are now available for determining when SSL is unavailable, automatic SSL certificate verification fails, user clicks Cancel in the certificate trust panel or some other SSL error occurs.
- Worked around potential issues with garbage collection where BaseTen used pointers to objects internal structures.
- KVO willChange notifications sent from -setPrimitiveValue:forKey: are now always called before the update. In certain cases with earlier BaseTen versions, observers might receive the notification after the change had been made.
- Some connection error messages are now more accurate.
BaseTenAppKit:
- BXSynchronizedArrayController can now remove objects even if the content set is bound to another array controller.
- BXSynchronizedArrayControllers property fetchesOnConnect is now called fetchesAutomatically. If its set, a fetch will also be performed when an already-connected database context is assigned to the array controller.
- BaseTenAppKit now embeds the Interface Builder plug-in. Interface Builder loads the plug-in if the framework has been added to a project.
- Fixed a crasher which occurred when connecting to a server with SSL capability in asynchronous mode.
- Fixed awkward user interaction when clicking Cancel in the certificate trust panel.
- Fixed a bug which caused object creation to fail if BXSynchronizedArrayController was instantiated in a nib and hadnt performed a fetch.
BaseTen Assistant:
- BaseTen Assistant can now name both sides of one-to-many and one-to-one relationships with the names entered in the Xcode Data Modeler.
- Optional relationships are now be created as optional and required relationships as required.
- Columns will no longer be created for transient attributes in data models.
- Relationships are now listed in the Inspector and info windows.
- A graphical representation of the database schema can now be created for use with Graphviz or OmniGraffle.
- Temporary information can now be deleted from BaseTen schema.
- Help is now more comprehensive.

Change File Types is a simple AppleScript that allows you to change a files creator and type information.

Completly Freeware.

Gift Management Database is a complete project build with Cocoa and Xcode that use ODBC drivers for interfacing the MySql database.

This package includes all source code needed to build a complete application for managing presents and gifts. With this tutorial everyone can start to create a complete commercial application using databases.

You can manage person, gift and recurrence tables, meaning that you can create, modify, delete and print database information for Person, Gifts and so on.