Re: [Firebird-devel] Jaybird migration to Subversion completed

[supp...@ibknowledgebase.com]

Hello Mark,

Congratulations!
Will you create appropriate ticket in Web section to update pages at 
Firebirdsql.org with the new way to get sources?

Regards,
Alexey Kovyazin


> The migration of Jaybird from CVS to Subversion is done and the
> subversion repository is available again for commits.
>
> The migration went a lot faster then I had expected, except for the
> upload of the zipped dumpfile which took 21 minutes where I expected it
> to take about 10.
>
> Mark
>
> On 5-8-2012 13:54, Mark Rotteveel wrote:
>> The migration of Jaybird to subversion will start in approximately 5
>> minutes.
>>
>> The Firebird subversion repository cannot be used during the migration.
>> Once migration is completed another mail will be sent.
>>
>> Mark Rotteveel
>


--
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Is Firebird 3 ready?

[supp...@ibknowledgebase.com]

Hello All,

I see that core developers started to discuss ruche features - hidden 
fields, readable db_key.

Did I miss something - do we already have beta of Firebird 3? Or we 
still not have even alpha?

Guys, let's CONCENTRATE on delivering Firebird 3 alpha, then beta, then 
release candidate and release, as soon as possible.
Last major release was in 2010. 3 years passed. We need new release ASAP.

Regards,
Alexey Kovyazin
IBSurgeon
Double Platinum Sponsor of Firebird Foundation







--
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire 
the most talented Cisco Certified professionals. Visit the 
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Update ICU in Windows

[supp...@ibknowledgebase.com]

Hi,


 >This way those who know what they have installed can save traffic.

Traffic does not matter anymore.


Regards,
Alexey Kovyazin

--
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] MySQL versus Firebird

[supp...@ibknowledgebase.com]

I cannot open it too

Regards,
Alexey

> On 03/10/2014 11:00 AM, marius adrian popa wrote:
>> I decided to compare the current versions of MySQL 5.6 and Firebird
>> SQL 2.5. I only looked at features that end users can see, without
>> benchmarking. http://ocelot.ca/blog/blog/2014/03/09/354/
> Is it only me?
>
> The server at ocelot.ca is taking too long to respond.
>   The site could be temporarily unavailable or too busy. Try again in
> a few moments.
>
>
> --
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and their
> applications. Written by three acclaimed leaders in the field,
> this first edition is now available. Download your free book today!
> http://p.sf.net/sfu/13534_NeoTech
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>


--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Using Firebird 3, beta 1 - installer report

[supp...@ibknowledgebase.com]

Hi Martijn,

Thanks for report, we'll go through things you listed.

Regards,
Alexey Kovyazin
IBSurgeon


Hi,
Download beta 1 on Win32.
1) installer usability failure
- cannot start the installer with a Firebird service (1.5 & 2.5) 
running, even though I’d like to install as a separate instance
- a warning would be fine, but even if it’s Firebird 3 running, it 
should be possible to install as an additional instance

2) the installer warning about Firebird 2.5
- why can’t I do a normal installation because 2.5 is already 
installed? This was the message I got:

--8<--
Pre-installation analysis indicates that 1 existing Firebird or 
Interbase version has been found.Firebird 2.5.2.26540  (Win32)  Full 
installation of Classic Server and development tools.   (Installation 
appears to be correct.) If you continue with this installation 
Firebird will be installed but not configured. You will have to 
complete installation manually. Do you want to CANCEL this installation?

--8<--
3) Installer ReadMe:
--8<--
Before installation
---
It is recommended that you UNINSTALL all previous
versions of Firebird or InterBase before installing
this package. It is especially important to verify that
fbclient.dll and gds32.dll are removed from .
--8<--
What now? Same issue as above: multiple instances is supported, so why 
this warning?

4) Installation folder:
Default folder selected was this:
C:\Program Files\Firebird\Firebird_3_0
This is an existing Fb 3 folder. When I click “Browse”, somehow it 
selects:

C:\Program Files\Firebird
The edit box above the treeview lists the full path, but if I expand 
and select my Firebird 3 folder, it insists on concatenating 
“Firebird_3_0”, so I end up with:

C:\Program Files\Firebird\Firebird_3_0\Firebird_3_0
5) Including the drivers: good! Smile
Although I would say that “including source” should be unchecked by 
default for the –> normal server <- install.

6) ODBC?
- After installation, it asks you to open the ODBC Driver folder. Is 
the ODBC driver installed or isn’t it? This is unclear to me.
Apparently, this only installs the ODBC installer? Why not execute 
that as well?

7) SYSDBA
The installer creates SYSDBA (yay!), could a custom password entry box 
be added for this?
-> After I uninstalled Fb 3, I noticed that when using the installer 
again, a custom password CAN be entered. Why and how is this 
difference caused?

