Running Plastic on Ubuntu and Firebird
What would you think is harder to do? Run a .NET Client/Server application through mono on Linux or install Ubuntu on Microsoft’s Virtual PC?
Here is the long answer
Author: mariuz
http://wiki.ubuntu.com/Mariuz
Database level Triggers, Firebird
Tutorial about database level triggers (on connect , disconnect …) in Spanish
Primary Database in Use – Firebird ?
Survey Results – Primary Database in Use on LewisC’s An Expert’s Guide To Oracle Technology
I’m starting to gather the data from my survey. When I get all the data gathered, I will post it as a downloadable file. Until then, I will post some summary data. This data shows the current PRIMARY database in use at the respondents companies. I find the data suspect and you’ll see why. This data has not been cleaned and duplicate IP addresses have not been removed. This is totally raw data and should remain suspect until after cleansing. Still, it is interesting.
|
Primary Database |
Percentage |
Respondents |
|
Oracle |
20.38% |
65 |
|
DB2 |
5.96% |
19 |
|
SQL Server |
8.78% |
28 |
|
MySQL |
25.39% |
81 |
|
Teradata |
0.31% |
1 |
|
Ingres |
0.00% |
0 |
|
Postgres |
7.21% |
23 |
|
SimpleDB |
0.00% |
0 |
|
Firebird |
25.71% |
82 |
|
LucidDB |
0.00% |
0 |
|
Vetica |
0.00% |
0 |
|
Sybase |
0.63% |
2 |
|
Netezza |
0.31% |
1 |
|
Access |
0.31% |
1 |
|
Excel |
0.63% |
2 |
|
xBase |
0.63% |
2 |
|
ADABAS |
0.00% |
0 |
|
Alpha 5 |
0.00% |
0 |
|
Filemaker |
0.00% |
0 |
|
IMS |
0.00% |
0 |
|
Informix |
0.63% |
2 |
|
SQLite |
0.63% |
2 |
|
Paradox |
0.00% |
0 |
|
Progress |
0.00% |
0 |
|
Other |
2.51% |
8 |
I have serious doubts that Firebird is primary database at 25.71% of the respondents. I think I may find some duplicate IP Addresses with that answer. I’m not really surprised at the remainder of the answers though.
I also posted a summary of countries who answered and a few questions on open source software usage.
LewisC
Multi-file Database ?
Some last database repair cases we did were with multi-file databases. Interesting, that latest InterBase and Firebird versions was used, and also file system for the storage was NTFS, not FAT32 and FAT16. But, the databases was created and maintained using 1 gigabyte files.
[ED: seems that is better to put the database on an good file system and in an single file ]
Random selection, with a bias ..
Say you want to randomly select your employee of the month, but not so randomly, better, you’d like to give your best employees a bigger chance to be selected based on their rating.
This is just an example, you could be randomly displaying ads from your customers, but giving an higher chance to be displayed to those who are paying more, there can be a million other example, but I hope you got the sense of this.
Firebird and Ruby on Rails
On Firebird-tools Pierre Yager asked about Firebird Ruby ActiveRecord Adapter
Does any one knows any project on maintaining an ActiveRecord-Firebird-Adapter?
Firebird 2.1 Domains in PSQL
Mario H. Cornejo wrote in his blog about creating domains in Firebird 2.1
Firebird on small windows machines
How to put firebird and dotnet framework on small windows machines (based on pentium @233Mhz)
Part 1 http://vault-co.blogspot.com/2008/08/98lite-megacheap-embedded-windows.html
and Part 2 http://vault-co.blogspot.com/2008/08/nano98-windows-in-7-seconds-45.html
Firebird 2.1.1 for Ubuntu released
The Firebird 2.1.1 packages are now in ppa for Ubuntu Dapper, Gutsy , Feisty , Hardy and Intrepid Ibex
The guide for installing is located in the ubuntu wiki
Also there is an released version in debian experimental
It’s an recomended update if you are still using firebird 2.1.0
Lazarus with Zeos components for Firebird tutorial
Here is the tutorial with screenshots in French , but from images you can follow the lazarus wizzards and it should be ok in any language