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 [...]
If you get this message in firebird.log
Fatal lock manager error: semaphores are exhausted, errno: 1
It means that you sould try to increase semaphores count in firebird.conf.
This is an howto create your own ubuntu live cd with firebird/ubuntu and custom applications ,in guide ubuntu variation used was Xubuntu (is smaller and can be customized easier ) but it works for any hardy release
FirebirdConfig is free and provides you with a friendly user interface in order to configurate the firebird operation modifying the firebird.conf file with the most intuitive and functional graphic form
Server generated values - not only autoincrements are very useful think. Entity Framework supports two types “Computed” and “Identity”. When you update or insert entity, these fields are automatically refreshed according to state in database (after calling SaveChanges). For more info look at StoreGeneratedPattern.
If there were statistics on corrupted Firebird databases, I believe more than 80% of them would have something in common: they were running with forced-writes off.
Since Firebird 2.1 forced-writes also work in linux. With that in mind I put together a comparison between the two modes.
What are forced-writes and when to use them?
I hope DBAs [...]
After a long struggle on Devshed forums I decided to try on my own, after all I know Firebird and don’t see why it and ColdFusion can’t play nice together … infact they did, and easily.
Google led me to a comparison sheet about PostgreSQL and Firebird by AMSoftwareDesign, as it looks a bit outdated I decided to add some infos about the latest Firebird release, see it in action
Called SuperClassic, it will be the basis for the multi-processor support that we’ll see in Firebird 3.0.
Don’t lose count. Starting from Firebird 2.5 you will be able to choose among SuperServer, ClassicServer and SuperClassic.
Basically SuperClassic is like ClassicServer. Only instead of a process for each attachment it uses a single process with a thread for [...]
I want to implement software which needs a embedded database engine. I search this forum so many times. The language I must use C++. Then I have two methods to choice
When configuring a Windows machine for use by the Evolution™ payroll service-bureau system, a common step is installing the open-source Firebird database software; this Evo Tip details the process.
Firebird .NET provider has ability to create parameterized queries. Both named and unnamed parameters are supported. Everything works as you expect with select, insert, delete or update commands. The tricky part comes with stored procedures. Unlike MS SQL, that has direct support for named parameters, in provider, we’re parsing parameter names and we’re sending it [...]
http://home.lsces.co.uk/lsces/wiki/index.php?page=FirebirdSQL+Reference
Has MySQL updated to 6.0 and PostgreSQL updated to 8.2.
Some pages will request a login. That is because we are using private information to provide them and can’t allow access in the public domain.
With the growing concerns regarding comment SPAM, XSS attacks, security breaches, etc, we should spend some time learning how to defend ourselves against such threats.etc. So, let’s focus on securing our PHP server, thus barring most of the attacks from the start.
http://www.alberton.info/secure_php_installation.html
I’ve created this blog for one reason only. I just starting my first steps in database applications using .NET and I would like to share my experiences that I will face during my journey.
The major thing that affected my decision was the embedded database that gives you the ability to create standalone applications.
I added FlameRobin to ohloh.net. It took our code from repository and calculated the development cost: 1.200.000 USD. Wow, I guess nobody would want to invest that kind of money into FR, but we invested our time/work instead
rvbyron wrote on [Firebird-Architect]:
[See remaining text…]
Hi all,
I have seen some comparisons of Firebird to other open source
databases, however, the list is not very extensive. Further,
most [...]
I did a talk on various strategies of how to bridge relational databases and object-oriented programming. In retrospect I should have submitted this as a “double feature” talk, so that I could cover more ground on the actual using of the existing packages in the PHP space.
The other talk was on database locking. I think [...]
My use of Firebird started with its precursor, Interbase. I used Interbase for almost two years in a Delphi project, and at the time I was already doing some Firebird tests to see if it was a good alternative to Interbase. It was. It is. But I ended up not using it. From then on, [...]
Charles Nutter has been keeping an updated page of Rails test run results that shows progress towards the goal of a fully-functioning JRuby on Rails. Members of the JRuby team have already demonstrated Rails applications working on JRuby, and even ActiveRecord talking to databases via JDBC. To be clear, what we’re talking about here is [...]
I was doing some coding today and couldn’t find some routines I’ve used often in the past. Since I had to search for them, obeying my rule, they get posted here. Maybe they can be of use to others.
I knew 9 years of IB/FB experience would come in handy. [ED:wordpress firebird conversion in progress]
[See remaining text…]
wp-db is the mini database abstraction layer for WordPress. It allows you to run WordPress on various [...]
“Scribus is an open-source
program that brings award-winning professional page layout to
Linux/Unix, MacOS X, OS/2 and Windows desktops with a combination
of “press-ready” output and new approaches to page layout.”
[See remaining text…]
I am not involved or [...]