databases for dummies
Appleworks Database Files 1.0
Appleworks database for software & hardware inventory. more>>
Netinfo Database Loader 1.1
Netinfo Database Loader is created to be a tiny yet effective Filemaker pro database which assists you to import information in your local or shared Netinfo databases. more>>
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.
Oracle9i Database R2
Enterprise database solution. more>>
Whether driving your web site, packaged applications, data warehouses or OLTP applications, Oracle9i Database is a foundation technology for any professional computing environment..
Tech Database 2.4
Two databases for hardware info and images. more>>
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 Database Engine 1.1.113
An SQL database engine written in Java more>> An SQL database engine written in Java
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!
H2 Database Engine is a web based java database engine. Main features: - Fast database engine - ... - EXPLAIN PLAN support - The database can generate SQL script files - Support for linked tablesEnsemble Database Converter 1.0
Ensemble Database Converter - Convert database from Ensemble v1.0 to Ensemble2 more>>
Do below operations at first, then you easily convert database from Ensemble v1.0.
1. Download Ensemble Database Converter
2. Launch Ensemble2
3. Only follow instructions
iRad Database 1.0.2
iRad Database is a highly-efficient, high-quality DICOM image server that functions as an optional database for iRad. more>>
iRad Database 1.0.2 is a highly-efficient, high-quality DICOM image server that functions as an optional database for iRad. iRad Database allows JPEG lossless and non compressed transfer syntaxes. iRad Database is a precompiled version of dcm4jboss and jboss.
GestLab Database 22
GestLab Database gives you a free tool which starts with version 1.1, the application and database are separate files. more>>
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.
MySQL Database Server 5.1.35
MySQL Database Server is a versatile and innovative tool which is designed for enterprise organizations delivering business critical database applications. more>>
MySQL Database Server 5.1.35 is a versatile and innovative tool which is designed for enterprise organizations delivering business critical database applications. It gives corporate developers, DBAs and ISVs an array of new enterprise features to make more productive developing, deploying, and managing industrial strength applications. If you need a GUI for MySQL Database, you can download - NAVICAT (MySQL GUI). It supports to import Oracle, MS SQL, MS Access, Excel, CSV, XML or other formats to MySQL.
MySQL Database Server delivers new enterprise features, including: ACID Transactions to build reliable and secure business critical applications. Stored procedures to improve developer productivity. Triggers to enforce complex business rules at the database level. Views to ensure sensitive information is not compromised. Information schema to provide easy access to metadata. Distributed transactions (XA) to support complex transactions across multiple databases.
tool which is designed for enterprise organizations delivering business critical database ... for MySQL Database, you can download - NAVICAT (MySQL GUI). It supports to import Oracle, MS SQLLicense Database 1.0
License Database is an innovative and versatile utility which stores software license information like serial numbers. more>>
License Database 1.0 is an innovative and versatile utility which stores software license information like serial numbers.
You all have lots of serial numbers lying around, and when ever the software needs to be reinstalled the job of finding the email with the serial number in it comes along. License Database hopes to solve this problem by providing a central storage area for all your serial numbers. Unlike other serial databases available License Database has kept things simple. The interface is clean and tidy and best of all License Database is free.
Xactuell for InDesign CS4 5.0r5
Xactuell for InDesign can be a really useful tool which lends you a helping hand in transfering information from databases into layout documents and backwards. more>> <<less
AppleSpec Database Jan, '03
AppleSpec Database Jan, 03 is known as an effective canonical list of every piece of hardware ever released by Apple Computer. more>>
AppleSpec Database Jan, '03 is known as an effective canonical list of every piece of hardware ever released by Apple Computer. Mostly for developers, macintosh consultants and technical afficionados, the database is the #1 Technical resource to help people do their jobs.
Requirements:
- Mac OS 8.6 - 9.x
dbSuite Admin Tool for MySQL 1.2
Graphically manage MySQL databases. more>>
Navicat for MySQL 8.1.5
Navicat for MySQL brings you an effective solution for MySQL administration and development. more>>
Navicat for MySQL 8.1.5 brings you an effective solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all verions of MySQL and let you converts Access to MySQL, MS SQL to MySQL, Excel to MySQL, synchronizes and backups database in a snap through helpful wizards.
Major Features:
- Latest MySQL Versions Support: Navicat for MySQL a powerful MySQL Database Server administration and development tool. Highlights of supported features:
- Support of MySQL versions from 3.21 or above
- Support of Unicode / Character Set
- Support of MySQL Events, Views and Stored Procedures creation
- Support of Triggers
- Support of Foreign Keys
- Support of Partition
- Additional Connection Options
- Support of SSH Tunnel: Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts.
- Support of HTTP Tunnel: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their MySQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
- Provide auto-reconnection for MySQL server: With the option "Keepalive Interval", you can keep connection alive with the server by pinging it.
- Comprehensive Management of MySQL objects
- Create, edit and drop table's fields, indices, foreign keys and triggers: With Table Designer the basic Navicat for MySQL tool for working with tables, you can create, edit and drop table's fields, indices, foreign keys, and much more.
- SQL Preview: The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.
- Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
- View Database / Table Structure: Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
- Diversified Import and Export Competence
- Import data from ODBC: You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.
- Import data from different file formats: XLS, CSV, TXT, DBF and XML: Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
- Export data to different file formats: XLS, TXT, CSV, DBF and XML: Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
- Export data and create records as INSERT statements in sql file: During Data Transfer, you can choose to export data as sql file with record options like complete insert statements / extended insert statements etc.
- Powerful Data Manipulation Tools
- Form View: Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.
- Support of Foreign Key Data Selection: With the GUI tool Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
- Data and Structure Synchronization: Navicat for MySQL allows you to transfer data from one MySQL database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source database or on another MySQL server.
- Support of Data Transfer between local / remote MySQL databases: Transfer tables/views/stored procedures/events from one MySQL database to another MySQL database, or to a plain text file.
- Support of Backup and Restore MySQL databases: Regular backup on database is important to users. Backup/restore all tables and records, views, stored procedures and events for your MySQL database using Navicat. You can also schedule backups between databases.
- Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization: Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Backup, Data Transfer, Data Synchronization, Import and Export.
- Send notification e-mail and attachment for schedule task: Generate notification e-mails with attach exported files to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.
- Powerful Security Management
- Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected databases, tables/views, fields and stored procedures/functions.
- Well-Designed Visual Builder / Editor
- Visual Query / View Builder: Visual Query / View Builder which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
- Query Editor: It allows you to create and edit SQL text for a query, prepare and execute selected queries.
- Support of Parameter Query: Set query parameters to add variable values to a query each time you run it.
- Code-Completion for Query, View, Stored Procedure and Event: Experience a quick way in constructing SQL statements in Query Editor, View, Stored Procedure and Event with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.
- More great features
- Virtual Grouping: Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure, Event, Query, Backup and Schedule.
- Server Monitor: Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status icon to show and/or modify the properties of MySQL servers.
- SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
- Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.
Enhancements:
- Improvements:
-
- Improved compatibility to some ODBC drivers for Import Wizard.
- Bug Fixes:
-
- Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
- Data grid was unable to be opened properly when some kind of text were displayed.
- Removed some internal SQL run by Navicat in Query Viewer.
- Unable to change the default value of an existing field from NULL to other values in Table Designer.
Requirements
- Mac OS X 10.4 Tiger or 10.5 Leopard
front end provides a powerful graphical interface for databases management, development and ... You can also schedule backups between databases. Create Schedule for Backup, Import / ExportLicense:update/patch
Xactuell for QuarkXPress 8.x 5.0r5
Xactuell for QuarkXPress 8.x proves itself to be a helpful and innovative tool for effectively transferring information from databases into layout documents and backwards. more>>
Xactuell for QuarkXPress 8.x 5.0r5 proves itself to be a helpful and innovative tool transferring information from databases into layout documents and backwards.for effectively. It communicates with all common databases and interchange formats like XML, MySQL, Microsoft SQL, Oracle, Excel, FileMaker, XML, CSV, DB/2, Sybase, Access, SQlite, Informix, Lotus Notes, An iBase database is already included.
With Xactuell it is possible to link text sections inside of text boxes, entire text boxes, picture boxes and tables. Once a link between a layout document and a database is established, the linked objects (e.g. prices, texts and pictures) in the document can be updated at any time. The update can either cover the entire document, or refer to certain selected page areas or queries only (e.g. if only the prices, but not the corresponding product descriptions are to be updated).
If required, the process also works the other way round: data from the layout document can be written back onto the database, e.g. to create a page index. Xactuell understands the full command scope of the tagged text filter, e.g. for formatting text passages exactly as they should appear in your layout.
Feel free to make manual layout modifications at any time, your layout will stay a native layout document (enriched with the latest information from your database). Catalogues produced with Xactuell can always have an individual appearance and do not necessarily look like typical generated "database publishing" catalogues.
Requirements:
- QuarkXPress 8.x TCP/IP Default Browser
