tag:blogger.com,1999:blog-524284054531930812024-03-13T14:30:00.735-07:00Firebird 3 - news, tips and tricksIBSurgeonhttp://www.blogger.com/profile/05116496519832864761noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-52428405453193081.post-41149430841299073032015-10-08T03:28:00.003-07:002015-10-08T06:51:27.819-07:00HQbird - advanced distribution of Firebird SQL for enterprises<h2>
What is HQbird<o:p></o:p></h2>
<div class="MsoNormal">
<a href="http://ib-aid.com/en/hqbird">HQbird </a>is an advanced distribution of Firebird for enterprises,
with the following list of features: optimized configurations, high
availability and replication, backups' automation, database health monitoring,
transactions and queries monitoring (TraceAPI, MON$ and FBScanner), database
structure analysis, recovery toolset and database development GUI. Also HQbird includes a performance self-test
to measure Firebird performance on the specific hardware and OS configuration. <o:p></o:p><br />
<i>HQbird is not a fork of Firebird, it is an advanced distribution with enhanced features and tools for enterprise use.</i></div>
<div class="MsoNormal">
HQbird contains 2 parts: server-side and administration. The
server-side part has versions for Windows and Linux, and the administration
part works on Windows only.<o:p></o:p></div>
<div class="MsoNormal">
There are 3 editions of HQbird: Standard, Professional and
Enterprise. </div>
<h2>
Feature matrix<o:p></o:p></h2>
<div class="MsoNormal">
Below there is the feature matrix for <a href="http://hqbird.com/">HQbird</a>. <o:p></o:p></div>
<table border="0" class="table table-striped cke_show_border" style="border: 1px dotted rgb(211, 211, 211); color: #333333; font-family: sans-serif, Arial, Verdana, 'Trebuchet MS'; font-size: 13px; line-height: 20.8px; width: 100%px;" tbody=""><thead>
<tr><th colspan="4" style="border: 1px dotted rgb(211, 211, 211);">HQbird Editions</th></tr>
<tr><th style="border: 1px dotted rgb(211, 211, 211);">Features</th><th style="border: 1px dotted rgb(211, 211, 211);">Standard</th><th style="border: 1px dotted rgb(211, 211, 211);">Professional</th><th style="border: 1px dotted rgb(211, 211, 211);">Enterprise</th></tr>
</thead><tbody>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">Backups<br />(automated verified and incremental backups and their combinations)</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">Optimized configurations<br />(balanced, read-intensive and write intensive)</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">Performance test suite<br />(hardware scoring)</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">SQL monitoring and profiling<br />(queries, connections, transactions through TraceAPI, MON$ and traffic analysys through FBScanner)</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">Health monitoring<br />(online validation, database health check, log analysis)</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">Transaction tracking<br />(transactions markers dynamics analysis)</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">Database structure analysis<br />(table and indices sizes, fragmentation, BLOBs, versioning, etc)</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">SQL development & debugging<br />(GUI tool to develop database and queries)</td><td style="border: 1px dotted rgb(211, 211, 211);"><br /></td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">Recovery<br />(Firebird databases recovery, backups recovery, Undelete records)</td><td style="border: 1px dotted rgb(211, 211, 211);"><br /></td><td style="border: 1px dotted rgb(211, 211, 211);">X</td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
<tr><td style="border: 1px dotted rgb(211, 211, 211);">High availability<br />(replication)</td><td style="border: 1px dotted rgb(211, 211, 211);"><br /></td><td style="border: 1px dotted rgb(211, 211, 211);"><br /></td><td style="border: 1px dotted rgb(211, 211, 211);">X</td></tr>
</tbody></table>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="RU">Licensing looks very interesting: an unlimited s</span>ubscription prices starts from EUR299/month for unlimited usage of HQbird Standard. More details here: <a href="http://www.ib-aid.com/en/hqbird">http://www.ib-aid.com/en/hqbird</a><br />
<br />
<br /></div>
IBSurgeonhttp://www.blogger.com/profile/05116496519832864761noreply@blogger.com0tag:blogger.com,1999:blog-52428405453193081.post-7968198857749770922015-09-22T08:34:00.001-07:002015-09-22T08:41:02.541-07:00Firebird 3 Launch Campaign<div dir="ltr" style="text-align: left;" trbidi="on">
Visit Firebird 3 Launch Campaign web site - <a href="http://www.firebird3.com/">www.firebird3.com</a><br />
<br /></div>
IBSurgeonhttp://www.blogger.com/profile/05116496519832864761noreply@blogger.com1tag:blogger.com,1999:blog-52428405453193081.post-14340390125672879642012-03-27T00:40:00.000-07:002015-09-30T14:15:52.735-07:00How to install Firebird 3?<div dir="ltr" style="text-align: left;" trbidi="on">
UPDATE 22/09/2015<br />
<br />
At the moment Firebird 3 is close to Release Candidate, and there is a full installer is available for Beta 2 - you can download it here <a href="http://firebird3.com/en/download-firebird-3/">http://firebird3.com/en/download-firebird-3/</a>.<br />
<br />
If you want to install snapshot of Firebird, in order to get pre-RC1 version, you need to follow steps below. Official installer for Firebird 3 RC1 will be available later.<br />
<br />
And below you can find the answer for the question "How to install Firebird".<br />
It requires some manual steps.<br />
<br />
First, you need to <a href="http://firebird3.com/en/download-firebird-3/">download snapshot of Firebird 3</a> and unpack its archive into some suitable location, like <b>C:\Firebird3</b>.<br />
<br />
Detailed explanation of Firebird 3 installation and initialization can be found here: <a href="http://ib-aid.com/en/articles/firebird-3-quick-start-guide-initializing-security-database/">Firebird 3 Quick Start Guide</a>.<br />
<br />
As you can see, folders structure in Firebird 3 was changed, and now there is no "Bin" folder, and executable files are in the root of Firebird installation.<br />
<br />
Below is the list of files from Firebird-3.0.0.29875-0_Win32 snapshot:<br />
<br />
<br />
<span style="font-family: 'Courier New', Courier, monospace;">Directory of C:\Firebird3</span><br />
<span style="font-family: 'Courier New', Courier, monospace;"><br /></span>
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> .</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> ..</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> doc</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:03 PM 852,992 fbclient.dll</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 103,424 fbguard.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 28,672 fbrmclib.dll</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:07 PM 88,064 fbsvcmgr.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">11/15/2011 09:56 AM 5,375 fbtrace.conf</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:07 PM 86,528 fbtracemgr.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 148,992 fb_lock_print.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 27,256 firebird.conf</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 416,768 firebird.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:02 PM 139,176 firebird.msg</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 281,600 gbak.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 100,864 gfix.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 501,248 gpre.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 145,408 gsec.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 56,832 gsplit.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 176,128 gstat.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> help</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:03 PM 7,680 ib_util.dll</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 12:52 PM 1,558,016 icudt30.dll</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 12:51 PM 331,776 icuin30.dll</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 12:51 PM 546,304 icuuc30.dll</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">04/26/2011 11:29 AM 26,519 IDPLicense.txt</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> include</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">04/26/2011 11:29 AM 303 install_classic.bat</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">05/11/2011 08:40 AM 305 install_super.bat</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:07 PM 16,896 instclient.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:07 PM 10,752 instreg.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:08 PM 59,392 instsvc.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> intl</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">04/26/2011 11:29 AM 24,405 IPLicense.txt</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:07 PM 289,792 isql.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> lib</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">01/07/2011 11:39 PM 768,848 msvcr100.dll</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:07 PM 171,520 nbackup.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> plugins</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/22/2012 01:07 PM 286,720 qli.exe</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:55 AM 933,888 security3.fdb</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> system32</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">03/26/2012 10:10 AM <DIR> udf</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">04/26/2011 11:29 AM 273 uninstall.bat</span><br />
<span style="font-family: 'Courier New', Courier, monospace;"> 33 File(s) 8,192,716 bytes</span><br />
<span style="font-family: 'Courier New', Courier, monospace;"> 10 Dir(s) 388,050,579,456 bytes free</span><br />
<div>
<br /></div>
<br />
The next discovery is that all Firebird architectures are implemented through the single executable file: firebird.exe. There is no fbserver.exe and fb_inet_server.exe anymore.<br />
<br />
To start Firebird 3 as application, type in command line:<br />
<b>C:\Firebird3>firebird -a -m</b><br />
Congratulations - you've launched Firebird 3.<br />
In the right bottom corner of your Windows desktop you'll see Firebird icon: right-click on it and see Properties:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3pOldVoH6IfJT1zCMdCptU-zeDTkX-kl7evt_RK0BBZvZa3xQNs8JgF2D6R55UUNDClIHlDRNIJodafsLiTjQWKEjA9pStojRsKldrRkYrM1wMp7eIaP1GwGJqsD9k6JTQ7Ft10xu9Q/s1600/firebird3_properties.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3pOldVoH6IfJT1zCMdCptU-zeDTkX-kl7evt_RK0BBZvZa3xQNs8JgF2D6R55UUNDClIHlDRNIJodafsLiTjQWKEjA9pStojRsKldrRkYrM1wMp7eIaP1GwGJqsD9k6JTQ7Ft10xu9Q/s1600/firebird3_properties.png" /></a></div>
<br />
Nothing really interesting here at the moment :)<br />
So, the next step is to connect to Firebird 3 and<br />
<h3 style="text-align: left;">
Create database in Firebird 3</h3>
run isql.exe and run the following<br />
<br />
<span style="font-family: 'Courier New', Courier, monospace;">C:\Firebird3>isql</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">Use CONNECT or CREATE DATABASE to specify a database</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">SQL> create database "C:\temp\myfb3.fdb";</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">SQL> exit;</span><br />
<br />
<br />
Now Firebird is running in embedded mode, so you don't need user and password for the local connections.<br />
If you try to create database through network interface, it will require username and password:<br />
<br />
<span style="font-family: 'Courier New', Courier, monospace;">C:\Firebird3>isql</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">Use CONNECT or CREATE DATABASE to specify a database</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">SQL> create database "localhost:c:\temp\mydbfb3_again.fdb";</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">Statement failed, SQLSTATE = 28000</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">Your user name and password are not defined. Ask your database administrator to set up a Firebird login.</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">-Install incomplete, please read chapter "Initializing security database" in Quick Start Guide</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">SQL></span><br />
<br />
Why it refers to the chapter <span style="font-family: inherit;">"Initializing security database" in Quick Start Guide? Let's just use our favourite SYSDBA/masterkey! And - oops:</span><br />
<br />
<span style="font-family: 'Courier New', Courier, monospace;">SQL> create database "localhost:c:\temp\mydbfb3_again.fdb" USER "SYSDBA" password "masterkey";</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">Statement failed, SQLSTATE = 28000</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">Your user name and password are not defined. Ask your database administrator to set up a Firebird login.</span><br />
<span style="font-family: 'Courier New', Courier, monospace;">-Install incomplete, please read chapter "Initializing security database" in Quick Start Guide</span><br />
<br />
Yes, there is<b> no more SYSDBA default user and "masterkey" default password</b>.<br />
<br />
You need to add this user first (password can be not masterkey, of course):<br />
<span style="font-family: 'Courier New', Courier, monospace;">C:\Firebird3>gsec -add SYSDBA -pass masterkey</span><br />
<br />
<span style="font-family: inherit;">and then create database with username/password.</span><br />
<span style="font-family: inherit;"><br /></span>
<br />
<br />
More details can be found here: <a href="http://ib-aid.com/en/articles/firebird-3-quick-start-guide-initializing-security-database/">http://ib-aid.com/en/articles/firebird-3-quick-start-guide-initializing-security-database/ </a><br />
<br />
<br /></div>
IBSurgeonhttp://www.blogger.com/profile/05116496519832864761noreply@blogger.com4tag:blogger.com,1999:blog-52428405453193081.post-20282309708507520822012-03-26T00:31:00.000-07:002012-03-26T00:31:18.538-07:00Where can I download Firebird 3?<div dir="ltr" style="text-align: left;" trbidi="on">
Firebird 3 is in alpha development stage (see <a href="http://www.firebirdsql.org/en/roadmap/">roadmap</a> for details), and it means that it's published as "snapshots" - regular builds from the current source code.
Snapshots can be found at Firebird SQL web site: <a href="http://www.firebirdsql.org/en/snapshot-builds/">http://www.firebirdsql.org/en/snapshot-builds/</a>.<br />
<br />
They contain also code for future minor releases for Firebird 2.x, so look carefully what you download.
Source code behind these snapshots (as well as other Firebird versions) is stored in Firebird code repositiory: now it's in trunk, and later, at beta stage, it will be forked to the separate branch.<br />
<br />
At the moment SVN URL for Firebird 3 is <a href="https://firebird.svn.sourceforge.net/svnroot/firebird/firebird/trunk">https://firebird.svn.sourceforge.net/svnroot/firebird/firebird/trunk</a><br />
(to extract sources you need SVN client like <a href="http://tortoisesvn.net/">Tortoise SVN</a>).<br />
<br />
In fact, there is no need to get source code, until you are not a C++ developer with intention to join Firebird Project. Snapshots are enough to have a quick look at Firebird 3 and play with it.<br />
<b><br /></b><br />
<b>Resources:</b><br />
<br />
<ul style="text-align: left;">
<li>Firebird code repository description and links: <a href="http://www.firebirdsql.org/en/code-repository/">http://www.firebirdsql.org/en/code-repository/</a></li>
<li>Firebird 3 Windows version snapshot direct link: <a href="http://web.firebirdsql.org/download/snapshot_builds/win/3.0/">http://web.firebirdsql.org/download/snapshot_builds/win/3.0/</a></li>
</ul>
<br />
<br /></div>IBSurgeonhttp://www.blogger.com/profile/05116496519832864761noreply@blogger.com0tag:blogger.com,1999:blog-52428405453193081.post-51964604957830034642012-03-26T00:02:00.000-07:002012-03-26T00:02:11.336-07:00Firebird 3: interesting even in alpha versionFirebird 3 is in alpha stage now (March 2012), but it's already interesting for many developers due to the many new features and performance improvements. So it's a natural to try Firebird 3 with your existing application and see it in action.
In this blog we'll consider Firebird 3 on its way to the release.IBSurgeonhttp://www.blogger.com/profile/05116496519832864761noreply@blogger.com0