Database level Triggers, Firebird
Tutorial about database level triggers (on connect , disconnect …) in Spanish
(No Ratings Yet)
Loading...Firebird and MS Sync Framework
Few days ago I was playing with Sync Framework (if you’re able to read Czech, you can check my series about it). You know, all testing and exploration I was always doing with SQL Server on server side. 🙂 But this should work with any ADO.NET “equiped” database. So why not to test Firebird?
(No Ratings Yet)Loading...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
(No Ratings Yet)Loading...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 ]
(No Ratings Yet)Loading...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.
(No Ratings Yet)Loading...Two weeks for FBConf 2008!
Subscribe now and meet several Firebird developers and gurus. You will have the chance of getting all that hard questions answered by the best people in the world 😉
(No Ratings Yet)Loading...Firebird x InterBase 2009
Paul Beach posted some comments about the SDTimes article “InterBase 2009 comes with multicore support” in his blog. Don’t forget to take a look at them.
(No Ratings Yet)Loading...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?
(1 votes, average: 5.00 out of 5)Loading...What page size should I use?
It’s a common question with interesting background from developers . As I can suppose from IBSurgeon statistics, 99% of Firebird and InterBase developers use default page size: since the old ages it is 1024 bytes, and only for Firebird 2.0 it is changed to 4096 by default. There are 4 main things related with page size: indices depth, database cache size, records per page quantity and disk cluster size.
The shortest answer to this question is to use 4k, 8k or 16k page size. That’s it.
If you want to go a bit deeper, keep reading…
(1 votes, average: 5.00 out of 5)Loading...DDEX Provider v2.0.4 for Visual Studio
The DDEX Provider v2.0.4 for Visual Studio has been released. Download it from
http://www.firebirdsql.org/index.php?op=files&id=netprovider.
(No Ratings Yet)Loading...