30 December 2006

Graphical administration tool for Oracle. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
DBA Companion 1.5 is a graphical administration tool for Oracle databases. It features browsing the data dictionary, drilling down from one information to related ones, generation of SQL scripts based on data dictionary information, and customisation of all the SQL used by the tool."

19 December 2006

Java-based tool for browsing virtually any database. Freeware

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
DataBrowser 3.4.2 is a Java-based tool for browsing virtually any database. It has been tested with Oracle, SQL Server, PostgreSQL/Postgres, MySQL, DB2, and MS Access (among some others). It requires a Java 2 runtime environment. The DataBrowser allows you to execute dynamic SQL, import and export data, view the schema in a treeview, and view query results in a table view."

Java-based tool that analyzes the metadata of a schema in a database. LGPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
SchemaSpy 3.1.1 is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships. Browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints."

15 December 2006

Sqlmap. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
sqlmap: a blind SQL injection tool 0.2 is an automatic blind SQL injection tool capable of enumerating an entire remote database, performing an active database fingerprint, and much more. The aim of this project is to implement a fully functional database mapper tool that takes advantages of Web application programming security flaws that lead to SQL injection vulnerabilities."
Understanding SQL Server's sysobjects table
Arthur Fuller explains why knowledge of the SQL Server sysobjects table can come in handy in certain situations. He also offers details about the two columns that will be most useful to you: sysobjects.name and sysobjects.xtype.

MySQLPHPGrid 0.6.3 puts data from a MySQL table into a grid on a Web page. LGPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
MySQLPHPGrid 0.6.3 puts data from a MySQL table into a grid on a Web page. The grid supports sorting of columns, editing of cells, adding rows, deleting rows, and pagination. It can display a full MySQL table or just a subset of a table."

08 December 2006

Tool to output your database schema. LGPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
SchemaCrawler 4.1 is a platform (OS and database) independent command line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema. SchemaCrawler is also an API that improves on standard JDBC metadata."

Persistent database generator for high performance C applications. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
DataDraw 3.0.0 is a feature rich persistent database generator for high performance C applications. It is based on 15 years of experience supporting over 1 million lines of high performance code."

05 December 2006

Why most database designers don't go beyond the Third normal form

Why most database designers don't go beyond the Third normal form
Normalization: How far is far enough? Normalization is one of the commandments of IT database pros, whether you are a data modeler, DBA, or SQL developer. Arthur Fuller defines each normal form and explores why most database designers don't go beyond the Third normal form.
Enable Change Tracking in Oracle for faster incremental backups
DBAs can do incremental backups made via Recovery Manager significantly faster by enabling a new Oracle 10g feature called Change Tracking. Bob Watkins explains how to enable the feature.
Normalization: How far is far enough?
Normalization is one of the commandments of IT database pros, whether you are a data modeler, DBA, or SQL developer. Arthur Fuller defines each normal form and explores why most database designers don't go beyond the Third normal form.

04 December 2006

Java-based tool for browsing virtually any database. Freeware

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
DataBrowser 3.4.0 is a Java-based tool for browsing virtually any database. It has been tested with Oracle, SQL Server, PostgreSQL/Postgres, MySQL, DB2, and MS Access (among some others). It requires a Java 2 runtime environment. The DataBrowser allows you to execute dynamic SQL, import and export data, view the schema in a treeview, and view query results in a table view."

02 December 2006

Front-end to the Oracle command-line utility sqlplus for Unix. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
gqlplus 1.12 is a front-end to the Oracle command-line utility sqlplus for Unix. It is functionally nearly identical to sqlplus, with the addition of command-line editing and history similar to tcsh and bash, as well as table name and column name completion."

27 November 2006

Replacement for sqlplus. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
PySQL 0.2 aim to be a full replacement for sqlplus (and much more). It has features such as history, completion, and line editing. It has high level functions (searching for tables, indexes, count, explain plan, list of sessions, etc.), proper output for screen and files (CSV ready for inclusion in spreadsheets), and user-defined SQL."

25 November 2006

Backups of a MySQL server's data files. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
mylvmbackup 0.3 (Default branch)
mylvmbackup is a Perl script for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations while the actual file backup proceeds."

22 November 2006

PHP report generator. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
phpreports 0.4.9 is a PHP report generator that uses XML report layout files to generate PHP code and create reports in output formats like HTML and TXT."

