ems data export 2005 postgresql 1.5.0.4
PostgreSQL 8.2.4
PostgreSQL is The Worlds Most Advanced Open Source Database. more>>
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.
PostgreSQL is an open-source descendant of this original Berkeley code. PostgreSQL supports SQL92 and SQL99.
Main features:
- complex queries
- foreign keys
- triggers
- views
- transactional integrity
- multiversion concurrency control
Additionally, PostgreSQL can be extended by the user in many ways, for example by adding new:
- data types
- functions
- operators
- aggregate functions
- index methods
- procedural languages
And because of the liberal license, PostgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic.
guile-dbd-postgresql 2.0.0
guile-dbd-postgresql is a PostgreSQL database driver for guile-dbi. more>>
guile-dbi is a database generic interface. The main lib provide a way to use dbds (data base drivers) which are linked at run-time (like perl dbi or php or...).
This provide a very flexible way to use guile scheme implementation for db works. Now, implemented main dbi interface lib, mysql and postgres plugins... In near future more drivers will be available (if someone ask for)
HDBC PostgreSQL Driver 1.1.2.0
HDBC PostgreSQL Driver is the Haskell PostgreSQL backend driver for HDBC. more>>
Please see HDBC itself for documentation on use. If you dont already have it, you can browse this documentation at http://darcs.complete.org/hdbc/doc/index.html.
This package provides one function in module Database.HDBC.PostgreSQL:
{- | Connect to a PostgreSQL server.
See for the meaning of the connection string. -}
connectPostgreSQL :: String -> IO Connection
An example would be:
dbh<<less
PostGIS 1.2.0
PostGIS is GIS extensions to the PostgreSQL relational database server. more>>
PostGIS follows the OpenGIS "Simple Features Specification for SQL" and will be submitted for conformance testing at version 1.0.
PostGIS has been developed by Refractions Research Inc as a research project in open source spatial database technology. PostGIS is released under the GNU General Public License. Our list of future projects includes enhanced technology for data loading and dumping, user interface tools for direct data access and manipulation, and support for advanced topologies at the server side, such as coverages, networks, and surfaces.
There are now several open source tools which work with PostGIS. The uDig project is working on a full read amd write desktop environment that can work with PostGIS directly.
For internet mapping, the University of Minnesota Mapserver can use PostGIS as a data source. The GeoTools Java GIS toolkit has PostGIS support, as does the GeoServer Web Feature Server.
GRASS now supports PostGIS as a data source, through the PostGRASS driver. The JUMP Java desktop GIS viewer has a simple plugin for reading PostGIS data, and the QGIS desktop has good PostGIS support.
PostGIS data can be exported to several output GIS formats using the OGR C++ library and commandline tools (and of cource with the bundled Shape file dumper). And of course any language which can work with PostgreSQL can work with PostGIS -- the list includes Perl, PHP, Python, TCL, C, C++, Java, and more.
Installation:
Un-tar the PostGIS tar-ball in the contrib directory of your PostgreSQL source tree. You must untar the PostGIS source there or the Makefile will not work. You must have the PL/pgSQL prodedural language installed before installing PostGIS.
cd contrib
gunzip postgis-0.9.0.tar.gz
tar xvf postgis-0.9.0.tar
cd postgis-0.9.0
make
make install
createlang plpgsql yourtestdatabase
psql -d yourtestdatabase -f postgis.sql
psql -d yourtestdatabase -f spatial_ref_sys.sql
Mysql Data Manager 1.73
Mysql Data Manager is multifunctional and multiplatform web based mysql administration tool and data editor. more>>
High-level functions allow to accomplish a lot with a single mouse click while low-level functions let you do precisely what you want. Using this tool you get a wide range of solutions to support any Mysql web application.
You log into Mysql server via transparent interface of MDM with no need to store your password into config file. You use all privileges granted to you on Mysql server to manage your databases and accounts. All your mouseclicks are being transmitted to mysql server transparently as a command or a chain of predefined commands.
Almost all messages you may receive from MDM interface are generated natively by mysql server and transparently transferred by MDM to web browser for your convenience.
Mysqk Data Manager is a transparent interface between you and Mysql that helps you to manage your data using pre-programmed operations.
Mysql Data Manager does not require root access to MySQL Server to do all the things you need to as a Database Administrator or Web Administrator through web interface.
Here are some operations that MDM can provide:
- CREATE AND ALTER TABLES. All table types are supported
- DELETE records using WHERE clause. DROP tables
- IMPORT DATA from CSV files generated by other applications.
- EXPORT DATA from search results or entire table into CSV files to use them with other applications.
- EDIT exported CSV FILES
- BACKUP and RESTORE the entire database or selected tables in seconds.
- ACCESS MANAGEMENT - create, edit and delete Mysql user accounts in bulk.
- Manage privileges of single and multiple users on all levels: global, database, table and column.
- SEARCH AND MODIFY records using multiple search criteria. (BLOBs are supported)
- INSERT AND EDIT DATA - edit multiple records from search result, directly or by uploading files from local computer. (unquoted expressions are supported).
- EDIT, INSERT and DELETE records in Spreadsheets
- ZOOM Blob and Text fields
- Visually compose SELECT query, joining several tables.
- PRINT DATA - Generate Printable Output.
- SQL SCRIPTING - Create, save, edit and run SQL scripts and use them as Shortcuts. Multiple queries and comments are supported.
- ADMIN FUNCTIONS - Optimize, Analyze, Repair and Check tables. Show status, Variables etc.
- GENEATE "CREATE TABLE" queries
- Provide each user with dedicated subdirectory to store backups, SQL scripts and exported or uploaded ASCII files.
- Assign maximum total size per user of saved backups, SQL scripts and exported or uploaded ASCII files.
- Customize colors and add clickable image.
- Assign a desired Character Set.
- Set up operational parameters using visual interface.
Main features:
- Security. Mysql Data Manager is as secure as your Mysql Server is. User name and password are not stored in any external file. There is no need to use .htaccess protection.
- Easy installation. Only single file must be uploaded. Setup is done using visual interface. You dont need to be root user to install this Mysql web Client.
- Easy in use. No programming skills are needed. Understandable and intuitive interface.
- Reliability and Efficiency. The program generates only pure HTML code. It does not use client side scripting.
- High Speed. Low Bandwidth. No image is used to build GUI. All you see on the screen is built from standard HTML elements. That means also compatibility with all web browsers.
- Multifunctionality.
- Ability to operate in Multi-User environment as universal control panel for wide range of database applications and services.
- All data types are supported.
- All table types are supported.
- All Mysql versions are supported.
- Ability to preview and customize automatically generated queries.
- Quick Backup and Restore
- Quick Import and Export
- High performance, affordable price.
- User friendly error handling
- Platform independence. This is Perl Script.
- Local connection to databases located on a remote host. Global access over the Internet.
- Fully transparent access to Mysql Server through Perl API.
Agata Report 7.2
Agata Report is a cross-platform database reporting tool with graph generation and a query tool. more>>
You can also define subtotals, levels and a grand total for the report, merge the data into a document, generate address labels, or even generate a complete ER-diagram from your database.

