Upscene Productions is proud to announce the availability of the next release of the popular multi-DBMS development tool:
” Database Workbench 5.1.6 “
This version is the next big release after version 5 and includes new features, enhancements and fixes.
The change logs for version 5.1.x is available.
“There is so much new in Database Workbench 5, I don’t know where to start”, says Martijn Tonies, founder of Upscene Productions. “This release adds code editor features, has diagramming improvements, comes in multiple editions, is fully HiDPI aware and offers tunneling for MySQL and MariaDB connections. It all was a lot of work, but it was worth it!”
“We worked closely with out customer and implemented many of their requests and for new users, we offer multiple editions to suit their development needs. From design to productivity, there’s new features and improvements in almost everything!”
New features in version 5 include:
- Support for the latest versions of database engines including SQL Azure and MariaDB support
- New and improved user interface
- Code editor features like block staples, code folding, object linking and dynamic highlighting
- “Diagram Navigator” for easier diagramming navigation
- MySQL/MariaDB tunneling support
- Firebird 3 Package Editor
- New tools, including a Data Compare tool
- Basic and Pro Edition to suit your needs
- and much more…
For more information, see What’s new in Database Workbench 5?
Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Azure, SQL Anywhere, NexusDB and InterBase, comes in multiple editions and is licensed based on selectable modules.
It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools.
About Database Workbench
Database Workbench is a database developer tool, over 10 years in the making and
is being used by thousands of developers across the globe who have come to rely on it
every day. From database design, implementation, to testing and debugging, it will aid you
in your daily database work.
About Upscene Productions
Based in The Netherlands, Europe, this small but dedicated company has been providing
database developers with useful tools for over 12 years. Slowly expanding the product portfolio
and gaining recognition amongst InterBase and Firebird database developers, they now offer
tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Background: The current Firebird automatic installer on El Capitan is no longer working, its format has been
finally deprecated. The installer is currently undergoing a complete re-write to comply with the Flat Package Format. Until this work is completed, you can manually install Firebird using the following method.
New release for node-firebird driver with one bug fix and a few improvements :
Fix a problem with sequential read (#78)
Improvement : Reading of fetched packet
Experimental : Add params to connection (cacheQuery and maxCachedQuery).
when cacheQuery is set to true each query is cached for faster re-use during the connection like in Jaybird.
after the query is cached these steps are saved :
- Query allocation
- Compilation and Plan
Firebird Project and IBSurgeon invite Firebird administrators and developers to «Firebird Big Databases» seminar (in Russian). Seminar will take place in Moscow, Russia, October 21, 2015.
Main speakers at seminar are Dmitry Yemanov, lead FirebirdSQL developer, Dmitry Kuzmenko, IBSurgeon and Alexey Kovyazin, IBSurgeon.
The seminar will cover topics of Firebird performance optimization and maintenance of big Firebird databases (>500Gb).
Seminars in Europe are planned, but not yet announced, please stay tuned.
More details and registration is at http://ibase.ru/firebirdtour2016.html (in Russian only).
|Upscene Productions is offering a 50% discount on FB TraceManager in October 2015! Simply use the coupon code FBTM-PROMO-50 when placing an order.|
More information on the product is available in the FB TraceManager section on our website, including an edition comparison sheet, webcasts etc.:
Thanks for your continued support.
Want an awesome Hacktoberfest tee?
Contribute to one of the many Firebird SQL Github Repositories!
and many others https://github.com/search?&q=firebird
dbMigration .NET is a simple, easy and intuitive multiple database migration and sync tool, With it you can easily migrate schema and data between different databases without complicated procedures.
Supported databases: Firebird, PostgreSQL, SQL Server, SQL Azure, LocalDB, MySQL, Oracle, IBM DB2, Informix, HP Vertica, NuoDB, Teradata, Sybase ASE, SQLite, SQLCe, Access, dBase, FoxPro, Excel, ODBC, OLEDB…etc.
- New features and improvements from 1.1 to 1.6 (2015/10/02)
- Added Data Synchronization
- Excel, Generic ODBC and Generic OleDB support
- VIEW Objects support
- Updated to FirebirdSql.Data.FirebirdClient.dll 18.104.22.168
- Improved Automatic column matching
- Improved Filter source data
- …and more.
For more information please visit http://fishcodelib.com/DBMigration.htm
Free, All-In-One, Portable, and Single executable file.
Here is the guide on installing Firebird 2.5.4 from FreeBSD 10.2 Ports and creating your first test database; also we show you how to install Flamerobin GUI (administration tool) and the PHP driver for it. This was tested on fresh FreeBSD 10.2 x64.
Download a compressed snapshot of the Ports Collection into /var/db/portsnap.
Or update it. If you are running Portsnap for the first time, extract the snapshot into /usr/ports:
If you already have a populated /usr/ports directory and you are just updating, run the following command instead:
Enter firebird server ports directory:
Compile and install firebird server:
Enable it by adding
Start it with:
logs and security2.fdb seems to be in /var/db/firebird.
To create a new database:
SQL> create database “tmp/first_database.fdb”;
SQL> connect “/tmp/first_database.fdb” ;
Commit current transaction (y/n)? <– y
If you want to create a simple table then insert 1-2 rows and select from it; here is one example:
SQL> CREATE TABLE TEST (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(20));
SQL> show tables;
SQL> INSERT INTO TEST VALUES (1, ‘John’);
SQL> INSERT INTO TEST VALUES (2, ‘Joe’);
SQL> select * from test;
To quit the isql-fb console, type quit:
For a good open source GUI admin tool you might check the flamerobin administration tool included in ports repository; it can be installed by a simple:
cd /usr/ports/databases/flamerobin/ && make install clean
Or if you don’t want to wait use pkg-add
pkg-add -r flamerobin
To use firebird with php, you will need the php5 driver:
cd /usr/ports/databases/php5-interbase/ && make install clean
You can choose to compile php with apache support (I have chosen cli, cgi , and apache support); check it if is enabled with:
Or if you don’t want to wait compile all the php use pkg-add
pkg-add -r php5-interbase