Backup and recovery solution for MySQL. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
Zmanda Recovery Manager for MySQL 1.1.2 for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL, you can schedule full and incremental logical or raw backups of your local or remote MySQL database, perform a backup that is the best match for your storage engine and your MySQL configuration, get encrypted and compressed backups, get email notification about the status of your backups (including RSS feeds), monitor and get backup reports, and recover a database easily to any point in time or to any particular transaction."

21 November 2006

Database normalization tips

Get practical database normalization tips
Normalization is a series of steps to guide you through analyzing and designing relations in your database schema. Tim Chapman explains why he thinks a database in the third normal form is sometimes not very practical and why he prefers a hybrid approach to table normalization.

16 November 2006

Perl script for quickly creating backups of a MySQL server's data files. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
mylvmbackup 0.2 (Default branch)
mylvmbackup is a Perl script for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations while the actual file backup proceeds."

08 November 2006

Run and edit complex reports from any SQL relational database. Freeware

Search for: free programs, free software, freeware, programs gratis.: "
Ariacom Business Reports v4.2a is a database reporting and analysis tool with dynamic SQL generation, that enables non-technical users to run and edit complex reports from any SQL relational database."

07 November 2006

02 November 2006

GTK+ 2 interface to Oracle that aids in Oracle application development. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "GTKO 1.72 (Default branch) is a GTK+ 2 interface to Oracle that aids in Oracle application development and testing. Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting. For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository in Oracle version 10g, and full AWR reports."

31 October 2006

30 October 2006

MySQL 5.0.27

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
MySQL 5.0.27 (Production (5.0.x) branch)
MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries."

Set of C++ libraries for rapid development of database applications. LGPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
hk_classes 0.8.2 (Default branch)
hk_classes is a set of C++ libraries for rapid development of database applications with all features a modern database application should have, like forms and reports. hk_classes is database and GUI independent. It also includes command line tools to use hk_classes in scripts. hk_classes includes drivers for DBase, Firebird, MS Access, MySQL, Paradox, PostgreSQL, ODBC, and SQL"

Monitoring utility for Microsoft SQL Server. Freeware

Search for: free programs, free software, freeware, programs gratis.: "
SQL Spy v5.0.6
SQL Spy is a real-time monitoring utility for Microsoft SQL Server. It allows you to view incoming SQL queries, external connections and locks, CPU usage (graph) as well as cache statistics"

27 October 2006

25 October 2006

Web interface for a database . GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
DaDaBIK 4.1 beta (Default branch)
DaDaBIK is a PHP application that allows you to easily create a highly customizable Web interface for a database in order to search, insert, update, and delete records; all you need do is specify a few configuration parameters. MySQL, PostgreSQL, Oracle, and MS SQL Server are supported. It is available in several languages."

21 October 2006

Convert MySQL databases to RSS feeds

Advanced search for RSS feeds. Complex filtering: "
SQL2RSS Script Converts Databases to RSS Feeds
NotePage has released SQL2RSS, a new PHP script that allows users to convert MySQL databases to RSS feeds. RSS is a format for syndicating information on the Internet. This new SQL2RSS script..."

20 October 2006

Set of scripts and programs that provide a high availability database cluster using MySQL replication. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
MySQL High Availability clustering alpha-6.2-1 (Default branch)
MySQL High Availability clustering is a set of scripts and programs that provide a high availability database cluster using MySQL replication. It is transparent to client applications, as the cluster uses a shared logical IP to provide the service."

19 October 2006

Recovery Manager (ZRM) for MySQL. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
Zmanda Recovery Manager for MySQL 1.1 (Default branch)
Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL, you can schedule full and incremental logical or raw backups of your local or remote MySQL database, perform a backup that is the best match for your storage engine and your MySQL configuration, get encrypted and compressed backups, get email notification about the status of your backups (including RSS feeds), monitor and get backup reports, and recover a database easily to any point in time or to any particular transaction."

17 October 2006

Free, graphical interface for management of MySQL

Search for: free programs, free software, freeware, programs gratis.: "
HeidiSQL
HeidiSQL is a graphical interface for easy management of your MySQL server and databases. It allows you to browse your databases, manage tables, view and edit records, manage user-privileges and more...."

16 October 2006

