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?
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
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 ]
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.
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
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
To blob or not to blob… good question!
I guess if you develop data intensive applications dealing with large files at some point, you’ve thought about it at least once: should I put my data files inside the database or should I write them directly to disk?
Ok, so here’s my point:
storing files in Firebird is faster than writing the same files on the filesystem!
The final version of SP1 for VS2008 and .NET 3.5 is out for a while. And you may noticed, that there were some [more …]
The list of open issues for Lazarus 0.9.26 is getting smaller by the day. Most are fixed. Some are re-targeted to 0.9.28, if we estimate it takes too long fix them now. Some are re-targeted to 1.0.0, if closer inspection turns out the bug is not a regression.
While on vacation I’ve been working on a pet-project that has been around for many years now. The service is a mobile device chat and is powered by Firebird and PHP.
There used to be lots of problems handling more than 400 simultaneous users, but after a DB upgrade to Firebird v2.5 Alpha 1 things really look different.
