I’ve got a database problem.
So I’m throwing this out to the rather small readership I have here in the hopes that someone knows some SQL code or something that can help us out.
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 [...]
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
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 [...]
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 [...]
For those tired of maintaining separate code bases for Web and desktop applications, Servoy offers a way to consolidate those code bases and cut development time in half.
Servoy apps can access many different databases, including Firebird.
More information here.
The application was a test-bed app that uses the FireBird SQL database to handle sessions and dynamic data, all on the same machine. [Performance Tip :Seems that you need to put KeepAlive Off on apache to server many images and too many clients :If you have more clients than available apache children, KeepAlive settings will [...]
Firebird has some funny ways of handling passwords. The maximum length of passwords that is evaluated is 8 characters. Every character after the 8th is silently ignored. That’s especially funny because the ‘default’ password for a Firebird-installation is ‘masterkey’, which has 9 characters. You can, however, successfully log in to freshly installed Firebird-servers providing the [...]
If I end up going with Firebird, then I’ll most likely be using the IBObjects components. I’ve used these before at a customer’s site and have been impressed at the genuine speed that results.
See full post here.
Thanks to Steve Ramacher, who sent me this info.
We run our business on a couple of AS400 mid range computers (we are in the process of converting to MS Dynamics AX). We use BPCS for out ERP system. 7 years ago we started running into situations where we need to archive our reports to externals [...]
The ministry’s Money Laundering Prevention Directorate (MLPD) used Gnu Privacy Guard (GPG) between 2004 and 2007. This is Open Source software for encrypting and electronically signing data, allowing it to be transmitted securely even through public networks. The directorate also uses the Open Source relational database management system Firebird. “Both the banks and the MLPD [...]
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.
One of the most important new features in Plastic 2.0 is the distributed system. Today I’m going to talk about the set up I’m using to work from my laptop, disconnected from any network, and how I use the distributed system to synchronize changes back and forth.