graphical database schema
Sponsored Links
Sponsored Links
Secleted [ 0 ] software to compare
Results 1 - 15 of about 4773
Valentina Database 3.2
Valentina is cross-platform DBMS that makes it easy to switch between a local embedded database and server using the same source more>>
Valentina is cross-platform DBMS that makes it easy to switch between a local embedded database and server using the same sources. It supports disk and in-memory databases, field types from Bit to BLOB, and both a SQL92(99) and non-SQL API.
Valentina supports Relational, Extended Navigational, and Object-Relational data models. It introduces a revolutionary model abstraction "Link". It works natively in UTF-16, can accept 270 encodings, and features advanced features such as regular expressions, XML, full-text search, pictures, functions, and calculated fields. It offers triggers, views, and stored procedures.
Enhancements:
- Valentina Studio now has a Diagrams panel for database schema.
- There are new examples on the usage of Link refactorings API and SQL commands.
- There are about 40 bugfixes over the entire product line (kernel, PHP, REALbasic, Director, VCOM, and VStudio).
<<lessValentina supports Relational, Extended Navigational, and Object-Relational data models. It introduces a revolutionary model abstraction "Link". It works natively in UTF-16, can accept 270 encodings, and features advanced features such as regular expressions, XML, full-text search, pictures, functions, and calculated fields. It offers triggers, views, and stored procedures.
Enhancements:
- Valentina Studio now has a Diagrams panel for database schema.
- There are new examples on the usage of Link refactorings API and SQL commands.
- There are about 40 bugfixes over the entire product line (kernel, PHP, REALbasic, Director, VCOM, and VStudio).
Download (MB)
Added: 2007-08-05 License: GPL (GNU General Public License) Price:
813 downloads
Irregular Operations Database 1.0
Irregular Operations Database is a project used for tracking flight delays. more>>
Irregular Operations Database is a project used for tracking flight delays.
Irregular Ops is a CGI script for intranet use to track irregular operations (flight delays) for scheduled airlines.
<<lessIrregular Ops is a CGI script for intranet use to track irregular operations (flight delays) for scheduled airlines.
Download (0.013MB)
Added: 2007-02-19 License: GPL (GNU General Public License) Price:
979 downloads
Navicat MySQL database tool for Linux (Freeware) 8.0.29
Navicat MySQL Manager is a set of graphical database management and monitoring tools for MySQL. Navicat is easy-to-use and powerful. It supports backup/ restore, import/ export data and synchronize database. more>>
Navicat MySQL Manager is a set of graphical database management and monitoring tools for MySQL.
Major features
- This is an all-inclusive mysql front end provides a powerful graphical interface for databases management 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 it lets you convert data to/ from MySQL, synchronizes and backups database in a snap through helpful wizards
- Major features of Navicat full version include Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore, SSH and HTTP Tunneling and Data Transfer.
- Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries),
printing of table structure. It also includes a full featured graphical manager for setting the users and access privileges - Navicat version 8 supports Code Completion, Form View and email Notification Services, etc.
- Navicat is the number 1 MySQL database administration shareware in Download.com with over 350,000 downloads and 1,100,000 installations worldwide. Some of the users including Sony Music, Intel, Kodak, FedEx, KPMG Consulting, Ericsson,
Siemens AG, Yahoo!, NTT DoCoMo (Japan), Hitachi (Japan), Imation, Lexmark, Cisco Systems, RSA Security, Avis (Europe), U.S. Department of Energy, UPS, Disney, Oxford University, Harvard University, NASA Space Flight Center, MIT, Michigan State University, University of Michigan, ... - Navicat delivers a personal experience, simplifying the way you work. The program is also available for Windows and Mac OS X.
Download (0.00KB)
Added: 2009-04-04 License: Freeware Price: $0
210 downloads
XML::Validator::Schema 1.08
XML::Validator::Schema is a Perl module to validate XML against a subset of W3C XML Schema. more>>
XML::Validator::Schema is a Perl module to validate XML against a subset of W3C XML Schema.
SYNOPSIS
use XML::SAX::ParserFactory;
use XML::Validator::Schema;
#
# create a new validator object, using foo.xsd
#
$validator = XML::Validator::Schema->new(file => foo.xsd);
#
# create a SAX parser and assign the validator as a Handler
#
$parser = XML::SAX::ParserFactory->parser(Handler => $validator);
#
# validate foo.xml against foo.xsd
#
eval { $parser->parse_uri(foo.xml) };
die "File failed validation: $@" if $@;
This module allows you to validate XML documents against a W3C XML Schema. This module does not implement the full W3C XML Schema recommendation (http://www.w3.org/XML/Schema), but a useful subset. See the SCHEMA SUPPORT section below.
IMPORTANT NOTE: To get line and column numbers in the error messages generated by this module you must install XML::Filter::ExceptionLocator and use XML::SAX::ExpatXS as your SAX parser. This module is much more useful if you can tell where your errors are, so using these modules is highly recommeded!
<<lessSYNOPSIS
use XML::SAX::ParserFactory;
use XML::Validator::Schema;
#
# create a new validator object, using foo.xsd
#
$validator = XML::Validator::Schema->new(file => foo.xsd);
#
# create a SAX parser and assign the validator as a Handler
#
$parser = XML::SAX::ParserFactory->parser(Handler => $validator);
#
# validate foo.xml against foo.xsd
#
eval { $parser->parse_uri(foo.xml) };
die "File failed validation: $@" if $@;
This module allows you to validate XML documents against a W3C XML Schema. This module does not implement the full W3C XML Schema recommendation (http://www.w3.org/XML/Schema), but a useful subset. See the SCHEMA SUPPORT section below.
IMPORTANT NOTE: To get line and column numbers in the error messages generated by this module you must install XML::Filter::ExceptionLocator and use XML::SAX::ExpatXS as your SAX parser. This module is much more useful if you can tell where your errors are, so using these modules is highly recommeded!
Download (0.052MB)
Added: 2006-09-15 License: Perl Artistic License Price:
1142 downloads
Object::Relation::Meta::Class::Schema 0.1.0
Object::Relation::Meta::Class::Schema is a Perl module for Object::Relation database store builder. more>>
Object::Relation::Meta::Class::Schema is a Perl module for Object::Relation database store builder.
This module is provides metadata for all Object::Relation classes while building a storage schema. Loading Object::Relation::Schema causes it to be used instead of Object::Relation::Meta::Class. This is so that extra metadata methods are available that are useful in constructing the schema, but are not otherwise useful when an application is actually in use.
At this point, those attributes tend to be database-specific. Once other types of data stores are added (XML, LDAP, etc.), other attributes may be added to allow their schemas to be built, as well.
<<lessThis module is provides metadata for all Object::Relation classes while building a storage schema. Loading Object::Relation::Schema causes it to be used instead of Object::Relation::Meta::Class. This is so that extra metadata methods are available that are useful in constructing the schema, but are not otherwise useful when an application is actually in use.
At this point, those attributes tend to be database-specific. Once other types of data stores are added (XML, LDAP, etc.), other attributes may be added to allow their schemas to be built, as well.
Download (0.024MB)
Added: 2006-09-21 License: Perl Artistic License Price:
1128 downloads
Aqua Data Studio 6.0.10
Aqua Data Studio is a database query tool and administration tool that allows developers to easily create, edit, and execute SQL more>>
Aqua Data Studio program is a database query tool and administration tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures.
Aqua Data Studio provides an integrated database environment with a single consistent interface to all major relational databases. This allows the database administrator or developer to tackle multiple tasks simultaneously from one application.
Main features:
Query Analyzer/Window
- Aqua Data Studios sophisticated Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test SQL scripts. Other features to speed up development include SQL automation, auto-describe and sortable multi-grid results. The query analyzer also provides client side variable binding, allowing a user to execute stored procedures or functions with local variables binded to receive out parameters. The query window also provides two modes of operation, using a SplitPane View or a MultiTab View for the editor and the query results.
Schema Browser & Visual Editing
- Its graphical browsing capabilities allow you to understand the structure and dependencies of the database schema with a single mouse click. The schema browser also allows you to visually edit any schema object with a graphical design form to CREATE, ALTER or DROP the object. Visual editing supports Tables, Indexes, Procedures, Data Types and other schema objects. The visual editors also provides an SQL preview of all the commands to be executed to commit the operation.
Schema Extraction & DDL Scripting
- Its graphical browsing allows you to extract the structure definition of all schema objects and to script the SQL DDL and DML (eg CREATE, ALTER, DROP, SELECT, INSERT, UPDATE and DELETE) syntax for database schema objects (including Tables, Views, Triggers, Stored Procedures and Functions).
Table Data Editor
- A powerful Table Data Editor allows you to modify your results graphically and save them. By writing a single table SELECT statement in the Query Analyzer and clicking on the Execute Edit button, a separate window is opened with the query results for you to edit and save. You may also browser to a table in the schema browser and select the Edit Table from the popup menu to edit the first 1000 records in a table.
Enhancements:
- Enhancements in this release include OS X Integration, Windows integration, complete and customizable keymapping, a schema difference tool, a directory difference tool, a file difference tool, a tab difference tool, a copy history difference tool, SQL Server DBA tools, and Sybase DBA tools.
- In total, there were over 100 new features.
<<lessAqua Data Studio provides an integrated database environment with a single consistent interface to all major relational databases. This allows the database administrator or developer to tackle multiple tasks simultaneously from one application.
Main features:
Query Analyzer/Window
- Aqua Data Studios sophisticated Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test SQL scripts. Other features to speed up development include SQL automation, auto-describe and sortable multi-grid results. The query analyzer also provides client side variable binding, allowing a user to execute stored procedures or functions with local variables binded to receive out parameters. The query window also provides two modes of operation, using a SplitPane View or a MultiTab View for the editor and the query results.
Schema Browser & Visual Editing
- Its graphical browsing capabilities allow you to understand the structure and dependencies of the database schema with a single mouse click. The schema browser also allows you to visually edit any schema object with a graphical design form to CREATE, ALTER or DROP the object. Visual editing supports Tables, Indexes, Procedures, Data Types and other schema objects. The visual editors also provides an SQL preview of all the commands to be executed to commit the operation.
Schema Extraction & DDL Scripting
- Its graphical browsing allows you to extract the structure definition of all schema objects and to script the SQL DDL and DML (eg CREATE, ALTER, DROP, SELECT, INSERT, UPDATE and DELETE) syntax for database schema objects (including Tables, Views, Triggers, Stored Procedures and Functions).
Table Data Editor
- A powerful Table Data Editor allows you to modify your results graphically and save them. By writing a single table SELECT statement in the Query Analyzer and clicking on the Execute Edit button, a separate window is opened with the query results for you to edit and save. You may also browser to a table in the schema browser and select the Edit Table from the popup menu to edit the first 1000 records in a table.
Enhancements:
- Enhancements in this release include OS X Integration, Windows integration, complete and customizable keymapping, a schema difference tool, a directory difference tool, a file difference tool, a tab difference tool, a copy history difference tool, SQL Server DBA tools, and Sybase DBA tools.
- In total, there were over 100 new features.
Download (53.2MB)
Added: 2007-01-16 License: Free for non-commercial use Price:
859 downloads
Rails 1.1
Rails is a full-stack framework for developing database-backed web applications according to the Model-View-Control pattern. more>>
Rails web framework is a full-stack framework for developing database-backed web applications according to the Model-View-Control pattern.
From the Ajax in the view, to the request and response in the controller, to the domain model wrapping the database, Rails gives you a pure-Ruby development environment. To go live, all you need to add is a database and a web server.
Everyone from startups to non-profits to enterprise organizations are using Rails. Rails is all about infrastructure so its a great fit for practically any type of web application Be it software for collaboration, community, e-commerce, content management, statistics, management, you name it.
Rails works with a wealth of web servers and databases. For web server, we recommend Apache or lighttpd running either FastCGI or SCGI. For database, you can use MySQL, PostgreSQL, SQLite, Oracle, SQL Server, DB2, or Firebird. Just about any operating system will do, but we recommend a nix-based one for deployment.
If you need hosting, TextDrive is the official Ruby on Rails host, offering fantastic plans with a knowledgeable staff. Whether you need shared or dedicated hosting, these guys are experts in Ruby on Rails.
Creating a weblog in 15 minutes
In 15 minutes, we go from scratch to complete weblog engine: with comments and an administrative interface. But since the actual application only took 58 lines to complete, we also have time left over to do unit testing, examine the logs, and play around with the domain model.
Putting Flickr on Rails
Ruby on Rails is not just for playing with your local database, its for taking on the web. So in 5 minutes, we create a web-based search engine for Flickr using their public API with all the fades and glamour of Ajax. Hows that for a low-tech alternative to something fancy like Flash.
Evolving your database schema without a sweat
Before you know it, youll have data that you care about in your application. Which makes adding, removing, or changing the schema an error-prone, time-consuming, and frustrating process. That is, unless youre using Ruby on Rails. In 20 minutes, youll learn all about how database migrations can make your schema as flexible as your code with no fear of data loss.
<<lessFrom the Ajax in the view, to the request and response in the controller, to the domain model wrapping the database, Rails gives you a pure-Ruby development environment. To go live, all you need to add is a database and a web server.
Everyone from startups to non-profits to enterprise organizations are using Rails. Rails is all about infrastructure so its a great fit for practically any type of web application Be it software for collaboration, community, e-commerce, content management, statistics, management, you name it.
Rails works with a wealth of web servers and databases. For web server, we recommend Apache or lighttpd running either FastCGI or SCGI. For database, you can use MySQL, PostgreSQL, SQLite, Oracle, SQL Server, DB2, or Firebird. Just about any operating system will do, but we recommend a nix-based one for deployment.
If you need hosting, TextDrive is the official Ruby on Rails host, offering fantastic plans with a knowledgeable staff. Whether you need shared or dedicated hosting, these guys are experts in Ruby on Rails.
Creating a weblog in 15 minutes
In 15 minutes, we go from scratch to complete weblog engine: with comments and an administrative interface. But since the actual application only took 58 lines to complete, we also have time left over to do unit testing, examine the logs, and play around with the domain model.
Putting Flickr on Rails
Ruby on Rails is not just for playing with your local database, its for taking on the web. So in 5 minutes, we create a web-based search engine for Flickr using their public API with all the fades and glamour of Ajax. Hows that for a low-tech alternative to something fancy like Flash.
Evolving your database schema without a sweat
Before you know it, youll have data that you care about in your application. Which makes adding, removing, or changing the schema an error-prone, time-consuming, and frustrating process. That is, unless youre using Ruby on Rails. In 20 minutes, youll learn all about how database migrations can make your schema as flexible as your code with no fear of data loss.
Download (0.014MB)
Added: 2006-03-28 License: GPL (GNU General Public License) Price:
1306 downloads
SQL::Schema 0.31
SQL::Schema is a Perl module to convert a data dictionary into SQL statements. more>>
SQL::Schema is a Perl module to convert a data dictionary into SQL statements.
SYNOPSIS
use DBI;
my $dbh = DBI->connect(...);
use SQL::Schema;
my $schema = SQL::Schema->new($dbh);
my $sql = $schema->string;
print $sql;
print "$schema";
WARNING
This is alpha software. It currently works with Oracle databases only. The name of the module might be changed in future releases as well as its interface.
If somebody is modifying the datase schema during the life time of an SQL::Schema object, the object will probably fail and / or produce wrong information.
SQL::Schema is a class for objects representing a database schema. The methods of an instanciated object do allow to access the information within a databases data dictionary and to represent them as SQL create statements and the like using the proper SQL dialect.
Constructor
$schema = SQL::Schema->new($dbh);
The new method instanciates a schema object. The only argument required is a database handle, which has to offer the same API as described within DBI(3).
Methods
$sql = $schema->string;
Returns an SQL string containing several statements at once. This string contains all the SQL statements to create the database schema.
This method is overloaded with the string operator. So the following two lines are equivalent:
$sql = $schema->string;
$sql = "$schema";
<<lessSYNOPSIS
use DBI;
my $dbh = DBI->connect(...);
use SQL::Schema;
my $schema = SQL::Schema->new($dbh);
my $sql = $schema->string;
print $sql;
print "$schema";
WARNING
This is alpha software. It currently works with Oracle databases only. The name of the module might be changed in future releases as well as its interface.
If somebody is modifying the datase schema during the life time of an SQL::Schema object, the object will probably fail and / or produce wrong information.
SQL::Schema is a class for objects representing a database schema. The methods of an instanciated object do allow to access the information within a databases data dictionary and to represent them as SQL create statements and the like using the proper SQL dialect.
Constructor
$schema = SQL::Schema->new($dbh);
The new method instanciates a schema object. The only argument required is a database handle, which has to offer the same API as described within DBI(3).
Methods
$sql = $schema->string;
Returns an SQL string containing several statements at once. This string contains all the SQL statements to create the database schema.
This method is overloaded with the string operator. So the following two lines are equivalent:
$sql = $schema->string;
$sql = "$schema";
Download (0.033MB)
Added: 2007-04-05 License: Perl Artistic License Price:
933 downloads
Audio::DB::Adaptor::dbi::sqlite 0.01
Audio::DB::Adaptor::dbi::sqlite is a database adaptor for a specific mysql schema. more>>
Audio::DB::Adaptor::dbi::sqlite is a database adaptor for a specific mysql schema.
This adaptor implements a specific mysql database schema that is compatible with Audio::DB. It inherits from Audio::DB. In addition to implementing the abstract SQL-generating methods of Audio::DB::Adaptor::dbi, this module also implements the data loading functionality of Audio::DB.
The schema uses several tables:
artists This the artists data table. Its columns are:
artist_id artist ID (integer); primary key artist artist name (string); may be null; indexed
albums This is the albums table. Its columns are:
album_id album ID (integer); primary key
album album name (string); may be null; indexed
album_type one of compilation or standard; may be null
total_tracks total songs on album (integer)
year self explanatory, no? (integer)
songs This is the primary songs table. Its columns are:
song_id song ID (integer); primary key
title song title (string)
artist_id artist ID (integer); indexed
album_id album ID (integer)
genre_id genre ID (integer) # may be superceded...see note
track track number (integer)
duration formatted song length (string)
seconds length in seconds (integer)
lyrics song lyrics (long text)
comment ID3 tag comment (text)
bitrate encoded bitrate (integer)
samplerate sample rate (real)
format format of the file (ie MPEG) (string)
channels channels (string)
tag_types type of ID3 tags present (ie ID3v2.3.0) (text)
filename file name (text)
filesize file size in bytes (real)
filepath absolute path (text)
year the year tag for single tracks
(since singles or songs on compilations
each may be different) (integer)
uber_playcount total times the song has been played
uber_rating overall song rating (see "users" below)
Currently, ID3 tags support but a single genre. The genre_id is now stored with the song table. Multiple genres may be assigned via the song_genres join table below. The year is a database denormalization that allows the assignment of years to single tracks not belonging to an album.
<<lessThis adaptor implements a specific mysql database schema that is compatible with Audio::DB. It inherits from Audio::DB. In addition to implementing the abstract SQL-generating methods of Audio::DB::Adaptor::dbi, this module also implements the data loading functionality of Audio::DB.
The schema uses several tables:
artists This the artists data table. Its columns are:
artist_id artist ID (integer); primary key artist artist name (string); may be null; indexed
albums This is the albums table. Its columns are:
album_id album ID (integer); primary key
album album name (string); may be null; indexed
album_type one of compilation or standard; may be null
total_tracks total songs on album (integer)
year self explanatory, no? (integer)
songs This is the primary songs table. Its columns are:
song_id song ID (integer); primary key
title song title (string)
artist_id artist ID (integer); indexed
album_id album ID (integer)
genre_id genre ID (integer) # may be superceded...see note
track track number (integer)
duration formatted song length (string)
seconds length in seconds (integer)
lyrics song lyrics (long text)
comment ID3 tag comment (text)
bitrate encoded bitrate (integer)
samplerate sample rate (real)
format format of the file (ie MPEG) (string)
channels channels (string)
tag_types type of ID3 tags present (ie ID3v2.3.0) (text)
filename file name (text)
filesize file size in bytes (real)
filepath absolute path (text)
year the year tag for single tracks
(since singles or songs on compilations
each may be different) (integer)
uber_playcount total times the song has been played
uber_rating overall song rating (see "users" below)
Currently, ID3 tags support but a single genre. The genre_id is now stored with the song table. Multiple genres may be assigned via the song_genres join table below. The year is a database denormalization that allows the assignment of years to single tracks not belonging to an album.
Download (0.061MB)
Added: 2006-10-11 License: Perl Artistic License Price:
1109 downloads
Databrid 1.3
Databrid is a powerful tool that provides easy access to data and manipulation of data within an Oracle or MySql database. more>>
Databrid is a browsing, retrieval and manipulation tool designed for the novice to the expert user. Databrid works on MySql and Oracle Database (versions 8 and above although not all functionality in the Browser is available for the lower versions). The core functionality of Databrid revolves around the tabbed areas within the Databrid application. The four main tabs in the main screen of Databrid are: SQL Editor, Browser, File and Jobs.
## SQL EDITOR ##
The SQL Editor tab allows you to write and run SQL and PLSQL. The tab provides the ability to use one of more sql autocompletion, word and syntax highlighting editors with automatic case adjustment for keywords. Provided with each editor is a table for displaying SQL query results and a text output area to display DBMS_Output output. Jobs can be run in the background allowing for the execution of multiple statements at any given time.
## BROWSER ##
The Browser tab allows the you to browse various parts of the database schema. The browsing is done via a particular schema user and displays information on tables, views, sequences etc. Features include the generation of database creation statements for tables, views etc, browsing table or view data, truncating tables, etc.
## FILE ##
The File tab allows you work with a CSV (comma delimited text file) and the database without having to load the CSV into the database. This tab has two areas that functionality: CSV Update and Database Update. CSV Update allows you to add additional columns to a CSV using a Select statement, including binding CSV column values to the Select statement. Database Update allows you to update the database using insert, updates, deletes or PLSql by binding the CSV column values into your statement.
## JOBS ##
This tab allows you to view which jobs are currently running or have finished. Jobs that are running can also be stopped.
<<less## SQL EDITOR ##
The SQL Editor tab allows you to write and run SQL and PLSQL. The tab provides the ability to use one of more sql autocompletion, word and syntax highlighting editors with automatic case adjustment for keywords. Provided with each editor is a table for displaying SQL query results and a text output area to display DBMS_Output output. Jobs can be run in the background allowing for the execution of multiple statements at any given time.
## BROWSER ##
The Browser tab allows the you to browse various parts of the database schema. The browsing is done via a particular schema user and displays information on tables, views, sequences etc. Features include the generation of database creation statements for tables, views etc, browsing table or view data, truncating tables, etc.
## FILE ##
The File tab allows you work with a CSV (comma delimited text file) and the database without having to load the CSV into the database. This tab has two areas that functionality: CSV Update and Database Update. CSV Update allows you to add additional columns to a CSV using a Select statement, including binding CSV column values to the Select statement. Database Update allows you to update the database using insert, updates, deletes or PLSql by binding the CSV column values into your statement.
## JOBS ##
This tab allows you to view which jobs are currently running or have finished. Jobs that are running can also be stopped.
Download (3.0MB)
Added: 2007-07-25 License: Freeware Price:
844 downloads
GEBORA Beta5
GEBORA is an administrative tool for the Oracle Relational Database Management System. more>>
GEBORA is an administrative tool for the Oracle Relational Database Management System. GEBORA project is an OpenSource alternative to TOAD.
Since beta-2, GEBORA uses native look-and-feel. This approach looks faster in Windows when huge tables are filled (something about 2000 or more rows).
Main features:
- Send manually created SQL commands to server, showing the results in a table;
- Browse thru all database schemas (users) and its tables and packages;
- Display tables:
- Data (with filter, ordering and printing);
- Columns (can be printed, too);
- Relations (foreign keys) in both directions (referenced tables and tables that references a table);
- Statistics (with unique profile generation and print);
- Creation script (without constraints);
- Display stored procedures source code and parameters;
- Run stored procedures, defining and viewing IN/OUT parameters.
<<lessSince beta-2, GEBORA uses native look-and-feel. This approach looks faster in Windows when huge tables are filled (something about 2000 or more rows).
Main features:
- Send manually created SQL commands to server, showing the results in a table;
- Browse thru all database schemas (users) and its tables and packages;
- Display tables:
- Data (with filter, ordering and printing);
- Columns (can be printed, too);
- Relations (foreign keys) in both directions (referenced tables and tables that references a table);
- Statistics (with unique profile generation and print);
- Creation script (without constraints);
- Display stored procedures source code and parameters;
- Run stored procedures, defining and viewing IN/OUT parameters.
Download (0.79MB)
Added: 2006-10-17 License: GPL (GNU General Public License) Price:
1102 downloads
XML::Compile::Schema 0.05
XML::Compile::Schema is a Perl module to compile a schema. more>>
XML::Compile::Schema is a Perl module to compile a schema.
INHERITANCE
XML::Compile::Schema
is a XML::Compile
SYNOPSIS
# preparation
my $parser = XML::LibXML->new;
my $tree = $parser->parse...(...);
my $schema = XML::Compile::Schema->new($tree);
my $schema = XML::Compile::Schema->new($xml_string);
my $read = $schema->compile(READER => mytype);
my $hash = $read->($xml);
my $doc = XML::LibXML::Document->new(1.0, UTF-8);
my $write = $schema->compile(WRITER => mytype);
my $xml = $write->($doc, $hash);
print $xml->toString;
This module collects knowledge about a schema. The most important method is compile() which can create XML file readers and writers based on the schema information and some selected type.
WARNING: The compiler is implemented in XML::Compile::Schema::Translate, which is NOT FINISHED. See that manual page about the specific behavior and its (current) limitations! Please help to find missing pieces and mistakes.
WARNING: the provided schema is not validated! In some cases, compile-time and run-time errors will be reported, but typically only in cases that the parser has no idea what to do with such a mistake. On the other hand, the processed data is validated: the output should follow the specs closely.
Two implementations use the translator, and more can be added later. Both get created with the compile() method.
XML Reader
The XML reader produces a hash from a XML::LibXML::Node tree, or an XML string. The values are checked and will be ignored if the value is not according to the specs.
XML Writer
The writer produces schema compliant XML, based on a hash. To get the data encoding correct, you are required to pass a document in which the XML nodes may get a place later.
<<lessINHERITANCE
XML::Compile::Schema
is a XML::Compile
SYNOPSIS
# preparation
my $parser = XML::LibXML->new;
my $tree = $parser->parse...(...);
my $schema = XML::Compile::Schema->new($tree);
my $schema = XML::Compile::Schema->new($xml_string);
my $read = $schema->compile(READER => mytype);
my $hash = $read->($xml);
my $doc = XML::LibXML::Document->new(1.0, UTF-8);
my $write = $schema->compile(WRITER => mytype);
my $xml = $write->($doc, $hash);
print $xml->toString;
This module collects knowledge about a schema. The most important method is compile() which can create XML file readers and writers based on the schema information and some selected type.
WARNING: The compiler is implemented in XML::Compile::Schema::Translate, which is NOT FINISHED. See that manual page about the specific behavior and its (current) limitations! Please help to find missing pieces and mistakes.
WARNING: the provided schema is not validated! In some cases, compile-time and run-time errors will be reported, but typically only in cases that the parser has no idea what to do with such a mistake. On the other hand, the processed data is validated: the output should follow the specs closely.
Two implementations use the translator, and more can be added later. Both get created with the compile() method.
XML Reader
The XML reader produces a hash from a XML::LibXML::Node tree, or an XML string. The values are checked and will be ignored if the value is not according to the specs.
XML Writer
The writer produces schema compliant XML, based on a hash. To get the data encoding correct, you are required to pass a document in which the XML nodes may get a place later.
Download (0.049MB)
Added: 2006-09-13 License: Perl Artistic License Price:
1136 downloads
PHPortal 0.2.7 beta
PHPortal is an extensible content management framework with object reuse. more>>
PHPortal is a PHP application development environment similar to Zope. It is a pipeline or tunnel application that can help you quickly create dynamic Web applications such as portal and intranet sites. It comes with membership, search, news, and more.
Its easy-to-use tools allow teams to productively and safely work together. It provides access to databases and other legacy data. Its support for Web standards such as SMTP, POP, FTP, and XML-RPC allows you flexibility and interoperability.
It consists of a number of components which work together to provide a complete, yet flexible, application server package. It includes an XML-RPC server, an object-oriented database schema, a search engine, a database virtual file mapping system, a Web page templating system, a Web-based development and management tool, and comprehensive extension support.
<<lessIts easy-to-use tools allow teams to productively and safely work together. It provides access to databases and other legacy data. Its support for Web standards such as SMTP, POP, FTP, and XML-RPC allows you flexibility and interoperability.
It consists of a number of components which work together to provide a complete, yet flexible, application server package. It includes an XML-RPC server, an object-oriented database schema, a search engine, a database virtual file mapping system, a Web page templating system, a Web-based development and management tool, and comprehensive extension support.
Download (1.0MB)
Added: 2005-05-05 License: ZPL (Zope Public License) Price:
1632 downloads
Jifty::DBI::SchemaGenerator 0.29
Jifty::DBI::SchemaGenerator is a Perl module to generate table schemas from Jifty::DBI records. more>>
Jifty::DBI::SchemaGenerator is a Perl module to generate table schemas from Jifty::DBI records.
This module turns a Jifty::Record object into an SQL schema for your chosen database. At the moment, your choices are MySQL, SQLite, or PostgreSQL. Oracle might also work right, though its untested.
SYNOPSIS
The Short Answer
See below for where we get the $handle and $model variables.
use Jifty::DBI::SchemaGenerator;
...
my $s_gen = Jifty::DBI::SchemaGenerator->new( $handle );
$s_gen->add_model($model);
my @statements = $s_gen->create_table_sql_statements;
print join("n", @statements, );
...
The Long Version
See Jifty::DBI for details about the first two parts.
MyModel
package MyModel;
# lib/MyModel.pm
use warnings;
use strict;
use base qw(Jifty::DBI::Record);
# your custom code goes here.
1;
MyModel::Schema
package MyModel::Schema;
# lib/MyModel/Schema.pm
use warnings;
use strict;
use Jifty::DBI::Schema;
column foo => type is text;
column bar => type is text;
1;
myscript.pl
#!/usr/bin/env perl
# myscript.pl
use strict;
use warnings;
use Jifty::DBI::SchemaGenerator;
use Jifty::DBI::Handle;
use MyModel;
use MyModel::Schema;
my $handle = Jifty::DBI::Handle->new();
$handle->connect(
driver => SQLite,
database => testdb,
);
my $model = MyModel->new($handle);
my $s_gen = Jifty::DBI::SchemaGenerator->new( $handle );
$s_gen->add_model($model);
# heres the basic point of this module:
my @statements = $s_gen->create_table_sql_statements;
print join("n", @statements, );
# this part is directly from Jifty::Script::Schema::create_all_tables()
$handle->begin_transaction;
for my $statement (@statements) {
my $ret = $handle->simple_query($statement);
$ret or die "error creating a table: " . $ret->error_message;
}
$handle->commit;
<<lessThis module turns a Jifty::Record object into an SQL schema for your chosen database. At the moment, your choices are MySQL, SQLite, or PostgreSQL. Oracle might also work right, though its untested.
SYNOPSIS
The Short Answer
See below for where we get the $handle and $model variables.
use Jifty::DBI::SchemaGenerator;
...
my $s_gen = Jifty::DBI::SchemaGenerator->new( $handle );
$s_gen->add_model($model);
my @statements = $s_gen->create_table_sql_statements;
print join("n", @statements, );
...
The Long Version
See Jifty::DBI for details about the first two parts.
MyModel
package MyModel;
# lib/MyModel.pm
use warnings;
use strict;
use base qw(Jifty::DBI::Record);
# your custom code goes here.
1;
MyModel::Schema
package MyModel::Schema;
# lib/MyModel/Schema.pm
use warnings;
use strict;
use Jifty::DBI::Schema;
column foo => type is text;
column bar => type is text;
1;
myscript.pl
#!/usr/bin/env perl
# myscript.pl
use strict;
use warnings;
use Jifty::DBI::SchemaGenerator;
use Jifty::DBI::Handle;
use MyModel;
use MyModel::Schema;
my $handle = Jifty::DBI::Handle->new();
$handle->connect(
driver => SQLite,
database => testdb,
);
my $model = MyModel->new($handle);
my $s_gen = Jifty::DBI::SchemaGenerator->new( $handle );
$s_gen->add_model($model);
# heres the basic point of this module:
my @statements = $s_gen->create_table_sql_statements;
print join("n", @statements, );
# this part is directly from Jifty::Script::Schema::create_all_tables()
$handle->begin_transaction;
for my $statement (@statements) {
my $ret = $handle->simple_query($statement);
$ret or die "error creating a table: " . $ret->error_message;
}
$handle->commit;
Download (0.097MB)
Added: 2007-01-17 License: Perl Artistic License Price:
1010 downloads
aSVERD Beta 2
aSVERD project is a Scalable Vector Graphics Entity Relationship Diagram generator. more>>
aSVERD project is a Scalable Vector Graphics Entity Relationship Diagram generator. It is a tool that should be seen as part of a tool chain rather than a complete solution. What it does is read tables and relationships from a database and generate an SVG file containing the tables and links.
The motivation for creating this was than I have worked in many organisations that have databases with no ERDs and no tools for creating them. I finally got so fed up that I decided to do something about it and this is the result.
The way it is intended to work is that you point SVERD at your database and it creates an SVG file containing all tables and links between them. It DOES NOT attempt to create a fancy layout. it just puts the tables on the diagram in a grid. This can be viewed in a web browser (may need an SVG plug-in). You then use an SVG editor, such as GLIPSGraffiti to lay ou the tables. If you re-run SVERD on an exisitng output file it will not move the tables, therefore the diagram can be updated with out loosing your edits.
NOTE: the links between the tables are rendered using JavaScript, so that if you move the tables around in an editor, the links stay with them. The disadvantage of this is that the editor may not show the links while you are editing (this is the case with GLIPS).
If the table references are not defined in the database they can be supplied in a text file.
Usage
java -jar asverd.jar PropertiesFile
Or
java -jar asverd.jar -d driver -c connectionString -u user -p password [-o outputFile] [-q tableQuery] [-s schema] [-c catalog] [-r refs.txt]
e.g. sverd.TableLister -d com.mysql.jdbc.Driver -c jdbc:mysql://168.0.0.200:3306/DataBase1 -u fred -p secret
The properties file should contain
sverd.driver=databaseDriver
sverd.url=connectionString
sverd.user=username
sverd.password=password
sverd.outputFile=outputFile (optional - STDOUT used if not present)
sverd.tableQuery=query for table name - e.g. INV% (optional - all tables returned if not present)
sverd.schema=database schema (optional - leave out for DBs that do not use)
sverd.catalog=database catalog (optional - leave out for DBs that do not use)
sverd.references=refs.txt (optional - a file containing referecnes if these are not defined in the database. This file should be of the format TABLE [tablename] [foriegnKeyColName] REFERENCES [tablename] [primaryKeyColName] - I know flat text files are not trendy but this format is relatively easy to generate from either XML or SQL (via AWK, SED, PERL, etc)
Enhancements:
- This release fixes bugs with using the SVG in FireFox and adds JavaScript based zooming (click an entity to zoom). The jar contains source and class files
<<lessThe motivation for creating this was than I have worked in many organisations that have databases with no ERDs and no tools for creating them. I finally got so fed up that I decided to do something about it and this is the result.
The way it is intended to work is that you point SVERD at your database and it creates an SVG file containing all tables and links between them. It DOES NOT attempt to create a fancy layout. it just puts the tables on the diagram in a grid. This can be viewed in a web browser (may need an SVG plug-in). You then use an SVG editor, such as GLIPSGraffiti to lay ou the tables. If you re-run SVERD on an exisitng output file it will not move the tables, therefore the diagram can be updated with out loosing your edits.
NOTE: the links between the tables are rendered using JavaScript, so that if you move the tables around in an editor, the links stay with them. The disadvantage of this is that the editor may not show the links while you are editing (this is the case with GLIPS).
If the table references are not defined in the database they can be supplied in a text file.
Usage
java -jar asverd.jar PropertiesFile
Or
java -jar asverd.jar -d driver -c connectionString -u user -p password [-o outputFile] [-q tableQuery] [-s schema] [-c catalog] [-r refs.txt]
e.g. sverd.TableLister -d com.mysql.jdbc.Driver -c jdbc:mysql://168.0.0.200:3306/DataBase1 -u fred -p secret
The properties file should contain
sverd.driver=databaseDriver
sverd.url=connectionString
sverd.user=username
sverd.password=password
sverd.outputFile=outputFile (optional - STDOUT used if not present)
sverd.tableQuery=query for table name - e.g. INV% (optional - all tables returned if not present)
sverd.schema=database schema (optional - leave out for DBs that do not use)
sverd.catalog=database catalog (optional - leave out for DBs that do not use)
sverd.references=refs.txt (optional - a file containing referecnes if these are not defined in the database. This file should be of the format TABLE [tablename] [foriegnKeyColName] REFERENCES [tablename] [primaryKeyColName] - I know flat text files are not trendy but this format is relatively easy to generate from either XML or SQL (via AWK, SED, PERL, etc)
Enhancements:
- This release fixes bugs with using the SVG in FireFox and adds JavaScript based zooming (click an entity to zoom). The jar contains source and class files
Download (0.024MB)
Added: 2007-01-19 License: GPL (GNU General Public License) Price:
1009 downloads
Secleted [ 0 ] software to compare
Copyright Notice:
Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators is illegal and prevent future software development. The above graphical database schema search only lists software in full, demo and trial versions for free download. Download links are directly from our mirror sites or publisher sites, torrent files or links from rapidshare.com, yousendit.com or megaupload.com are not allowed
