Simonov Denis wrote:
My list is as follows.
still would like to have implemented something safe from what it was
postponed FB3:
Groups of users and rights http://tracker.firebirdsql.org/browse/CORE-751
Ability to grant role to another role
http://tracker.firebirdsql.org/browse/CORE-1815
And
On 04/28/2014 06:29 PM, Carlos H. Cantu wrote:
5) An embedded Firebird version for Android (even if only basic
server features could be available):
http://tracker.firebirdsql.org/browse/CORE-3885
Why do you treat it as post-v3? I plan to activate work with Android
port after beta1.
On 04/28/2014 09:59 PM, Dmitry Yemanov wrote:
A scheduler for firebird would totally eliminate my own use of custom
applications tied to database events/time events.
Architecturally, Firebird database is not active without user
connections. This slightly changes with the LINGER support, but
29.04.2014 02:13, Thomas Beckmann wrote:
Main focus should be in asynchronous multi master scenarios, as Carlos
pointed out. Everything else seems to be as specialization...
Dimitry Sibiryakov will surely correct me, but I always thought that
multi-master replication can hardly work without
28.04.2014 23:05, Carlos H. Cantu wrote:
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
On Mon, 28 Apr 2014 15:36:45 -0300, Adriano dos Santos Fernandes
adrian...@gmail.com wrote:
On 28/04/2014 15:30, Dmitry Yemanov wrote:
2. Add JAVA, .NET PROCEDURE and FUNCTION (not just C++)
You can do it in v3 as soon as someone writes the required interfacing
plugins (external engines).
28.04.2014 23:31, Dalton Calford wrote:
Architecturally, Firebird database is not active without user
connections. This slightly changes with the LINGER support, but not so
much. So the question is who should be waiting for the timer events when
nobody is connected. And if it
I know people will feel outraged with my opinion, but anyway: make DDL
operations atomic and immediate.
This is the Oracle way.
Atomic and immediate means autocommitted or always executed in a
separate (e.g. system) transaction?
I have strong opinion that system transaction must
29.04.2014 02:02, Dimitry Sibiryakov wrote:
I may be wrong as often, but AFAIU this dream may be a reality if:
1) Eliminate DFW
2) Perform DDL (operations with system tables) in user transaction
3) Make garbage collector to handle system tables well
And reimplement the undo log to handle
On Tue, 29 Apr 2014 11:58:57 +0400, Dmitry Yemanov firebi...@yandex.ru
wrote:
Who should initiate that dedicated listener deamon/user after a server
restart? Should the server attach all the databases itself to check
whether one needs a startup? What about databases unknown to the server
29.04.2014 12:09, Mark Rotteveel wrote:
If you look at SQL Server, there jobs themselves are not defined for a
specific database (although they may depend on one or more databases).
AFAIK they are stored in the master database. Execution requires an Agent
service to be running.
We neither
On 04/29/2014 12:03 PM, Vlad Khorsun wrote:
I know people will feel outraged with my opinion, but anyway: make DDL
operations atomic and immediate.
This is the Oracle way.
Atomic and immediate means autocommitted or always executed in a
separate (e.g. system) transaction?
I
29.04.2014 10:03, Dmitry Yemanov wrote:
29.04.2014 02:02, Dimitry Sibiryakov wrote:
I may be wrong as often, but AFAIU this dream may be a reality if:
1) Eliminate DFW
2) Perform DDL (operations with system tables) in user transaction
3) Make garbage collector to handle system tables
29.04.2014 12:03, Vlad Khorsun wrote:
So, i see autocommit as only possibility, if we choose Oracle way
Out of curiosity, why cannot it be done in a separate *non-system*
transaction? I.e. instead of committing user transaction start we and
immediately commit a new one.
Technically
29.04.2014 11:05, Vlad Khorsun wrote:
Practically - what generation of altered object
user transaction should work with ?
According to its isolation level, I'd say.
--
WBR, SD.
--
Accelerate Dev Cycles with
29.04.2014 13:12, Dimitry Sibiryakov wrote:
According to its isolation level, I'd say.
So user snapshot transaction should not seen changes done by itself (as
user thinks, as it executes DDL in the same transaction)? Of course it
can be documented, but I'd rather avoid such a tricky behavior.
29.04.2014 13:05, Vlad Khorsun wrote:
Technically - it is possible. Practically - what generation of altered object
user transaction should work with ?
Statements already having the object cached - the old version.
Statements to be [re]prepared - the new version, as the metadata cache
will
29.04.2014 11:17, Dmitry Yemanov wrote:
So user snapshot transaction should not seen changes done by itself (as
user thinks, as it executes DDL in the same transaction)?
That's why I think that executing DDL in separate autocommit transaction is
a bad idea.
--
WBR, SD.
29.04.2014 11:07, Alex wrote:
On 04/29/2014 12:49 PM, Dimitry Sibiryakov wrote:
May be stop separate metadata cache at all and use ordinary data cache
for reading
system tables directly every time.
And have prepare time increased many times...
Not an option due to performance
On 04/29/14 13:49, Dimitry Sibiryakov wrote:
29.04.2014 11:07, Alex wrote:
On 04/29/2014 12:49 PM, Dimitry Sibiryakov wrote:
May be stop separate metadata cache at all and use ordinary data
cache for reading
system tables directly every time.
And have prepare time increased many
5) An embedded Firebird version for Android (even if only basic
server features could be available):
http://tracker.firebirdsql.org/browse/CORE-3885
A Why do you treat it as post-v3? I plan to activate work with Android
A port after beta1.
Really?! That's a great news!!!
[]s
Carlos
DY 28.04.2014 23:05, Carlos H. Cantu wrote:
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
DY 29.04.2014 12:09, Mark Rotteveel wrote:
If you look at SQL Server, there jobs themselves are not defined for a
specific database (although they may depend on one or more databases).
AFAIK they are stored in the master database. Execution requires an Agent
service to be running.
DY We
29.04.2014 14:24, Carlos H. Cantu wrote:
You are right about the DB design, but that's up to the user. You
dont and should not worry with this.
But the one who implements built-in replication will have to worry about
conflict
handling, constraint failure and so on.
In the case of
On 04/29/14 16:32, Carlos H. Cantu wrote:
DY 29.04.2014 12:09, Mark Rotteveel wrote:
If you look at SQL Server, there jobs themselves are not defined for a
specific database (although they may depend on one or more databases).
AFAIK they are stored in the master database. Execution requires
On 29-4-2014 14:45, Alex Peshkoff wrote:
We do not have single fixed security database in FB3. Therefore us of it
as jobs storage is not good choice. Adding new one looks better to me.
But once again embedded problem is here - up to the fact that embedded
user may have no rights to start
Hi,
At April 29, 2014, 5:09 AM, Mark Rotteveel wrote:
On Tue, 29 Apr 2014 11:58:57 +0400, Dmitry Yemanov firebi...@yandex.ru
wrote:
Who should initiate that dedicated listener deamon/user after a server
restart? Should the server attach all the databases itself to check
whether one needs
MR On 29-4-2014 14:45, Alex Peshkoff wrote:
We do not have single fixed security database in FB3. Therefore us of it
as jobs storage is not good choice. Adding new one looks better to me.
But once again embedded problem is here - up to the fact that embedded
user may have no rights to start
On 04/29/14 16:46, Daniel Rail wrote:
Hi,
At April 29, 2014, 5:09 AM, Mark Rotteveel wrote:
On Tue, 29 Apr 2014 11:58:57 +0400, Dmitry Yemanov firebi...@yandex.ru
wrote:
Who should initiate that dedicated listener deamon/user after a server
restart? Should the server attach all the
-Original Message-
From: Dmitry Yemanov [mailto:firebi...@yandex.ru]
Sent: Martes, 29 de Abril de 2014 3:44
29.04.2014 01:21, Claudio Valderrama C. wrote:
I know people will feel outraged with my opinion, but
anyway: make DDL
operations atomic and immediate.
Atomic and
On 4/24/2014 6:19 AM, Dmitry Yemanov wrote:
All,
We're getting closer to the v3.0 feature freeze which is going to happen
this summer. Everything roadmapped for v3 but not implemented before the
deadline will be postponed. The next-after-v3 release is likely to
incorporate most of the postponed
On 29/04/2014 12:04, Dmitry Yemanov wrote:
29.04.2014 18:11, Claudio Valderrama C. wrote:
Maybe true for the current FB code, but not generally. Other
databases can handle this reliably.
But they have a limited degree of data versioning, if any.
AFAIK, PostgreSQL can handle transactional
I regularly build fb3 and then run a script to drop and rebuild a database.
The script terminates normally, but when I type 'show tables', isql crashes.
This has been happening for some time.
On restarting isql, the command works correctly.
The script calls many other scripts and changes the
While you mention PDP maybe is time for a task to cleanup all VMS dead
code and languages (Claudio ?)
Also we soon need to reserve PowerPC64 Little-Endian
http://cdimage.ubuntu.com/ubuntu-server/daily/current/
https://wiki.debian.org/ppc64el/
On Tue, Apr 29, 2014 at 3:10 PM, Alex Peshkoff
So, for Firebird, I think that it would be up to the user and/or the
software developer to decide how they would want to execute such
tasks(either creating their own service, or using a batch/script to
execute the commands scheduled via a task scheduler). As an example,
our application has a
29.04.2014 20:40, marius adrian popa wrote:
While you mention PDP maybe is time for a task to cleanup all VMS dead
code and languages (Claudio ?)
Is there any VMS code remaining? We had wiped it out a while ago, IIRC.
Only a few pieces were kept, related to the DLM (in tra.cp and /lock).
Or,
Have a standard client/daemon such as gstat/gfix/gsec ship with firebird
that when started, it is provided with a config file or command line
specifying the database to use.
In this way, any database could be the master database as long as it has
the appropriate data structures in it.
The
lower function does not get lowercase in some case
--
Key: CORE-4410
URL: http://tracker.firebirdsql.org/browse/CORE-4410
Project: Firebird Core
Issue Type: Bug
Affects Versions: 2.5.2
Den 2014-04-29 20:52 skrev Dalton Calford såhär:
Have a standard client/daemon such as gstat/gfix/gsec ship with
firebird that when started, it is provided with a config file or
command line specifying the database to use.
In this way, any database could be the master database as long as it
You might be interested to know that gpre, gbak, and dudley were initiated
on a PDP-11 based Pro-350 running Zenix (no, not Xenix) loaned by DEC. I
cut over to an Apollo DN-300 at the earliest opportunity to take advantage
of a 32 address space and gigantic 3MB of physical memory. The Apollo
On 4/29/2014 8:38 AM, Dimitry Sibiryakov wrote:
29.04.2014 14:24, Carlos H. Cantu wrote:
You are right about the DB design, but that's up to the user. You
dont and should not worry with this.
But the one who implements built-in replication will have to worry about
conflict
handling,
Hi,
If we talking about synchronous replication then what problem with extending
shadow files feature to support it?
Regards,
Karol Bieniaszewski
- Reply message -
Od: Jim Starkey j...@jimstarkey.net
Do: firebird-devel@lists.sourceforge.net
Temat: [Firebird-devel] Replication
Data:
42 matches
Mail list logo