I am working on my first WinForms application with a Firebird database shared over a network. Now I wonder how should I ensure database backup and restoring? Up till now, my applications used embedded databases (SQLite), so I was sure that only my application accessed the database. The application itself was responsible for the backups ...
I just upgraded my BDS2006 Prof to D2010 Prof. I usually use Interbase component (TIBDatabase, etc) to connect with the database. I am thinking about other alternative components. Sadly, Zeos component (6.X) currently still not working with D2009/D2010. DBExpress support FB connection but not in Prof. Version (only in Enterprise/Architec...
I need query (to be more specific, it is view, not query) that will return string column. String will be code, that might be prefixed with two letters (LJ). If it is prefixed -- prefix have to be trimmed. If there is no prefix present, it should be left untouched. Is it possible to do such thing in SQL? Server is FirebirdSQL 1.5. Non...
After I close my application fbclient.dll remains in memory for about 3 seconds. So it locks the database file and prevents my application from unloading. I'm using Firebird embedded. The problem is related to events. I signup to events using isc_que_events. If I don't signup to events dll unloads instantly. I faced this problem in pre...
I mean, even if the database is empty, you have to drop a varchar(50) field and recreate it to make it varchar(30). Not to mention constraints... This is very frustrating. I am the SYSDBA and Firebird make very simple things way harder than it should be. If I voluntarily decide to shoot my own feet, then by all means, let me do so! So ...
i am using jdbc to connect to a database server the connection is over a wireless network and can be dodgy at times at the moment when the connection is lost they need to close and restart the application does anyone have some examples of code, where i could write some sort of wrapper to automatically reconnect and rerun the last query,...
I am weighing my options for integer primary keys that can be used in multi master replication. (I'm pretty much sold on using integer keys instead of GUIDs) The best I can come up with is having the most significant data first and having the server number last: eg. invoice 1 on server 1 = 101 invoice 1 on server 2 = 102 where the non s...
Hi all, Can we set the index active when another transaction is in progress. Will firebird wait till the other transaction completes its operation and the index will become inactive/active (this is for reindexing) after that ? Thank you. Regards, Sabu ...
Basically this task is pretty easy when you think about it... but i found no Answers in Microsoft Access or MSDN. I have to create a connection to an new Database and query the old one. After validating the old data, everything is written in a new fine Form to the my new Database. Any Ideas? Add: Old Database is an Firebird Database. T...
I'm developing an app which will have a central database users can add entries to. The database will have to be on a server somewhere but I want the users to be able to add entries offline. The app will sync to the main db when connection is available. So, I supose I need 2 databases - the main one sitting on a server (preferably linux) ...
I'd like to create a new Firebird database in my C# client application. Is there a command line utility that lets you do this? ...
So I'm an MSSQL guy and I have been for a while because it's what I've always used in my workplaces. So when I create a new project I'm usually inclined to just grab a copy of SQL Express and start working from there. However, I've been asked to work on a new project but for various reasons, we can't use SQL Express edition and the lice...
My SQL database (Firebird) has a table named tTransaction. It contains two columns, senderFK and receiverFK. There are three other tables, tBufferStock, tFacility and tOutsideLocation. A sender or a receiver can be either a buffer stock, our own facility or a location outside. My problem is that I don't know how to let senderFK or rece...
I have written a psychological testing application, in which the user is presented with a list of words, and s/he has to choose ten words which very much describe himself, then choose words which partially describe himself, and words which do not describe himself. The application itself works fine, but I was interested in exploring the m...
I am researching the possibility of using Firebird for a project. However, one potential problem is replication and failover, or rather, lack of a (subjective) "good" solution. There are several potential solutions listed in the Firebird FAQ but they are either 1) Windows-centric; 2) horribly outdated; 3) commerical; or 4) not full-f...
Currently, I have an application that uses Firebird in embedded mode to connect to a relatively simple database stored as a file on my hard drive. I want to switch to using PostgreSQL to do the same thing (Yes, I know it's overkill). I know that PostgreSQL cannot operate in embedded mode and that is fine - I can leave the server process ...
We have a data collection system that collects measurements from environmental sensors that measure velocity of water flowing through a river or channel. Each measurement generates a fixed number of values (e.g. Date, Time, Temperature, Pressure etc.) plus a list of velocity values. Originally the sensors supplied three velocity values s...
I need to export entries in a table to an .ini file. I need to set this up as a trigger that is performed each time the table is updated. So if the fields list for the table is MessengerIPAddress, MessengerPort it would ouput [Messenger] IPAddress=fieldvalue Port=fieldvalue ...
I'm looking to use either Firebird or Postgres in my next development project ... largely because both are available under a BSD-like license. I found a great comparison of the two database at http://www.amsoftwaredesign.com/pg_vs_fb But this comparison is a good 2+ years old and both databases have come a long ways since. Does anyone...
In Firebird 2.0, is using an explicit transaction faster on a SELECT command than executing the command with an implicit one? ...