Final part of the story with 1.7 Terabyte Firebird SQL database
Tuning 1.7 Terabyte FirebirdSQL database (part 3)
For those who did not read the first 2 parts:
Firebird Performance Degradation (part 1)
More details about 1.7Tb database (part 2)
Category: General news
Firebird related news
FireServer site is online!
The official site for the FireServer Project is now on-line! You can find basic information about the project. There are no ISO downloads available yet. We expect to have the first ISO until the end of August.
Firebird for #Python driver FDB 1.4.1 released with fixes and a few enhancements
FDB release 1.4.1 is out:
http://pypi.python.org/pypi/fdb
This release fixes some issues found over last year and adds few
enhancements. Check out the changelog at
http://pythonhosted.org//fdb/changelog.html#version-1-4-1
ANN: CopyCat LiveMirror 1.2
Microtec is pleased to announce a new release of our database mirroring and backup tool : CopyCat LiveMirror version 1.2 !
LiveMirror makes it trivial to setup a one-way replication setup between two Firebird databases, so that you can easily have a reliable, up-to-date backup at your fingertips, at all times.
For more information about CopyCat LiveMirror, have a look at our product page.
Changes in this release:
- Added an option allowing you to specify a list of tables to exclude from replication.
- Added an option allowing you to manually create or remove CopyCat meta-data (system tables and triggers) from your databases.
- Add button to synchronize manually.
- If no primary key is available, LiveMirror will now use any available unique index to identify the rows to replicate.
- Fixed a bug causing incorrect date/time formatting for date fields used in primary keys in dialect 1 databases.
- Corrected a refresh problem : if you kill the service from the task manager, the “Started” label does not get refreshed in the LiveMirror Manager.
A few changes and fixes to libfq
Fireserver Project is coming
Fireserver is a project of a custom linux server distro that includes Firebird as default database server, and can be used freely by any company who want to simplify their customer’s servers administration and support.
You can read a full article about the Fireserver project in opensource.com/life/14/6/fireserver-project
Firebird SQL syntax for VIM
If you like Vim here is the Syntax Highlighter for Firebird SQL dialect (First version)
There is a github project pushed up here:
https://github.com/blumf/firebird_vim_syntax
Should be pretty simple for most *nix users to use.
sudo apt-get install lua5.2
git clone https://github.com/blumf/firebird_vim_syntax.git
cd firebird_vim_syntax
make
make install
A few Firebird fixes are commited in LibreOffice git
A few more Firebird fixes are commited in LibreOffice git
Fdo#79493 Refresh Tables option fails with Firebird
https://bugs.freedesktop.org/show_bug.cgi?id=79493
Fdo#73352 firebird don’t claim to support interfaces one doesn’t
https://bugs.freedesktop.org/show_bug.cgi?id=73352
Fdo#74019 – FILEOPEN: Any table or select query having more than 10 fields cannot be opened in a database with embedded FireBird
https://bugs.freedesktop.org/show_bug.cgi?id=74019#c19
Only 3 days left on our 75% FIFA World Cup discount on all our database development tools!
We’re offering a 75% FIFA World Cup special discount on all our database development products!
We’re a company offering several database development tools, our tools include test data generator tools that includes a data library for real-life-like data (useful for volume testing, giving presentations etc), auditing, design, debugging and development tools.
Take a look at www.upscene.com – download a trial version today and place your order tomorrow!
Database .NET 11.7 released
Database .NET is an innovative, powerful and intuitive multiple database management tool, With it you can Browse objects, Design tables, Edit rows, Export data and Run queries with a consistent interface.
- Updated to FirebirdSql.Data.FirebirdClient.dll 4.2.0
- Added Table and View List
- Added Open last query tabs on startup
- Added Using quoted identifiers for database object names
- Added Query Builder -> Full support for JOIN types
- Added Select the entire column
- Added (*.txt;*.csv) Export NULLs As Empty or NULL string
- Added Support for All Object Comments
- Added Support for Automatic reconnection
- Added Support for IntelliSense Cache
- Improved Selected Text to Query Builder
- Improved AutoComplete and IntelliSense
- Improved Generate Scripts(DDL and SCRIPT AS)
- Improved Search Table Data
- …and more.
What’s New (2014/06/09)
You’re welcome to download the Database .NET right now at:
http://fishcodelib.com/Database.htm
Free, All-In-One, Portable, Standalone (No Installation) and Multlanguage.
Supported Platforms: Windows All (x86/x64)