Free searchable web database software software for linux

Used Textbook Database provides a database for listing used textbooks.

Used Textbook Database is a Web-based textbook database that lets users to create an account and list their used textbooks or books.

It is very modular and customizable and allows for easy integration into an existing Web site.

Web Reference Database is a bibliographic manager that can import and export references in various formats (including BibTeX, Endnote, MODS XML, and OpenOffice).
It can make formatted lists of citations in HTML, RTF, PDF, or LaTeX, and offers powerful searching, rich metadata, and RSS support
Enhancements:
- This release offers major function enhancements and bugfixes.
- Batch import from various bibliographic formats (including BibTeX, Endnote, RIS, ISI, and MODS XML) is now supported, as is import from a PubMed ID.
- An OpenDocument spreadsheet for use with OpenOffice.org can be exported, and formatted citation lists can be generated as HTML, RTF, PDF, or LaTeX. An SRU/W service and support for unAPI, OpenURL, and COinS metadata have been added.
- These allow the data to be used by the next generation of bibliographic clients.
- A new command line client is also included.

Contemplate Web Templating System is a set of server-side scripts that makes it easy for web developers to separate content from code when building sites.
Contemplate assembles text content, page layouts, and server-side or client-side scripts into dynamically generated or precompiled web pages based on arguments you pass into each page.
From simple, content-oriented websites to complex, data-driven web applications, Contemplate separates different production tasks and allows writers, front-end developers, and web programmers to focus on what they do best.
Contemplate is distributed under the Apache Software License, which provides for free distribution and use for any purpose. The license forbids, however, the use of the name Contemplate for new products derived from the source code, and requires that Type A be credited in the source code and documentation of any derivative products.
The Contemplate source code is managed under an open source, closed development model, which means that users may view and modify the source for their own purposes, and may submit enhancement suggestions to Type A, but do not have direct access to Type As development environment. Suggestions relating to performance, security, and consistency between the different ports are particularly welcome.
Contemplate was originally written in Perl and subsequently ported to both PHP and ASP, so youll need one of those three scripting languages installed on your web server. We recommend the ASP version of Contemplate for Microsoft IIS servers and the PHP version for other servers, including Apache.
ASP comes pre-installed on all IIS servers, and PHP comes pre-installed with many Apache distributions; you can install PHP from a free download if your server does not already support it. The three Contemplate versions work identically, except for occasional differences noted in the documentation.
Since Contemplate stores its content in standard HTML files, you dont need any database software on your web server, and you can even switch from one version of Contemplate to another (for example, if migrating from a Windows to a Unix server) without modifying your content files or templates.
And Contemplate includes a Flattener utility, which allows you to develop on a server that supports server-side scripting, then compile your website to plain HTML pages and post it on any web server --even one with no scripting support at all!
Enhancements:
- Better Windows compatibility, improved localization, URL rewriting, and menu capabilities, and miscellaneous bugfixes.

H2 Database Engine is a free SQL database engine writen in Java.
JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported.H2 Database Engine is a web based java database engine.
Main features:
Fast database engine
- Free, source code is included
- Supports standard SQL
- Written in Java
- Disk based or in-memory databases
- Browser base Console application
- JDBC API
- Limited ODBC support
- Embedded and client/server (network) mode
- High availablility support (clustering / failover)
- Wide range of data types including large objects (BLOB/CLOB)
- Strong security features (SSL, users, roles, encrypted files)
- Multiple connections, table level locking
- Cost based optimizer, using a genetic algorithm for complex queries
- Transaction support (serializable transaction isolation)
- Zero-administration, automatic recovery
- Large resultset, external sorting
- Scrollable and updatable resultset support
- Read only views and inline views
- Inner and outer joins, subqueries
- Many functions already built-in
- Triggers and Java functions / stored procedures
- Referential integrity / foreign key constraints with cascade, check constraints
- Multiple schema support
- Compatibility modes for HSQLDB, MySQL and PostgreSQL
- Sequence and autoincrement columns
- Well tested (high code coverage, randomized stress tests)
- Small footprint (smaller than 1 MB)
- Uses a small number of database files
- Can be compiled to native code using GCJ
- Primary keys, multiple index types (b-tree, linear hash, tree, hash)
- ORDER BY, GROUP BY, HAVING, UNION, LIMIT
- Information Schema
- Multiple connections
- Collation support
- EXPLAIN PLAN support
- The database can generate SQL script files
- Support for linked tables, and a built-in virtual range table
- Automatic re-compilation of prepared statements
- Sophisticated trace options
- Low memory requirements
- Easy to understand exception messages
- Standard handling of NULL values
- Multilanguage console application (at this time, English and German)
Currently, this is not traditional GPL software, but the source code is included. It is free for private and commercial use.
Enhancements:
- H2 now supports the PostgreSQL network protocol, and can be accessed using the PostgreSQL ODBC driver.
- Regular expressions are now supported.
- The per session undo log and referential integrity can be disabled.
- Default settings have been changed to save memory. NOT, boolean columns, and certain joins are optimized now.
- Part of the documentation has been translated to Japanese.

