Free firebird restaurant software for linux

Firebird .NET Data Provider is an ADO.NET data provider for Firebird. Firebird .NET Data Provider is written in C# and provides a high-performance native implementation of the Firebird API. It also includes an implementation of the Firebird Services API and Firebird array datatype support.

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981.

Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000 under the InterBase Public License v.1.0

Tiny Report is a free software that helps you to Design, Manage, and Deliver Reports for Extreme Business Insight.
It simply automates to production of dynamic PDFs. It allows you to design your templates in OpenOffice.
Main features:
The process
- Design your .SXW fie in OpenOffice,
- Use tiny_sxw2rml.py to convert the file in a .RML template,
- Use tiny_report.py to produce PDF file using any database.
Report Designer
- The report designer used is OpenOffice. All styles, tags and features of OpenOffice documents (.SXW) are implemented instead frames.
- No specific language to learn,
- Support style, colors, table, section, items, images, ...
- OpenOffice is not needed to render the PDF
Data Acquisition
- Support python expressions for effective computation,
- Browse through table with the object relationnal mapping,
- You do not have to code the database structure (introspection on the DB),
- You can create your own object and functions
- Lots of databases supported: MySQL, Postgres, SQLite, Firebird, SybaseConnection, MAX DB
- Support all links between tables (one2many, many2one, ...),
- Lots of special features using simple Python: group, sort.
Report Renderer
- Fast, simple and easy,
- Standalone to be included in other applications.

libdbi implements a database-independent abstraction layer in C, similar to the DBI/DBD layer in Perl.
Writing one generic set of code, programmers can leverage the power of multiple databases and multiple simultaneous database connections by using this framework.
The libdbi-drivers project provides the database-specific drivers for the libdbi framework. The drivers officially supported by libdbi are:
- Firebird/Interbase
- FreeTDS (provides access to MS SQL Server and Sybase)
- MySQL
- PostgreSQL
- SQLite/SQLite3
The following drivers are in various stages of completion and are supposed to be included into the next release:
- mSQL
- Oracle
Enhancements:
- This release fixes a packaging error in 0.8.2. There are no source code changes.

Jaybird is JCA/JDBC driver suite to connect to Firebird database server. Historically Borland opened sources of type 3 JDBC driver called InterClient.

However due to some inherent limitations of Firebird client library it was decided that type 3 driver is a dead end, and Firebird team developed pure Java implementation of wire protocol.

This implementation became basis for JayBird, pure Java driver for Firebird relational database.

This driver is based on both the new JCA standard for application server connections to enterprise information systems and the well known JDBC standard.

The JCA standard specifies an architecture in which an application server can cooperate with a driver so that the application server manages transactions, security, and resource pooling, and the driver supplies only the connection functionality.

While similar to the JDBC 2 XADataSource idea, the JCA specification is considerably clearer on the division of responsibility between the application server and driver.

JayBird 1.5 provides extensions to some JDBC interfaces. All extension interfaces are released under modified BSD license, on “AS IS” basis, this should make linking to these classes safe from the legal point of view. All classes belong to org.firebirdsql.jdbc.* package.

JayBird 1.0 provided only pure Java wire protocol implementation. While being most effective in client-server setups (even more effective than native client libraries), it performed worser when connected to the server residing on the same host compared to native (C/C++/Delphi/etc) solutions. Reason is that type 4 driver communicates with the server using network sockets, which introduce additional overhead. Native client library has possibility to use IPC when connecting to the database on the same host. This might increase performance even by 100%.

JayBird 1.5 provides also type 2 JDBC driver that uses native client library to connect to the databases. Additionally JayBird 1.5 can use embedded version of Firebird relational database allowing to create Java applications that does not require separate server setup.

However type 2 driver has also limitations. Due to multi-threading issues in Firebird client library, it is not possible to access it from different threads simultaneously when running in local mode (IPC). In this case only one thread is allowed to access library at a time. Driver tries to provide needed synchronization.

Current implementation uses mutex that is local to the classloader that loaded JayBird classes. This poses some deployment limitations: firebirdsql.jar must be deployed so, that it is loaded by the system classloader. For standalone web containers like Resin or Tomcat, JayBird should usually be deployed in their lib/ directory. It is allowed to include it in the WAR archives, but if and only if it is guaranteed that only one application will access Firebird.

When accessing remote servers thread per connection policy applies. Driver provides necessary synchronization for this situation.

Embedded version of the server cannot be used on Linux systems in multi-threaded applications. In particular this makes embedded version of the server unusable for web applications, where usually each request is served in separate thread.

Quick Order provides an ordering system using Java Wireless HTTP Form.
It uses J2ME libraries to submit forms to an HTTP server running PHP and MySQL. It can run on any embedded device that supports Java Wireless, including mobile phones and Palm systems.
It is ideal for making orders in restaurants, point of sale (POS), etc. It supports English and Chinese Big 5 encoding.
Enhancements:
- PASP is used for the server-side language font.
- An HTTP POST method was added to the server.
- A vector is used to allow flexibility of ordered items.

ibWebAdmin is a web frontend for the Firebird and InterBase database server. ibWebAdmin project makes the attempt to support all features which Firebird and SQL are offering.
Even if this goal is unattainable, quite a few steps have already been done. By now ibWebAdmin has the basic functions for creating, deleting, modifying databases, tables, generators, triggers and domains. It lets you import, export, enter, edit, delete, query, browse your data. And some more ...
To execute this program you need, beside the Firebird or InterBase database server, an apache webserver with php support.
Enhancements:
- restored php4 compatibility by adding a php4 replacement for the php5-only array_combine() function

The Job Scheduler runs executable files, shell scripts and database procedures automatically (MySQL, PostgreSQL, Firebird and SQL Server, Oracle, DB2).

Job Scheduler processes sequential and parallel tasks and job chains, provides an API for job implementation with Java, Javascript, VBScript, Perl and exposes jobs as Web Services.

fb_shash is a UDF library for Firebird/Interbase. It implements hash and hmac interfaces to the openssl library.

It supports hash and hmac algorithms such as SHA1 and MD5. fb_shash supports BLOB data.