API for software developers to different database management systems. LGPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
OpenDBX 1.1.7 (Development branch)
The OpenDBX library provides a unified and consistent API for software developers to different database management systems. The function library is written in the C programming language and aims at implementing access to the native database interfaces efficiently via a thin abstraction layer. It consists of a basic set of functions that are part of all vendor database libraries and can be extended by additional function blocks. Currently, Firebird/Interbase, MS SQL Server, MySQL, Oracle PostgreSQL, SQLite 2 and 3, and Sybase ASE are supported."

15 October 2006

Free DbVisualizer

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
DbVisualizer 5.1 (Default branch)
DbVisualizer is a feature rich and intuitive cross platform database tool for developers and DBAs that provides a single, powerful interface for a variety of databases. It supports simultaneous database connection and lets you explore and manage database objects, execute SQL queries, visualize information, and a lot more."

13 October 2006

NG-Admin specializes in editing the content of Web sites. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
NG-Admin 1.2 (Default branch)
NG-Admin is designed for the content management of databases. It allows the user to browse, add, edit, and delete data. It is somewhat similar to phpMyAdmin, but it specializes in editing the content of Web sites, not database structure. Its features are very easy to use and highly tunable."

11 October 2006

Free tool for developing management and database applications

New Releases of Computer Software, Games, Tools and Utilities at Simtel.net: "
Velneo vDevelop 6.4
Velneo vDevelop is a programming tool for developing management and database applications in a completely visual way in 32 bits multitask environments, developed initially for Windows. It uses the market's standards. Great VB/.Net alternative."

10 October 2006

Filesystem engine for MySQL. Work with your files using SQL queries. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
RitmarkFS 0.3.4 (Default branch)
Ritmark FS Engine is a filesystem engine for MySQL. Using it, you can work with your files using SQL queries. It provides replication and directory changes tracking."

09 October 2006

API for software developers to different database management systems. LGPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "OpenDBX 1.0.3 (Stable branch)
The OpenDBX library provides a unified and consistent API for software developers to different database management systems. The function library is written in the C programming language and aims at implementing access to the native database interfaces efficiently via a thin abstraction layer. It consists of a basic set of functions that are part of all vendor database libraries and can be extended by additional function blocks. Currently, Firebird/Interbase, MS SQL Server, MySQL, Oracle PostgreSQL, SQLite 2 and 3, and Sybase ASE are supported."

06 October 2006

Creating database schemas and inserting, querying, and processing data. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
Kexi 1.1 RC1 (Development branch)
Kexi is an integrated environment for managing data. It helps with creating database schemas and inserting, querying, and processing data. It integrates smoothly into KDE and KOffice, and is designed to compete with Microsoft Access. It is supported under Linux and MS Windows."

05 October 2006

Java-based tool that analyzes the metadata of a schema in a database. LGPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
SchemaSpy 3.1.0 (Default branch)
SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships. Browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints."

04 October 2006

XML/Java Framework for rapidly and easily developing J2EE business applications. LGPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
OpenXava 2.0.3 (Default branch)
OpenXava is an XML/Java Framework for rapidly and easily developing J2EE business applications. It is based on business components defined with XML. It is feature rich and flexible, since it has been used for years to create real business applications."

PHP/MySQL report generator. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
PM Report 3.5 (Default branch)
PM Report is a PHP/MySQL report generator. It creates customizable reports and is very simple to setup and use. You can select which database, table, and individual fields to use on your report. You can also select the order in which the fields should appear on the report, the field you would like to group by, the field you would like to sort by, and whether or not you would like a total for each column. Once the report has been generated, you can highlight individual rows and export the results to CSV."

Web interface for a databases: MySQL, PostgreSQL, Oracle, and MS SQL Server. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
DaDaBIK 4.0 (Default branch)
DaDaBIK is a PHP application that allows you to easily create a highly customizable Web interface for a database in order to search, insert, update, and delete records; all you need do is specify a few configuration parameters. MySQL, PostgreSQL, Oracle, and MS SQL Server are supported. It is available in several languages."

Password Recovery is a free toolkit for MS Access databases

New Releases of Computer Software, Games, Tools and Utilities at Simtel.net: "
Password Recovery for MS Access 1.0
Password Recovery is a free toolkit for MS Access databases from 95, 97, 2000, XP, 2002, to 2003. This program should work on any platform that supports Java."

29 September 2006

