2191 projects tagged "Database"
ExportSpreadsheets is a class that can be used to create an Excel spreadsheet from data in a MySQL table. It performs a query to a given MySQL table and creates an Excel spreadsheet file using the PEAR Spreadsheet_Excel_Writer package. The class can export multiple worksheets to a single Excel file. Several parameters may be used to configure details like which table fields map to which spreadsheet columns, field sorting, etc.
MADAL is an AJAX based database access layer for MySQL written in PHP and Javascript. It generates PHP and JavaScript/jQuery source code that is well documented, so you can use your IDE's auto-completion against database tables and fields. The documentation was designed with PHP Eclipse in mind, but should work for any IDE that recognizes PHP doc. It generates a set of PHP classes that mirror your database schema. It generates a set of JavaScript/jQuery classes allowing for simple client side display and modification. It generates an easy-to-use Web-service for accessing your database. An AJAX enabled field can be produced simply by printing the input field. Input fields are validated for their type. MADAL includes the whole set of default jQuery UI themes for styling of your pages.
OrientDB is a NoSQL DBMS which can store 150,000 documents per second on common hardware. Even with a document-based database, the relationships are managed as in graph databases, with direct connections among records. You can traverse entire or parts of trees and graphs of records in a few milliseconds. It supports schema-less, schema-full, and schema-mixed modes, has a strong security profiling system based on users and roles, and supports SQL between the query languages. Thanks to the SQL layer, it's straightforward to use for people skilled in the relational world.
Orient Key/Value Server is based on the Document Database technology and is accessible as an embedded repository via Java APIs or via HTTP using a RESTful API. It uses a new algorithm called RB+Tree, derived from the Red-Black Tree to maintain tree balance, and from the B+Tree storing the links to records in pages to optimize memory consumption and loading time. Orient Key/Value Server scales out very well in a cluster with thousands of running machines: Orient will divide the load among all the nodes. Clustering, by default, works in auto-discovery mode: when a node starts, it attaches itself to the cluster if one is available. When a node goes down, the cluster automatically rebalances itself.
The goal of Funani is to solve the management of large image and other media collections in a practical way. To help you find the data you want in big data collections, this software allows you to sort it in many different ways. Advanced queries on dates, locations, events, or people, or more generically categories and tags, allow you to narrow the search quickly. Funani can be thought of primarily as a safe. Every file put into the system remains in the system. It is an additive system, which makes unintended deletion impossible. A maintenance mode can still remove unwanted files, but standard users cannot perform this operation. Funani is also a framework designed for extensibility. When new features are requested, they can be implemented by adding new functionality and leaving the existing system alone. Each feature is completely isolated from others as long as it does not depend on them.
The stx::CBTreeDB is a collection of C++ classes with which read-only key-value database files can be created and read. A database efficiently maps a large number of integral fixed-length keys to opaque binary value blobs. Variable-length or duplicate keys are currently not supported. Keys are organized into a highly compact index structure, which is very similar to a B-tree and allows very fast key lookups. Both keys and values are stored in order and thus queries in a local proximity can benefit from caching effects. All applications mapping a large number of constant, integral keys to string or data blobs can benefit from this library.
AGENCY is software that allows non-profit organizations to track data and manage operations. It is a fork and continuation of CHASERS. AGENCY aims to become a collectively-maintained and developed project that puts organizations in charge of their data systems. There are currently two “flavors” of AGENCY: one for managing clients and services, case management, and such (think “social service”); and one for managing donations and volunteers (think “fundraising”). Features include a report generator, permissions and access control, the ability to merge reports to OpenOffice documents, a log system, and real-time alerts with email notification. In the client version, many tables and data structures are already set up for organizations doing human service, homeless services, or HMIS. The donor version is set up to track donors, addresses, gifts (cash and inkind), flags, volunteers, volunteer activities, and more.