Ports Search

DBIx::Ease is intended to allow less-code DBI interactions. Upon creation of a new DBIx::Ease object you should pass the portion of the DSN (Data Source Name) common to all connections the object is supposed to store. Replace the variable portions with '<databasename>'. Whenever you wish to make only one connection you may enter the complete DSN, also when you want to make connections with the same source but as different users, then call exec() with different names of your choice as initial argument.

When searching through large amounts of data, it is often the case that a result set is returned that is larger than we want to display on one page. This results in wanting to page through various pages of data. The maths behind this is unfortunately fiddly, hence this module. The main concept is that you pass in the number of total entries, the number of entries per page, and the current page number. You can then call methods to find out how many pages of information there are, and what number the first and last entries on the current page really are.

Rose::DBx::Object::Renderer generates web UIs for Rose::DB::Object. It encapsulates many web conventions in the generated UIs as default behaviours. For example, email addresses are by default rendered as mailto links in tables and appropiate validation is enforced automatically in forms. These behaviours are highly extensible. Renderer uses CGI::FormBuilder to generate forms and the Google Chart API to render charts. Template::Toolkit is used for template processing, however, Renderer can dynamically generate a full set of UIs without any templates.

sqldf is an R package for runing SQL statements on R data frames, optimized for convenience. The user simply specifies an SQL statement in R using data frame names in place of table names and a database with appropriate table layouts/schema is automatically created, the data frames are automatically loaded into the database, the specified SQL statement is performed, the result is read back into R and the database is deleted all automatically behind the scenes making the database's existence transparent to the user who only specifies the SQL statement.

phpPgAdmin is phpMyAdmin (for MySQL) ported to PostgreSQL. phpPgAdmin is a fully functional PostgreSQL administration utility. You can use it to create and maintain multiple databases and even multiple servers. Features include: - create and drop databases - create, copy, drop and alter tables/views/sequences/functions/indicies/triggers - edit and add fields (to the extent Postgres allows) - execute any SQL-statement, even batch-queries - manage primary and unique keys - create and read dumps of tables - administer one single database - administer multiple servers - administer postgres users and groups LICENSE: GPL2 or later

postgresql-relay can be used to as a single point of origin for all your databases. Instead of having to remember (or modify in case of changes) all the names of your databases, on which machines and on which ports they are running, you only need to remember one machine and the name of the database. The postgresql-relay will then forward the connection to the proper database on the proper port of the proper server. No more changes in the hundreds of clients and scripts!

Riak is an open source, distributed database. Riak is architected for: * Low-Latency Riak is designed to store data and serve requests predictably and quickly, even during peak times. * Availability Riak replicates and retrieves data intelligently, making it available for read and write operations even in failure conditions. * Fault-Tolerance Riak is fault-tolerant so you can lose access to nodes due to network partition or hardware failure and never lose data. * Operational Simplicity Riak allows you to add machines to the cluster easily, without a large operational burden.

Xapian is an Open Source Probabilistic Information Retrieval library, released under the GPL. It's written in C++, with bindings to allow use from other languages. Xapian is designed to be a highly adaptable toolkit to allow developers to easily add advanced indexing and search facilities to their own applications. Xapian features include: - Ranked probabilistic search - word importance weighting - Relevance feedback - Phrase and proximity searching - Full range of structured boolean search operators - Term stemming - Database files > 2GB - Platform independent data formats - Allows simultaneous update and searching.

LMDB is an ultra-fast, ultra-compact key-value data store developed by Symas for the OpenLDAP Project. It uses memory-mapped files, so it has the read performance of a pure in-memory database while still offering the persistence of standard disk-based databases, and is only limited to the size of the virtual address space, (it is not limited to the size of physical RAM). LMDB was originally called MDB, but was renamed to avoid confusion with other software associated with the name MDB.

TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers - which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools.