Damyan asked if we can simplify the packages for firebird 2.5 and
by dropping the old classic support and pushing the super and super-classic
Here is my response:
The best pictures with what arhitecture to choose from and
where to use them
Is better to be safe creating an new package is easy for super-classic
I proposed to stay the old way and provide all packages
If the user wants the new superclassic then he can install it
And he is wrong – page cache is not shared on SuperClassic
Roman replied :
Classic has one nice property for hosting providers – when somebody use
a buggy UDF, only his process dies, others remain intact.
Also, I’m pretty sure that it is currently not possible, but should be
possible to do in the future, is that we could make the process to run
with the SID of the logged in user (when the PAM authentication is
Super-classic and Classic will use the same binaries in Linux. But
startup is different.
At the End we all agreed that it’s easier to create an new package for firebird 2.5 named superclassic
Damyan response and final statement:
Thanks for reminding me each architecture’s advantage:
- – classic: full SMP, isolated connections
- – super: shared cache
- – superclassic: full SMP with low OS resource usage
I wanted to provide just one server package for Debian as
I (mistakenly) thought that superclassic uses shared cache too and
didn’t value the isolated connections that much. You do write bug-free
code, right? 😉
Thanks to your comments, instead of cutting, I’ll add a -superclassic
package so that the user can have the final choice.
Here are my notes on installing/using Firebird 2.1.x Classic and Flamerobin .9 on Debian , soon i will update the ubuntu wiki page
Article submitted by Anton Kavalenka.
Firebird SQL server is popular because it is free, open, lightweight and secure. Firebird is based on the Interbase SQL server, and can be accessed by the same client libraries.
FlameRobin is a X-platform GUI application that makes the life of Firebird/Interbase admins easier. It’s a very light-weight solution (implemented with wxWidgets) as opposed to Tora, which tries to be universal, but is very huge and takes a while to load. FlameRobin starts almost instantly, but being lightweight doesn’t mean to be poor in features. Some of them are:
- Create and drop database entities like tables, views, procedures, indices, domains, constraints, triggers, generators, etc.
- Powerful SQL Editor
- Perform SQL queries and view results in Unicode-aware GUI. Queries can be built by drag-and-dropping table columns in the SQL editor.
- Manage several server connections
- Perform queries on system tables RDB$xxxx (system tables)
- Manage database rights
- Get the DDL as text for automated table creation.
- Event monitoring. You can subscribe to one or multiple events and control when and how many of each event happened in the database.
- Create all the TABLES, DOMAINS, CONSTRAINTS, USERS, TRIGGERS, PROCEDURES etc, needed for database functionality.
- FlameRobin always displays the SQL statement it’s going to run, so you always know what is happening in your database and no under-the-hood mechanism obscures your actions.
- Editable data grid, you can modify existing data inside the grid and also add and remove rows. Blob values can be updated from files.
- FlameRobin can have multiple log files for a given database, one for each statement, making it easy to build update scripts for production databases.
Using Firebird and FlameRobin included in Debian it is possible to backup a database from Windows, restore it on Linux and take off SQL server load from workstation. This is the only way to move database between 32-bit and 64-bit architecture. It is a feature of Firebird (or maybe bug). On the same architectures database files can be simply copied.
If you use debian then you can download from here
Quote from linux tiny mailing list about the ARM market share
Arm shipped the processors in 250 million “smart phones” in 2006 (83%
market share in that niche).
According to ARM Inc. quarterly results for Q1 2007:
In the first quarter of 2007, the licensees of ARM Inc. shipped 724 million
ARM processors. In one quarter. (ARM Inc. collected $45 million in license
fees, which is an average of 6.2 cents/processor.)
In a May 23 2006 presentation to ARM investors, ARM Inc. estimated its 2006
market share at 80-90% of the cell phone market, but only 21% of the larger
market. (The embedded world is big, folks.)
Drew highlighted five key growth areas for ARM between now and 2010…
[The first four are] set-top-box, high-definition television and DVD systems,
solid-state and hard disk drive storage, automotive electronics and 32-bit
microcontrollers. In these areas in 2006, ARM had market shares of 14, 20,
5 and 13 percent respectively… They are also market sectors that will
represent a total available annual market of nearly a billion cores or more
each in 2010. The biggest annual market opportunities are likely to be
automotive and 32-bit microcontrollers at 2.0 billion and 1.9 billion cores
ARM’s fifth key target market is the smart phone, where it is already
enjoying success. In this area the company shipped 250 million units in 2006
and has a market share of 83 percent, according to its own estimates.
Firebird 2.1.x will be included in the top most popular linux distributions
Here is the list of where firebird 2.1 is included or can be installed (I will create an table later)
- Debian [DONE] by Damyan Ivanov http://www.firebirdnews.org/?p=1715
- Ubuntu [DONE] in the next release Intrepid Ibex 8.10 imported from debian http://www.firebirdnews.org/?p=1718
- Fedora [Working] One friend of mine will upload in the main http://www.firebirdnews.org/?p=1649
- Gentoo [Done] http://www.gentoo-portage.com/dev-db/firebird
- Knoppix [Debian based] it should work by debian package or official tar.gz installer
- Linspire [Debian based] it should work by debian package or official tar.gz installer
- Mandriva [Will be DONE] by Philippe Makowski
- OpenSuse [Will be DONE] by Philippe Makowski
- PCLinuxOS [Mandriva based] it should work by Mandriva package or tar.gz/rpm installer
- Red Hat Enterprise Linux [Fedora Based] it should work by Fedora package or official tar.gz/rpm installer
- Centos [Fedora Based] it should work by Fedora package or official tar.gz/rpm installer
- Slackware [DONE] http://www.linuxpackages.net/pkg_details.php?id=12350 or official tar.gz installer
This feature was requested on ubuntu bug tracker and now fix is released in firebird2.0 for Ubuntu Intrepid Ibex
and in firebird2.1/firebird.2.0 for debian
I would really appreciate if you give these some testing.
2.0.4 is more urgent as this is what I very much want to release with
2.1.0 is possible for Lenny too, especially if 2.1.1 comes out soon.
Thanks in advance.
It is my pleasure to announce the widest architecture coverage for
firebird ever – amd64, arm, i386, ia64, mips, mipsel, powerpc, sparc
and amd64/i386 kfreebsd. Thanks to all porters! I hope alpha, armel,
m68k and s390 will get some porting attention too.
Testing more uncommon ports is also much appreciated.
Here is howto use it in debian
for the moment i have this in debian unstable
# aptitude update
# aptitude install -t experimental firebird2.0-classic
… tests … 🙂
# aptitude install -t experimental firebird2.0-super
… tests …. and same for firebird2.1-super/classic
If you watch the debian building logs for different architectures then there are a few ones left to be done , Itanium , Hppa and Alpha (dead one)
and seem that this will be solved very soon