>> 2) I second Jesus Garcia request for native replication, since people at >> FDD and in FireBase's list are always claiming about the lack of such >> feature.
DY> Replication is a too common word. What do they really need? Warm DY> standby? Hot standby? Sync replication? Async replication? Multi-master? DY> Maybe point-in-time recovery? Maybe FB->Oracle or vice versa? I think most of them needs basic asynchronous replication, covering single and multi-master scenarios. For those who needs more complex scenarios, there are third party comercial tools. Anyway, I'm not the right person to answer, since I didn't need replication in my projects so far, so I'll leave this for Jesus or any others to answer. If you are interested, I can run a poll at firebirdnews.org and firebase about what users would expect in "native" FB replication. >> 4) A way to access data in external files/non-fb-databases . AFAIR, >> this was planned as an extension of currently "execute statement" DY> I don't remember promises for external files, although it might be DY> doable. I'd rather settle on non-fb-databases for the time being. DY> It means we need someone with non-fb-database API knowledge to implement DY> a plugin. Volunteers anyone? Or we may create some common (ODBC / JDBC / DY> ADO.NET) plugins and don't care about the rest. But again, volunteers DY> anyone? Afair, the idea was to use ODBC/JDBC as source. My chat about this was with Vlad, long time ago. Probably he can give more details about what he was thinking about. >> 7) It is known that mixing DDL/DML in the same transaction can cause >> corruption in DBs. If this cannot be 100% fixed, I suggest to >> introduce some mechanism to detect such situation and avoid the >> execution of the statement before corruption happens. DY> Maybe my memory is failing, but I don't remember corruptions because of DY> this reason. v1.0 and v1.5 don't count. I asked Alexey and seems that most of the previous problems are fixed, but dropping tables with active connections still causes corruption. Maybe he can give more details. >> 8) Enhancement to the numerics calculations. The currently rule of >> summing the scale of the types involved in muls/divs is very bad and >> can easily cause overflow. Maybe FB could automatically truncate the >> result to the maximum precision possible to accommodate the final >> value. Even better if the truncation happens only in the final result >> (not during the internal calculations). DY> Blame me for delaying it again and again. But I don't agree with DY> truncations, Mark is right that a longer precision is a better way to DY> go. However, longer NUMERIC/DECIMAL data types and longer intermediate DY> results during calculations are two different things, even if related. DY> Please create a ticket so that I can have it assigned. Done: http://tracker.firebirdsql.org/browse/CORE-4409 >> I suggest that if some of those features are impossible to be >> implemented, their existing tickets should be marked to "Wont/Fix" and >> the details of "why" be added to the comments. DY> Usually the problem is not implementation possibility but need and DY> reasonableness. Whatever the reason is, if it will not be done, it should not be left "open". []s Carlos http://www.firebirdnews.org FireBase - http://www.FireBase.com.br ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel