Firebird International Conference 2014 will take place on October 24-25, in Prague. 2 days of the intensive talks from Firebird core and drivers developers, vendors of leading Firebird tools and even legends of the database world: Ann Harrison and Jim Starkey.

Take a look at detailed talks descriptions. Don’t miss the biggest event of the year, register now!

Be Sociable, Share!

Here is the guide on installing Firebird 2.5.3 from FreeBSD 10 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 on a kvm-linux virtual machine.

Download a compressed snapshot of the Ports Collection into /var/db/portsnap.

# portsnap fetch

Or update it.
If you are running Portsnap for the first time, extract the snapshot into /usr/ports:

# portsnap extract

If you already have a populated /usr/ports directory and you are just updating, run the following command instead:

# portsnap update

Enter firebird server ports directory:

# cd /usr/ports/databases/firebird25-server

Compile and install firebird server:

# make -DPACKAGE_BUILDING

# make install

Enable it by adding

firebird_enable="YES"

in

/etc/rc.conf
.

Start it with:

# /usr/local/etc/rc.d/firebird start

logs and security2.fdb seems to be in /var/db/firebird.

# /usr/local/bin/isql-fb

To create a new database:

SQL> create database “tmp/first_database.fdb”;

SQL> connect “/tmp/first_database.fdb” ;

Commit current transaction (y/n)? <– y

Committing.

Database: “/tmp/first_database.fdb”

SQL>

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;

TEST

SQL> INSERT INTO TEST VALUES (1, ‘John’);

SQL> INSERT INTO TEST VALUES (2, ‘Joe’);

SQL> select * from test;

ID NAME

============ ====================

1 John

2 Joe

To quit the isql-fb console, type quit:

SQL> quit

CON>;

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:

# /usr/local/bin/php -m

Or if you don’t want to wait compile all the php use pkg-add

# pkg-add -r php5-interbase

Be Sociable, Share!

I think it is time for updating the WordPress’s theme used in FirebirdNews. The actual theme is based in the Firefox theme (old and no more maintained) and doesn’t support well some of the new features available in the most recent versions of WordPress.

WordPress has thousands of themes, and choosing the right one is a difficult task, when so many choices are available. So, if you know a good and beautiful theme that could be used in this site, please comment below.

Remember that we are a news site, so theme should fit this purpose. Also, it should has no cost (meaning it should be free or donated)

Be Sociable, Share!

More info here.

You can get the bits from NuGet FirebirdSql.Data.FirebirdClient and EntityFramework.Firebird.

Be Sociable, Share!

Mark Rotteveel tweeted about his progress towards using JNA instead of JNI:

Continuing my adventure with JNA for Firebird native client and embedded support in Jaybird 3.0, so I can remove existing JNI wrapper.

Be Sociable, Share!

EPEL 7 left the beta stage so you can install Firebird 2.5.3 packages for Centos/RHEL 7 from stable repository

sudo yum install http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-1.noarch.rpm

yum –enablerepo=epel install firebird-superclassic

and since EPEL 7 use Systemd, you can use Systemd to enable the service
and stop or start it
read the README provided :
http://pkgs.fedoraproject.org/cgit/firebird.git/tree/README.Fedora?h=epel7

you also have classic and superserver
http://dl.fedoraproject.org/pub/epel/7/x86_64/repoview/firebird.html
http://dl.fedoraproject.org/pub/epel/7/x86_64/repoview/firebird-classic.html
http://dl.fedoraproject.org/pub/epel/7/x86_64/repoview/firebird-superserver.html

Be Sociable, Share!

Github model for contributions really works : here is the project pulse for last month.

There are quite a few pull requests closed and merged for .NET Provider

Be Sociable, Share!

FreeBSD port is updated to Firebird 2.5.3 . Please consult the release notes

ps: Unicode patch is not needed anymore (Fix included in 2.5.3 release)

Be Sociable, Share!

The report of the 11th edition of the Firebird Developers Day Conference  is now available either in English and Portuguese, and contains several pictures from the conference day.

fddnewlogo_small

Be Sociable, Share!

Upscene Productions is proud to announce the availability of the next major version of the popular multi-DBMS development tool:

” Database Workbench 5 “

There have been numerous improvements to existing tools and the new, more consistent user interface is better than ever and works fine under Wine on Linux.

Database Workbench now comes in multiple editions with different pricing models, there’s always a version that suits you!

DBW 5

“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 include:

  • Support for the latest versions of database engines 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
  • 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 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.

Be Sociable, Share!

« Previous PageNext Page »

Link to us!

This Firebird & Interbase WebRing site owned by Carlos H. Cantu .
[ Previous 5 Sites | Previous | Next | Next 5 Sites | Random Site | List Sites ]