I do not like C-styled languages. If Java was muti-langauge at its roots...
IF there will be share of.NET applications, that are compatible with ECMA standardf and do not need MS-only extensions to it, i will move towards. Otherwise... At least 'no news' will make not thinggs worse:-)
Is Mono (or better and faster www.DotGNU.org) closer to native code than Java?
I hope sooner or later SuperCompiling (www.refal.org) will be completed for Java, then.NET will go to sleep.
On the other hand, let Java be highly optimised server environment, and let.NET be relativelly slow client environment (non-optimised but enough for Office-like needs), why not ?
Hey, then let's look at Pascal (say, Component Pascal - latest Wirth's creature) - it is Pascal that created the very terms of "p[ascal]-code" and "virtual machine":-)
And read about Lilith project - CPU was designed for Pascal, OS was written in Pascal, Office components were written in Pascal, etc:-)
BTW, i've heard that "esmertech" made some Java-based realtime environment "Jbed" sized less that 300Kb. Don't know nothing but rumours though.
Take a look at.NET IT has open ECMA specification - and Microsoft made a great P on that.
But the real programs will be made upon MS.NET with all it's propietary extensions to the standard. The standard itself is gonne mean nothing.
Projects like www.DotGNU.org understands it well, so they are running behind (and trying to chase) the very MS libraries, not only the standards. And Microsoft said that it is their strategy - add new technologies so fast, that competitors have no time to invent their own one.
Those tabs are badly cloned MDI, like the one in Opera.
Indeed, when You have a lot of different windows - MDI sucks. But when windows a similar, like web-poages or word documents - then MDI rocks.
But sure, the Gimp is not to place all those windows to task bar, it is better to have it's own one if it needs so.
Like Borland Delphi for example - mayne windows - but only one on taskbar.
..as soon as someone will create one. Those PDF's that are on their homepage (http://firebirdsql.org/) are taken form Borland. You can distibute and read them but cannot change a single bit in them.
You see, nothing is locked. Opposite, Helen Borrie (hope i did not misspelled) created the book on Firebird that is going to be published, do not know how detailed it is. Year ago russian usergroup created a book too (most efforts was from developers of www.devrace.com), though it is more like 'getting started', things You must know, and things You must be interested and searching beyond this book for particular kinds of work you need done. Maybe You can read of that book at www.interbase-world.com, though it may appear - since no interest to the book was shown aside Russia - it may be omitted on English pages.
Aaahh! shame on me, i forgotten. 3 years ago a book in Germany was published.
Yopu see, 3 books it is not 'nothing'.
So why there is no documentation? Simple. Try to make one *without* reading those PDF's and any derived from them information.... Can anyone do it?
That is like the disclamer at www.DotGNU.org that tells You never read any documentation, that has some license restriction, if You want to participate - cause after all Your work may be used to issue the whole project as pirated one.
Did You try special options of GBACK and GFIX ? They are described in manual.
But You are right, IB 6 OS,and IB 5.x before 5.6 are known to be buggy.
Maybe You never will find them, but trying to do something complex - You will certainly nned to understand inner engine to avoid them.
PS: gback never warranted that You will succesfully restore database that You successfully backed up. Simplest way it to alter table, makeing some column constrained as 'NOT NULL' while cintainning NULL values. This database will be easily backed up and never restored (without special options, descibed in manual) I've heard of nback for Firbird project though.
Yaffil (hance i think Firbird too) has function-based and expression-based indices.
Same as SubSelects in COMPUTED BY columns.
But sure, in each of Oracle, DB2 and MS SQL, one may find a *set* of features that no one else provides.
They are leaders, that's so.
Borland developed Interbase for years, and suddenly... Suddenly they tld they are no more interested in Interbase, so the project is discontinued. there worst thing about commercial apps, is that once You may hear 'game over'. The developers was shocked and even organised some movement to force Borland notto harry killinh Interbase. Thanks to www.mers.com
In about a year Borland reacted, telling here is You Interbase 6.0 - if You like it - take it and do whatever needed. Later they acted back with IB 6.5, but that is out of iinterest here. They has been taken - by developers who resigned from Borland after that, especially those, who resigned from Digital many years ago to create the database, as Digital's chiefs were not interested in enhancing OpenVMS OS built-in database management. Sure during this year they found themself a work and could not soent too much time on cleaning ex-IB6 code. So the next year was spent for creating the community and finding sponsors. This 2 years delay was so dark time, that 2 programmers in SaintPetersburg forked the stalled Firebird project and started Yaffil project (http://yaffil.ibase.ru, seems the fastest but Win32-only clone of Interbase)
Later there appeared new developers, some grants, fund, et cetera. But those two years were defenitely years of death. Personally i treat 'Firebird' as sardonic codename, meant "We're still here after those years, are we dead or not?"
Currently, when life is back in Firebird, and after they together fixed some awfull legacy bugs, they desided to merge together again, but theis is another story...:-)
You're lucky!!! I started development for Intebase 5.1 and in a month i found 2 bugs, one of them made database unable to restore from backup. Just a specific order fo creating tables. Dummy finding bugs, how would You like it?
And had You heard of merge of Firebird and Yaffil projects. Why... Some points are told in 'in the beginning' post. To continue it: Later some developers from both teams were pricking themselves in russian Interbase usergroup. Firebird was enhancing SQL, making Yaffil re-implement those features. While Yaffil was too much faster, making Firebird team try to optimise their codebase. It was a neverending reason of jokes.
And sure they were finding and fixing bugs. Each in their own codebase, with only limited help to each other. By the way, Yaffil, and later in 1.5alpha Firebird too, had changed heap manager - and found reasons of 'Interbase is unstable under heavy load' rumours. There were place, where memory was freed, but still used after.
This spring 2 awfull bugs was discovered, one of them existed in Interbase 4.1 and maybe even longer back to the history. There was legal way to make duplicate values in P.K. It is amazing that no one stepped upon that 2 rooks ever before. That was the last drops, working together on fixes the teams finally decided to merge back. It will be interesting and, i hope, great story.
PS: i wonder if You will look through Firebird issue tracker, and try those bugs over Borland Interbase, wat will there be the result ?
PPS: Have Your heard of www.ibaid.com ? Alas, interbase _can_ crash the database. For early IB6.0x it was enougth to grow database file 4gb of size, the next bytes were written into header:-( Small office never needed such amounts of data, but will they - they will certainly need mature DBA that knows about the issue.
"SELECT word FROM dictionary WHERE id IN (SELECT word_id FROM article WHERE article_id = 1)"
That is not good for Interbase-clones, it is treated like "WHERE (id = word_id_1) or (id = word_id_2) or..."
The better way is SELECT word FROM dictionary WHERE EXISTS( SELECT * FROM article WHERE (article_id = 1) AND (word_id = id))
I think even mySQL is capable of that:-)
PS: Bill Todd made a comparision of MySQL vs Interbase, and while there is a load of Borland PR, it has correct points. Sorry, have no URL under fingertips, but there is link on www.IBPhoenix.com
With Firbird or Yaffil you can just open read-only transaction and never close it.
Indeed one of suggested mode it bi-connection, when each applications holds 2 connections: one for transaction looooong read-only with 'read-commited', and one for short transactions, changing data.
AS: there are special data storage servers for datamining, not RDBMS, or based upon RDBMS. Maybe try some of them?
IB-clones do not have meterialized views. You can add functions yourself, with external DLL (SO) file - they are called UDF - user-defined functions.
Yaffil team is now adding more SDFs (server-defined functions) to meet some of MSSQL and Oracle. So later they might appear in Firebird 1.6 or 2.0
But usually datamining starts at gigabytes or maybe terabytes of raw data. Why FB is capable of working with tens of GB, i'm sure it will not fly beeing loaded with TBs of data:-)
No imagine that i purchased PC off-the-shelf.
Imagine there is Linux pre-installed.
Now imagine that i try to install some other software, that need Firebird(DB)
How soon i, beeing dummy, will realise that the Firbird browser, in which i read the help for theprogram is not the Firebird that program is asking for ?
What if such a program is pre-installed to, and i will need an assistance? Those HowTo's written by superminds for superminds - will they make it clear for dummy me that 'start firebird' suggestion has nothing with 'launch Mozilla' ?
What if both projects will choose to keep there configuration in same folder/etc/firebird ?
The very fact of FireFox name shows there was some point.
Though FibirdDB community indeed was not polite.
To some excuse may be 1st posts on Mozilla's forum when they choosed the Firebird title.
Someone pointed that the name was always taken - and immediately replied with notes like 'go away! who are You? No one knows of You! We are lefgion, We are power, get away from our marching'
Indeed it is hard to believe that no one had known of FirebirdDB project - Sourceforge is one of the famoust sites and type 'firebird' in Search box coul;d be a matter of 5 seconds.
Maybe it was, alas, frequent situation, when two are exchanging with blows and each new blow is 10% harder than previous one. It can rapidly come from slaps to killing.
You quoting the famous "1984" by Orwell.
Rage seems to quote it too.
But this nightmare will not be in the whole.
It will be more like "Our brave new world" by Huksly mixed wed some points of "We" by Zamyatin
PS: i'm probably mis-spelling, sorry, i'm not English-speaking one.
GTK -> XEmbed -> Qt -> Xserver ?
WHY ??? What for ?
I do not like C-styled languages.
.NET applications, that are compatible with ECMA standardf and do not need MS-only extensions to it, i will move towards. :-)
If Java was muti-langauge at its roots...
IF there will be share of
Otherwise... At least 'no news' will make not thinggs worse
Is Mono (or better and faster www.DotGNU.org) closer to native code than Java?
.NET will go to sleep.
.NET be relativelly slow client environment (non-optimised but enough for Office-like needs), why not ?
I hope sooner or later SuperCompiling (www.refal.org) will be completed for Java, then
On the other hand, let Java be highly optimised server environment, and let
Hey, then let's look at Pascal (say, Component Pascal - latest Wirth's creature) - it is Pascal that created the very terms of "p[ascal]-code" and "virtual machine" :-)
:-)
And read about Lilith project - CPU was designed for Pascal, OS was written in Pascal, Office components were written in Pascal, etc
BTW, i've heard that "esmertech" made some Java-based realtime environment "Jbed" sized less that 300Kb. Don't know nothing but rumours though.
..or i can say Qt is not flexible enough to act like GIMP event loop.
:-)
Let as not talk of GTK as some generic tooklit. GTK is (at least at its basement) subset of GIMP.
I'd prefer to say, it is GIMP event loop, not one of GTK
Take a look at .NET
.NET with all it's propietary extensions to the standard. The standard itself is gonne mean nothing.
IT has open ECMA specification - and Microsoft made a great P on that.
But the real programs will be made upon MS
Projects like www.DotGNU.org understands it well, so they are running behind (and trying to chase) the very MS libraries, not only the standards.
And Microsoft said that it is their strategy - add new technologies so fast, that competitors have no time to invent their own one.
"GIMP relied heavily on the Gtk"
:-)
If i got it correct GTK is GIMP ToolKit - it was created as part of the GIMP itself
http://www.deforum.ru/forum/viewtopic.php?t=19589
Those tabs are badly cloned MDI, like the one in Opera. Indeed, when You have a lot of different windows - MDI sucks. But when windows a similar, like web-poages or word documents - then MDI rocks. But sure, the Gimp is not to place all those windows to task bar, it is better to have it's own one if it needs so. Like Borland Delphi for example - mayne windows - but only one on taskbar.
Time is flying fast...
:-)
Not this spring, sure, but the last fall.
Merge was announced in December.
I remember those troubles was between winter and summer and...
Sorry, seems i am too longing for March
The can be hanfled 'in code' 'by the database server' - triggers.
..as soon as someone will create one.
Those PDF's that are on their homepage (http://firebirdsql.org/) are taken form Borland. You can distibute and read them but cannot change a single bit in them.
You see, nothing is locked.
Opposite, Helen Borrie (hope i did not misspelled) created the book on Firebird that is going to be published, do not know how detailed it is.
Year ago russian usergroup created a book too (most efforts was from developers of www.devrace.com), though it is more like 'getting started', things You must know, and things You must be interested and searching beyond this book for particular kinds of work you need done.
Maybe You can read of that book at www.interbase-world.com, though it may appear - since no interest to the book was shown aside Russia - it may be omitted on English pages.
Aaahh! shame on me, i forgotten. 3 years ago a book in Germany was published.
Yopu see, 3 books it is not 'nothing'.
So why there is no documentation?
Simple. Try to make one *without* reading those PDF's and any derived from them information....
Can anyone do it?
That is like the disclamer at www.DotGNU.org that tells You never read any documentation, that has some license restriction, if You want to participate - cause after all Your work may be used to issue the whole project as pirated one.
Did You try special options of GBACK and GFIX ?
,and IB 5.x before 5.6 are known to be buggy.
They are described in manual.
But You are right, IB 6 OS
Maybe You never will find them, but trying to do something complex - You will certainly nned to understand inner engine to avoid them.
PS: gback never warranted that You will succesfully restore database that You successfully backed up.
Simplest way it to alter table, makeing some column constrained as 'NOT NULL' while cintainning NULL values. This database will be easily backed up and never restored (without special options, descibed in manual)
I've heard of nback for Firbird project though.
Yaffil (hance i think Firbird too) has function-based and expression-based indices. Same as SubSelects in COMPUTED BY columns. But sure, in each of Oracle, DB2 and MS SQL, one may find a *set* of features that no one else provides. They are leaders, that's so.
Borland developed Interbase for years, and suddenly... Suddenly they tld they are no more interested in Interbase, so the project is discontinued.
:-)
there worst thing about commercial apps, is that once You may hear 'game over'.
The developers was shocked and even organised some movement to force Borland notto harry killinh Interbase. Thanks to www.mers.com
In about a year Borland reacted, telling here is You Interbase 6.0 - if You like it - take it and do whatever needed. Later they acted back with IB 6.5, but that is out of iinterest here.
They has been taken - by developers who resigned from Borland after that, especially those, who resigned from Digital many years ago to create the database, as Digital's chiefs were not interested in enhancing OpenVMS OS built-in database management.
Sure during this year they found themself a work and could not soent too much time on cleaning ex-IB6 code.
So the next year was spent for creating the community and finding sponsors.
This 2 years delay was so dark time, that 2 programmers in SaintPetersburg forked the stalled Firebird project and started Yaffil project (http://yaffil.ibase.ru, seems the fastest but Win32-only clone of Interbase)
Later there appeared new developers, some grants, fund, et cetera. But those two years were defenitely years of death.
Personally i treat 'Firebird' as sardonic codename, meant "We're still here after those years, are we dead or not?"
Currently, when life is back in Firebird, and after they together fixed some awfull legacy bugs, they desided to merge together again, but theis is another story...
You're lucky!!!
:-(
I started development for Intebase 5.1 and in a month i found 2 bugs, one of them made database unable to restore from backup. Just a specific order fo creating tables.
Dummy finding bugs, how would You like it?
And had You heard of merge of Firebird and Yaffil projects. Why... Some points are told in 'in the beginning' post. To continue it:
Later some developers from both teams were pricking themselves in russian Interbase usergroup.
Firebird was enhancing SQL, making Yaffil re-implement those features.
While Yaffil was too much faster, making Firebird team try to optimise their codebase.
It was a neverending reason of jokes.
And sure they were finding and fixing bugs. Each in their own codebase, with only limited help to each other.
By the way, Yaffil, and later in 1.5alpha Firebird too, had changed heap manager - and found reasons of 'Interbase is unstable under heavy load' rumours. There were place, where memory was freed, but still used after.
This spring 2 awfull bugs was discovered, one of them existed in Interbase 4.1 and maybe even longer back to the history.
There was legal way to make duplicate values in P.K.
It is amazing that no one stepped upon that 2 rooks ever before.
That was the last drops, working together on fixes the teams finally decided to merge back.
It will be interesting and, i hope, great story.
PS: i wonder if You will look through Firebird issue tracker, and try those bugs over Borland Interbase, wat will there be the result ?
PPS: Have Your heard of www.ibaid.com ? Alas, interbase _can_ crash the database.
For early IB6.0x it was enougth to grow database file 4gb of size, the next bytes were written into header
Small office never needed such amounts of data, but will they - they will certainly need mature DBA that knows about the issue.
"SELECT word FROM dictionary WHERE id IN (SELECT word_id FROM article WHERE article_id = 1)"
:-)
That is not good for Interbase-clones, it is treated like "WHERE (id = word_id_1) or (id = word_id_2) or..."
The better way is
SELECT word FROM dictionary WHERE EXISTS( SELECT * FROM article WHERE (article_id = 1) AND (word_id = id))
I think even mySQL is capable of that
PS: Bill Todd made a comparision of MySQL vs Interbase, and while there is a load of Borland PR, it has correct points. Sorry, have no URL under fingertips, but there is link on www.IBPhoenix.com
With Firbird or Yaffil you can just open read-only transaction and never close it.
Indeed one of suggested mode it bi-connection, when each applications holds 2 connections: one for transaction looooong read-only with 'read-commited', and one for short transactions, changing data.
AS: there are special data storage servers for datamining, not RDBMS, or based upon RDBMS. Maybe try some of them?
:-)
IB-clones do not have meterialized views.
You can add functions yourself, with external DLL (SO) file - they are called UDF - user-defined functions.
Yaffil team is now adding more SDFs (server-defined functions) to meet some of MSSQL and Oracle.
So later they might appear in Firebird 1.6 or 2.0
But usually datamining starts at gigabytes or maybe terabytes of raw data.
Why FB is capable of working with tens of GB, i'm sure it will not fly beeing loaded with TBs of data
:-)
You've forgotten dates, just like Windows 95 or latest snapshots of www.IBExpert.com
No imagine that i purchased PC off-the-shelf. Imagine there is Linux pre-installed. Now imagine that i try to install some other software, that need Firebird(DB) How soon i, beeing dummy, will realise that the Firbird browser, in which i read the help for theprogram is not the Firebird that program is asking for ? What if such a program is pre-installed to, and i will need an assistance? Those HowTo's written by superminds for superminds - will they make it clear for dummy me that 'start firebird' suggestion has nothing with 'launch Mozilla' ? What if both projects will choose to keep there configuration in same folder /etc/firebird ?
The very fact of FireFox name shows there was some point.
Though FibirdDB community indeed was not polite.
To some excuse may be 1st posts on Mozilla's forum when they choosed the Firebird title.
Someone pointed that the name was always taken - and immediately replied with notes like 'go away! who are You? No one knows of You! We are lefgion, We are power, get away from our marching'
Indeed it is hard to believe that no one had known of FirebirdDB project - Sourceforge is one of the famoust sites and type 'firebird' in Search box coul;d be a matter of 5 seconds.
Maybe it was, alas, frequent situation, when two are exchanging with blows and each new blow is 10% harder than previous one. It can rapidly come from slaps to killing.
agree.
Consider it same way as GIMP2, which development unbstable branch is still numbered for 1.x