Re: [Firebird-devel] Planning the post v3 development

[Dalton C. <dal...@gm...>]

Hi Dmitry,


On 28 April 2014 13:59, Dmitry Yemanov <fir...@ya...> wrote:

> Isn't sqlite solid enough? ;-) At least for the tasks a tablet can run.
>
>
Today's tablets blow away the server systems I used to run interbase on.
In some cases, they are more powerful than some realtime firebird servers
we have - don't question the power of cell phones and tablets, they will
amaze you.



> > 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 not so
> much. So the question is who should be waiting for the timer events when
> nobody is connected. And if it should be the server's (not the engine's)
> feature, then what to do with the embedded setup?
>
> You should be able to define a database daemon/virtual user that runs as a
separate transaction space.   If defined and active, the database would
always be running.




> > Database links, which would require the Object names and schema support
>
> I fail to see how they would require one or another. Or maybe I just see
> database links completely differently.
>

Well, picture schema that can contain schema ie
 database.schema_level1.schema_level2.schema_leveln.database_object.

In this case, you could attach the root of a remote database as a
branch/schema to the current database.



>
> > For example, you could put each schema into a remote server/database
>
> Your imagination surely takes a lead over mine. I've never thought of
> the database links this way. And I'm not really sure I want to.
>
>
The key here is, don't limit the end user/developer, give the tools and let
them shoot themselves in the foot.

Firebird and Interbase before it, was all about the flexibility/power in an
easy to use package.   But, it always assumed that the users where
intelligent and capable, instead of trying to make the simplest system for
the lowest common denominator.

;)