Skin that sits on top of MySQL, making it accessible to every-day users. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
Dataface 0.6.9 (Default branch)
Dataface is a flexible and shapable skin that sits on top of MySQL, making it accessible to every-day users. It automatically generates the appropriate forms, lists, and menus for a user to interact with the database without having to know any SQL. It is a full-featured Web application framework, and gives developers the flexibility to customize the features and behavior of their application via configuration files (using the simple INI-file syntax), templates, and plug-ins. A generic application with no customizations is completely functional, but the developer is free to customize things at his leisure."

28 September 2006

Web-based application for keeping track of stocks. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
Advance Stock Tracker 0.2.2 (Default branch)
Advanced Stock Tracking System (AST) is a Web-based application for keeping track of stocks. It features a portfolio with dividend tracking, a worksheet to keep track of prospects, a stock comparison utility, and a search engine for the stock market based heavily on technical analysis."

Database development framework for rapidly creating applications. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
building object network databases 2.3.4 (Default branch)
BOND (building object network databases) is database development framework for rapidly creating applications. It creates live forms for the Web with AJAX and desktop applications using GTK. Using XML to define widget layouts, it drives the live forms to which SQL statements and methods can be attached."

Database development framework. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
building object network databases 2.3.4 (Default branch)
BOND (building object network databases) is database development framework for rapidly creating applications. It creates live forms for the Web with AJAX and desktop applications using GTK. Using XML to define widget layouts, it drives the live forms to which SQL statements and methods can be attached."

27 September 2006

Advanced search for RSS feeds. Complex filtering

Advanced search for RSS feeds. Complex filtering: "
Developing T-SQL Stored Procedures to Deal with Lookup Tables
In this article I shall go through a set of Transact-SQL stored procedures which are very frequently used for CRUD operations on lookup tables. My upcoming articles will deal with DAL Data Access Layers in .NET based on these stored ..."

Optimize database code to boost performance

Optimize database code to boost performance
Tony Patton offers .NET developers a few guidelines for developing efficient database code. For instance, he explains when to use the WHERE clause and reveals what code to avoid.
Using Oracle's COALESCE function as a quick CASE statement
In this Oracle tip, Bob Watkins explains how you can use the COALESCE function in lieu of the more wordy CASE statement when testing for null results in multiple expressions.

23 September 2006

Backup and recovery solution for MySQL server. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "Zmanda Recovery Manager for MySQL 1.0.3 (Default branch)
Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL, you can schedule full and incremental logical or raw backups of your MySQL database, perform a backup that is the best match for your storage engine and your MySQL configuration, get email notification about the status of your backups, monitor and browse your backups, and recover a database easily to any point in time or to any particular transaction"

21 September 2006

enhanced version of SAP DB, SAP AG's open source database. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
MaxDB by MySQL 7.6.00.34 (7.6.00.x branch)
MaxDB is a re-branded and enhanced version of SAP DB, SAP AG's open source database. It is a heavy-duty, SAP-certified open source database that offers high availability, scalability and a comprehensive feature set. MaxDB complements the MySQL database server, targeted for large mySAP ERP environments and other applications that require maximum enterprise-level database functionality. It is available for a wide range of platforms, including Linux on several different architectures and Windows."

20 September 2006

GTK+ 2 interface to Oracle that aids in Oracle application development and testing. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
GTKO 1.52 (Default branch)
GsqlR2 is a GTK+ 2 interface to Oracle that aids in Oracle application development and testing. Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting. For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository in Oracle version 10g, and full AWR reports."

15 September 2006

Backup and recovery solution for MySQL server. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
Zmanda Recovery Manager for MySQL 1.0.2 (Default branch)
Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL, you can schedule full and incremental logical or raw backups of your MySQL database, perform a backup that is the best match for your storage engine and your MySQL configuration, get email notification about the status of your backups, monitor and browse your backups, and recover a database easily to any point in time or to any particular transaction."

14 September 2006

Database development framework. Forms for the Web with AJAX. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
building object network databases 2.3.3 (Default branch)
BOND (building object network databases) is database development framework for rapidly creating applications. It creates live forms for the Web with AJAX and desktop applications using GTK. Using XML to define widget layouts, it drives the live forms to which SQL statements and methods can be attached."

13 September 2006

JSP code generator. GPL

Bezpłatne programy, darmowe, za darmo, gratis - wyszukiwanie i nowości.: "
MySQL2JSP 0.3.1.1 (Default branch)
MySQL2JSP is an easy-to-use, quick, and template driven JSP code generator that creates a full set of JSPs, servlets, and JavaBeans from a MySQL database using JDBC. Using the generated JSPs, developers and users can view, edit, add, and delete records"