XAO::Web is a part of XAO open source web services suite. It allows to build dynamic web content using data, templates and external input.
The distinguishing feature of XAO::Web is in its modular design where almost every aspect of functionality can be altered and alterations can be re-used. No complex code is embedded in the templates which allows to upgrade code and templates separately or maintain multiple visual representations of the same functionality at the same time.
Installation
perl Makefile.PL
make
make test
sudo make install
Saying "install XAO::Web" from the CPAN shell is a good way too:
perl -MCPAN -eshell
install XAO::Web
Using CPAN shell is usually the best way because all dependencies will be resolved automatically.
If you do manual installation then XAO::Web depends on at least the following modules (look into Makefile.PL or just watch closely the output of `perl Makefile.PL for additional dependencies):
XAO::Base
XAO::FS
Digest::MD5
Error
MIME::Lite
Test::Unit
When you run "perl Makefile.PL" you will be asked for XAO::Web test database. That database is only used when you do `make test and it have to exist. It does not matter what is inside the database, it will be completely wiped out for each test case.
Normally the database should be the same that you have used for XAO::FS tests and in case of MySQL is usually test or test_fs.
The directory where templates get installed is the same that you gave to XAO::Base when you installed it. Normally that directory is /usr/local/xao -- we will assume that for the rest of the document.
Main features:
- Perl code is not mixed with templates. Templates can be normal HTML files if no processing is required.
- A specific site can replace or modify standard XAO::Web objects if required by overriding or extending their methods. You do not need to re-implement entire object to make a site specific change. In case of system object upgrade or bug fix there is no need to alter site-specific changes normally.
- Site can create any extension objects or embed third-party extensions as well.
- One server can serve arbitrary number of XAO::Web sites each with however extended functionality without creating any conflicts. That includes different modifications to the system objects for different sites.
- Not limited to Web environment, allows to build any dynamic content -- content of mail messages or reports for instance.
- Works with CGI or mod_perl (mod_perl is recommended for production grade sites).
- If used in mod_perl mode improves performance by using caching of configuration, parsed templates, database handlers and so on.
- XAO::Web is by default integrated with XAO::FS (see XAO::FS) as a database layer, but this is not a requrement -- if for any reason a different database must be used for a site it can be easily and gracefully achieved.
- Hosting providers can allow their customers to build very complex sites without allowing them to execute arbitrary code, by allowing to modify only templates.
Enhancements:
- Fixed a problem with Web.pm for mod_perl usage, introduced last minute just before releasing 1.06

Wikidbase is an idea that combines the functionality of a database system and a wiki web application.
The wikidbase concept is based on the view that non-technical users of a database system (i.e. those who are the experts of the nature of the data they handle) should be able to create and evolve their database model over time (i.e. without paying a database expert over and over again to do it).
This is particularly relevant to non-profit and charity organizations.
Furthermore, since the designer of a conventional database system cannot foretell all future demands of the system, it is highly likely that a database model will be frozen too early, causing problems later on when the requirements of an organistion change - as they so often do.
A conventional database is a system for information storage and retrieval that is highly optimised through organisation of the data into a rigid model; as such, whilst being highly optimised, it is not easy for a non-technical user of the system to later change the model (e.g. to add or change fields, or tables), change reports and queries, or alter the data-entry interface.
A wiki is a website that allows non-technical users to easily edit the contents of webpages, allowing them to add images, alter styling, etc. A wiki can be likened to an unstructured database, since there is no predetermined modal for the information that will be stored, and so a wiki can be used to store highly flexible data - and lots of it - (wikipedia, a web wiki-based encylopedia, is a good example of this). Unlike a structured database, however, information held in a wiki can usually only be retrieved by string searches, and it is not possible, therefore, to retrieve structured information from the wiki (e.g. a list of phone numbers or email addresses for all staff members).
Wikidbase can be thought of as more than just a database, as a rich groupware application that will be capable of storing and organising all sorts of information (e.g. fully relational data, plain old information pages, files, images, media, semi-structured data, shared calendar type information, etc.). Wikidbase will be released as open source under the GPL licence (i.e it will be free).
Enhancements:
- Minor optimizations have been made and work begun on calendar-view enhancement and user authorization.
- The database model has been updated for future optimization.
- Some screencasts are available.

The Simple RSS Service (SRSSS) generates and serves RSS feeds through a common interface via CGI-enabled webservers. It uses modules to extract items for feeds from various sources, and has a virtual filesystem where feeds can be read by CGI-clients.
The package contains everything needed to start providing RSS feeds, including server and CGI programs, and has support for PostgreSQL, MySQL and MimerSQL.
Main features:
- Modular and clean design based on object oriented C++
- Resource-friendly functions that keeps the load down on web- and database-servers by only parsing data and generate new feeds when required, instead of at every request.
- Interface for run-time loading of modules for data-extraction
- A virtual filesystem stored in shared memory
- Feed extraction via CGI program for easy integration in any CGI-enabled webserver
- A trigger-system that allows external sources to trigger daemon software to fetch new updates
- Easy configuration via a configfiles
- Designed for easy integration towards SQL servers etc
- Support for NetBSD, FreeBSD, OpenBSD and Linux.
Modules:
These modules are currently available for RSS item extraction:
mod_pgsql
This module allows the RSS daemon (rssd) to extract items for RSS feeds from a PostgreSQL database. It can select an entire column as description field for the feed, or base it on a pre-formated string in which variables are replaced with values from columns returned in the SQL query.
This module also support triggering, where any client connected to the same database is able to trigger RSSD to fetch a new update via the SQL LISTEN and NOTIFY functions.
mod_mysql
This module integrates RSSD with the MySQL database, allowing it to produce RSS feeds based on any information stored in databases running on MySQL. The module allows the user to run just about any SQL query supported by the database to extract the needed information to create a feed.
Mod_mysql does also support pre-formated strings to generate the description for each RSS item it produces.
mod_mimersql
This module allows the RSS daemon to fetch items from the MimerSQL database.
The module allows the user to run just about any SQL query supported by the database to extract the needed information to create a feed.
Mod_mimersql does also support pre-formated strings to generate the description for each RSS item it produces.
mod_template
This is a template-module that can be used as a starting-point when developing new modules. It is usable, but does not really provide a usable feature.

cheapskate is a simple Ruby on Rails application for personal budgeting.

Rails is a web-application and persistence framework that includes everything needed to create database-backed web-applications according to the Model-View-Control pattern of separation. This pattern splits the view (also called the presentation) into "dumb" templates that are primarily responsible for inserting pre-built data in between HTML tags. The model contains the
"smart" domain objects (such as Account, Product, Person, Post) that holds all the business logic and knows how to persist themselves to a database. The controller handles the incoming requests (such as Save New Account, Update Product, Show Post) by manipulating the model and directing data to the view.

In Rails, the model is handled by whats called an object-relational mapping layer entitled Active Record. This layer allows you to present the data from database rows as objects and embellish these data objects with business logic methods. You can read more about Active Record in
link:files/vendor/rails/activerecord/README.html.

The controller and view are handled by the Action Pack, which handles both layers by its two parts: Action View and Action Controller. These two layers are bundled in a single package due to their heavy interdependence. This is unlike the relationship between the Active Record and Action Pack that is much more separate. Each of these packages can be used independently outside of Rails. You can read more about Action Pack in link:files/vendor/rails/actionpack/README.html.