DataWorkshop 1.1.1
DataWorkshop is an editor to view and modify binary data. more>>
DataWorkshop 1.1.1 with its functionality will help you a lot. It is actually an editor to view and modify binary data. The editor provides different views which can be used to edit, analyze and export the binary data.
A simple hex view can be used to simulate a standard hexeditor but more complex dynamic views are possible to comfortable edit binary structure like executables or captured network traffic. DataWorkshop editor provides powerful search and diff functionality and user defined transformations.
Views can be filtered using the XPath query language (e.g. selecting several IP packets in a network traffic capture file). Also, views can be exported as in various formats for further processing. This can be used to convert old binary formats into modern xml tagged data.
Keep in mind the limitations:
- Too slow when editing large files (> 100MB) or using complex views
- Maximal data size 2 147 483 647 bytes (~ 2 GB)
Major features:
- Mulitplatform (Windows, Linux, MacOS)
- User defined view definitions which are compiled into complex data views
- Data view can can be exported as xml
- Data view can be queried using XPath syntax to generate a new data view (e.g. selecting several IP packages according to their flags)
- Configurable data encodings used to edit and view data (e.g Hex, Decimal, IEEE 754 Reals, USAscii, EBCDIC, TimeInMillis etc.)
- Configurable data transformation (e.g. Rot13 Encoder / Decoder)
- Diff tool with bit granularity
- Find and replace with bit granularity
- Data clipboard for cut, copy and paste
- Undo/Redo
- XML based storage for persistent data
- Data conversion between different formats (e.g little endian big endian, hexdump binary data)
- Read and write from sockets
Enhancements: 12 July 2004
- Open Source release
Requirements:
- Java 1.4
- 1.0 Ghz Processor with 256MB Ram
DKP Log Parser 1.4.1
DKP Log Parser (DKPLP) is a tool designed to help administrate time-based and/or event-based DKP reward system. more>>
DKP Log Parsers goal is to reduce the administrative overhead of running complex DKP reward system, by parsing the logs, calculating the DKP per person and sending the results (the loot, raids, participants and DKP) directly to EQDKP (or other DKP software). Its widely configurable, allowing it to be used by the many variations of zero-sum and time-based DKP around.
Overview of how DKP Log Parser is used
DKP Log Parser is a software program run on a users desktop (Windows or Unix). It reads in the contents of a game log once a raid has been completed, parses all the information and displays the data for administrators to edit. Once happy with the information, the administrator uploads the data from their PC to the DKP Log Parser plugin on an EQDKP webserver (or any other server implementing the required DKPLP interface), where it can be viewed by all members of the DKP system.
Main features:
- Inbuilt support for Everquest, Everquest II, World of Warcrafts CT RaidTracker plugin, and Ventrilo.
- Extensible enough to be able to handle most logs.
- Time based dkp:
- Accrue DKP by minute, by interval, by event or by a combination of these.
- Zero-sum DKP can be enabled (by minute or by interval) or disabled.
- Tag certain intervals as being more or less important by using weightings to adjust the DKP.
- Data export:
- Upload data to for example EQDKP, select from a number of different data representations.
- Export to plain text
- Export to BB forum markup
- Export to wiki markup
- Export to XML
- Member list and alt character list synchronises with server, making it easy to share setups with other users.
- Optional autocompletion database to remember item names and values between sessions.
- Preprocessors available to perform other operations on the log file. The skys the limit!
Npgsql 1.0
Npgsql is a .Net data provider for Postgresql. more>>
Npgsql library is implemented in 100% C# code. Works with Postgresql 7.x and 8.x.
Horde Groupware 1.0.1
Horde Groupware is a free, enterprise ready, browser based collaboration suite. more>>
Horde Groupware can be extended with any of the released Horde applications or the Horde modules that are still in development, like a file manager, a bookmark manager, a forum or a wiki.
Main features:
- Public and shared resources (calendars, address books, tasklists and notepads)
- Unlimited resources per user
- Translated into 41 languages including right-to-left scripts and unicode support
- Global categories (tags)
- Customizable portal screen including applets for weather, quotes, etc.
- 25 different interface themes
- Online help system
- Import and export of groupware data from other applications
- Synchronization with PDAs, mobile phones, groupware clients
- Integrated user management, group support and permissions system
- User preferences with global default values
- Strong integration, e.g. address book lookups in meeting planning, task due dates in calendar
- Platform independant, works on any web server with PHP support, i.e. Linux, Windows, Solaris, Mac OS X Server
- Abstract database support, e.g. for MySQL, PostgreSQL, Oracle, Microsoft SQL-Server
Calendar
- Day, week, work week, month and year views
- Recurring and all-day events
- Alarms with email notifications
- Simple and advanced search forms
- Meeting planning, also with other calendar applications
- Email notification about changed events
- Free/busy information exchange with other calendar applications
- Subscription of remote calendars
- Integration into external clients like Apple iCal, Mozilla Sunbird, Microsoft Outlook
- iCalendar and iTip support
Contacts
- Distribution lists/email groups, also across address books
- Simple and advanced search forms
- Customizable address book listings
- vCard support
- Address book pager (rolodex)
- Customizable contact fields
- Integration of existing address books
Tasks
- Priorities and due dates
- Searchable descriptions
- Email notification about changed tasks
- Integration into external clients like Apple iCal, Mozilla Sunbird, Microsoft Outlook
- vTodo support
Notes
- Fulltext search
- Character counter
Enhancements:
- A local arbitrary file deletion vulnerability has been fixed.
- The Oracle session handler has been rewritten.
- vTimezone support for iCalendar data and ORG support for vCard data have been added.
- Samba and Cyrus SQL authentication drivers, automatic Web root detection, signature dimming, and compatibility of generated ZIP files have been improved.
- Calendar support for non-ASCII character sets has been improved.
- vCard support has been improved.
- Brazilian Portuguese, Catalan, Dutch, Finnish, French, German, Portuguese, and Traditional Chinese translations have been updated.
Suri Pluma 1.0.1
Suri Pluma is a satellite image processing tool and visualizer. more>>
Suri Pluma project can open the most common image formats without importing to an internal format and minimizing the memory required for visualization.
It is designed to be modular and extensible. It has a meassurement tool (distance and areas with error estimation) and geographical and map coordinate information.
Designed with state of the art techniques and tools, it offers means to extract information in easy and intuitive ways, offering to the user quantitative and qualitative information immediatly, taking full profit of the different satellite sources.
It provides simplified access to the different data formats and exports to the most common and spreaded formats. It takes full advantage of the hardware resources, with very low minimal requirements.
The goal is to provide the user with a high quality software, bringing a simple tool for image processing and remote sensing.
Main features:
User Interface
- Windows based single-document user interface (SDI) for more flexibility.
- Intuitive graphic user interface, making the tasks simple for both beginner and advanced users.
Input file formats
- Automatic opening of Fast Format images (including SAC-C and Landsat), Tiff and GeoTiff distribuited by CONAE, as well as the different formats used by GLCF and other propietary formats as the ENVI format. Also supports standard graphic formats like Jpg, Png and Bmp.
- Image type auto detect. There is no need to import for visualization the data with known formats.
- Direct access to the different data types without conversion.
- Immediate opening images independently from their size.
- Opening many images at once without memory overflow.
- Supports generic RAW binary format with manual definition of parameters.
Image analysis:
- Area and distances measurement tools available.
- Planar coordinate and pixel value displaying in real-time.
Image visualization:
- RGB color composite viewing capabilites.
- Grayscale viewing capabilites.
- Zoom In/Out capabilites using the wheel on the mouse.
- Flexible navigation using Scroll/Zoom windows.
Image enhancement:
- Linear and nonlinear contrast enhancement.
- Histogram equalization.
Geographic location:
- Automatic recognition of georeferenced meta-data of the different formats, making possible the search of areas of interest by geographic coordinates.
Export images:
- Exports to different image formats, making Suri compatible with other analysis tools. Available on Suri Pluma V1.1.
Minimal requirements:
- Takes advantage of the hardware resources, making possible the visualization and analysis of big images in low-end hardware with great efficiency.
Available platforms:
- Suri is developed in C++ in Linux and Windows environments simultaneously and distribuited in both systems.
Data::CTable 1.03
Data::CTable is a Perl module that helps you read, write, manipulate tabular data. more>>
SYNOPSIS
## Read some data files in various tabular formats
use Data::CTable;
my $People = Data::CTable->new("people.merge.mac.txt");
my $Stats = Data::CTable->new("stats.tabs.unix.txt");
## Clean stray whitespace in fields
$People->clean_ws();
$Stats ->clean_ws();
## Retrieve columns
my $First = $People->col(FirstName);
my $Last = $People->col(LastName );
## Calculate a new column based on two others
my $Full = [map {"$First->[$_] $Last->[$_]"} @{$People->all()}];
## Add new column to the table
$People->col(FullName => $Full);
## Another way to calculate a new column
$People->col(Key);
$People->calc(sub {no strict vars; $Key = "$Last,$First";});
## "Left join" records matching Stats:PersonID to People:Key
$Stats->join($People, PersonID => Key);
## Find certain records
$Stats->select_all();
$Stats->select(Department => sub {/Sale/i }); ## Sales depts
$Stats->omit (Department => sub {/Resale/i}); ## not Resales
$Stats->select(UsageIndex => sub {$_ > 20.0}); ## high usage
## Sort the found records
$Stats->sortspec(DeptNum , {SortType => Integer});
$Stats->sortspec(UsageIndex, {SortType => Number });
$Stats->sort([qw(DeptNum UsageIndex Last First)]);
## Make copy of table with only found/sorted data, in order
my $Report = $Stats->snapshot();
## Write an output file
$Report->write(_FileName => "Rept.txt", _LineEnding => "mac");
## Print a final progress message.
$Stats->progress("Done!");
## Dozens more methods and parameters available...
OVERVIEW
Data::CTable is a comprehensive utility for reading, writing, manipulating, cleaning and otherwise transforming tabular data. The distribution includes several illustrative subclasses and utility scripts.
A Columnar Table represents a table as a hash of data columns, making it easy to do data cleanup, formatting, searching, calculations, joins, or other complex operations.
The objects hash keys are the field names and the hash values hold the data columns (as array references).
Tables also store a "selection" -- a list of selected / sorted record numbers, and a "field list" -- an ordered list of all or some fields to be operated on. Select() and sort() methods manipulate the selection list. Later, you can optionally rewrite the table in memory or on disk to reflect changes in the selection list or field list.
Data::CTable reads and writes any tabular text file format including Merge, CSV, Tab-delimited, and variants. It transparently detects, reads, and preserves Unix, Mac, and/or DOS line endings and tab or comma field delimiters -- regardless of the runtime platform.
In addition to reading data files, CTable is a good way to gather, store, and operate on tabular data in memory, and to export data to delimited text files to be read by other programs or interactive productivity applications.
To achieve extremely fast data loading, CTable caches data file contents using the Storable module. This can be helpful in CGI environments or when operating on very large data files. CTable can read an entire cached table of about 120 megabytes into memory in about 10 seconds on an average mid-range computer.
For simple data-driven applications needing to store and quickly retrieve simple tabular data sets, CTable provides a credible alternative to DBM files or SQL.
For data hygiene applications, CTable forms the foundation for writing utility scripts or compilers to transfer data from external sources, such as FileMaker, Excel, Access, personal organizers, etc. into compiled or validated formats -- or even as a gateway to loading data into SQL databases or other destinations. You can easily write short, repeatable scripts in Perl to do reporting, error checking, analysis, or validation that would be hard to duplicate in less-flexible application environments.
The data representation is simple and open so you can directly access the data in the object if you feel like it -- or you can use accessors to request "clean" structures containing only the data or copies of it. Or you can build your own columns in memory and then when youre ready, turn them into a table object using the very flexible new() method.
The highly factored interface and implementation allow fine-grained subclassing so you can easily create useful lightweight subclasses. Several subclasses are included with the distribution.
Most defaults and parameters can be customized by subclassing, overridden at the instance level (avoiding the need to subclass too often), and further overridden via optional named-parameter arguments to most major method calls.
Network Probe 2.1
Network Probe and protocol analyzer is the ultimate tool for traffic-level network monitoring, troubleshooting, analysis. more>>
If your network is crawling to a standstill, and you suspect there might be a problem with the network traffic, Network Probe will quickly help you identify what is causing the problem, show you who is generating any troublesome traffic, and where the traffic is being transmitted.
Network Probe will collect traffic statistics for all protocols, hosts, and conversations on your network, and show you all the top talkers and listeners on your network. Hosts generating large amounts of traffic such as music and movie streaming, playing online games, or listening to streaming media are easily identified.
Main features:
- Watch in real time which protocols are used on your network
- Watch in real time which hosts are active on your network and the Internet
- Watch in real time which conversations are taking place on your network and to and from the Internet
- Watch in real time detailed protocol statistics per host
- Watch in real time detailed protocol statistics per conversation
- Watch in real time network card details for your network
- Watch traffic amount of selected entries relative to the total and filtered traffic
- Watch traffic amount over time for any host, conversation, and protocol
- Watch in real time network throughput for the entire network segment
- Inspect detailed logged statistical data from days and weeks earlier
- Filter out and search for selected protocols, hosts, conversations, and network cards
- Sort network traffic by amount of data transmitted or received
- Export network traffic statistics data
- Configure users with restricted access to statistical data
- Password protected login
PHP EMS Tools 2.0
PHP EMS Tools project is a software for volunteer and small paid emergency medical services. more>>
PHP EMS Tool is a software package for Emergency Medical Services (EMS) agencies. It allows you to maintain a monthly crew schedule, roster, record of apparatus checks, address book, count your members monthly hours, and more. It is designed to be installed on a server on the local network at your headquarters. It *can* be installed on an internet-based host, but this is not suggested, as security is very lax in the current version - it is designed to stop members from casually doing things they shouldnt, not to protect your server from the dangers of the Internet.
The current version incorporates a feature to allow the schedule, roster, and hours count to be visible from the Internet, when configured properly.
PHP EMS Tools is totally free, and open source. It is programmed in the PHP language, which most web servers support. To run PHP EMS Tools, you will need a web server (Apache recommended), the MySQL database server, PHP, and a few other pieces of software. PHP EMS Tools *should* run under any operating system that supports these packages, but is designed to be run under Linux (which is also 100% free and open source). To install PHP EMS Tools, you will need root access to the server, or will need to get the systems administrator to create a database and users for you.
UMMF::Export::Java 1.02
UMMF::Export::Java is a code generator for JavaTemplate. more>>
SYNOPSIS
use UMMF::Export::Java;
my $exporter = UMMF::Export::Java->new(output => *STDOUT);
my $exporter->export_Model($model);
This package allow UML models to be represented as Java code.