>> 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

Reply via email to