Free Software Foundation!

Join now

Category/Database/application

From Free Software Directory
Revision as of 12:50, 6 July 2011 by WikiSysop (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation,

Broaden your selection: Category/Database

Category/Database Search icon.png

application (73)



ADL
Database load balancing class for PHP applications who need to deal with various MySQL servers. The class will properly detect write queries and will try the next available server(s) until running out of connections. Multi server connection handling in progress in order to allow running transactions in many servers at the same time.

ADOdb
ADOdb is a database abstraction library for PHP. The PHP version currently supports an amazing number of databases, thanks to the wonderful ADOdb community: MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and generic ODBC, ODBTP. The Sybase, Informix, FrontBase and PostgreSQL, Netezza, LDAP, ODBTP drivers are community contributions. Some reasons why ADOdb is popular include:

  • Designed for speed. It is probably the fastest free software database abstraction library available for PHP. See benchmarks.
  • Provides extensive portability support such as date and type-handling and portable schema creation. See portable sql tips
  • Support many enterprise features such as database backed sessions (with session expiry notification), SQL code generation, pivot tables, SELECT LIMIT emulation for all databases, performance monitoring.
  • Easy to learn.
  • Extensive QA, every release is unit-tested on Access, MySQL, PostgreSQL, MS SQL, Oracle 9.
  • Mature, continuously developed since August 2000. Has a large community of users.
  • Powerful Active Record support. See docs.
  • Very reasonable licensing terms (BSD). This means that you can incorporate (and even compile) it into your software applications royalty-free without asking the author's permission, provided you include license.txt in your release.

ADOdb Lite
A small, fast replacement for ADODB that uses 1/6th of the memory and upto 300% faster while being compatible with ADODB using a subset of the most often used ADODB commands.. Supports Frontbase, MaxDB, MiniSql, MSSQL, MySql, Postgres, SqLite and Sybase.

ADOdb for Python
ADOdb is a database abstraction library. ADOdb was originally developed for PHP, and ported to Python. The Python version implements a subset of the PHP version. You might ask why Python needs a database abstraction library when Python provides the official DB API. Unfortunately the DB API does not encapsulate differences in the database implementations. For example, to select a limited number of rows, say 10 rows, you would have to use very different SQL for different databases:

  • MS SQL select top 10 from table
  • MySQL and PostgreSQL select * from table limit 10
  • Oracle select * from (select * from table) where rownum <= 10
  • These differences are handled by ADOdb (using SelectLimit), but not by the Python DB API. Other important database differences transparently handled by ADOdb include date-formating, associative arrays (records as dictionaries) and LOB-handling.

Apache CouchDB
Apache CouchDB is a distributed, fault-tolerant and schema-free document-oriented database accessible via a RESTful HTTP/JSON API. Among other features, it provides robust, incremental replication with bi-directional conflict detection and resolution, and is queryable and indexable using a table-oriented view engine with JavaScript acting as the default view definition language. CouchDB is written in Erlang, but can be easily accessed from any environment that provides means to make HTTP requests. There are a multitude of third-party client libraries that make this even easier for a variety of programming languages and environments.

Ara
'Ara' is a command-line utility for querying the Debian package database. It has a query syntax allowing you to search for boolean combinations of regular expressions. It includes a simple syntax and line-editing. A graphical interface, xara, is also provided.

AutoCodeGenerator
AutoCodeGenerator is a tool which is able to generate other programs that insert, delete, or update database records for a number of different database programs. Programs can be generated in Python, bash, ksh, Java, C, or other languages; the package also generates code for various database servers via a plain text file.

Bibfilex
Bibfilex is a free bibliographic manager for GNU/Linux and Windows. It's useful to create and to manage archives of bibliographical items (books, articles, etc.) with possible attachments of any kind according to Biblatex structure and rules, but it can be used also with a wordprocessor like Writer or Word. Bibfilex may create and manage files which are catalogs of many items – also thousands of them. A file of Bibfilex is a database of SQLite (www.sqlite.org), a popular software whose data can be easily read and exported through different tools available on the Internet. In a Bibfilex file data are not stored according to Biblatex format, so it cannot be used as a bibliographic file in a Latex document. Anyway, Biblatex may export with a one-click functionality all or part of its content in Biblatex format file; this can be read directly with JabRef or used in a Latex document. At the same time, Bibfilex may import directly a JabRef database. The main features of the software are: store the items according to each one of the entry types described in the Biblatex manual (book, article, etc.); import the content of a file in Biblatex format (like a JabRef database); export data in a Biblatex file (like a JabRef database); import and export data from a Bibfilex file to another along with possible attachments; locate an item just typing its author name, title, etc.; filter the items selecting a keyword in a list; filter the items by the BibTex keys contained within a \cite{} or similar command in a Latex document; filter the items according to three different conditions, or modify manually the SQL statement of the filter to make it more suitable or complex; replace the citation commands (\cite, etc.) and \printbibliography command in a Latex document with extended citations and bibliography, which are composed according to a user defined pattern, and convert the resulting file in other formats with Pandoc (http://johnmacfarlane.net/pandoc); associate various attachments (files of every kind) to each item; the attachments are zipped and stored in a directory with the same name and path of the Bibfilex file in use, and automatically managed by the software; the number of attachments is limited only by the available disk space; activate autocompletion of data in each field with “Ctrl + Space”; create automatically unique BibTex keys according to a pattern defined by the user; specify the fields (columns) shown in the grid view of the data; forms to insert easily special characters and keywords; bookmarks, to go easily to a specified item; copy in the current item the content of some fields of another item referenced by the crossref field. Bibfilex has also the possibility to compose the citation of an item according to a user defined pattern and copy it in the clipboard in Latex or HTML format; in the last case, the citation may be pasted in a word processor like LibreOffice Writer mantaining font formatting (italic, small caps, etc.). This makes Bibfilex useful also for those who do not use Latex, but a word processor instead.

Bond
BOND (building object network databases) is a rapid application development tool which allows you to develop GUI front ends to PostgreSQL databases. It uses XML to define widget layout and how to obtain information from databases. This project is designed to simplify the process of developing database applications for GTK.

Bonddb
'bonddb' is an object orientated wrapper for PostgreSQL. It's a fast data abstraction layer C/C++ applications, to allow easy access to class objects. You can use existing PostgreSQL databases without any modification or additional tables needed in the backend. "bonddb' easily modifies rows in database fields without you having to construct sql statements or worry about refreshing existing datasets. It also lets you easily map your tables together in object to object relationships. Method calls aren't supported yet but they are being worked on.

… further results



Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the page “GNU Free Documentation License”.

The copyright and license notices on this page only apply to the text on this page. Any software or copyright-licenses or other similar notices described in this text has its own copyright notice and license, which can usually be found in the distribution or license text itself.


Personal tools
Namespaces

Variants
Actions
Navigation
Contribute