Since we are talking datatypes, I wonder if some other datatypes could be
considered.
UUID - a native supported UUID type without the need for domain declaration
including support for using it in identity type columns.
TCP4 or TCP6 (32bit unsigned and 64bit unsigned values).
Currently we make
We use Oracle and table spaces. We specify which drives/drive channels
hold which data/tables/indexes to optimize various OLAP/OLTP needs.
We also use firebird. We use multiple files as large multi-raid drive
arrays have problems in that the larger arrays may have multiple drives
fail faster
Changing a column definition for a column defined with a domain, should
result in an error.
ie
alter table alter type should not work for columns that use domains.
but the following should work (syntax to be agreed upon as I have seen it
used differently in different databases)
alter table X
Nicolay,
I am wondering if you ever considered adding large sql identifiers and
schema to your implementation?
On 19 September 2014 18:33, Nikolay Samofatov
nikolay.samofa...@red-soft.biz wrote:
Hello, All!
I implemented intermediate versions GC algorithm and tried to run some
stress tests
I still argue that we should take the opportunity to not only fix this
issue, but to improve the FB product functionality.
The core requirement is to stop non-authorized users from viewing source
code. The current process is to delete the source code from the database.
There is also the common
16:49, Dalton Calford wrote:
So, DDL statements such as GRANT VIEW which is used by MS SQL for
metadata security could
be applied to FB.
No, they couldn't unless Firebird is run in controlled environment
which is not the
case of topic starter.
--
WBR, SD
.
On 9/4/2014 10:49 AM, Dalton Calford wrote:
I still argue that we should take the opportunity to not only fix this
issue, but to improve the FB product functionality.
The core requirement is to stop non-authorized users from viewing source
code. The current process is to delete
it has not already made
it's way back into the core product.
On 4 September 2014 11:17, Geoff Worboys ge...@telesiscomputing.com.au
wrote:
Dalton Calford wrote:
I still argue that we should take the opportunity to not only
fix this issue, but to improve the FB product functionality.
Part
That would mean that the de
On 4 September 2014 12:10, Geoff Worboys ge...@telesiscomputing.com.au
wrote:
Dalton Calford wrote:
[...]
What it does mean, is that if someone tries to connect to a
database that is fully encrypted and their client does not
securely pass the decryption key
On 29 August 2014 08:53, Dimitry Sibiryakov s...@ibphoenix.com wrote:
Actually, they have to ask themselves if the sources are precious
enough to waste time
for their protection. AFAIK, database itself is usually pointless without
application that
works with it.
Not always true.
I have
option as an
appropriate manner of dealing with the problem without breaking any
existing applications.
best regards
Dalton
On 29 August 2014 09:51, Dalton Calford dalton.calf...@gmail.com wrote:
On 29 August 2014 08:53, Dimitry Sibiryakov s...@ibphoenix.com wrote:
Actually, they have
Hi Dimitry,
May I ask why you say a database system is not suitable for CVS? I had
ours on cvs for a few years before moving it to git.
If you view the operational database as source code, then I can understand
your point, but, I view an operational database as a compiled end product
while the
...@lawinegevaar.nl wrote:
On 12-8-2014 19:22, Dalton Calford wrote:
May I ask why you say a database system is not suitable for CVS? I had
ours on cvs for a few years before moving it to git.
If you view the operational database as source code, then I can
understand your point, but, I view
I wonder - is there anyway via sql to get access to the comments other than
via the system tables?
Shouldn't there be something like a DESCRIBE statement as a corollary to
COMMENT ON?
A DESCRIBE DDL or DESCRIBE DEPENDENCIES giving a standard tool via sql for
database developers would be perfect
that is isql only - try it in any other tool.
On 28 July 2014 12:12, Adriano dos Santos Fernandes adrian...@gmail.com
wrote:
On 28/07/2014 12:08, Dalton Calford wrote:
I wonder - is there anyway via sql to get access to the comments other
than via the system tables?
show comments
Hi Dmitry
On 28 July 2014 14:39, Dmitry Yemanov firebi...@yandex.ru wrote:
Yes, it's actively developed. No, it doesn't support schemas. I don't
think you can have/use schemas without recompiling all those thousands
of existing applications and/or their underlying database connectivity
It would be nice if there was an option for visibility ie
GRANT VISIBLE FOR OBJECT TYPE OBJECT TO [USER|ROLE] user/role name
[with grant option];
REVOKE VISIBLE FOR OBJECT TYPE OBJECT FROM [USER|ROLE] user/role name;
With a default of all things being visible to maintain backwards
Hi Roman,
On 14 July 2014 08:37, Roman Simakov roman.sima...@gmail.com wrote:
I do not think that separate operators for these are good. It can lead
to inconsistence like user has permissions on object but cannot see
it.
Actually, that is preferred. For developers and power users, we can
Failures happen.
No matter how much you spend, how much time you design, failures happen.
You might even have a boss who thinks its fun to randomly shut off machines
to ensure the load balancing and fail over systems work
So, you design with failure in mind.
This is a discussion that
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
Hi Dmitry,
On 28 April 2014 13:59, Dmitry Yemanov firebi...@yandex.ru 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
My quad core, 1.7 ghz 2 GB ram/32 GB storage phone, is more powerful than
our scp systems which have been processing millions of customer calls in
real time over the past 14 years.
Android also runs on tablets, some of which are far superior than the
average desktop pc from five years ago.
I
if firebird supported namespaces/schema AND longer identifiers, this would
be alot simpler...
On 27 August 2013 14:11, Leyne, Sean s...@broadviewsoftware.com wrote:
On 27/08/2013 14:11, Dmitry Yemanov wrote:
27.08.2013 20:03, Adriano dos Santos Fernandes wrote:
I think an USING
Hex encoded - and with some engines, you can specify compressed (read
zlib) output.
I have seen multiple different implementations of the extract
including some that use multiple different files in sub-directories,
while others extract to xml.
It all depends upon the engine and the purpose of
On 19 November 2012 12:52, Ann Harrison a...@qbeast.net wrote:
I assure you that MySQL dump produces a text file containing insert
statements.
Best regards,
Ann
Oh, I believe you, as I have seen them/used them, but like I said, I
could not imagine anyone (implied 'reasonable') using them
On 1 November 2012 09:23, marius adrian popa map...@gmail.com wrote:
Maybe is time for Dialect 4 with all the Dialect 3+1 fixes
Perhaps with longer SQL Object identifiers ie CHAR(80) UTF8 and schema
support ie select * from SCHEMANAME.TABLENAME so that it is easier to
migrate from other
If possible, the linux servers should support pam authentication (default
linux security authentication) which means they can also support microsoft
active directory once the linux machine is setup correctly (simple install).
My concern is the length of the user identifiers - if the users have a
On 29 May 2012 03:51, Alex Peshkoff peshk...@mail.ru wrote:
There is syntax problem with providing comments on privileges -
privileges do not have names.
Is it not possible to extend the syntax of the comment on DDL? for example
COMMENT ON [SELECT|UPDATE|INSERT|DELETE|ALL] GRANT FOR
On 29 May 2012 03:56, Dimitry Sibiryakov s...@ibphoenix.com wrote:
Why not to keep all comments in a separate table? It should decrease
fragmentation of
main tables and speed up work with them.
This sounds reasonable
Greetings,
I want to discuss this before posting it to the wish list section of the
bug tracker to see if others see value in the suggestion or have a better
suggestion for implementation.
I am currently using a diagramming tool that allows extensive comments upon
referential integrity
Why not have all password connections use a single default encoding
regardless of the overall codepage that is in use?
Select a codepage, make it the password default, have the client libraries
understand this and you are no longer worried about differences in client
code pages.
On 1 March 2012
Quick Question in regards to passwords and user names in general,
Has the max length of User names, Passwords and System objects been
increased in FB3?
With a 31 Char limit and UTF8 some users can be severely limited in their
use of FB unless the limits are increased substantially.
regards
Actually, the telecom standard is 99.999% uptime which is referred to
as a Five-Nines system and we have had this for over a decade with
Firebird, running 24/7/365.
Our transaction count is quite high, if you consider the number of
databases being queried in parallel to perform the various tasks,
How about a command that actually shows the comments on an object
without having to read the system tables?
Security grants for creating and viewing the comments?
Right now you can use various tricks to grant and revoke rights on
system tables, giving various levels of security, but there is no
Is Fyracle still active?
I am wondering if the project is moving ahead or if it has stalled?
--
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing
Thanks Carlos, much appreciated.
On 27 October 2011 15:38, Carlos H. Cantu lis...@warmboot.com.br wrote:
Afaik, it is dead in the since of not being updated for years.
Also, afaik, Fyracle owner used to follow FB-Architect list. Yoy may ask
this there and get some official answer ;)
[]s
Being able to spread a database across multiple files is a great
feature when moving large databases on devices that do not support
large file support - such as 32GB thumb drives that still use a form
of FAT32 for their file system.Sure we can format them up with a
different filing system but
1 - you are still using a Win98 system and so NTFS isn't supported???
NTFS is not supported on some forms of solaris, linux and other OS's
we have in the office - windows is not the only operating system on
the market and many standalone devices only support the win98/fat32
formats due to MS
38 matches
Mail list logo