Month: January 2010

JVCS 2.45 released

Leave a comment

he JVCS team is happy to announce JEDI VCS 2.45 release, which is intended as a maintenance release for 2.40.

Most important changes from between 2.44 and 2.45 are:

    – Improved database system migration tool for Firebird and MS-SQL Server based repositories
    – Performance improvement for blank modules
    – changed server log file location for better compatibility with Windows VISTA/7/2003/2008
    – bug fixes

Installer is available on sourceforge in the file section or follow this link:
https://sourceforge.net/projects/jedivcs/files/2.45/

Please consider to help this project we always need helping hands for design, usablitity, programming, test, writing documentation.
If you’re interested please check “Positions Available” or contact us by E-Mail.

JVCS Team

Window Functions in Firebird 3

Leave a comment

Adriano has published in his blog some information about the implementation of the OVER function in Firebird 3. Really cool.

By the SQL specification, window functions are a kind of aggregation, but which does not “filter” the result set of a query. The aggregated data is mixed with the query result set. That sort of functions are used with the OVER clause. Users of Oracle also knows window functions as analytical functions[…]

Today, on January 18, 2010, IBProvider celebrates its 10th anniversary.

Leave a comment

Today, on January 18, 2010, IBProvider celebrates its 10th anniversary. The grand banquet is preceded by the release of the latest IBProvider version with enhanced support of DDL and updatable rowsets.

  • We thank all who have been with us all these years.
  • We thank FibPlus, ZStyle Group, Gemini InterBase/Firebird ODBC Driver, Easysoft ODBC-InterBase Driver, IBObjects. Owing to you, we have what to compare IBProvider to; together we make a big deal of promoting Firebird and Intrebase among masses.
  • We thank Firebird developers. Owing to you, people have a good free database server.
  • We thank our clients. Owing to you, IBProvider has been developed and will be developed.

Changes in IBProvider

  • Supports DDL query “COMMENT ON” in Firebird 2.1
  • Updatable rowsets code revision in IBProvider

Read details here.

Database Master 1.7 released

Leave a comment

Database Master is a powerful database development, management and administration software for the Oracle, SQL Server, MySQL, PostgreSQL, FireBird and SQLite database systems. It allows you to manage databases, tables, views, procedures, indexes, triggers and provides productivity features for rapidly creating and executing SQL queries and connect some major database systems via ODBC and OleDb. Database Master is being imagesed for modern multi-cpu/core architecture.

From Firebird Foundation blog

Leave a comment
Thu 14 Jan 2010 23:59:59 GMT Gold Sponsorship Renewals Secretary
It is heartening to have received renewals of two more Gold sponsorships for a further year from DRB Systems (U.S.A) and and UVData A/S (Denmark) as the New Year begins. Thanks to Steve Summers and Jan Gaardboe Jensen, respectively.
Wed 06 Jan 2010 11:27:52 GMT FFMember List Restored Secretary
As you probably are aware, we’ve lost the Atkin News server in a series of bad events in previous weeks. Thanks to Philippe Makowski and some of his FLOSS buddies, we have a temporary new home for our members’ forum. All current members (and some not so current!) should have received notifications in your in-boxes.

Older posts here.

Firebird Tracker is Restored

3 comments

Firebird’s Jira Tracker is now restored on the new VM, with data up to 5 December 2009. However, we have lost attachments from the last two years. Missing ticket headers from after Dec 5 will need to be reconstructed from notification messages.

Firebird support for Identity Columns in 3.0

One comment

An identity column is a column associated with an internal sequence generator and has it value automatically set when omitted in an INSERT statement.

Example:

create table objects (
id integer generated by default as identity primary key,
name varchar(15)
);

insert into objects (name) values (‘Table’);
insert into objects (name) values (‘Book’);
insert into objects (id, name) values (10, ‘Computer’);

select * from objects;

ID NAME
============ ===============
1 Table
2 Book
10 Computer

1 2 3