8) Uninstaller
- it’s possible to run the Uninstaller, while Firebird is running
Starting command line:
"C:\Program Files\Firebird\Firebird_3_0\firebird.exe" -a -i -p 3054 -m
- the installer then finishes with “Firebird is uninstalled 
succesfully”, which is rubbish, as most file still exists in the 
installation folder!
- the installer also told me “Succes”, when files got locked in 
another way
I removed the file & folder manually, for some reason, when installing 
some files had “read only” set to true, but the installer 
“success”-message was obviously wrong.
- installed again, into a new folder, uninstalled again, after 
uninstall, there’s lots of files left.
- files ending with .url are registered as shared files? Yet, they’re 
in the Fb 3 folder and can be removed safely without prompting the 
user, can’t they?

Hope this helps.
With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!


--


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Please publish the unofficial FB 3.0 beta release notes for testing

[supp...@ibknowledgebase.com]

Hi Robert,

We will update Unofficial installer soon with some more documents.
Also, official Beta 1 is on the way too.

Regards,
Alexey Kovyazin



Hi,
I’ve tested the “unofficial” FB 3.0 beta-1 release (after installing 
it with the “unofficial” installer) for a couple of weeks now.
I am now at a point, that I start missing the release notes, just to 
get a better understanding of the new features and for designing my 
test cases efficiently and effectively.
Is it possible to publish the unofficial (as-is) release notes for FB 
3.0 beta-1?

Thanks,
Robert


--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrk


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://pubads.g.doubleclick.net/gampad/clk?id=154624111&iu=/4140/ostg.clktrkFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Fields in data pages

[supp...@ibknowledgebase.com]

Hi Stuart,

Download FirstAID from www.ib-aid.com, run FirstAID Extractor and open 
your database. It "decrypts" data from Firebird database using its 
internal structures and shows you the values of fields in tables' records.


Regards,
Alexey Kovyazin
IBSurgeon


OK, but version numbers tell me nothing. What I am looking for is an 
explanation of how Firebird (the package) can tell which bytes belong 
to which fields. Somehow Firebird must be able to tell the difference 
between the following two records:


FirstName LastName
'Jim'   'Starkey'
'Jim Starkey'  ''


It may well be that it was coded in the Interbase days and has not 
been looked up until now. Or maybe it's the blob in the 
"RDB$DESCRIPTOR" field, in which case I do not know how to decode it 
into text.


On Sun, Nov 30, 2014 at 7:49 AM, James Starkey > wrote:


No for all questions.  The record is a) run length encoded and b)
contains a format version number that must be looked up in
rdb$formats.


On Sunday, November 30, 2014, Stuart Simon mailto:stuart...@gmail.com>> wrote:



On Sunday, November 30, 2014, Stuart Simon
 wrote:

Hello Firebird Developers:
Pardon  me, but I found the structs I was looking for in
the source code (it was hard!). I don't want to bog you
down with novice questions, but I want to know two things:

1. Is there a field (e.g., "fp_field_type") in the field
or record header that would indicate the field type?
2. What indicates the end (or, alternatively, size in
bytes) of a non-final field in a record with two or more
fields?

Thank you!

Stuart



-- 
Stuart Simon

stuart...@gmail.com



-- 
Stuart Simon

stuart...@gmail.com



-- 
Jim Starkey



--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and
Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration
& more
Get technology previously reserved for billion-dollar
corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel




--
Stuart Simon
stuart...@gmail.com 


--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel


--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrkFirebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Fields in data pages

[supp...@ibknowledgebase.com]

Stuart,

It does not show BLOBs in preview, but during export - yes - it supports 
Firebird BLOBs and "small BLOBs" introduced in recent Interbase versions.


Regards,
Alexey Kovyazin
IBSurgeon

Not to be rude or anything, but does FirstAID Extractor decrypt all 
types of BLOBs?


On Mon, Dec 1, 2014 at 2:17 AM, supp...@ibknowledgebase.com 
<mailto:supp...@ibknowledgebase.com> <mailto:supp...@ibknowledgebase.com>> wrote:


Hi Stuart,

Download FirstAID from www.ib-aid.com <http://www.ib-aid.com>, run
FirstAID Extractor and open your database. It "decrypts" data from
Firebird database using its internal structures and shows you the
values of fields in tables' records.

Regards,
Alexey Kovyazin
IBSurgeon



OK, but version numbers tell me nothing. What I am looking for is
an explanation of how Firebird (the package) can tell which bytes
belong to which fields. Somehow Firebird must be able to tell the
difference between the following two records:

FirstName LastName
'Jim'   'Starkey'
'Jim Starkey'  ''


It may well be that it was coded in the Interbase days and has
not been looked up until now. Or maybe it's the blob in the
"RDB$DESCRIPTOR" field, in which case I do not know how to decode
it into text.

On Sun, Nov 30, 2014 at 7:49 AM, James Starkey
mailto:j...@jimstarkey.net>> wrote:

No for all questions. The record is a) run length encoded and
b) contains a format version number that must be looked up in
rdb$formats.


On Sunday, November 30, 2014, Stuart Simon
mailto:stuart...@gmail.com>> wrote:



On Sunday, November 30, 2014, Stuart Simon
 wrote:

Hello Firebird Developers:
Pardon  me, but I found the structs I was looking for
in the source code (it was hard!). I don't want to
bog you down with novice questions, but I want to
know two things:

1. Is there a field (e.g., "fp_field_type") in the
field or record header that would indicate the field
type?
2. What indicates the end (or, alternatively, size in
bytes) of a non-final field in a record with two or
more fields?

Thank you!

Stuart



-- 
Stuart Simon

stuart...@gmail.com



-- 
Stuart Simon

stuart...@gmail.com



-- 
Jim Starkey



--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and
Dashboards
with Interactivity, Sharing, Native Excel Exports, App
Integration & more
Get technology previously reserved for billion-dollar
corporations, FREE

http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel




-- 
Stuart Simon

stuart...@gmail.com <mailto:stuart...@gmail.com>



--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk


Firebird-Devel mailing list, web interface 
athttps://lists.sourceforge.net/lists/listinfo/firebird-devel




--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and
Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration
& more
Get technology previously reserved for billion-dollar
corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel




--
Stuart Simon
stuart...@gmail.com <mailto:stuart...@gmail.com>


--
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel

Re: [Firebird-devel] Time to update our headers.

[supp...@ibknowledgebase.com]

Hi,


http://www.firebirdsql.org/en/licensing/

Regards,
Alexey

> People,
> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_idpl.
> is pointing to nothing. We need to update the files in the repository to
> point to the right location of the license or please suggest an alternative.
> I think that only FB v3 matters.
>
> C.
> ---
> Claudio Valderrama C.
> Consultant, SW developer.
>
>
> --
> Dive into the World of Parallel Programming The Go Parallel Website, sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for all
> things parallel software development, from weekly thought leadership blogs to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> Firebird-Devel mailing list, web interface at 
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>


--
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird 3.0 Is Available Now

[supp...@ibknowledgebase.com]

Firebird 3.0 Is Available Now - with major improvements in performance, 
security and SQL features

April 19, 2016 -- The Firebird Project is pleased to announce the 
release of version 3 of Firebird, its open source relational database 
management system:
http://www.firebirdsql.org/en/firebird-3-0-0/

This version is the most extensive re-architecture of the Firebird DBMS 
since its initial release more than 14 years ago.  Its new 
multi-threaded engine processes and shared page caching enable better 
utilization of multi-core hardware and large address spaces. With these 
changes, this release features dramatic performance increases, while 
maintaining compatibility with old client libraries.

In addition, Firebird 3.0 includes a long list of SQL improvements 
(including Window and statistical functions), enhanced security features 
such as wire and database encryption and multiple security databases, 
and more -- over 100 significant improvements.  Yet even with its new 
enterprise-level features, it retains the tiny footprint and simple 
deployment and management that have made it "the right tool for the job" 
for so many applications.

Steve Summers, President of the non-profit Firebird Foundation, said: 
"We're very excited about this release. Re-architecting a system as 
complex as a relational database system is a very difficult task. We're 
extremely impressed with the skills shown by Firebird's development team 
and the great job they've done."

Dmitry Yemanov, the core team leader, agreed. "Firebird 3.0 development 
was quite a challenge but we've finally completed the work and ensured 
that it complies with our QA standards. Besides the scalability and 
security features that were our top priority tasks, I'm particularly 
happy about the performance improvements in garbage collection and 
incremental backup areas. With the renewed architecture and 
significantly refactored code, this release establishes a solid platform 
for our further progress. Thanks to all the Firebird developers and 
contributors."

Mr. Summers added: "If you're building a system that needs to store 
structured data at end-users' sites, from a few megabytes to hundreds of 
gigabytes, on a desktop or a network with thousands of users, Firebird 
has always been a great choice. It's an even better choice now. You owe 
it to yourself to at least take a look!"

Pricing and Availability

Firebird 3.0 is an open source database system that is completely free 
of charge for any use – including deployment as part of commercial 
products (not just non-profit, private or educational use like some of 
its competitors).  Both binary packages and the complete source code can 
be downloaded at no cost through the Firebird Project website:
http://www.firebirdsql.org/en/firebird-3-0-0/

No registration or activation is required.

As of today, Firebird 3.0 is available in 32 and 64 bit versions for 
both Windows and Linux. OS X and other platforms will be available soon. 
Drivers for JDBC (Java), .NET, ODBC, Python and more are also available 
through the FirebirdSQL.org web site, along with documentation.
http://www.firebirdsql.org/en/downloads/

Additional tools (drivers, administration, replication, UDF 
(user-defined-function) libraries, etc.) are also available through 
third parties:
http://www.firebirdsql.org/en/third-party-tools/

About the Firebird Foundation

The Firebird Foundation is a non-profit organization that supports the 
development and maintenance of the Firebird relational database system. 
The Foundation was incorporated in 2002 and is currently supported by 
more than 300 active members and 23 sponsors. If you find Firebird 
useful, and especially if it is helping you earn money, please join us 
to help ensure the future of this valuable tool.  For details, please 
click the Community tab on our website
http://www.firebirdsql.org/en/firebird-foundation/

For more information, contact:

Steve Summers, sesumm...@firebirdsql.org, or

Alexey Kovyazin, c...@firebirdsql.org

--
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel